About
This comprehensive database management course is designed to provide participants with a solid foundation in database concepts, theory, and practical skills. Participants will learn how to design, implement, manage, and optimize relational databases using industry-standard technologies and best practices. The course will cover topics ranging from Database fundamentals to advanced Database Administration and Optimization techniques. Key Topics Covered: Overview of different types of databases RDBMS Entity-Relationship (ER) modeling Designing schemas and tables Basic SQL queries (SELECT, INSERT, UPDATE, DELETE) Advanced query techniques (nested queries, correlated subqueries) Dimensional modeling Introduction to NoSQL databases Capstone Project at end Course Details: Weekly (Mon-Fri) and week-night (2-3x/week) options available 144 in-class hours 12 week program Certificate Course