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

Database Foundations: Database Management

via LinkedIn Learning

Go to class Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

2 hours 15 minutes
Sessions

On-Demand
Level

Intermediate

Found in

Part of

Become a Database Administrator

Datacamp

Power BI Fundamentals - Create visualizations and dashboards from scratch

OpenLearning

Future-Proof Your Career: AI Manager Masterclass

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

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