Database Management Essentials

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle, MySQL, or PostgreSQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle, MySQL, or PostgreSQL

• Create relational databases and write SQL queries for business reporting
• Design entity relationship diagrams (ERDs)
• Analyze table designs to minimize redundancy
• Use tools like Oracle, MySQL, PostgreSQL, and ER diagrammers

• Basic familiarity with the topic and its common terminology
• Readiness to practice through applied exercises or case-based work