D205 - Data Acquisition

This course includes
Interactive Lessons
Gamified TestPrep
Hands-On Labs
Get A Free Trial

About This Course

Skills You’ll Get

Download Course Outline

1

Welcome to Data Acquisition

  • About this Course
  • About the Labs in this Course
  • Learning Resources
2

Understanding and Describing Data

  • Introduction
  • The World of Data
  • Methods of Descriptive Statistics
  • Statistical Significance Testing
  • Videos
  • Summary
3

The Basics of SQL for Analytics

  • Introduction
  • Relational Databases and SQL
  • Basic Data Types of SQL
  • Reading Tables: The SELECT Query
  • Creating Tables
  • Updating Tables
  • Deleting Data and Tables
  • SQL and Analytics
  • Videos
  • Summary
4

SQL for Data Preparation

  • Introduction
  • Assembling Data
  • Transforming Data
  • Videos
  • Summary
5

Aggregate Functions for Data Analysis

  • Introduction
  • Aggregate Functions
  • Aggregate Functions with GROUP BY
  • The HAVING Clause
  • Using Aggregates to Clean Data and Examine Data Quality
  • Summary
6

Window Functions for Data Analysis

  • Introduction
  • Window Functions
  • Statistics with Window Functions
  • Videos
  • Summary
7

Importing and Exporting Data

  • Introduction
  • The COPY Command
  • Using R with Our Database (SKIP; You will cover R in the next course, D206.)
  • Using Python with Our Database (SKIP; You will cover Python in the next course, D206.)
  • Best Practices for Importing and Exporting Data (SKIP; You will cover this material later in D211.)
  • Videos
  • Summary
8

Analytics Using Complex Data Types (SKIP)

  • Introduction
  • Date and Time Data Types for Analysis
  • Performing Geospatial Analysis in Postgres
  • Using Array Data Types in Postgres
  • Using JSON Data Types in Postgres
  • Text Analytics Using Postgres
  • Summary
9

Performant SQL (SKIP)

  • Introduction
  • Database Scanning Methods
  • Performant Joins
  • Functions and Triggers
  • Summary
10

Using SQL to Uncover the Truth – a Case Study (SKIP)

  • Introduction
  • Case Study
  • Summary

1

Welcome to Data Acquisition

  • Sandbox Lab
  • PostgreSQL
2

The Basics of SQL for Analytics

  • Conceptual Schema - ER Model
  • Physical Schema - ER Model
  • Creating a Database
  • Creating a Database
  • Create Table
  • Display Table and Table Structure
  • Creating a Table
  • Creating a Table to Store Encryption Keys
  • Create Table
  • Display Table and Table Structure
  • Creating a Table
  • Creating a Table to Store Login Information
  • Retrieving Data from a Table
  • Retrieving Specific Column Data from a Table
  • Selecting Specific Columns from a Table
  • Retrieving Data from a Table
  • Retrieving Specific Column Data from a Table
  • Update Data in a Table
  • Adding New Data in a Table
  • Copying Data from One Table to Another Table
  • Updating Data in a Table
  • Updating Specific Data in a Table
  • Adding Data in the Table
  • Update Data in a Table
  • Adding New Data in a Table
  • Copying Data from One Table to Another Table
  • Updating Data in a Table
  • Updating Specific Data in a Table
  • Adding Data in the Table
  • Selecting Specific Columns from a Table
  • Adding a Column in a Table
  • Modifying a Column in a Table
  • Adding a Comment
  • Inserting Data from One Table to Another
  • Adding a New Column in a Table
  • Using ALTER Command to Modify a Column in a Table
  • Adding a Column in a Table to Store timestamp
  • Modifying a Column in a Table to Include a Comment
  • Adding a Column in a Table
  • Modifying a Column in a Table
  • Adding a Comment
  • Inserting Data from One Table to Another
  • Adding a New Column in a Table
  • Using ALTER Command to Modify a Column in a Table
  • Adding a Column in a Table to Store Timestamp
  • Modifying a Column in a Table to Include a Comment
  • Dropping a Database
  • Dropping a Database
  • Delete Rows
  • Deleting Specific Data from a Table
  • Delete Rows
  • Deleting Specific Data from a Table
  • Deleting a Table
  • Deleting All the Data from a Table
  • Deleting a Column from a Table
  • Deleting a Table
  • Deleting All the Data from a Table
  • Deleting a Column from a Table
3

SQL for Data Preparation

  • Joining Tables
  • Joining Tables
  • Using DISTINCT Keyword
  • Using DISTINCT Keyword
4

Aggregate Functions for Data Analysis

  • Using COUNT Function in GROUP BY Clause
  • Using CONCAT Function
  • Using CONCAT Function
  • Using ORDER BY Clause
  • Displaying Data in Alphabetical Order
  • Using GROUP BY Clause
  • Using ORDER BY Clause
  • Displaying Data in Alphabetical Order
  • Using GROUP BY Clause
  • Using COUNT Function in GROUP BY Clause
  • Using Operators in GROUP BY Clause
  • Using Operators in GROUP BY Clause
  • Normalizing the Unnormalized Model to 1NF
  • Normalizing from 1NF to 2NF
  • Normalizing the 2NF to 3NF
5

Importing and Exporting Data

  • Create a View
  • Creating a View
  • Creating a View Using UNION Operator
  • Create a View
  • Creating a View
  • Creating a View Using the UNION Operator
6

Performant SQL (SKIP)

  • Create an Index
  • Create an Index
  • Creating a Function

D205 - Data Acquisition

$ 279.99

Buy Now
scroll to top