Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Database Foundations: Database Management

via LinkedIn Learning

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Part three of the Database Foundations series focuses on data management.

Syllabus

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

Taught by

Adam Wilbert

Reviews

4.7 rating at LinkedIn Learning based on 222 ratings

Start your review of Database Foundations: Database Management

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.