on-demand course

Database Fundamentals LiveLessons

with Eric Johnson

October 2019

Beginner

6h 42m

English

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Database Fundamentals LiveLessons (Video Training): Introduction
3m 25s
Learning objectives
46s
1.1 Understand tables
7m 8s
1.2 Understand and select primary keys
14m 19s
1.3 Understand foreign keys
15m 16s
Learning objectives
44s
2.1 Understand database normalization
23m 53s
2.2 Understand indexes and how they are used in databases
8m 12s
2.3 Configure non-clustered indexes
19m 17s
2.4 Configure clustered indexes
10m 56s
Learning objectives
57s
3.1 Understand data definition language (DDL)
4m 24s
3.2 Choose appropriate data types
15m 15s
3.3 Create tables
28m 2s
3.4 Understand and create views
12m 18s
3.5 Understand and create stored procedures and functions
25m 2s
Learning objectives
41s
4.1 Understand data manipulation language (DML)
4m 8s
4.2 Read data using SELECT statements
22m 32s
4.3 Query multiple tables with join statements
17m 7s
4.4 Use UNION and INTERSECT statements
10m 15s
4.5 Add data using INSERT statements
14m 40s
4.6 Change data using UPDATE statements
16m 26s
4.7 Remove data using DELETE statements
12m 59s
Learning objectives
44s
5.1 Understand the need for database security
3m 16s
5.2 Understand logins and users
14m 51s
5.3 Set permissions on database objects
17m 38s
5.4 Understand database roles
19m 30s
Learning objectives
43s
6.1 Understand different types of backups
9m 54s
6.2 Create and verify backups
17m 25s
6.3 Restore a database
16m 28s
6.4 Define a backup and recovery strategy
10m 49s
Database Fundamentals LiveLessons (Video Training): Summary
2m 36s

Content preview from Database Fundamentals LiveLessons

1.3 Understand foreign keys

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

You might also like

Introducing SQL and Relational Databases

Introducing SQL and Relational Databases

Allen Taylor

Oracle DBA Fundamentals

Oracle DBA Fundamentals

Robert G. Freeman

Getting Started with SQL

Getting Started with SQL

Thomas Nield

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition

John L. Viescas

Publisher Resources

ISBN: 9780136617105