SQL Beginner to Advanced Level – Data Analytics

Course Curriculum

Chapter 1: Introduction

Lecture 1: SQL Course Introduction

Lecture 2: Instructor Introduction

Lecture 3: Course Requirement & Prerequisite

Lecture 4: Course Curriculum

Lecture 5: Course Structure

Lecture 6: Udemy Review System

Lecture 7: Application Downloads & Installation

Lecture 8: Windows Applications Download & Installation

Lecture 9: Mac book Applications Download & Installation

Lecture 10: Microsoft SQL Server Environment Review

Chapter 2: Data, Databases & Database Management system

Lecture 1: Section Introduction

Lecture 2: What is Data?

Lecture 3: What are Databases?

Lecture 4: Introduction to Database Management System (DBMS)

Lecture 5: Relational Database Management System (RDBMS)

Lecture 6: How to Create a database

Lecture 7: Saving Queries in SQL Server

Lecture 8: Selecting a Database

Lecture 9: Delete a Database

Chapter 3: Introduction to SQL (Structured Query Language)

Lecture 1: Section Introduction

Lecture 2: What is SQL ?

Lecture 3: SQL Dialect

Lecture 4: SQL Naming Convention

Chapter 4: Data Types in SQL

Lecture 1: Section Introduction

Lecture 2: SQL Data Types

Lecture 3: Numeric Data Type

Lecture 4: String Data Type

Lecture 5: Importance of Data Types

Chapter 5: Tables in SQL

Lecture 1: Section Introduction

Lecture 2: Introduction to Tables

Lecture 3: Create Tables

Lecture 4: Insert Data into Tables

Lecture 5: Retrieve Data from Tables

Lecture 6: Delete a Table

Chapter 6: Data Definition Language (DDL)

Lecture 1: Section Introduction

Lecture 2: CREATE, DROP, ALTER

Lecture 3: Adding comments to query

Lecture 4: Null & Not Null – SQL Constraint

Lecture 5: Add a Default Constraint

Lecture 6: Add a Unique Constraint

Lecture 7: Primary Key Constraint

Lecture 8: Using IDENTITY in SQL

Chapter 7: Data Query Language (DQL)

Lecture 1: Section Introduction

Lecture 2: SELECT statement

Lecture 3: WHERE clause

Chapter 8: Data Manipulation Language (DML)

Lecture 1: Section Introduction

Lecture 2: UPDATE command

Lecture 3: DELETE command

Lecture 4: Adding Aliases

Lecture 5: Decimal Data Type – Numeric Data Type

Chapter 9: String Functions

Lecture 1: Section Introduction

Lecture 2: String Functions

Lecture 3: CONCAT Function

Lecture 4: CONCAT_WS Function

Lecture 5: LEFT Function

Lecture 6: RIGHT Function

Lecture 7: LEN Function

Lecture 8: UPPER Function

Lecture 9: LOWER Function

Lecture 10: LTRIM, RTRIM, TRIM Functions

Lecture 11: REVERSE Function

Lecture 12: REPLACE Function

Lecture 13: SUBSTRING Function

Chapter 10: Sorting Records

Lecture 1: Section Introduction

Lecture 2: Insert character value with apostrophe/single quote

Lecture 3: Order By

Lecture 4: DISTINCT Statement

Lecture 5: TOP Clause

Lecture 6: OFFSET & FETCH

Lecture 7: % Percentage Wildcard

Lecture 8: Underscore Wildcard

Chapter 11: Aggregate Functions

Lecture 1: Section Introduction

Lecture 2: COUNT Function

Lecture 3: GROUP BY

Lecture 4: AVERAGE Function

Lecture 5: SUM Function

Lecture 6: MAX Function

Lecture 7: MIN Function

Lecture 8: HAVING Clause

Lecture 9: IN Operator

Lecture 10: Sub Queries

Chapter 12: Date & Time Data Type

Lecture 1: Section Introduction

Lecture 2: Date & Time Data Type

Lecture 3: Extract Part of Date Values

Lecture 4: GETDATE Function

Lecture 5: CURRENT_TIMESTAMP

Lecture 6: DATEPART Function

Lecture 7: DATEDIFF Function