Curriculum
Introduction | |||
Introduction to SQL Server and Databases 00:04:00 | |||
Download and Install SQL Server Express 00:05:00 | |||
Manipulating Tables and Data | |||
Connect to Database Instance and Create a Database 00:06:00 | |||
Drop or Remove Database 00:04:00 | |||
What is a Database Table? 00:02:00 | |||
Create an SQL Database Table 00:32:00 | |||
Insert Data into the Table with SQL Script 00:15:00 | |||
Insert Data into the Table with Management Studio 00:05:00 | |||
Select Data from the Table with SQL Script 00:09:00 | |||
More Advanced Select Queries Part 1 00:18:00 | |||
Update Data in the Table with Management Studio GUI 00:02:00 | |||
Update Data in the Table with Management Studio GUI 00:02:00 | |||
Delete Data from the Table with SQL Script 00:06:00 | |||
Delete Data from the Table with Management Studio GUI 00:01:00 | |||
Relationships and Foreign Keys | |||
What are Relationships, Foreign Keys and Normalization 00:11:00 | |||
Create a Relationship in SQL Server 00:19:00 | |||
Insert Records in Related Tables 00:13:00 | |||
Run Queries on Related Tables 00:19:00 | |||
Left, Right and Full Joins 00:11:00 | |||
Group By and Aggregate Functions | |||
Grouping Data using SQL GROUP BY Clause 00:12:00 | |||
SQL AVG Aggregate Function 00:11:00 | |||
SQL COUNT Aggregate Function 00:04:00 | |||
SQL MAX and MIN Aggregate Functions 00:04:00 | |||
SQL SUM Aggregate Function 00:04:00 | |||
Advanced SQL Server Objects and Concepts | |||
Create and Manage Views 00:23:00 | |||
Scalar Valued Functions 00:27:00 | |||
Inline Table Valued Functions9 00:09:00 | |||
Multi Statement Table Valued Functions 00:12:00 | |||
Stored Procedures 00:28:00 | |||
Table Triggers 00:19:00 | |||
Database Scripting, Backup and Restore 00:15:00 |
What our STUDENT says
Based on 812 Reviews
No Reviews found for this course.