Microsoft SQL Server Development for Everyone

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