Free Course on Udemy - Microsoft SQL Server Development for Everyone!

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017

Course content

• 6 sections 
• 32 lectures 
• 6h 1m total length

What you'll 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
• 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

Click to Join