Overview
In this Database Management Essentials course offered by Coursera in partnership with University of Colorado System, 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.
Key facts
- This course is part of the Data Warehousing for Business Intelligence Specialization
- 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.
Skills You Will Gain
- Databases
- Data Warehousing
- Oracle Databases
- PostgreSQL
- SQL
- Database Design
- Data Modeling
- Relational Databases
- Database Management Systems
- Data Integrity
Programme Structure
Courses included:
- Databases and DBMSs
- Relational Data Model and the CREATE TABLE Statement
- Basic Query Formulation with SQL
- Extended Query Formulation with SQL
- Notation for Entity Relationship Diagrams
- ERD Rules and Problem Solving
- Developing Business Data Models
- Data Modeling Problems and Completion of an ERD
Key information
Duration
- Part-time
- 3 months
- 10 hrs/week
Start dates & application deadlines
Language
Delivered
Campus Location
- Mountain View, United States
Disciplines
Management Studies Data Science & Big Data Human Computer Interaction View 463 other Short Courses in Data Science & Big Data in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- Intermediate level
- Some related experience required
Tuition Fees
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
- This short course is included with Coursera Plus subscription
Funding
Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project.