.jpg){kind=logo}
UOP-DAT325v1.AJ1
DAT/325v1: SQL for Data Analytics
Self-paced · 1 year access
36 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
6 Interactive Lessons · 34 topics01 Basics of Data and SQL for Analytics 10 topics · 12 LiveLab +
- 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
12 LiveLab in this lesson — see the labs panel →
02 SQL for Data Preparation 3 topics · 6 LiveLab +
- Introduction
- Assembling Data
- Transforming Data
6 LiveLab in this lesson — see the labs panel →
03 Aggregate and Window Functions for Data Analysis 6 topics · 5 LiveLab +
- 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
5 LiveLab in this lesson — see the labs panel →
04 Importing and Exporting Data 5 topics · 1 LiveLab +
- Introduction
- The COPY Command
- Using R with Our Database
- Using Python with Our Database
- Best Practices for Importing and Exporting Data
1 LiveLab in this lesson — see the labs panel →
05 Complex Data Types and Performant SQL 8 topics · 11 LiveLab +
- 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
11 LiveLab in this lesson — see the labs panel →
06 Using SQL to Uncover the Truth – a Case Study 2 topics · 1 LiveLab +
- Introduction
- Case Study
1 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
36 LiveLabs- 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
- 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
- Using the AVG Function
- Using the COUNT Function
- Using the GROUP BY Clause
- Using the HAVING Clause
- Using the PARTITION BY Clause
- Using the COPY Command
- 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
- Sandbox
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for DAT/325v1: SQL for Data Analytics
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 36 LiveLab included
- Certificate of completion
No credit card required