Getting Started with Data Management

Getting Started with Data Management, available at $44.99, has an average rating of 4.43, with 61 lectures, based on 919 reviews, and has 3775 subscribers.

You will learn about Get started working with data Understand big data fundamentals Explore tabular data with Python Learn the fundamentals of SQL Use the ETL workflow for data integration This course is ideal for individuals who are Anyone seeking a career in data management or Aspiring DBAs, Developers, Data Analysts, Data Scientists and Data Engineers It is particularly useful for Anyone seeking a career in data management or Aspiring DBAs, Developers, Data Analysts, Data Scientists and Data Engineers.

Enroll now: Getting Started with Data Management

Summary

Title: Getting Started with Data Management

Price: $44.99

Average Rating: 4.43

Number of Lectures: 61

Number of Published Lectures: 61

Number of Curriculum Items: 61

Number of Published Curriculum Objects: 61

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will Learn

Get started working with data

Understand big data fundamentals

Explore tabular data with Python

Learn the fundamentals of SQL

Use the ETL workflow for data integration

Who Should Attend

Anyone seeking a career in data management

Aspiring DBAs, Developers, Data Analysts, Data Scientists and Data Engineers

Target Audiences

Anyone seeking a career in data management

Aspiring DBAs, Developers, Data Analysts, Data Scientists and Data Engineers

Data Management is one of the most important competencies your company has. With Digital Transformation at the top of the strategic agenda for many large organizations, Data Governance and Data Management are vital to building a strong foundation for integration, analysis, execution, and overall business value. Business and data professionals are currently facing The Fourth Industrial Revolution’s convergence of megatrends around Customer 360, Artificial Intelligence, Big Data, programmatic marketing, and globalization. To survive these unrelenting business pressures, it’s more critical, and strategic, than ever to put your data to work!

In this course, you will learn about the various disciplines of data management. First, you will discover what Data Governance is and why you might want to implement a governance program for your organization, after which you will go through some very basic exploratory Data Analysis using the Python programming language.

Next up, you’ll cover basic Database Design, Data Quality essentials, and the fundamentals of the Structured Query Language. Then, you will get hands-on with some rudimentary Data Integration ETL, as well as Big Data with Hadoop.

Finally, you will explore the various disciplines in the Data Management space.

By the end of the course, you will have a firm understanding of enterprise data management and what the various disciplines do.

Course Curriculum

Chapter 1: The Value of Data Management

Lecture 1: The Value of Data Management

Lecture 2: The Lifecycle of Data

Chapter 2: Understanding Data Governance

Lecture 1: Why Do We Need Data Governance

Lecture 2: Understanding Data Stewardship

Lecture 3: Implementing Master Data Management

Lecture 4: Developing Data Definitions

Lecture 5: The Importance of Standardization

Chapter 3: Exploring Tabular Data

Lecture 1: Understanding Tabular Data

Lecture 2: Installing Jupyter Notebook

Lecture 3: Exploring Tabular Data

Lecture 4: Most Common Names in California

Lecture 5: How Frequently Does Your Name Occur?

Lecture 6: Statistical Data Types

Lecture 7: Visualizing Data

Chapter 4: Relational Database Basics

Lecture 1: Database Management Systems

Lecture 2: The Database Development Lifecycle

Chapter 5: Improving Data Quality

Lecture 1: Removing Duplicate Data

Lecture 2: Removing Inconsistent Data

Lecture 3: Breaking-down Data into Smaller Components

Lecture 4: Requiring Complete Information

Lecture 5: Designating the Primary Key

Chapter 6: Database Design

Lecture 1: One to Many Relationship

Lecture 2: Many to Many Relationship

Lecture 3: Integrity Constraints

Lecture 4: Indexing for Performance

Chapter 7: SQL

Lecture 1: Downloading Oracle XE

Lecture 2: Installing Oracle XE

Lecture 3: Opening the Oracle XE Database

Lecture 4: Connecting to Your Brand New Database

Lecture 5: Oracle Live SQL

Lecture 6: The SELECT Statement

Lecture 7: Restricting and Sorting Data

Lecture 8: Using Single-row Functions

Lecture 9: Aggregating Data with Group Functions

Lecture 10: Displaying Data from Multiple Tables

Lecture 11: Answering Multi-step Questions Using Subqueries

Chapter 8: Up and Running with Ubuntu Linux

Lecture 1: Downloading Ubuntu and Workstation Pro

Lecture 2: Up and Running with Ubuntu

Lecture 3: Transferring Files Using SFTP

Chapter 9: Data Integration

Lecture 1: Setting-up Your Postgres Database

Lecture 2: Setting-up Your Postgres Data Sources

Lecture 3: Installing Python and PySpark

Lecture 4: Installing Java and JDBC for Postgres

Lecture 5: Extracting Data

Lecture 6: Transforming Data

Lecture 7: Loading Data

Chapter 10: Understanding Big Data

Lecture 1: Big Data Overview

Lecture 2: Types of Big Data

Lecture 3: Limitations of Relational Systems

Lecture 4: Introducing Hadoop

Lecture 5: Setting-up Hadoop

Lecture 6: Connecting to Your Hadoop VM

Lecture 7: Issuing SQL Queries through Hive

Chapter 11: Data Management Careers

Lecture 1: Data Management Roles

Lecture 2: Data Steward

Lecture 3: Data Analyst

Lecture 4: Data Engineer

Lecture 5: Data Architect

Lecture 6: DBA

Lecture 7: Application Developer

Lecture 8: Data Scientist

Instructors

Philip Agaba
Backend expert, Author

Rating Distribution

1 stars: 9 votes

2 stars: 17 votes

3 stars: 152 votes

4 stars: 309 votes

5 stars: 432 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!