WGU-D191.AJ1
D191 - Advanced Data Management
- Practice in 87 Hands-On Labs — nothing to install
- 10 Interactive Lessons and 52 topics mapped to the official exam objectives
- 89 Practice Test Questions
Self-paced · 1 year access
87 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
10Interactive Lessons
52Topics
87LiveLab
89Practice Test Questions
40Flashcards
40Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
10 Interactive Lessons · 52 topics01 Welcome to Advanced Data Management 3 topics · 2 LiveLab +
- About this Course
- About the Labs in this Course
- Learning Resources
2 LiveLab in this lesson — see the labs panel →
02 OPTIONAL: Understanding and Describing Data 5 topics +
- Introduction
- The World of Data
- Methods of Descriptive Statistics
- Statistical Significance Testing
- Summary
03 The Basics of SQL for Analytics 9 topics · 57 LiveLab +
- Introduction
- Relational Databases and SQL
- Basic Data Types of SQL
- Reading Tables: The SELECT Query
- Creating Tables
- Updating Tables
- Deleting Data and Tables
- SQL and Analytics
- Summary
57 LiveLab in this lesson — see the labs panel →
04 SQL for Data Preparation 4 topics · 4 LiveLab +
- Introduction
- Assembling Data
- Transforming Data
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Aggregate Functions for Data Analysis 6 topics · 15 LiveLab +
- Introduction
- Aggregate Functions
- Aggregate Functions with GROUP BY
- The HAVING Clause
- Using Aggregates to Clean Data and Examine Data Quality
- Summary
15 LiveLab in this lesson — see the labs panel →
06 OPTIONAL: Window Functions for Data Analysis 4 topics +
- Introduction
- Window Functions
- Statistics with Window Functions
- Summary
07 Importing and Exporting Data 6 topics · 6 LiveLab +
- Introduction
- The COPY Command
- Using R with Our Database
- Using Python with Our Database
- Best Practices for Importing and Exporting Data
- Summary
6 LiveLab in this lesson — see the labs panel →
08 OPTIONAL: Analytics Using Complex Data Types 7 topics +
- Introduction
- Date and Time Data Types for Analysis
- Performing Geospatial Analysis in Postgres
- Using Array Data Types in Postgres
- Using JSON Data Types in Postgres
- Text Analytics Using Postgres
- Summary
09 Performant SQL 5 topics · 3 LiveLab +
- Introduction
- Database Scanning Methods
- Performant Joins
- Functions and Triggers
- Summary
3 LiveLab in this lesson — see the labs panel →
10 OPTIONAL: Using SQL to Uncover the Truth – a Case Study 3 topics +
- Introduction
- Case Study
- Summary
Hands-On Labs Our edge
87 LiveLabs- Sandbox Lab
- PostgreSQL
- Conceptual Schema - ER Model
- Physical Schema - ER Model
- Creating a Database
- Creating a Database
- Create Table
- Display Table and Table Structure
- Creating a Table
- Creating a Table to Store Encryption Keys
- Create Table
- Display Table and Table Structure
- Creating a Table
- Creating a Table to Store Login Information
- Retrieving Data from a Table
- Retrieving Specific Column Data from a Table
- Selecting Specific Columns from a Table
- Retrieving Data from a Table
- Retrieving Specific Column Data from a Table
- Update Data in a Table
- Updating Data in a Table
- Updating Specific Data in a Table
- Adding Data in the Table
- Update Data in a Table
- Adding New Data in a Table
- Updating Data in a Table
- Updating Specific Data in a Table
- Adding Data in the Table
- Adding New Data in a Table
- Copying Data from One Table to Another Table
- Copying Data from One Table to Another Table
- Selecting Specific Columns from a Table
- Adding a Column in a Table
- Modifying a Column in a Table
- Adding a Comment
- Inserting Data from One Table to Another
- Adding a New Column in a Table
- Using ALTER Command to Modify a Column in a Table
- Adding a Column in a Table to Store timestamp
- Modifying a Column in a Table to Include a Comment
- Adding a Column in a Table
- Modifying a Column in a Table
- Adding a Comment
- Inserting Data from One Table to Another
- Adding a New Column in a Table
- Using ALTER Command to Modify a Column in a Table
- Adding a Column in a Table to Store Timestamp
- Modifying a Column in a Table to Include a Comment
- Dropping a Database
- Delete Rows
- Deleting Specific Data from a Table
- Delete Rows
- Deleting Specific Data from a Table
- Deleting a Table
- Deleting All the Data from a Table
- Deleting a Column from a Table
- Deleting a Table
- Deleting All the Data from a Table
- Deleting a Column from a Table
- Joining Tables
- Joining Tables
- Using DISTINCT Keyword
- Using DISTINCT Keyword
- Using COUNT Function in GROUP BY Clause
- Using CONCAT Function
- Using CONCAT Function
- Using ORDER BY Clause
- Displaying Data in Alphabetical Order
- Using GROUP BY Clause
- Using ORDER BY Clause
- Displaying Data in Alphabetical Order
- Using GROUP BY Clause
- Using COUNT Function in GROUP BY Clause
- Using Operators in GROUP BY Clause
- Using Operators in GROUP BY Clause
- Normalizing the Unnormalized Model to 1NF
- Normalizing from 1NF to 2NF
- Normalizing the 2NF to 3NF
- Create a View
- Creating a View
- Creating a View Using UNION Operator
- Create a View
- Creating a View
- Creating a View Using the UNION Operator
- Create an Index
- Create an Index
- Creating a Function
Labs run in your browser — nothing to install.
Prepare for D191 - Advanced Data 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
- 87 LiveLab included
- Certificate of completion
No credit card required