ANC-ITM4110.AA1
ITM4110 - Database Management
- Practice in 26 Hands-On Labs — nothing to install
- 5 Interactive Lessons and 23 topics mapped to the official exam objectives
- 26 Practice Test Questions
Beginner Self-paced · 1 year access
26 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
5Interactive Lessons
23Topics
26LiveLab
26Practice Test Questions
301Videos
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 · 7 LiveLab +
- Understand How Data is Stored in Tables
- Understand Relational Database Concepts
- Understand Data Manipulation Language (DML)
- Understand Data Definition Language (DDL)
- Summary
7 LiveLab in this lesson — see the labs panel →
02 Create Database Objects 5 topics · 5 LiveLab +
- Choose Data Types
- Understand Tables and How to Create them
- Create Views
- Create Stored Procedures and Functions
- Summary
5 LiveLab in this lesson — see the labs panel →
03 Manipulate Data 6 topics · 7 LiveLab +
- Select Data
- Insert Data
- Update Data
- Delete Data
- Transaction Controls
- Summary
7 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 · 3 LiveLab +
- Understand Database Security Concepts
- Understand Database Backups and Restore
- Summary
3 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
26 LiveLabs- Creating 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
- Using the CREATE Command
- Handling NULL Values
- Inserting Values into a Table using the Stored Procedure
- Using the CREATE VIEW Syntax
- Creating a Stored Procedure
- Altering a Stored Procedure
- Using the SELECT DISTINCT Statement
- Using the SELECT, FROM, and WHERE Clauses
- Using the ORDER BY Keyword
- Using a Simple Inner Join
- Using the INSERT statement
- Using the UPDATE Statement
- Using the DELETE Statement
- 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
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Prepare for ITM4110 - Database Management
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
- 26 LiveLab included
- Certificate of completion
No credit card required