Database Foundations: Database Management

Part three of the Database Foundations series focuses on data management.

Introduction

• Managing database performance
• What you should know
• Set up the database servers
• Create the Two Trees database

1. Database Views

• 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

2. Query Performance

• The query optimizer
• Reading execution plans
• View a SQL Server execution plan
• View a PostgreSQL execution plan
• Control query plans with hints

3. Transactions

• Transactions and data consistency
• ACID properties
• Commit and rollback transactions
• Understanding concurrency and locks

4. Data and Object Management

• Explore the system tables
• Duplicate tables
• Delete data with TRUNCATE
• Remove database objects with DROP
• Create temporary tables

5. Functions and Stored Procedures

• 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

Conclusion

• Next steps