Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL for Beginners with Microsoft SQL Server Database
Introduction
Introduction (1:47)
Installing the SQL Server (3:01)
Understanding the SQL Server Structure (4:25)
What is Normalization? (4:26)
Restoring a Backup Database with AdventureWorks (3:39)
Finding Data in the Database
SQL Query to Select Data from a Table (12:39)
Selecting Top N records (5:04)
Narrowing Down the Result Set with the WHERE Clause (7:20)
Pattern Matching Using LIKE in the WHERE Clause (4:46)
Specifying Multiple Values from a Column Using IN in the WHERE Clause (5:05)
Sorting the Result Set (4:48)
Selecting a Unique Result Set (3:08)
Joining Multiple Tables to Get the Desired Result Set (10:25)
Using Aliases in SQL (7:38)
Aggregating the Data in SQL - COUNT, MIN, and MAX (12:57)
Aggregating the Data in SQL - SUM and AVG (4:05)
Identifying Null Values Using an Aggregate function (3:52)
Using Aggregate Functions in the WHERE Clause (4:04)
Manipulating Data Using the SELECT Statement
Combining Multiple Columns and String Values (4:39)
Extracting Characters from a String - Learn LEFT, RIGHT, and SUBSTRING Functions (5:19)
Finding the Length of a String/Column and Position of a Character in a Column (3:57)
Other Key SQL Statements
Inserting Values in a Table Using SQL Statements (5:03)
Updating Records in a Table Using SQL Statements (4:45)
Deleting Records from a Table Using SQL Statements (3:26)
Outer Join - Left and Right (7:06)
Conclusion
Conclusion (0:16)
Aggregating the Data in SQL - SUM and AVG
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock