Course Summary
This course teaches the fundamentals of database management, including database design, SQL, and data modeling. Students will learn how to create and manipulate databases, as well as how to query and analyze data.Key Learning Points
- Understand the basics of database management
- Learn SQL and data modeling
- Create and manipulate databases
- Query and analyze data
Related Topics for further study
Learning Outcomes
- Create and manipulate databases
- Write complex SQL queries
- Understand data modeling concepts
Prerequisites or good to have knowledge before taking this course
- Basic computer skills
- Familiarity with spreadsheets
Course Difficulty Level
BeginnerCourse Format
- Online
- Self-paced
Similar Courses
- Data Science Essentials
- Data Warehousing for Business Intelligence
Notable People in This Field
- Computer Scientist
- Database Theorist
Related Books
Description
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.
Outline
- Course Introduction
- Specialization Introduction video lesson
- Course introduction video lecture
- Course objectives video lecture
- Topics and assignments video lecture
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Optional textbook
- Overview of database management software requirements
- Oracle installation notes
- Making a connection to a database on a local Oracle server
- Introduction to Databases and DBMSs
- 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
- 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
- Powerpoint lecture notes for lesson 6
- Powerpoint lecture notes for lesson 7
- Optional reading
- Learning check-in
- Module02 Quiz
- Relational Data Model and the CREATE TABLE Statement
- 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
- Powerpoint lecture notes for lesson 1 and extras
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- University database SQL statements for Oracle, PostgreSQL, and MySQL
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Optional reading
- DBMS installation and configuration notes
- Practice Problems for Module 3
- Extra Problems for Module 3
- Assignment for Module 3
- Quiz for Module 3 practice problems
- Basic Query Formulation with SQL
- 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
- Powerpoint lecture notes for lesson 1
- University database examples
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Practice Problems for Module 4
- Extra Problems for Module 4
- Assignment for Module 4
- Optional reading
- DBMS installation and configuration notes
- Quiz for Module 4 Practice Problems
- Extended Query Formulation with SQL
- 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
- 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
- Powerpoint lecture notes for lesson 6
- Optional textbook reading material
- DBMS installation and configuration notes
- Practice Problems for Module 5
- Extra Problems for Module 5
- Assignment for Module 5
- Quiz for Module 5 Practice Problems
- Notation for Entity Relationship Diagrams
- Database development goals video lecture
- Basic ERD notation video lecture
- Relationship variations I video lecture
- Relationship variations II video lecture
- 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 6
- Assignment for Module 6
- ERD Rules and Problem Solving
- 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
- 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
- ER Assistant download
- Download for Visual Paradigm
- Optional textbook reading material
- Practice Problems for Module 7
- Assignment for Module 7
- Developing Business Data Models
- Conceptual data modeling goals and challenges
- Analyzing narrative problems
- Design transformations I
- Design transformations II video lecture
- 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
- Data Modeling Problems and Completion of an ERD
- Data modeling problems I video lecture
- Data modeling problems II video lecture
- Finalizing an ERD video lecture
- Powerpoint lecture notes for lesson 1 and extras
- 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
- Schema Conversion
- Goals and steps of logical database design video lecture
- Conversion rules video lecture
- Conversion problems video lecture
- Powerpoint lecture notes for lesson 1 and extras
- 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
- Normalization Concepts and Practice
- Modification anomalies video lecture
- Functional dependencies video lecture
- Normal forms video lecture
- Practical concerns video lecture
- Normalization problems video lecture
- Course Conclusion
- 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
Summary of User Reviews
Discover the world of database management with Coursera's comprehensive course. Students have rated this course highly for its in-depth coverage of the subject matter, practical examples, and engaging instructors.Key Aspect Users Liked About This Course
Many users appreciated the practical examples provided in the course.Pros from User Reviews
- In-depth coverage of database management
- Engaging instructors who provide practical examples
- Good mix of theory and practice
- Flexible learning options with self-paced online courses
- Well-structured course content
Cons from User Reviews
- Some users found the course challenging and required additional resources for support
- Limited interaction with instructors and other students
- Some users felt that the course did not cover advanced topics in database management
- Occasional technical issues with the Coursera platform
- Some users found the course content to be outdated
Michael Mannino
4.6 Raiting
The Complete PHP MYSQL Professional Course with 5 Projects
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn PHP MYSQL by building 5 Projects including PHP Regular Expressions & CMS | Become a Full Stack Back-End Developer. For example the basic videos, Free starter content etc....
Professional Azure SQL Database Administration
- 3.7
-
![]()
![]()
![]()
![]()
![]()
Master your skills to efficiently manage and maintain data on the cloud Azure SQL Database is the cloud version of SQL Server....
Ethical Hacking: Network Scan Nmap&Nessus | ethical hacking
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Discover networks, check devices with vulnerabilities by using Nmap. Become expert in Cyber Security | ethical hacking Welcome to the "Ethical Hacking: Network Scan by Nmap & Nessus" course....
AWS Cloud Technical Essentials
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Are you in a technical role and want to learn the fundamentals of AWS? If so, AWS Cloud Technical Essentials is an ideal way to start....
