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 or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant 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 or MySQL.Introduction to Web Domains, Hosting & S.E.O
The target group of this course are people without any prior knowledge of databases, or persons who are end users of databases but have never been involved in designing a database, or lastly, persons who may have used 4GL tools to build database applications, but who lack the conceptual background on relational databases and knowledge as to how to optimise the design of relational tables for an application.
We assume that you have previously passed a computer literacy course or have end-user experience in using computers and the Microsoft Windows environment.
The goal of this short course is to provide an introduction to conceptual database design. Conceptual databases are designed where basic concepts are introduced and students get the opportunity to apply these concepts.