Get updates on Eligibility, Admission, Placements Fees Structure
Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Course Overview
In the Database Management, Essentials course candidates can create relational databases, create entity relationship diagrams (ERDs) to construct databases, analyse excessive redundancy table designs and write SQL statements to extract information to fulfill demands for business reporting. Candidates can use either MySQL/ PostgreSQL/ Oracle to execute SQL statements and a database diagramming method like ER Assistant or Visual Paradigm to build ERDs as they improve these skills.
Database Management Basics provides the basis for a career in data warehousing, the creation of databases, business intelligence, as well as for the entire specialisation in Data Warehousing for Business Intelligence. The Database Management Essentials course has been built in a way to provide a shared base for students of specialisation. Anyone taking this particular course will be able to jump right in with writing SQL statements in MySQL/ PostgreSQL/ Oracle. The Database Management Essentials course is the first one of the 5 courses in Data Warehousing for Business Intelligence Specialisation. This specialisation encompasses skills in data architecture that are increasingly important in a wide variety of fields of technology.
The Highlights
- 100 percent online course
- Approx. 122 hours to complete the programme
- Offered by the University of Colorado
- 7-day free trial
- Shareable certificate
Programme Offerings
- online programme
- Quiz
- Assignment
- video.
Courses and Certificate Fees
| Certificate Availability | Certificate Providing Authority |
|---|---|
| yes | CU DenverCoursera |
Database Management Essentials Fees Details
Head | Amount |
1 Month | Rs. 4,115 |
3 Months | Rs. 8,230 |
6 Months | Rs. 12,345 |
Eligibility Criteria
Certification Qualifying Details
To get a certificate for the Database Management Essentials course, candidates should finish the 7 weeks long training. Candidates who are enrolled for free auditing, will not get a certificate of completion. The certificate is offered only to candidates who subscribed for the course by paying the full fee.
Technical phrases are picking up which cannot be changed.
What you will learn
After the completion of the Database Management Essentials course candidates will learn these:
- Candidates can learn the fundamentals of gain practical experience in SQL coding, structured data modelling, and develop a comprehensive knowledge of data warehouse architecture and data manipulation.
- In a data warehouse environment, candidates will have the ability to work with large data sets to create dashboards and Visual Analytics.
- To build dashboards and Visual Analytics, candidates can use OLAP (online analytical processing), MicroStrategy, which is a leading BI tool, and Visual Insights capabilities.
- Candidates will apply their skills to build a small and simple data warehouse in the final Capstone Project. They will populate it with data, and create dashboards and other visualisations to interpret and communicate the data to a large audience.
Who it is for
Application Details
Candidates applying for Database Management Essentials admission process needs to check the following steps:
Step 1: Go to the course webpage.
Step 2: The candidate needs to visit the ‘Enroll for free’ tab. The course can be accessed free for 7 days trial.
Step 3: Thereafter the candidate will sign up via Facebook or Google ID and access the programme for free
Step 4: Once the free trial is over, the candidate needs to make a fee payment per month
The Syllabus
Videos
- Specialization Introduction video lesson
- Course introduction video lecture
- Course objectives video lecture
- Topics and assignments video lecture
Readings
- Powerpoint lecture notes for lesson
- Powerpoint lecture notes for lesson
- Optional textbook
- Database management software requirements
Videos
- Database characteristics video lecture
- Organizational Roles video lecture
- DBMS overview and database definition feature video lecture
- Non-procedural access video lecture
- Transaction processing overview video lecture
- Data warehouse processing overview video lecture
- DBMS technology evolution video lecture
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Powerpoint lecture notes for lesson 6
- Powerpoint lecture notes for lesson 7
- Optional reading
Quiz
- Learning check-in
- Concept Quiz for Module 2
Videos
- Basics of relational databases video lecture
- Integrity rules video lecture
- Basic SQL CREATE TABLE statement video lecture
- Integrity constraint syntax video lecture
- Assignment 1 notes video lecture
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- University database SQL statements for Oracle and PostgreSQL
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Optional reading
- DBMS installation and usage notes
- Practice Problems for Module 3
- Extra Problems for Module 3
- Assignment for Module 3
- Self Evaluation for the Module 3 assignment
Quiz
- Concept Quiz for Module 3
- Quiz for Module 3 practice problems
- Reflective Quiz for the Module 3 Assignment
Videos
- SQL Overview video lecture
- SELECT statement introduction video lecture
- Join Operator video lecture
- Using Join operations in SQL SELECT statements video lecture
- GROUP BY clause video lecture
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Lesson examples using SQL statements
- Practice problems for Module 4
- Extra problems for Module 4
- Assignment for Module 4
- Self evaluation for the Module 4 Assignment
- Optional reading
- DBMS installation and usage notes
Quiz
- Concept Quiz for Module 4
- Quiz for the practice problems in Module 4
- Reflective Quiz for the Module 4 Assignment
Videos
- Query formulation guidelines video lecture
- Multiple table problems video lecture
- Problems involving join and grouping operations video lecture
- SQL set operators video lecture
- SQL modification statements video lecture
- Query formulation errors video lecture
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Powerpoint lecture notes for lesson 6
- Lesson examples using SQL statements
- Optional textbook reading material
- Practice problems for Module 5
- Extra problems for Module 5
- Assignment for Module 5
- Self evaluation for the Module 5 assignment
- DBMS installation and usage notes
Quiz
- Concept Quiz for Module 5
- Quiz for practice problems in Module 5
- Reflective Quiz for the Module 5 Assignment
Videos
- Database development goals video lecture
- Basic ERD notation video lecture
- Relationship variations I video lecture
- Relationship variations II video lecture
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Optional textbook reading material
- Practice problems for Module 6
- Assignment for Module 6
- Self evaluation for the Module 6 assignment
Videos
- Conceptual data modeling goals and challenges
- Design transformations I
- Analyzing narrative problems
- Design transformations II video lecture
Quiz
- Concept Quiz for Module 6
- Reflective Quiz for the Module 6 Assignment
Videos
- Basic diagram rules video lecture
- Extended diagram rules video lecture
- ERD problems I video lecture
- ERD problems II video lecture
- ER Assistant Demonstration video
- Software demonstration video for Visual Paradigm
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- ER Assistant download
- Download for Visual Paradigm
- Optional textbook reading material
- Practice Problems for Module 7
- Assignment for Module 7
- Self evaluation for the Module 7 assignment
Quiz
- Concept Quiz for Module 7
- Reflective Quiz for the Module 7 Assignment
Videos
- Conceptual data modeling goals and challenges
- Design transformations I
- Analyzing narrative problems
- Design transformations II video lecture
Readings
- Powerpoint lecture notes for lesson 1 and extras
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Optional textbook reading material
- Practice problems for Module 8
- Assignment for Module 8
- Self evaluation for the Module 8 assignment
Quiz
- Concept Quiz for Module 8
- Reflective Quiz for the Module 8 Assignment
Videos
- Data modeling problems I video lecture
- Finalizing an ERD video lecture
- Data modeling problems II video lecture
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Optional textbook reading material
- Practice Problems for Module 9
- Assignment for Module 9
- Self evaluation for the Module 9 assignment
Quiz
- Concept Quiz for Module 9
- Reflective Quiz for the Module 9 Assignment
videos
- Goals and steps of logical database design video lecture
- Conversion rules video lecture
- Conversion problems video lecture
Readings
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Optional textbook reading material
- Practice Problems for Module 10
- Assignment for Module 10
- Self evaluation for the Module 10 assignment
Quiz
- Concept Quiz for Module 10
- Reflective Quiz for the Module 10 Assignment
Video
- Modification anomalies video lecture
- Functional dependencies video lectur
- Normal forms video lecture
- Practical concerns video lecture
- Normalization problems video lecture
Readings
- Powerpoint lecture notes for lesson 1 and extras
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Optional textbook reading materials
- Practice Problems for Module 11
- Assignment for Module 11
- Self evaluation for the Module 11 assignment
Quiz
- Concept Quiz for Module 11
- Reflective Quiz for the Module 11 Assignment
Videos
- Part 1: Outer Join Operators
- Part 2: One-Sided Outer Join Problems in SQL
- Nested queries video lecture
- Membership exception problem Video lecture
- Part 1: Relational division operator video lecture
- Part 2: Containment exceptions video lecture
- Summary of problem-solving guidelines video lecture
- Course Conclusion
Readings
- Part 1: Powerpoint lecture notes for outer join operators
- Part 2: Powerpoint lecture notes for one-sided outer join problems in SQL
- Powerpoint slides for nested queries in the SELECT statement
- Powerpoint slides for the membership exception problem
- Powerpoint slides for the relational division operator
- Part 2: Powerpoint slides for containment exceptions in the SELECT statement
- Powerpoint slides for summary of problem-solving guidelines
- Optional textbook reading material
- Lesson SQL examples
- Practice problems using the University Database
- Extra problems using the Order Entry Database
- Assignment for Module 12
- Self evaluation for the Module 12 assignment
Quiz
- Concept Quiz for Module 12
- Reflective Quiz for the Module 12 Assignment
Instructors
CU Denver Frequently Asked Questions (FAQ's)
Depending on the type of enrollment, you will get access to the course content. Though most of the course material is available for free if the candidate has taken audit mode. To get access to graded assignments and to get a certificate, the candidate needs to subscribe to the paid version before or after the course.
With a subscription plan, the candidate gets access to the entire course content as well as a certificate at the end of the course. They can add the certificate to the achievements tab, take a print out, or even add it to their Linkedin profile.
Enrolment is free and candidates can register as well as access some of the content without paying anything.
Financial aid is provided by Coursera. Candidates need to fill up an application form and there will be a review process. It takes a minimum of 15 days to complete the process and inform about the same. Candidates must follow this process in each course of the specialisation.
In this course, candidates will learn some basics of database management. It provides the basis for a career in data warehousing, the creation of databases, business intelligence and also for the entire specialisation in Data Warehousing for Business Intelligence.