Complete Microsoft SQL Server Database Design Masterclass

Database Design | SQL Server | T-SQL | Database Tables | Foreign Keys | SQL CRUD | Views | Triggers | Stored Procedures

Created by: Trevoir Williams
Certified Trainer • Top-Rated Instructor • 450,000+ Students

Created by: Learn IT University
The Best Programming Courses

Created by: Andrii Piatakha
Founder and CEO in IT-Bulls, Founder of Learn-IT University

What Will I Learn?

• Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
• Using Microsoft SQL Management Studio
• SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
• DELETE: How to remove data from a database
• INSERT INTO: How to insert data into a table
• UPDATE: How to update existing data
• Filter groups of data using the HAVING clause
• Overall Database Development Best Practices
• Creating Relationships and Foreign Keys
• How to query related data from multiple tables
• Using Aggregate Functions in SQL
• How to export Query Results to Excel
• How to craft SQL statements based on real scenarios
• Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers)
• Backup and Restore Databases
• Generate Database Scripts for Automation
• How to manage database users and security

Requirements

• A Computer
• A desire to learn database development

Target audience

• Beginner Database Developer
• Intermediate Database Developers
• Potential Database Administrators
• Everyone!