SQL Made Easy for Beginners

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview

Lecture 2: Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)

Chapter 2: Practice different SQL Statements, Clauses, Keywords and Operators

Lecture 1: How to Practice SQL without installing any Software?

Lecture 2: Select Command

Lecture 3: distinct keyword

Lecture 4: SQL is not case sensitive

Lecture 5: Semicolon

Lecture 6: Where Clause

Lecture 7: Using Relational Operators in Where Clause Condition

Lecture 8: Using Logical Operators (AND, OR, NOT)

Lecture 9: Between Operator

Lecture 10: Order By Clause (ASC, DESC)

Lecture 11: Using Between Operator with Text

Lecture 12: In Operator

Lecture 13: Like Operator and Wildcard Characters

Lecture 14: Aliases for Table Column Names (AS Keyword)

Lecture 15: Limit Keyword

Lecture 16: Breaking the Lengthy SQL Statement into multiple lines

Chapter 3: MySQL Built-in Functions

Lecture 1: MySQL Built-in Functions

Lecture 2: upper() MySQL String Function

Lecture 3: lower() MySQL String Function

Lecture 4: length() MySQL String Function

Lecture 5: instr() MySQL String Function

Lecture 6: substr() MySQL String Function

Lecture 7: concat() MySQL String Function

Lecture 8: trim() MySQL String Function

Lecture 9: abs() MySQL Numeric Function

Lecture 10: mod() MySQL Numeric Function

Lecture 11: greatest() and least() MySQL Numeric Functions

Lecture 12: truncate() MySQL Numeric Function

Lecture 13: power() and sqrt() MySQL Numeric Functions

Lecture 14: current_date(), curdate(), current_time(), curtime(), now() and sysdate() MySQL

Lecture 15: year(),month(),day,monthname(),dayname() MySQL Date Time Functions

Lecture 16: avg(), max(), min(), count() and sum() MySQL Aggregate Functions

Lecture 17: Arithmetic Operators

Chapter 4: Practicing SQL on MySQL

Lecture 1: Installing MySQL Server and Workbench Client for Practising SQL

Lecture 2: Creating, Deleting, viewing and using Databases

Lecture 3: Creating,Viewing, Describing and Deleting Tables

Lecture 4: Insert Into Statements (For inserting data into Tables)

Lecture 5: Data Types

Lecture 6: Null Value, Is Null Operator and Is Not Null Operator

Lecture 7: Delete Statement (For Deleting the Records from Table)

Lecture 8: Update Statement and Set Keyword (For Updating the Table Records)

Lecture 9: Rename statement and To Keyword (For Renaming Table Name)

Lecture 10: Alter Statement, Add, Modify Column, Rename Column and Drop Column Keywords

Lecture 11: Set Autocommit

Lecture 12: Commit Statement

Lecture 13: Rollback Statement

Lecture 14: Truncate Statement

Lecture 15: Single Line and Multi-Line Comments

Lecture 16: Group By Clause

Lecture 17: Having Clause

Lecture 18: Sequence of using where, group by, having and order by clauses

Chapter 5: Set Operators

Lecture 1: Set Operators

Lecture 2: Union Operator

Lecture 3: Union All Operator

Lecture 4: Intersect Operator

Lecture 5: Minus Operator

Chapter 6: Sub Queries and Other Advanced Concepts

Lecture 1: Tables and Aliases

Lecture 2: Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)

Lecture 3: Sub Query (Explaining Single Row Sub Query by solving different SQL problems)

Lecture 4: In Operator

Lecture 5: Using In Operator with Multi Row Sub Query

Lecture 6: Using Any Operator in Multi Row Sub Query

Lecture 7: Using All Operator in Multi Row Sub Query

Lecture 8: Exists Operator

Lecture 9: Using Sub Queries for retrieving the records from multiple tables

Lecture 10: Using Multiple Sub Queries in a single SQL statement

Chapter 7: Integrity Constraints and other advanced concepts

Lecture 1: Integrity Constraints

Lecture 2: Not Null (Integrity Constraint)

Lecture 3: Unique (Integrity Constraint)

Lecture 4: Primary Key (Integrity Constraint)

Lecture 5: Foreign Key (Integrity Constraint)

Lecture 6: Check (Integrity Constraint)

Lecture 7: Default (Integrity Constraint)

Lecture 8: auto_increment

Lecture 9: Insert Into

Lecture 10: AS Keyword

Lecture 11: IfNull() function

Lecture 12: Case, When,Then and End Keywords

Lecture 13: Delimiter

Lecture 14: Delimiter usage in Stored Procedures

Lecture 15: Views

Lecture 16: Indexes

Chapter 8: JDBC and ODBC

Lecture 1: JDBC (Connecting to MySQL Database from Java Programs)

Lecture 2: ODBC

Chapter 9: Client Tools and other topics

Lecture 1: MySQL Shell Command Line Tool

Lecture 2: MySQL Command Line Client

Lecture 3: Using default Windows Command Prompt for connecting to MySQL Server

Lecture 4: Types of SQL Statements

Lecture 5: Grant and Revoke SQL Statements