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)
TOP Clause To Select Number Or Percentage Of ROWS That Are In The Top Of Result
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock