Database Fundamentals
(DB-FUND.AA1)/ISBN:978-1-64459-307-3
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 OutlineLessons 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