What you’ll be studying
Basic Architecture for Databases (Tables, Columns, Data Types, Primary Keys, Normalization)
Use SQL Management Studio from Microsoft
SELECT Statements: Single-table queries (Filtering, Ordering, Grouping)
DELETE: How to delete a database’s data
Embed INTO: How to insert a table with the data
Upload: How to update current information
Best Practices Overall Database Creation
Relationship formation and international keys
How to ask associated information from different tables
Use SQL’s Aggregate Functions
How to export the results of queries to Excel
Based on real scenarios, how to construct SQL statements
