Course Overview
- Course Title: The Complete SQL Bootcamp: A Step-by-Step Approach
- Instructor: Bantu Ngxola
- Target Audience:
- Beginners looking for a solid foundation in SQL
- SQL professionals striving for mastery
- Users of any database, including Oracle, MySQL, Microsoft SQL Server, Amazon Redshift, and PostgreSQL
- Prerequisites: No SQL experience is required
Curriculum Highlights
- Key Topics Covered:
- Principles of relational databases
- SQL programming language
- Writing queries for single and multiple tables
- Data manipulation within tables
- Creating database objects
- Generating reports using SQL
- Complex SQL queries using Common Table Expressions (CTEs)
- GROUP BY clause
- SQL Joins and Window Functions (RANK, DENSE_RANK, ROW_NUMBER)
- SQL for Data Analytics and Business Intelligence
- SQL for Data Migration and Data Manipulation
- Key Skills Learned:
- Retrieve Data using basic SQL SELECT Statements
- Restrict and Sort Data
- Use Aggregate Functions
- Apply Conditional Expressions
- Generate Reports with Aggregated Data Using Group Functions
- Display Data from Multiple Tables Using Joins
- Utilize Window Functions
- Work with Common Table Expressions (CTEs) using the WITH clause
- Manage Data using Subqueries and Advanced Queries
- Manage Tables using DML Statements
- Create Sequences, Views, and Schema Objects
Course Format
- Duration: 3 hours on-demand video
- Format: Self-paced online course
- Resources:
- 21 coding exercises
- 6 articles
- 7 downloadable resources
- Access on mobile and TV
- Certificate of completion