Database Fundamentals

Focused View

6:42:26

51 View

Introduction

001. Database Fundamentals LiveLessons (Video Training) Introduction.mp4

03:25

Lesson 1 Understanding Database Concepts

001. Learning objectives.mp4

00:46

002. 1.1 Understand tables.mp4

07:08

003. 1.2 Understand and select primary keys.mp4

14:19

004. 1.3 Understand foreign keys.mp4

15:16

Lesson 2 Understanding Database Storage

001. Learning objectives.mp4

00:44

002. 2.1 Understand database normalization.mp4

23:52

003. 2.2 Understand indexes and how they are used in databases.mp4

08:12

004. 2.3 Configure non-clustered indexes.mp4

19:17

005. 2.4 Configure clustered indexes.mp4

10:56

Lesson 3 Creating Database Objects

001. Learning objectives.mp4

00:57

002. 3.1 Understand data definition language (DDL).mp4

04:23

003. 3.2 Choose appropriate data types.mp4

15:15

004. 3.3 Create tables.mp4

28:01

005. 3.4 Understand and create views.mp4

12:17

006. 3.5 Understand and create stored procedures and functions.mp4

25:02

Lesson 4 Manipulating Data

001. Learning objectives.mp4

00:41

002. 4.1 Understand data manipulation language (DML).mp4

04:08

003. 4.2 Read data using SELECT statements.mp4

22:32

004. 4.3 Query multiple tables with join statements.mp4

17:07

005. 4.4 Use UNION and INTERSECT statements.mp4

10:15

006. 4.5 Add data using INSERT statements.mp4

14:40

007. 4.6 Change data using UPDATE statements.mp4

16:25

008. 4.7 Remove data using DELETE statements.mp4

12:58

Lesson 5 Understanding Database Security

001. Learning objectives.mp4

00:44

002. 5.1 Understand the need for database security.mp4

03:16

003. 5.2 Understand logins and users.mp4

14:50

004. 5.3 Set permissions on database objects.mp4

17:37

005. 5.4 Understand database roles.mp4

19:29

Lesson 6 Understanding Database Backup and Restore

001. Learning objectives.mp4

00:43

002. 6.1 Understand different types of backups.mp4

09:54

003. 6.2 Create and verify backups.mp4

17:25

004. 6.3 Restore a database.mp4

16:27

005. 6.4 Define a backup and recovery strategy.mp4

10:49

Summary

001. Database Fundamentals LiveLessons (Video Training) Summary.mp4

02:36

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Pearson's video training library is an indispensable learning tool for today's competitive job market. Having essential technology training and certifications can open doors for career advancement and life enrichment. We take learning personally. We've published hundreds of up-to-date videos on wide variety of key topics for Professionals and IT Certification candidates. Now you can learn from renowned industry experts from anywhere in the world, without leaving home.