Sunday, August 1, 2021

Microsoft SQL Server Development for Everyone!

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

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

Beginner Database Developer
Intermediate Database Developers
Potential Database Administrators
Those who work in organizations where the company typically uses Microsoft databases