Course Summary
Learn how to design, create and manipulate relational databases to store and manage large data sets.Key Learning Points
- Understand the fundamentals of relational database management systems
- Learn to use SQL to retrieve data from databases
- Design and create databases that are efficient and scalable
Related Topics for further study
Learning Outcomes
- Create and manage relational databases
- Write SQL queries to retrieve data from databases
- Design efficient and scalable databases
Prerequisites or good to have knowledge before taking this course
- Basic understanding of computer programming
- Familiarity with databases and SQL is helpful but not required
Course Difficulty Level
IntermediateCourse Format
- Self-paced online course
- Video lectures
- Interactive quizzes and assignments
Similar Courses
- Database Systems Concepts and Design
- Introduction to Data Science in Python
Related Education Paths
Notable People in This Field
- Michael Stonebraker
- Donald D. Chamberlin
Related Books
Description
Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies.
Outline
- Information Systems
- Components of information systems
- Database concepts
- Welcome to the course!
- Information system
- Entity Relationship Theory and Conceptual Design
- Conceptual Design
- Power Designer
- Conceptual Design
- Relational Database Theory and Logical Design
- Concepts of the logical design
- From the conceptual model to the logical design
- Logical Design
- Structured Query Language Data Manipulation Language
- Physical modeling
- Create and populate a database
- DDL Sailors
- MySQL Tutorial
- Create and complete a database. Code
- Physical Design
- Structured Query Language and Advanced SQL Programming
- Data Manipulation Language
- SQL-Clauses
- DML Sailors
- Transactions and query optimization
- Create transactions
- Triggers, store procedures and cursors
- Transactions and query optimization
- Assessment
Summary of User Reviews
Discover the fundamentals of relational databases with this comprehensive online course on Coursera. Students have praised the course for its clear and engaging presentation of complex concepts. One key aspect that many users have found helpful is the hands-on practice provided in the course assignments.Pros from User Reviews
- Clear and engaging presentation of concepts
- Hands-on practice with course assignments
- In-depth coverage of relational databases
Cons from User Reviews
- Some users found the course pacing to be too slow
- Limited interaction with instructors
- Course content may not be suitable for those with advanced knowledge of relational databases
María del Pilar Ángeles
4.2 Raiting
Google BigQuery & PostgreSQL : Big Query for Data Analysis
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Become BigQuery expert by mastering Google BigQuery for data analysis. Cover all SQL qureies in PostgeSQL & Big Query 6 Reasons why you should choose this PostgreSQL and BigQuery course...
Learning MongoDB Schema, Indexes and Queries
- 5
-
![]()
![]()
![]()
![]()
![]()
Understand how good design facilitates scale and achieve top performance by gaining insights into indexing strategies. We need to discuss database schemas....
AWS Certification - Cloud Practitioner - 2021
- 4.6
-
![]()
![]()
![]()
![]()
![]()
AWS Certification - Cloud Practitioner. Achieve the AWS Cloud Practitioner Certification in the in28minutes way! AWS Certified Cloud Practitioner is an easy certification to get your journey started with AWS....
Foundations of Computer Science
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Welcome to Introduction to Programming: Visual Basic. In the course sequence you will learn to write programs that utilize both procedural and object oriented techniques to solve business problems....
