| Unit 1 |
Welcome |
| Unit 1 |
Welcome |
| Unit 1 |
Understand How Data is stored in Tables |
| Unit 2 |
Understand Relational Database Concepts |
| Unit 3 |
Understand Data Manipulation Language (DML) |
| Unit 4 |
Understand Data Definition Language (DDL) |
| Unit 1 |
Choose Data Types - Part 1 |
| Unit 2 |
Choose Data Types - Part 2 |
| Unit 3 |
Understand Tables and How to Create Them |
| Unit 4 |
Create Views |
| Unit 5 |
Create Stored Procedures and Functions |
| Unit 1 |
Select Data - Part 1 |
| Unit 2 |
Select Data - Part 2 |
| Unit 3 |
Insert and Update Data |
| Unit 4 |
Delete Data |
| Unit 1 |
Understand Normalization |
| Unit 2 |
Understand Primary, Foreign and Composite Keys |
| Unit 3 |
Understand Indexes |
| Unit 1 |
Understand Database Security Concepts |
| Unit 2 |
Understand Database Backups and Restore |
| Unit 1 |
Bonus Exam 1 |
| Unit 2 |
Bonus Exam 2 |
| Unit 1 |
Data Schemas and Dimensions |
| Unit 2 |
Data Types, Structures and File Formats |
| Unit 1 |
Data Acquisition Concepts |
| Unit 2 |
Data Manipulation Techniques |
| Unit 3 |
Data Manipulation and Query Optimization |
| Unit 1 |
Statistical Methods |
| Unit 2 |
Types of Analysis |
| Unit 3 |
Common Data Analytics Tools |
| Unit 1 |
Design Components for Reports |
| Unit 2 |
Dashboard Development |
| Unit 3 |
Appropriate Type of Visualization |
| Unit 4 |
Compare and Contrast Types of Reports. |
| Unit 1 |
Important Data Governance Concepts. |
| Unit 2 |
Data Quality Control Concepts |
| Unit 3 |
Master Data Management (MDM) Concepts. |
| Unit 1 |
AI and Generative AI in Analytics |
| Unit 2 |
Cloud Data Environments |
| Unit 3 |
Governance of AI and Data |
| Unit 1 |
Introduction |
| Unit 2 |
Create Worksheets and Workbooks |
| Unit 3 |
Create Worksheets and Workbooks 2 |
| Unit 4 |
Navigate through Worksheets and Workbooks |
| Unit 5 |
Navigate through Worksheets and Workbooks 2 |
| Unit 6 |
Format Worksheets and Workbooks |
| Unit 7 |
Format Worksheets and Workbooks 2 |
| Unit 8 |
Format Worksheets and Workbooks 3 |
| Unit 9 |
Format Worksheets and Workbooks 4 |
| Unit 10 |
Format Worksheets and Workbooks 5 |
| Unit 11 |
Format Worksheets and Workbooks 6 |
| Unit 12 |
Format Worksheets and Workbooks 7 |
| Unit 13 |
Customize Options and Views for Worksheets and Workbooks |
| Unit 14 |
Customize Options and Views for Worksheets and Workbooks 2 |
| Unit 15 |
Customize Options and Views for Worksheets and Workbooks 3 |
| Unit 16 |
Customize Options and Views for Worksheets and Workbooks 4 |
| Unit 17 |
Customize Options and Views for Worksheets and Workbooks 5 |
| Unit 18 |
Configure Worksheets and Workbooks to Print or Save |
| Unit 19 |
Configure Worksheets and Workbooks to Print or Save 2 |
| Unit 1 |
Insert Data in Cells and Ranges |
| Unit 2 |
Insert Data in Cells and Ranges 2 |
| Unit 3 |
Insert Data in Cells and Ranges 3 |
| Unit 4 |
Format Cells and Ranges |
| Unit 5 |
Format Cells and Ranges 2 |
| Unit 6 |
Format Cells and Ranges 3 |
| Unit 7 |
Format Cells and Ranges 4 |
| Unit 8 |
Order and Group Cells and Ranges |
| Unit 9 |
Order and Group Cells and Ranges 2 |
| Unit 10 |
Order and Group Cells and Ranges 3 |
| Unit 11 |
Order and Group Cells and Ranges 4 |
| Unit 1 |
Create a Table |
| Unit 2 |
Modify a Table |
| Unit 3 |
Filter and Sort a Table |
| Unit 1 |
Utilize Cell Ranges and References in Formulas and Functions |
| Unit 2 |
Summarize Data with Functions |
| Unit 3 |
Utilize Conditional Logic in Functions |
| Unit 4 |
Format and Modify Text with Functions |
| Unit 1 |
Create a Chart |
| Unit 2 |
Format a Chart |
| Unit 3 |
Insert and Format an Object |
| Unit 4 |
Insert and Format an Object 2 |
| Unit 1 |
Introduction |
| Unit 2 |
Part 1 |
| Unit 3 |
Part 2 |
| Unit 4 |
Part 3 |
| Unit 5 |
Part 4 |
| Unit 6 |
Part 5 |
| Unit 1 |
Introduction |
| Unit 2 |
Part 1 |
| Unit 3 |
Part 2 |
| Unit 4 |
Part 3 |
| Unit 5 |
Part 4 |
| Unit 6 |
Part 5 |
| Unit 1 |
Introduction |
| Unit 2 |
Part 1 |
| Unit 3 |
Part 2 |
| Unit 4 |
Part 3 |
| Unit 5 |
Part 4 |
| Unit 6 |
Part 5 |
| Unit 7 |
Part 6 |