What is SQL?
A practical SQL pathway covering relational data, filtering, sorting, joins, aggregation and data modification. Microsoft's current learning materials likewise centre SQL on querying relational data.
What you'll learn
✓Relational databases, tables and keys
✓SELECT queries, filtering and sorting
✓Aggregations, grouping and useful calculations
✓JOINs and combining related tables
✓INSERT, UPDATE, DELETE and safe data handling
What you'll be able to do
✓Write useful queries against relational data
✓Combine data from multiple tables
✓Create summary reports from databases
✓Explain database results clearly
Suggested practical projects
Customer database queries
A practical project idea to turn learning into portfolio evidence.
Sales reporting database
A practical project idea to turn learning into portfolio evidence.
Training records analysis
A practical project idea to turn learning into portfolio evidence.