Microsoft

Database Fundamentals

(DB-FUND.AA1) / ISBN : 978-1-64459-307-3
Lessons
Lab
TestPrep
261 Reviews
Get A Free Trial

About This Course

Skills You’ll Get

Download Course Outline

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
2

Create Database Objects

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

Manipulate Data

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

Understand Data Storage

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

Administer a Database

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

1

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
2

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
3

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
4

Understand Data Storage

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

Administer a Database

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

Related Courses

All Course