Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft SQL Server for Marketing Analysis
Introduction
Introduction (1:47)
Installing Microsoft SQL Server (3:01)
Understanding SQL Server Structure (4:25)
Normalized Database (4:29)
Restoring a Backup Database - Adventureworks (3:39)
Pulling the Data from Database
SQL Query to Select Data from a Table (12:39)
Selecting top N records (5:04)
Narrowing down result set with WHERE clause (7:20)
Pattern Matching in WHERE clause using LIKE (4:46)
Where In... SQL Clause - Using Multiple values from a column in Where Clause (5:05)
Sorting the Result set (4:48)
Selecting unique values (3:08)
Joining multiple tables to get the desired result set (10:25)
Using Alias in SQL (7:38)
Aggregating the Data in SQL - Count, Min and Max (13:04)
Aggregating Data - Sum and Average (4:05)
Null Values in Aggregations (3:52)
Using Aggregated Values in WHERE Clause (4:04)
Manipulating Data in Select Statement
Combining Multiple Columns and String Values in Select Statement (4:39)
Extracting Characters from a String - Learn Left, Right and Substring functions (5:19)
Find length of a string/column and position of a character in a column (3:57)
Other Key SQL Statements
Inserting new records in Tables using SQL (5:03)
Updating records (4:45)
Deleting Records from a Table (3:26)
Outer Join - Left & Right (7:09)
Teach online with
Narrowing down result set with WHERE clause
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock