Complete Microsoft SQL Server Database Design Masterclass
Database Design | SQL Server | T-SQL | Database Tables | Foreign Keys | SQL CRUD | Views | Triggers | Stored Procedures
4.61 (2733 reviews)
150,614
students
8.5 hours
content
Jul 2023
last update
$99.99
regular price
What you will 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
2254351
udemy ID
3/5/2019
course created date
5/18/2019
course indexed date
Bot
course submited by