Database Fundamentals

(DB-FUND.AA1)
This course includes
Lessons
TestPrep
LiveLab
98-364 98-364
Share
$279.99
Try This Course
Are you an instructor?
Request a free evaluation copy

Database Fundamentals

Here's what you will get

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
Lab
  • 42+ Performance lab
  • 42+ Video tutorials
  • 39+ Minutes
Video Lessons
  • 319+ Videos
  • 06:03+ Hours
Here's what you will learn
Download Course Outline
  • Understand How Data is Stored in Tables
  • Understand Relational Database Concepts
  • Understand Data Manipulation Language (DML)
  • Understand Data Definition Language (DDL)
  • Summary
  • Choose Data Types
  • Understand Tables and How to Create them
  • Create Views
  • Create Stored Procedures and Functions
  • Summary
  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Transaction Controls
  • Summary
  • Understand Normalization
  • Understand Primary, Foreign, and Composite keys
  • Understand Indexes
  • Summary
  • Understand Database Security Concepts
  • Understand Database Backups and Restore
  • Summary

Hands on Activities (Performance Labs)

  • 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
  • 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
  • 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
  • Using Referential Integrity Constraints
  • Creating a Function-Based Index
  • Using a Function-Based Index
  • Creating a Non-Clustered Index
  • Adding a New Login
  • Accessing the Database Roles
  • Creating a Backup
×