ANC-DBM4310.AD1
DBM4310: Advanced Data Management
- Practice in 22 Laboratorios prácticos — nothing to install
- 5 Lecciones interactivas y 31 topics mapped to the official exam objectives
- 42 Preguntas del examen de práctica
Intermediate A tu propio ritmo · 1 año de acceso
22 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
5Lecciones interactivas
31Topics
22Laboratorio en vivo
42Preguntas del examen de práctica
44Tarjetas didácticas
44Glosario de términos
01 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
5 Lecciones interactivas · 31 topics01 Using Subqueries to Perform Advanced Querying 8 topics · 6 Laboratorio en vivo +
- Lesson Objectives
- Introduction
- TOPIC A: Search Based on Unknown Values
- TOPIC B: Compare a Value with Unknown Values
- TOPIC C: Search Based on the Existence of Records
- TOPIC D: Generate Output Using Correlated Subqueries
- TOPIC E: Filter Grouped Data Within Subqueries
- TOPIC F: Perform Multiple-Level Subqueries
6 Laboratorio en vivo in this lesson — see the labs panel →
02 Manipulating Table Data 4 topics · 1 Laboratorio en vivo +
- Lesson Objectives
- Introduction
- TOPIC A: Insert Data
- TOPIC B: Modify and Delete Data
1 Laboratorio en vivo in this lesson — see the labs panel →
03 Manipulating the Table Structure 7 topics · 7 Laboratorio en vivo +
- Lesson Objectives
- Introduction
- TOPIC A: Create a Table
- TOPIC B: Create a Table with Constraints
- TOPIC C: Modify a Table's Structure
- TOPIC D: Back Up Tables
- TOPIC E: Delete Tables
7 Laboratorio en vivo in this lesson — see the labs panel →
04 Working with Views 6 topics · 5 Laboratorio en vivo +
- Lesson Objectives
- Introduction
- TOPIC A: Create a View
- TOPIC B: Manipulate Data in Views
- TOPIC C: Create Aliases
- TOPIC D: Modify and Delete Views
5 Laboratorio en vivo in this lesson — see the labs panel →
05 Indexing Data and Managing Transactions 6 topics · 3 Laboratorio en vivo +
- Lesson Objectives
- Introduction
- TOPIC A: Create Indexes
- TOPIC B: Drop Indexes
- TOPIC C: Create Transactions
- TOPIC D: Commit Transactions
3 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
22 Laboratorio en vivos- Searching for Records Based on Unknown Values
- Searching for Records by Comparing Them with Unknown Values
- Searching for Records Based on Their Existence in Another Table
- Generating Output Using Correlated Subqueries
- Filtering Grouped Data Within a Subquery
- Generating Output Using Nested Subqueries
- Inserting, Modifying, and Deleting Data
- Creating a Table
- Creating a Table with Constraints
- Adding and Dropping Columns in a Table
- Adding and Dropping Constraints in a Table
- Modifying the Column Definition in a Table
- Backing Up a Table
- Deleting a Table
- Creating Views
- Creating Views with Schema Binding
- Manipulating Data in Views
- Creating Aliases
- Modifying and Deleting Views
- Creating Indexes
- Dropping Indexes
- Creating and Comitting Transactions
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
Keep going
You might also like
Prepárate para DBM4310: Advanced Data Management
Pago único. Acceso completo durante 1 año. Comienza con una prueba gratuita si primero quieres echar un vistazo.
- 1 año de acceso completo
- 22 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito