SQL for Data Analytics
Please note: This product is non-refundable
Overview:
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.
What’s Included:
9 Lessons
60 Quizzes
40 Flashcards
40 Glossary of terms
55 Pre Assessment Questions
55 Post Assessment Questions
36 Live lab
Course Outline:
Lesson 1: Understanding and Describing Data
Lesson 2: The Basics of SQL for Analytics
Lesson 3: SQL for Data Preparation
Lesson 4: Aggregate Functions for Data Analysis
Lesson 5: Window Functions for Data Analysis
Lesson 6: Importing and Exporting Data
Lesson 7: Analytics Using Complex Data Types
Lesson 8: Performant SQL
Lesson 9: Using SQL to Uncover the Truth – a Case Study