Microsoft

Database Fundamentals

(DB-FUND.AA1)/ISBN:978-1-64459-307-3

This course includes
Database Fundamentals

Lessons

5+ Lessons | 50+ Quizzes | 76+ Flashcards | 76+ Glossary of terms

TestPrep

50+ Pre Assessment Questions | 2+ Full Length Tests | 54+ Post Assessment Questions | 108+ Practice Test Questions

Hands-On Labs

43+ LiveLab | 42+ Video tutorials | 36+ Minutes

Video Lessons

319+ Videos | 05:11+ Hours

Need guidance and support? Click here to check our Instructor Led Course.

Here's what you will learn

Download Course Outline

Lessons 1: Understand Core Database Concepts

  • Understand How Data is Stored in Tables
  • Understand Relational Database Concepts
  • Understand Data Manipulation Language (DML)
  • Understand Data Definition Language (DDL)
  • Summary

Lessons 2: Create Database Objects

  • Choose Data Types
  • Understand Tables and How to Create them
  • Create Views
  • Create Stored Procedures and Functions
  • Summary

Lessons 3: Manipulate Data

  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Transaction Controls
  • Summary

Lessons 4: Understand Data Storage

  • Understand Normalization
  • Understand Primary, Foreign, and Composite keys
  • Understand Indexes
  • Summary

Lessons 5: Administer a Database

  • Understand Database Security Concepts
  • Understand Database Backups and Restore
  • Summary

Hands-on LAB Activities

Understand Core Database Concepts

  • Creating a Database
  • Deleting a Database
  • Adding a Column to a Table
  • Renaming a Table
  • Modifying a Column in a Table
  • Dropping a Column from a Table
  • Using the SELECT Command
  • Creating an ER Diagram
  • Using the CREATE Command

Create Database Objects

  • Exceeding Data Type Limit
  • Handling NULL Values
  • Inserting Values into a Table using the Stored Procedure
  • Creating an Inline Table-Valued Function
  • Using the CREATE VIEW Syntax
  • Using the ALTER VIEW Statement
  • Creating a View using the WITH CHECK OPTION Clause
  • Creating a Stored Procedure
  • Altering a Stored Procedure
  • Modifying Stored Proc Definitions

Manipulate Data

  • Using the SELECT DISTINCT Statement
  • Using the SELECT, FROM, and WHERE Clauses
  • Using the ORDER BY Keyword
  • Using the UNION Operator
  • Using the INTERSECT Operator
  • Using the EXCEPT Operator
  • Using LEFT OUTER JOIN
  • Using RIGHT OUTER JOIN
  • Using FULL OUTER JOIN
  • Using CROSS JOIN
  • Using a Simple Inner Join
  • Using a Complex Inner Join
  • Using the INSERT statement
  • Using the UPDATE Statement
  • Using the DELETE Statement
  • Using Transaction Controls

Understand Data Storage

  • Using Referential Integrity Constraints
  • Creating a Function-Based Index
  • Using a Function-Based Index
  • Creating a Non-Clustered Index

Administer a Database

  • Analyzing Interpersonal Skills
  • Adding a New Login
  • Accessing the Database Roles
  • Creating a Backup