Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL DATABASE Queries Hands-on Training with MS SQL SERVER
Section 1 - Database SQL Introduction and Motivation
Database SQL Introduction And Motivation (2:47)
Section 2 - Installing SQL SERVER And Its Structure Understanding
Installing SQL SERVER With Management Studio (Free Version) (3:26)
Understanding SQL SERVER Structure (1:54)
Section 3 - Creating Database and Tables in SQL
Creating Database In SQL SERVER (3:56)
CREATE, USE And DROP DATABASE (SQL CODE)
Creating Tables In SQL SERVER (4:59)
EMPLOYEES TABLE (SQL CODE)
Section 4 - Select Statement in SQL
SELECT Statement To Retrieve Data From Database Tables (3:04)
SELECT DISTINCT Statement To Return Only Unique ROWS In A Result-Set (2:37)
Section 5 - Practice Session 1 ( SELECT, DISTINCT )
Lecture 1 - Practice Query (SELECT Statement )
Lecture 2 - Solution - Practice Query (SELECT Statement )
Lecture 3 - Practice Query (SELECT DISTINCT)
Lecture 4 - Solution - Practice Query (SELECT DISTINCT)
Section 6 - WHERE Clause in SQL
WHERE Clause To Filter Out ROWS Of A Table (4:15)
Section 7 -ORDER BY Keyword in SQL
ORDER BY Keyword To Sort The Result In Ascending Or Descending Order (7:38)
Section 8 - Practice Session 2 ( WHERE, ORDER BY )
Practice Query (WHERE And ORDER BY)
Solution - Practice Query (WHERE And ORDER BY)
Section 9 - TOP Clause in SQL
TOP Clause To Select Number Or Percentage Of ROWS That Are In The Top Of Result (6:37)
Section 10 - Logical Operators (OR, AND, NOT) in SQL
Logical Operators (OR, AND, NOT) In SQL (11:38)
Section 11 - Practice Session 3 ( TOP, OR, AND, NOT )
Practice Query ( Top, NOT)
Practice Query ( Top, NOT)
Practice Query (OR, AND)
Solution - Practice Query (OR, AND)
Section 12 - Special Operators in SQL
BETWEEN Special Operators To Check Whether An Attribute Value Is Within A Range (5:00)
IN Special Operators Used For Matching Any Value Within A Value List (3:28)
IS NULL Special Operators To Check Whether An Attribute Value Is Null Or Not (4:26)
LIKE Special Operators Used For Matches A Given String Pattern (9:32)
Section 13 - Practice Session 4 ( BETWEEN, IS NULL, IN, LIKE )
Practice Query (BETWEEN)
Solution - Practice Query (BETWEEN)
Practice Query (IN)
Solution - Practice Query (IN)
Practice Query (IS NOT NULL)
Solution - Practice Query (IS NOT NULL)
Practice Query (LIKE , - )
Solution - Practice Query (LIKE , - )
Practice Query (LIKE , _ )
Solution - Practice Query (LIKE , _ )
Section 14 - Comparison Operators In SQL
Comparison Operators To Compare A Given Value (2:45)
Section 15 - ALIAS And Computed Column In SQL
ALIAS To Give A Table Or A Column In A Table, A Temporary Name (2:45)
Computed Column To Perform Arithmetic’s Operations On Columns (2:11)
Section 16 - Practice Session 5 ( Comparison Operators, ALIAS, Computed Column )
Practice Query (Comparison Operator)
Solution - Practice Query (Comparison Operator)
Practice Query (ALIAS And Computed Column)
Solution - Practice Query (ALIAS And Computed Column)
Section 17 - CASE Statement in SQL
CASE Returns a Value on a Specified Condition just like if and else. (5:08)
Section 18 - SQL STRING Built-In Functions
Concatenate Two Different String Columns And Returns A Single Column (3:00)
Strings To UPPER And LOWER CASE (2:20)
Get A Substring Or Part Of A String (3:16)
Retrieve The Length Of Strings (1:51)
Replace A NULL With A Value (2:00)
Replace, Replicate, And Reverse Strings Built-In Functions (3:20)
Section 19 - Practice Session 6 ( STRING Functions )
Practice Query (STRING Functions)
Solution - Practice Query (STRING Functions)
Section 20 - SQL Datatypes Conversion Built-In Functions
Convert A Value Of Any Type Into A Specified Datatype (4:38)
Section 21 - SQL Date And Time Built-In Functions
Manipulate Year Part Of The Date (2:36)
Manipulate Month Part Of The Date (2:06)
Manipulate Day Part Of The Date (3:09)
Calculate Difference Between Two Dates (4:31)
Adds A TimeDate Interval To A Date (3:56)
Section 22 - Practice Session 7 ( DATE And TIME Functions )
Practice Query ( DAY, MONTH, YEAR)
Solution - Practice Query ( DAY, MONTH, YEAR)
Section 23 - SQL MathNumeric Built-In Functions
Perform Numeric Operation Using SQL Built-In Functions (5:30)
Section 24 - Aggregate Functions In SQL
Count Function Used To Tally Number Of Non-Null Values Of An Column (7:33)
Calculate Minimum And Maximum Values Of A Column (2:42)
Calculate Sum, Average And Standard Deviation Of A Column (5:05)
Section 25 - Practice Session 8 ( COUNT, MAX, MIN, SUM, AVG, STEDEV )
Practice Query (COUNT, MAX, MIN)
Solution - Practice Query (COUNT, MAX, MIN)
Practice Query (SUM, AVG, STDEV)
Solution - Practice Query (SUM, AVG, STDEV)
Section 26 - GROUP BY And HAVING CLAUSE
GROUP BY to Summarize Result across Small Grouped Items in the Database Table (11:46)
HAVING To Filters Result Based On The Output Of The Grouped Items (3:00)
Section 27 - Practice Session 9 ( GROUP BY, HAVING )
Solution - Practice Query (GROUP BY)
Practice Query (HAVING)
Practice Query (GROUP BY)
Solution - Practice Query (HAVING)
Section 28 - JOINS In SQL - Write Advance & Complex Queries
Introduction To JOINS And Their Types (1:04)
Concept of Relationships using Foreign Key (4:14)
Tables for JOINS (4:38)
TABLES SQL CODE - EMPLOYEES MANAGEMENT SYSTEM
INNER JOIN (6:10)
OUTER JOINS (5:33)
CROSS JOINS (1:52)
SELF JOIN (3:32)
Section 29 - Practice Session 10 (JOINS)
Tables SQL Code For Joins Practice Queries
Practice Query (INNER JOIN)
Practice Query (INNER JIOIN)
Practice Query (SELF JOIN)
Solution - Practice Query (SELF JOIN)
SELECT DISTINCT Statement To Return Only Unique ROWS In A Result-Set
Complete and Continue