Part three of the Database Foundations series focuses on data management.
Overview
Syllabus
Introduction
- Managing database performance
- What you should know
- Set up the database servers
- Create the Two Trees database
- Save queries as database view objects
- Create a database view
- Views and database maintenance
- Views and database security
- Challenge: Create a view
- Solution: Create a view
- The query optimizer
- Reading execution plans
- View a SQL Server execution plan
- View a PostgreSQL execution plan
- Control query plans with hints
- Transactions and data consistency
- ACID properties
- Commit and rollback transactions
- Understanding concurrency and locks
- Explore the system tables
- Duplicate tables
- Delete data with TRUNCATE
- Remove database objects with DROP
- Create temporary tables
- Add programming elements to the database
- Create a function
- Create a stored procedure in PostgreSQL
- Create a stored procedure in SQL Server
- Challenge: Write a stored procedure
- Solution: Write a stored procedure
- Next steps
Taught by
Adam Wilbert