Introduction | StackSkills

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)

Introduction

This video provides an introduction to the course.

This video provides an introduction to the course.

Complete and Continue

Lesson Content Locked

Your session expired. Please sign in again to continue.

Log In