Syllabus
Get the detailed Course Information here.
- Chapter 1: Introduction
- Chapter 2: Data Sources
- Chapter 3: The SELECT Statement
- Chapter 4: The WHERE Clause
- Chapter 5: CASE Statements
- Chapter 6: SQL JOINs
- Chapter 7: Aggregating Results for Analysis
- Chapter 8: Window Functions and Subqueries
- Chapter 9: Date and Time Functions
- Chapter 10: Exploratory Data Analysis with SQL
- Chapter 11: Building SQL Datasets for Analytical Reporting
- Chapter 12: More Advanced Query Structures
- Chapter 13: Creating Machine Learning Datasets Using SQL
- Chapter 14: Analytical Dataset Development Examples
- Chapter 15: Storing and Modifying Data
Hands on Activities (Live Labs)
- The SELECT Statement
- The WHERE Clause
- CASE Statements
- SQL JOINs
- Aggregating Results for Analysis
- Window Functions and Subqueries
- Exploratory Data Analysis with SQL
- Building SQL Datasets for Analytical Reporting
- More Advanced Query Structures
- Creating Machine Learning Datasets Using SQL
- Analytical Dataset Development Examples
This course can be customized to fit the specific needs of the attendees and the company or industry they operate in.
Get the detailed Course Datasheet here.
Below are some of the career paths and potential opportunities after passing the XXXX exam.
- SQL Database Administrator (DBA).
- SQL Database Developer
- SQL Data Analyst
- Cloud Database Expert
- Business Intelligence Administrator
- BI Application Developer
- SQL Data Scientist
- BI Solution Architect (SME)
- BI Solution Architect
- BI Reporting Engineer
There are no prerequisites for taking this course. A desire to get a solid grounding in data science is expected of the student.
There are no specific exams for this course. You will get a Certificate of Completion.