Overview
-
Learn the basics of building databases in a platform agnostic way so you can continue on to other platforms later. Explore database setup, servers, GUIs, tables, objects, and more.
Syllabus
-
Introduction
- An introduction to database foundations
- What you should know
- Using the exercise files
- What is a database?
- Storing data efficiently
- Relational database management systems
- The client-server model
- Purpose of the playground
- Install Docker
- Database server containers
- RDBMS command-line interfaces
- Challenge: Create a server container
- Solution: Create a server container
- Management interfaces
- Install Azure Data Studio
- Connect to a database server
- Explore the server’s contents
- Create a database
- Challenge: Create a database
- Solution: Create a database
- Structured Query Language
- Organize a database with schemas
- Table columns
- Create tables
- Alter tables
- Reserved keywords
- Challenge: Create a table
- Solution: Create a table
- Table rows
- Add records
- Update and delete records
- Saving and using SQL scripts
- Challenge: Add data to a table
- Solution: Add data to a table
- Querying data
- Return data with SELECT and FROM
- Filter rows with WHERE
- Sort values with ORDER BY
- Combine data with JOIN
- Limiting the number of rows returned
- Display column aliases with AS
- Mathematical operations
- Use built-in functions
- Aggregate data with GROUP BY
- Filtering groups with HAVING
- Challenge: Query data
- Solution: Query data
- Next steps
