DB-FUND.AA1
Database Fundamentals
- Practice in 43 Hands-On Labs — nothing to install
- 5 Interactive Lessons and 23 topics mapped to the official exam objectives
- 201 Practice Test Questions and 2 Full Length Tests
Beginner Self-paced · 1 year access 4.6/5 (261 Reviews)
43 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
5Interactive Lessons
23Topics
43LiveLab
201Practice Test Questions
319Videos
76Flashcards
76Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
5 Interactive Lessons · 23 topics01 Understand Core Database Concepts 5 topics · 9 LiveLab +
- Understand How Data is Stored in Tables
- Understand Relational Database Concepts
- Understand Data Manipulation Language (DML)
- Understand Data Definition Language (DDL)
- Summary
9 LiveLab in this lesson — see the labs panel →
02 Create Database Objects 5 topics · 10 LiveLab +
- Choose Data Types
- Understand Tables and How to Create them
- Create Views
- Create Stored Procedures and Functions
- Summary
10 LiveLab in this lesson — see the labs panel →
03 Manipulate Data 6 topics · 16 LiveLab +
- Select Data
- Insert Data
- Update Data
- Delete Data
- Transaction Controls
- Summary
16 LiveLab in this lesson — see the labs panel →
04 Understand Data Storage 4 topics · 4 LiveLab +
- Understand Normalization
- Understand Primary, Foreign, and Composite keys
- Understand Indexes
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Administer a Database 3 topics · 4 LiveLab +
- Understand Database Security Concepts
- Understand Database Backups and Restore
- Summary
4 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
43 LiveLabs- 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
- Applying Interpersonal Skills in Agile Project Management
- Adding a New Login
- Accessing the Database Roles
- Creating a Backup
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Prepare for Database Fundamentals
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 43 LiveLab included
- Certificate of completion
No credit card required