Booking options
£25
£25
Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
On-Demand course
6 hours
All levels
Learn basic Database Design, use of Microsoft SQL Management Studio, creating Complex Database Objects & boost up your skill with the Microsoft SQL Server Development Training. This expert-outlined course aims to help learners gain a good skill on database management, providing them with a solid foundation of knowledge to become a qualified professional.
This course provides you with fundamental SQL Server training that is enough to get you started at a Database Developer or Junior Database Administrator. From this course you will Learn basic Database Design, like- Tables, Columns, Data Types, Primary Keys, Normalization, SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping), INSERT INTO: How to insert data into a table, Learn to use Microsoft SQL Management Studio, Learn how to craft SQL statements based on real scenarios, Create Complex Database Objects, such as- Stored Procedures, Functions, Views, Triggers.
Gain both practical and theoretical understanding of microsoft SQL server development and increase your employability in this field.
Enrol in Microsoft SQL Server Development Training course today and learn the researched and proven approach adopted by successful salespeople to transform your career.
Unit 01: Introduction | |||
▶ | Introduction to SQL Server and Databases | 🕐 00:04:00 | |
▶ | Download and Install SQL Server Express | 🕐 00:05:00 | |
Unit 02: 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 | |
Unit 03: 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 | |
Unit 04: 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 | |
Unit 05: 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 |
Skill Up presents a rigorous online education experience, helping you obtain industry-relevant skills certified by the world’s...