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
Are there any course requirements or prerequisites?
- A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)
Who this course is for:
- This course is for beginners with absolutely no experience.
- This course is for you if you are already comfortable with basic database operations.
- This course is for you if you feel a bit ‘rusty’ and need to refresh your knowledge.
- This course is for you if you want to understand design principles in database development.
- This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System
- This course is for EVERYONE!