SQL-DA.AJ1
SQL for Data Analytics
Gain hands-on expertise to work with SQL for Data science with the SQL for Data Analytics course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, or training. The SQL course and lab will teach everything from the basics of SQL for Analytics to SQL for Data preparation, aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.
- Practice in 37 Hands-On Labs — nothing to install
- 10 Interactive Lessons and 50 topics mapped to the official exam objectives
- 124 Practice Test Questions
Beginner Self-paced · 1 year access 4.3/5 (150 Reviews)
37 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
10 Interactive Lessons · 50 topics01 Understanding and Describing Data 5 topics · 1 LiveLab +
- Introduction
- The World of Data
- Methods of Descriptive Statistics
- Statistical Significance Testing
- Summary
1 LiveLab in this lesson — see the labs panel →
02 The Basics of SQL for Analytics 9 topics · 12 LiveLab +
- 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
12 LiveLab in this lesson — see the labs panel →
03 SQL for Data Preparation 4 topics · 6 LiveLab +
- Introduction
- Assembling Data
- Transforming Data
- Summary
6 LiveLab in this lesson — see the labs panel →
04 Aggregate Functions for Data Analysis 6 topics · 4 LiveLab +
- Introduction
- Aggregate Functions
- Aggregate Functions with GROUP BY
- The HAVING Clause
- Using Aggregates to Clean Data and Examine Data Quality
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Window Functions for Data Analysis 4 topics · 1 LiveLab +
- Introduction
- Window Functions
- Statistics with Window Functions
- Summary
1 LiveLab in this lesson — see the labs panel →
06 Importing and Exporting Data 6 topics · 1 LiveLab +
- Introduction
- The COPY Command
- Using R with Our Database
- Using Python with Our Database
- Best Practices for Importing and Exporting Data
- Summary
1 LiveLab in this lesson — see the labs panel →
07 Analytics Using Complex Data Types 7 topics · 8 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
08 Performant SQL 5 topics · 4 LiveLab +
- Introduction
- Database Scanning Methods
- Performant Joins
- Functions and Triggers
- Summary
4 LiveLab in this lesson — see the labs panel →
09 Using SQL to Uncover the Truth – a Case Study 3 topics +
- Introduction
- Case Study
- Summary
10 Appendix 1 topics +
- Installing pgAdmin 4
Hands-On Labs Our edge
37 LiveLabs- Sandbox
- 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
- 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
- Creating an Index on a Column of a Table of a Database
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for 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
- 37 LiveLab included
- Certificate of completion
No credit card required