This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
SQL Query to Select Data from a Table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock