Building and Working with Relational Databases

via Coursera Specialization

Go to class Write review

Details

Go to class

Provider

Coursera Specialization
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Duration & workload

12 weeks, 10 hours a week

Found in

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

This specialization covers the core principles and practical applications of relational databases, focusing on design, implementation, and management. Learners will build hands-on skills in SQL querying, data modeling, normalization, and developing database-driven applications. Through real-world scenarios and projects, participants will learn how to create efficient, scalable database solutions to support business intelligence and decision-making processes.

Syllabus

Course 1: Introduction to Relational Databases
Course 2: Relational Database Design
Course 3: Relational Database Implementation and Applications

Courses

0 reviews
1 day 23 hours 39 minutes
View details

This course provides you with the opportunity to learn about relational database design. You will be provided an in-depth understanding of the design principles and methodologies involved in creating well-structured, normalized, and efficient relational databases to manage data for small, medium, and large-scale enterprises. Possessing database design skills will enable you to excel in careers such as Database Administrators, Data Analysts, Software Developers, Data Engineers, and Business Intelligence Developers; capitalizing on the ability to create robust and efficient data solutions for any organization. These are one of the top sought-after careers across many industries today. At the end of this course, you will be able to: - Describe the process and the design aspects involved in relational database design. - Interpret the main components of an Entity-Relationship diagram (ERD) using unified modeling language (UML) notation. - Develop entity-relationship diagrams using basic and extended Entity-relationship features in relational design. - Translate Entity-Relationships diagrams into logical schemas (relation schemas). - Describe the theory and practical application of functional dependencies in relational database design. - Use the theory to recognize candidate keys and primary keys. - Derive minimal and canonical covers of functional dependencies. - Describe the principles of database normalization. - Identify and apply normalization techniques.
0 reviews
2 days 23 hours 52 minutes
View details

Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language. At the end of the course, you will be able to: - Describe what relational databases are, and how they are used. - Master the Relational Database Model. - Demonstrate proficiency in formal relational database theory. - Demonstrate comprehensive SQL skills. - Apply database knowledge to practical problems. Software Requirements: Jupyter Notebooks, SQL
0 reviews
1 day 6 hours 53 minutes
View details

In today's data-driven world, the ability to work with relational databases is an essential skill for professionals in various fields. This course is designed to equip you with the knowledge and practical skills needed to become proficient in database management and application development. Whether you are pursuing a career as a database administrator, software developer, or data analyst, this course provides you with a strong foundation to excel in your chosen field. By the end of this course, students will be able to: • Describe relational databases and their core components, including tables, rows, columns, and keys. • Implement relational database and usage of indexes, views, triggers, temporary tables, functions, and stored procedures. • Describe their role in enforcing business logic and data integrity in database environment. • Apply database design and SQL knowledge to real-world application development. • Develop database-driven applications using programming languages, such as Java, Python or C/C++ and frameworks. • Describe the concepts of indexing and hashing in efficient support for search operations. • Describe the concepts of transactions and their properties (ACID: Atomicity, Consistency, Isolation, Durability). • Define concurrency control and understand the impact of uncontrolled concurrent transactions on data integrity. Software Requirements: VS Code editor, MySQL Workbench, PostgreSQL To succeed in this course, learners should possess a solid understanding of relational database design. If you haven't yet mastered these skills, we strongly recommend completing Introduction to Relational Databases and Relational Database Design beforehand. These foundational courses are designed to equip you with the essential knowledge necessary to excel in this material.