Database Foundations: Database Management

Focused View

Adam Wilbert

2:14:27

0 View

01 Introduction

001 Managing database performance.mp4

01:02

002 What you should know.mp4

00:50

003 Set up the database servers.mp4

06:53

004 Create the Two Trees database.mp4

07:09

02 Database Views

001 Save queries as database view objects.mp4

02:27

002 Create a database view.mp4

06:34

003 Views and database maintenance.mp4

06:39

004 Views and database security.mp4

02:30

005 Challenge Create a view.mp4

01:05

006 Solution Create a view.mp4

10:59

03 Query Performance

001 The query optimizer.mp4

05:01

002 Reading execution plans.mp4

06:54

003 View a SQL Server execution plan.mp4

06:20

004 View a PostgreSQL execution plan.mp4

03:16

005 Control query plans with hints.mp4

03:11

04 Transactions

001 Transactions and data consistency.mp4

02:12

002 ACID properties.mp4

01:58

003 Commit and rollback transactions.mp4

06:27

004 Understanding concurrency and locks.mp4

06:12

05 Data and Object Management

001 Explore the system tables.mp4

04:57

002 Duplicate tables.mp4

04:08

003 Delete data with TRUNCATE.mp4

02:28

004 Remove database objects with DROP.mp4

02:19

005 Create temporary tables.mp4

06:26

06 Functions and Stored Procedures

001 Add programming elements to the database.mp4

03:54

002 Create a function.mp4

04:51

003 Create a stored procedure in PostgreSQL.mp4

04:30

004 Create a stored procedure in SQL Server.mp4

03:06

005 Challenge Write a stored procedure.mp4

00:58

006 Solution Write a stored procedure.mp4

08:07

07 Conclusion

001 Next steps.mp4

01:04

Description

In the realm of relational databases, the table is the main event, the showstopper, the lead singer, the king. However, there are several other components of databases that are just as vital to a fully functioning system. In this course—the third part of his Database Foundations series—Adam Wilbert turns the spotlight on the supporting cast of database management characters. He covers topics like view objects, query performance, transactions, and stored procedures, and shows how each is an integral part of database management. Adam also includes challenges designed to test your skills as the course advances. As Adam illustrates, knowledge of these elements of database management can enhance your system performance and lead to a more consistent end-user experience.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.