SQL Bootcamp 2026: Learn SQL from Beginner to Advanced

Master SQL with hands-on projects — learn PostgreSQL, MySQL, SQL Server & more for real-world data analysis and database

4.7

(220 đánh giá)

4,310 học viên

Giảng viên

Bantu Ngxola

Phụ đề Việt chất lượng cao Phụ đề tiếng Anh Bán chạy Đánh giá cao

50.000đ 399.000đ -87%

✓ Xem giỏ hàng và thanh toán

Bao gồm phụ đề tiếng Việt, tiếng Anh

4.0 giờ video

235 bài giảng

76 bài quiz

61 bài coding

Truy cập vĩnh viễn

Học trên mọi thiết bị

Cập nhật: 28/05/2026

#Bootcamp #Business #Business Analytics & Intelligence #Sql

Bạn sẽ học được gì

Generate reports using SQL and address business challenges

Write Complex SQL Queries Using Common Table Expressions (CTEs)

Lean about GROUP by clause

Master SQL Joins and Window Functions (RANK, DENSE_RANK, ROW_NUMBER)

Master SQL for Data Analytics and Business Intelligence

Master SQL for Data Migration and Data Manipulation

Create Database Objects

Yêu cầu

No SQL experience is required, and you will learn all that you need.

Đối tượng phù hợp

Managers

Data Analytics and Business Intelligence

Data Scientists and Data Engineers

Data Migrations Specialist

Other Database Users

Nội dung khóa học

24 phần • 235 bài giảng

1 Introduction

2 Database Server

3 Installing PostgreSQL on Windows

4 Installing PostgreSQL on MacOS

5 Entity Relational Model

6 Entity

7 Table

8 Column

9 Relationship (Primary Key and Foreign key)

10 Relationship (Connectivity and Cardinality)

11 pgAdmin Introduction

1 Basic Select Statement

2 Literal(character, String)

3 Literal(constant)

4 Non-numeric Literals

5 Numeric Literals

6 Arithmetic Expression Operators

7 Mathematical Operator Precedence

8 Using aliases

9 Escape character sequence

10 Concatenation Operator

11 Comments Within SQL Statements code

1 Data Types

2 Cast Function(CAST()) and cast operator(::)

3 Numeric Data Types

4 Character Data Types

5 Date Time Data Types

6 Boolean Data Type

1 SELECTING columns or expressions FROM a table

2 Selecting All Columns

3 Selecting Specific Columns or Expressions

4 Identifiers (Quoted/ Unquoted )

5 Types of Identifiers(Unquoted)

6 Types of Identifiers(Quoted)

7 Using Column Aliases

8 Eliminating duplicate rows

9 SELECT from a generated (VALUES Lists)

1 Using WHERE Clause

2 Comparison Operators

3 Match any Range search condition( [NOT] BETWEEN )

4 Match any of a list of values ( [NOT] IN )

5 Pattern match search condition ( [NOT] LIKE )

6 Using ( IS [NOT] NULL ) Conditions

7 Using the AND Operator

8 Using the OR Operator

9 Rules of Precedence(Order of operation )

10 ORDER BY clause

11 OFFSET

12 FETCH

13 LIMIT

14 OFFSET and LIMIT

15 OFFSET and FETCH

1 Functions and Operators

2 String functions and Operators (String Concatenation)

3 String functions(Case Conversion)

4 Show part of a string(LEFT,RIGHT, SUBSTR)

5 Remove from a String(LTRIM,RTRIM,TRIM)

6 Add and Replace characters in a String(LPAD, RPAD, REPLACE)

7 Length of string(LENGTH)

8 Numeric functions (MOD)

9 Numeric functions (CEILING, FLOOR)

10 Numeric functions (ROUND, TRUNCATE)

11 Date , Time Functions)

1 Introduction

2 POSIX Regular Expressions

3 Regular Expression Atoms

4 Literal Characters:

5 Dot : .

6 Regular Expression Constraints (also called Anchors): ^, $

7 Regular Expression Quantifiers: { }

8 Bracket Expressions (Character classes): [ ]

9 Escaping characters: \

10 Groups(Parentheses): ( )

11 Day2: Alternatives: |

12 REGEXP_COUNT

13 REGEXP_INSTR

14 REGEXP_LIKE

15 REGEXP_REPLACE

16 REGEXP_SUBSTR

1 Conditional Expressions

2 CASE Statement

3 Working with NULLs(NULLIF)

4 Working with NULLs(COALESCE)

5 LEAST and GREATEST

1 Day2: Aggregate Functions(COUNT, SUM, AVG, MIN, MAX)

2 Day2: Using Aggregate Functions on the entire column(COUNT, SUM, AVG, MIN, MAX)

3 Using Aggregate Functions with WHERE clause(COUNT, SUM, AVG, MIN, MAX)

4 Aggregate Function(COUNT)

5 Handling Null values in Aggregate Functions(COUNT, SUM, AVG, MIN, MAX)

6 GROUP BY Clause

7 GROUP BY Clause(Grouping by Multiple Columns)

8 HAVING Clause (Filter Groups using Aggregated column)

1 Generating Reports by Grouping Related Data_

2 ROLLUP

3 CUBE

4 GROUPING

5 GROUPING SETS

1 Joining Multiple Tables

2 Table aliases

3 Types of JOINS

4 INNER JOIN(ON clause, USING clause)

5 LEFT OUTER JOIN(ON clause)

6 RIGHT OUTER JOIN(ON clause)

7 FULL OUTER JOIN(ON clause)

8 CROSS JOIN

1 Windowing

2 Windowing calculations(aggregate function)

3 Window Functions

4 Window Function OVER(ORDER BY order_list ) clause

5 Window Function OVER(PARTITION BY ORDER BY ) clause

6 Window Function OVER() without "window_definition"

7 Window Function OVER(PARTITION BY ) clause

8 WINDOW clause

1 SUBQUERY

2 Scalar subquery

3 Row subquery

4 Subquery Expressions

5 Multi-Row Subquery (IN, SOME/ANY, ALL)

6 Multi-Row Subquery ([NOT] IN)

7 Multi-Row Subquery ( ANY/SOME)

8 Table subquery(Inline View)

9 Multi-Row Subquery ( ALL)

10 Correlated Subquery

11 [NOT] EXISTS Subquery Expressions

1 Basic SELECT from a Common Table Expressions (CTE’s)

2 Common Table Expressions Column List

3 With Clause in Common Table Expressions

4 Common Table Expressions (CTEs) vs Subquery

5 Using WITH Clause( split complicated queries into smaller parts)

6 Purpose and Benefits of the WITH Clause

7 Multiple Common Table Expressions (CTEs)

1 Introduction

2 UNION [ ALL]

3 INTERSECT [ ALL ]

4 EXCEPT

1 Database Server

2 Entity Relationship Model

3 Data Modelling and Design

4 Conceptual Modelling

5 Logical Modelling (Normalization)

6 Day4: Physical Modelling

1 Data definition language (DDL)

2 CREATE DATABASE

3 CREATE DATABASE

4 CREATE TABLE

5 CREATE TABLE

6 CREATE TABLE with AS keyword

7 CREATE TABLE with AS keyword

8 ALTER TABLE (ADD Column)

9 ALTER TABLE (ADD Column)

10 ALTER TABLE(DROP COLUMN)

11 ALTER TABLE(DROP COLUMN)

12 ALTER ADD (Primary key )

13 ALTER ADD (Primary key )

14 ALTER TABLE(ADD foreign key)

15 ALTER TABLE(ADD foreign key)

16 RENAME TABLE

17 RENAME TABLE

18 RENAME Column

19 RENAME Column

20 RENAME Constraint

21 RENAME Constraint

22 Comment on a TABLE

23 Comment on a TABLE

24 ALTER TABLE(DROP COLUMN)

25 ALTER TABLE(DROP COLUMN)

26 Remove TABLE comment

27 Remove TABLE comment

28 TRUNCATE

29 TRUNCATE

30 DROP

31 DROP

1 Check Constraint (column constraint, explicit constraint name )

2 Check Constraint (column constraint, implicit constraint name )

3 Check Constraint (table constraint, implicit constraint name )

4 Check Constraint (table constraint, implicit constraint name )

5 Not-Null Constraints (column constraint explicit)

6 Unique Constraints (column constraint, explicit constraint name )

7 Unique Constraints (column constraint, implicit constraint name )

8 Unique Constraints (table constraint, explicit constraint name )

9 Unique Constraints (table constraint, implicit constraint name )

10 Primary Keys (column constraint, implicit constraint name )

11 Primary Keys (table constraint, implicit constraint name )

12 Foreign Keys (table constraint, explicit constraint name )

13 Foreign Keys (table constraint, implicit constraint name )

14 Default (column constraint only )

15 Clean-up

1 Data manipulation language (DML)

2 SELECT

3 INSERT

4 Basic INSERT using literal, expression, and DEFAULT method1 (column name)

5 Basic INSERT using literal, expression, and DEFAULT method 2(values)

6 INSERT using query

7 UPDATE

8 UPDATE specific values

9 UPDATE all values in column

10 UPDATE multiple columns

11 DELETE

12 Delete specific rows

13 Delete all rows

14 MERGE

15 Clean-up

1 Disable auto-commit in pgAdmin4

2 COMMIT

3 ROLLBACK

4 SAVEPOINT

5 Cleanup

1 CREATE SEQUENCE

2 Sequence Functions

3 NEXTVAL

4 CURRVAL

5 ALTER Sequence

6 RENAME a Sequence

7 COMMENT on Sequence

8 DROP sequence

1 Create a View

2 SELECT from a View

3 (OR REPLACE) keyword

4 ALTER VIEW

5 RENAME a View

6 COMMENT

7 Drop a View

1 CREATE USER

2 CREATE ROLE

3 Data Control Language (DCL)

4 GRANT specific privileges to a role

5 GRANT ALL PRIVILEGES to a role

6 GRANT specific privileges to a user

7 GRANT(add members on the existing role)

8 REVOKE specific privileges from a role

9 REVOKE ALL PRIVILEGES from a role

10 REVOKE (remove members on the existing role)

11 DROP USERS

12 DROP ROLES

1 Congratulations

Giới thiệu khóa học

Introduction

The Complete SQL Bootcamp 2026 is a practical, step-by-step SQL course that takes you from absolute beginner to advanced SQL developer in just 30 hours.

You’ll learn how to write SQL queries, analyze data, and manage databases across the most in-demand platforms: PostgreSQL, MySQL, SQL Server, and Oracle.

Whether you want to become a data analyst, business intelligence specialist, developer, or database administrator, this SQL training will give you the skills employers want in 2026.

What You’ll Learn

By the end of this course, you’ll be able to:

Write efficient SQL SELECT queries for real-world data analysis
Filter, sort, and group results with WHERE, ORDER BY, GROUP BY
Perform reporting with aggregate & group functions
Combine data using INNER JOIN, LEFT JOIN, FULL JOIN & advanced joins
Apply window functions and CTEs (WITH clause) for analytics
Execute subqueries and optimize performance
Manage data with INSERT, UPDATE, DELETE (DML) statements
Build and manage views, schema objects, and sequences
Complete hands-on SQL projects for analytics, BI, and reporting

Who This Course Is For

This SQL Bootcamp is ideal for:

Absolute beginners who want to learn SQL step by step
Data analysts & business analysts advancing their SQL skills
Developers & IT professionals working with databases
Students & job-seekers preparing for SQL interviews
Anyone who needs SQL for data analysis, BI, or database management

No prior programming or database knowledge is required.

Why Choose This Course?

Learn SQL from beginner to advanced in 30 hours
Hands-on projects using real-world datasets
Covers multiple databases: PostgreSQL, MySQL, SQL Server, Oracle
Updated for 2026 with lifetime access
Step-by-step lessons + exercises after each module
Prepares you for SQL jobs, technical interviews, and certifications

Call to Action

Start mastering SQL today!
Enroll in the Complete SQL Bootcamp 2026 and gain the skills to analyze data, manage databases, and succeed in business intelligence and tech careers.

Build your portfolio with projects. Become confident in SQL. Secure your future in data.