About this Course
This course provides a broad and general understanding of the technical concepts that are often considered assumed knowledge by employers and educators in the database industry. Learn about the Relational Database Management System (RDMS), design and implement a basic relational database from scratch, and explore the Structured Query Language (SQL) used to create, manipulate and operate a relational database.
You can take this course on its own (single-course enrollment); you can also apply it towards the Certificate in IT Foundations. You can also take it in preparation for the Certificate in Database Management, the Certificate in SQL Server Development, the Certificate in Data Visualization or the Certificate in Data Analytics: Techniques for Decision Making.
- The technologies, vocabulary, mathematics and economics supporting database systems
- The database development life cycle (spec, design, build, operate)
- Transactional databases vs. Decision Support databases
- Designing a basic database using Entity Relationship Diagram (ERD) modeling and an introduction to normalization
- Basic database security and administration
- Career tracks
Students should expect up to nine hours of work a week, including class sessions.