SQL Programming | B-Tree | Clustered & Non Clustered Indexes | Faster Execution of Select Queries

SQL Programming Complete Course Outline

This Playlist on SQL Programming is designed to give you a complete hands-on experience with SQL.
Course Outline:

Database Basics
-- What is Database?
-- What is Schema?
-- SQL Programming & ANSI Standards
-- Applications of Database (OLTP & OLAP)
-- ACID Properties

Introduction to SQL Programming
-- Types of SQL Queries: DDL, DML, DCL
-- DDL – Data Definition Language
-- DML – Data Manipulation Language
-- DCL – Data Control Language

Data Types: Character, Numeric, Date, Boolean, BLOB

Data Definition Language
-- CREATE, ALTER, and DROP
-- Primary Key, Foreign Key, and Unique Key
-- Null, Not Null, and Check Constraints
-- Default Value
-- Auto Increment Column
-- Indexes

Data Modeling Concepts
-- Conceptual, Logical, and Physical Data Model
-- ER Model & Normalization (OLTP)
-- Dimensional Model & Denormalization (OLAP)
-- Star & Snowflake Schema

Data Manipulation Language
-- INSERT, UPDATE, DELETE Queries
-- SELECT Queries, Sub-Queries, and Common Table Expressions
-- Commonly used String, Date, and Math Functions
-- Dimensions and Measures Concept in SQL Group By Aggregation queries
-- Commonly used aggregation functions: count(), sum(), min(), max(), and avg()
-- TRUNCATE Table
-- Usage of IN, NOT IN, EXISTS & NOT EXISTS in SELECT Queries

Indexes and their importance in SELECT Query
-- Clustered Index
-- Non-Clustered Index

JOINS
-- Inner, Full Outer, Left, and Right Outer Join
Semi & Anti Join

Window Functions
-- row_number(), rank(), dense_rank()
-- lag(), lead()
-- Partition By, Order By, Rows Preceding and Following

Overview of Advanced Topics
-- Views, User Defined Functions, Stored Procedures, Cursors, and Triggers

Capstone Project