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

Write review
CodeSignal Ad

2,000+ Free Courses with Certificates: Coding, AI, SQL, and More

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

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 292 ratings

Start your review of Database Foundations: Database Management

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.