Database Fundamentals
(DB-FUND.AA1) / ISBN : 978-1-64459-307-3
About This Course
Skills You’ll Get
Get the support you need. Enroll in our Instructor-Led Course.
Interactive Lessons
5+ Interactive Lessons | 50+ Quizzes | 76+ Flashcards | 76+ Glossary of terms
Gamified 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 | 00+ Minutes
Video Lessons
319+ Videos | 05:43+ Hours
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
Create Database Objects
- Choose Data Types
- Understand Tables and How to Create them
- Create Views
- Create Stored Procedures and Functions
- Summary
Manipulate Data
- Select Data
- Insert Data
- Update Data
- Delete Data
- Transaction Controls
- Summary
Understand Data Storage
- Understand Normalization
- Understand Primary, Foreign, and Composite keys
- Understand Indexes
- Summary
Administer a Database
- Understand Database Security Concepts
- Understand Database Backups and Restore
- Summary
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