Database Fundamentals LiveLessons

Database Fundamentals LiveLessons

by Eric Johnson
Released October 2019
Publisher(s): Addison-Wesley Professional
ISBN: 0136617106

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

6+ Hours of Video Instruction

Learn the fundamentals of databases.

Overview

In MTA 98-364 Database Fundamentals LiveLessons, you gain the knowledge required to work with and design relational databases and prepare for Microsoft MTA Exam 98-364.

Drawing on his experience as a SQL Server MVP, Eric Johnson guides you from the basic elements of databases, such as tables and indexes, and progresses into the principles of database design and layout. Building on that foundation, you learn how to perform more advanced skills, such as database administration, backup, and security.

Topics are organized into easily digestible lessons so you can learn these skills with ease. This video course, along with additional study, helps you achieve the hands-on experience recommended to take the exam and demonstrate your mastery of database fundamentals.

Skill Level

  • Beginner

Learn How To
  • Understand concepts involved with database storage
  • Perform database normalization
  • Create database objects
  • Manipulate data in databases
  • Secure databases
  • Back up and restore databases

Who Should Take This Course
  • Developers and system administrators with no prior experience working with databases

Course Requirements
  • Knowledge of Windows operating system
  • IT background with no prior database experience

About Pearson Video Training

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at  http://www.informit.com/video.

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.

Table of contents

  1. Introduction
    1. Database Fundamentals LiveLessons (Video Training): Introduction
  2. Lesson 1: Understanding Database Concepts
    1. Learning objectives
    2. 1.1 Understand tables
    3. 1.2 Understand and select primary keys
    4. 1.3 Understand foreign keys
  3. Lesson 2: Understanding Database Storage
    1. Learning objectives
    2. 2.1 Understand database normalization
    3. 2.2 Understand indexes and how they are used in databases
    4. 2.3 Configure non-clustered indexes
    5. 2.4 Configure clustered indexes
  4. Lesson 3: Creating Database Objects
    1. Learning objectives
    2. 3.1 Understand data definition language (DDL)
    3. 3.2 Choose appropriate data types
    4. 3.3 Create tables
    5. 3.4 Understand and create views
    6. 3.5 Understand and create stored procedures and functions
  5. Lesson 4: Manipulating Data
    1. Learning objectives
    2. 4.1 Understand data manipulation language (DML)
    3. 4.2 Read data using SELECT statements
    4. 4.3 Query multiple tables with join statements
    5. 4.4 Use UNION and INTERSECT statements
    6. 4.5 Add data using INSERT statements
    7. 4.6 Change data using UPDATE statements
    8. 4.7 Remove data using DELETE statements
  6. Lesson 5: Understanding Database Security
    1. Learning objectives
    2. 5.1 Understand the need for database security
    3. 5.2 Understand logins and users
    4. 5.3 Set permissions on database objects
    5. 5.4 Understand database roles
  7. Lesson 6: Understanding Database Backup and Restore
    1. Learning objectives
    2. 6.1 Understand different types of backups
    3. 6.2 Create and verify backups
    4. 6.3 Restore a database
    5. 6.4 Define a backup and recovery strategy
  8. Summary
    1. Database Fundamentals LiveLessons (Video Training): Summary

Product information

  • Title: Database Fundamentals LiveLessons
  • Author(s): Eric Johnson
  • Release date: October 2019
  • Publisher(s): Addison-Wesley Professional
  • ISBN: 0136617106