uCertify

DAT/325v1: SQL for Data Analytics

(UOP-DAT325v1.AJ1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Basics of Data and SQL for Analytics

  • The World of Data
  • Methods of Descriptive Statistics
  • Statistical Significance Testing
  • 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
2

SQL for Data Preparation

  • Introduction
  • Assembling Data
  • Transforming Data
3

Aggregate and Window Functions for Data Analysis

  • Aggregate Functions
  • Aggregate Functions with GROUP BY
  • The HAVING Clause
  • Using Aggregates to Clean Data and Examine Data Quality
  • Window Functions
  • Statistics with Window Functions
4

Importing and Exporting Data

  • Introduction
  • The COPY Command
  • Using R with Our Database
  • Using Python with Our Database
  • Best Practices for Importing and Exporting Data
5

Complex Data Types and Performant SQL

  • 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
  • Database Scanning Methods
  • Performant Joins
  • Functions and Triggers
6

Using SQL to Uncover the Truth – a Case Study

  • Introduction
  • Case Study

1

Basics of Data and SQL for Analytics

  • Creating an ER Diagram
  • Using the ORDER BY Clause
  • Using the SELECT Statement
  • Using the WHERE Clause
  • Using the AND Clause
  • Using the NOT IN Clause
  • Using the LIMIT Clause
  • Using the CREATE TABLE Statement
  • Using the INSERT INTO…VALUES Statement
  • Using the UPDATE Statement
  • Using the DROP TABLE Statement
  • Using the DELETE Statement
2

SQL for Data Preparation

  • Using the Cross Join
  • Using the Inner Join
  • Using the Left Outer Join
  • Using the Right Outer Join
  • Using the DISTINCT Keyword
  • Using the CASE WHEN Statement
3

Aggregate and Window Functions for Data Analysis

  • Using the AVG Function
  • Using the COUNT Function
  • Using the GROUP BY Clause
  • Using the HAVING Clause
  • Using the PARTITION BY Clause
4

Importing and Exporting Data

  • Using the COPY Command
5

Complex Data Types and Performant SQL

  • Using the INTERVAL Keyword
  • Using the EXTRACT Keyword
  • Using the now() Function
  • Understanding the current date Keyword
  • Using the STRING_TO_ARRAY Function
  • Using the REGEXP_REPLACE Function
  • Using the row_to_json Function
  • Using the ARRAY_TO_STRING Function
  • Using the DROP INDEX Command
  • Using the CREATE INDEX Command
  • Using the EXPLAIN Command
6

Using SQL to Uncover the Truth – a Case Study

  • Sandbox

Related Courses

All Courses