Online based
Downloadable exercise
Offline viewing
Fixed/flex schedule
Fixed time homework
Certificate of completion
Objectives
- Describe fundamental database concepts, including data models, database architecture, and DBMS functionalities.
- Develop a logical and physical database design using normalization techniques.
- Write complex SQL queries for data manipulation and retrieval.
- Apply constraints to ensure data integrity and consistency.
- Use DBMS tools for database creation, backup, and recovery.
- Implement indexing and query optimization techniques to improve database performance.
- Explore advanced database functionalities such as stored procedures, triggers, and views.
Level expectations
- Understand Database Concepts
- Design Databases
- Write SQL Queries
- Implement Database Constraints
- Manage Databases
- Optimize Performance
- Handle Advanced Database Features
Content
- Introduction to Databases
- Database Design and Modeling
- SQL Basics
- Advanced SQL
- Database Constraints and Integrity
- Database Administration
- Performance Optimization
- Advanced Database Features
- Hands-On Lab Projects