Database Management Essentials
Master database fundamentals including SQL, database design, ERD creation, and normalization techniques for effective data management.
Master database fundamentals including SQL, database design, ERD creation, and normalization techniques for effective data management.
This course cannot be purchased separately - to access the complete learning experience, graded assignments, and earn certificates, you'll need to enroll in the full Data Warehousing for Business Intelligence Specialization program. You can audit this specific course for free to explore the content, which includes access to course materials and lectures. This allows you to learn at your own pace without any financial commitment.
4.6
(3,297 ratings)
1,96,523 already enrolled
Instructors:
Michael Mannino
English
پښتو, বাংলা, اردو, 2 more
Powered by
What you'll learn
Create and manage relational databases
Write complex SQL queries
Design effective entity-relationship diagrams
Implement database normalization
Optimize database performance
Skills you'll gain
This course includes:
4.4 Hours PreRecorded video
25 assignments
Access on Mobile, Tablet, Desktop
FullTime access
Shareable certificate
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 12 modules in this course
This comprehensive course covers essential database management concepts and skills. Students learn relational database design, SQL query formulation, entity-relationship diagramming, and normalization techniques. The curriculum includes hands-on practice with multiple database systems, focusing on creating and managing databases, writing complex queries, and optimizing database designs.
Course Introduction
Module 1 · 2 Hours to complete
Introduction to Databases and DBMSs
Module 2 · 4 Hours to complete
Relational Data Model and CREATE TABLE
Module 3 · 13 Hours to complete
Basic Query Formulation with SQL
Module 4 · 13 Hours to complete
Extended Query Formulation with SQL
Module 5 · 14 Hours to complete
Notation for Entity Relationship Diagrams
Module 6 · 9 Hours to complete
ERD Rules and Problem Solving
Module 7 · 10 Hours to complete
Developing Business Data Models
Module 8 · 9 Hours to complete
Data Modeling Problems
Module 9 · 9 Hours to complete
Schema Conversion
Module 10 · 9 Hours to complete
Normalization Concepts and Practice
Module 11 · 9 Hours to complete
Advanced Query Formulation with SQL
Module 12 · 15 Hours to complete
Fee Structure
Instructor
Michael Mannino
4.6 rating
449 Reviews
2,33,053 Students
4 Courses
Associate Professor
Dr. Michael Mannino is an Associate Professor at the University of Colorado Denver, specializing in database technology and business intelligence. With over 35 years of experience in academia, research, and consulting, he has held faculty positions at prestigious institutions such as the University of Florida, the University of Texas at Austin, and the University of Washington. His extensive background in data warehouse development includes 15 years of teaching, authoring a supporting textbook, and conducting research projects that enhance understanding in this critical area of information systems.Dr. Mannino teaches several courses on Coursera, including Data Warehouse Concepts, Design, and Data Integration, Database Management Essentials, Design and Build a Data Warehouse for Business Intelligence Implementation, and Relational Database Support for Data Warehouses. He is passionate about sharing his knowledge and excitement for data management with students, helping them prepare for rewarding careers in data warehousing and business intelligence. His contributions to the field are reflected not only in his teaching but also in his research endeavors that focus on practical applications in information systems engineering.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
4.6 course rating
3,297 ratings
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.