Related Courses
Learn How to Develop SQL Databases
£299.00
Course 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 | 00:10: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 Functions | 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 | ||
