uCertify

SQL for Data Analytics

(SQL-DA.AJ1) / ISBN : 978-1-64459-222-9
Lessons
Lab
TestPrep
AI Tutor (Add-on)
150 Reviews
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Understanding and Describing Data

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

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
  • Summary
3

SQL for Data Preparation

  • Introduction
  • Assembling Data
  • Transforming Data
  • Summary
4

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
5

Window Functions for Data Analysis

  • Introduction
  • Window Functions
  • Statistics with Window Functions
  • Summary
6

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
  • Summary
7

Analytics Using Complex Data Types

  • 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
8

Performant SQL

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

Using SQL to Uncover the Truth – a Case Study

  • Introduction
  • Case Study
  • Summary
A

Appendix

  • Installing pgAdmin 4

1

Understanding and Describing Data

  • Sandbox
2

The Basics of SQL for Analytics

  • 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
  • Adding a Column to a Table
  • Using the DROP TABLE Statement
  • Using the DELETE Statement
3

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
4

Aggregate Functions for Data Analysis

  • Using the AVG Function
  • Using the COUNT Function
  • Using the GROUP BY Clause
  • Using the HAVING Clause
5

Window Functions for Data Analysis

  • Using the PARTITION BY Clause
6

Importing and Exporting Data

  • Using the COPY Command
7

Analytics Using Complex Data Types

  • 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
8

Performant SQL

  • Using the DROP INDEX Command
  • Using the CREATE INDEX Command
  • Using the EXPLAIN Command
  • Creating an Index on a Column of a Table of a Database

Related Courses

All Course