What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Database Management 1: Analysis

kurs ist nicht verfügbar in Deutsch (Deutschland)

Wir übersetzen es in weitere Sprachen.

Database Management 1: Analysis

Dozent: 孔令傑 (Ling-Chieh Kung)

Bei Mehr erfahren enthalten

6 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

Stufe Anfänger

Empfohlene Erfahrung

1 Woche zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

6 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

Stufe Anfänger

Empfohlene Erfahrung

1 Woche zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

Was Sie lernen werden

Design relational database schemas by using ER diagrams and ER-to-relational mapping to turn business rules into tables and keys.
Write SQL queries using PostgreSQL to retrieve, filter, join, aggregate, and manipulate data across relational databases.
Apply advanced SQL techniques including CTEs, Views, Window Functions, and User-Defined Functions to extract complex business insights.
Integrate SQL analysis with Python tools — comparing SQL and pandas, and using DuckDB to query DataFrames and files within a Python environment.

Kompetenzen, die Sie erwerben

Kategorie: Data Integrity
Kategorie: Data Analysis Software
Kategorie: Analytics
Kategorie: Data Dictionary
Kategorie: Database Architecture and Administration
Kategorie: Database Development
Kategorie: Database Management
Kategorie: Database Theory
Kategorie: Databases
Kategorie: SQL
Kategorie: Data Analysis
Kategorie: Data Modeling
Kategorie: Database Design

Werkzeuge, die Sie lernen werden

Kategorie: Relational Databases
Kategorie: Query Languages
Kategorie: Database Management Systems
Kategorie: NoSQL
Kategorie: Database Systems
Kategorie: PostgreSQL
Kategorie: Pandas (Python Package)

Wichtige Details

Zertifikat zur Vorlage

Zu Ihrem LinkedIn-Profil hinzufügen

Kürzlich aktualisiert!

Oktober 2026

Bewertungen

6 Aufgaben

Unterrichtet in Englisch

Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.

Weitere Informationen zu Coursera für Unternehmen

Logos von Petrobras, TATA, Danone, Capgemini, P&G und L'Oreal

In diesem Kurs gibt es 6 Module

Learn SQL and Database Analysis From Scratch! Go from no database experience to writing advanced SQL queries and analyzing real-world data with PostgreSQL and Python. This course gives you the core knowledge and practical skills to understand, query, and analyze data in relational databases — with no prior background required.

You'll start by learning why organizations use database systems, how relational and NoSQL databases differ, and how databases fit into a standard system architecture. From there, you'll learn to model real-world business rules using Entity-Relationship (ER) diagrams, then convert those models into concrete relational schemas with tables, primary keys, and foreign keys. The core of the course is SQL programming, taught using PostgreSQL. You'll write queries to retrieve, filter, join, sort, and aggregate data — then progress to advanced techniques including nested queries, Common Table Expressions (CTEs), Views, Window Functions, and User-Defined Functions. These skills let you extract complex business insights directly from a database. The course closes by bridging SQL with general-purpose programming: you'll compare SQL with Python's pandas library, learn when to use each, and apply DuckDB to run SQL queries directly on DataFrames and CSV files within a Python environment. A real-world ambulance allocation case study ties analysis and visualization together. Who this is for: Aspiring data analysts, business analysts, developers, and anyone who works with data and wants to build practical, job-ready database and SQL skills from the ground up.

Discover why organizations rely on databases instead of traditional files like Excel. Explore how Database Management Systems solve problems like data redundancy, inconsistency, and concurrency. Compare Relational and NoSQL databases to understand when to use each. Examine system architecture through the Taiwan High Speed Rail (THSR) ticketing case study, and identify the professional roles that make up the database ecosystem.

Das ist alles enthalten

6 Videos1 Lektüre1 Aufgabe

6 VideosInsgesamt 66 Minuten

1-0 Prologue2 Minuten
1-1 Course introduction4 Minuten
1-2 What is “database management”15 Minuten
1-3 Relational and NoSQL databases15 Minuten
1-4 Role played by databases in a system18 Minuten
1-5 Course overview12 Minuten

1 LektüreInsgesamt 5 Minuten

NTU MOOC course information & QAs5 Minuten

1 AufgabeInsgesamt 15 Minuten

W1 Quiz15 Minuten

Design a relational database from the ground up. Model business rules using entities, attributes, and relationships in the Entity-Relationship (ER) framework. Construct ER diagrams to visualize requirements for a retail business case study. Then convert your ER models into concrete relational schemas—complete with tables, primary keys, and foreign keys—using a systematic 7-step mapping algorithm.

Das ist alles enthalten

12 Videos1 Aufgabe

12 VideosInsgesamt 133 Minuten

2-1 A motivating example13 Minuten
2-2 Entities (1)11 Minuten
2-3 Entities (2)9 Minuten
2-4 Relationships (1)10 Minuten
2-5 Relationships (2)9 Minuten
2-6 Entity-relationship diagram (1)13 Minuten
2-7 Entity-relationship diagram (2)6 Minuten
2-8 ER models, relational models, and relational schema12 Minuten
2-9 The ER-relational mapping (1)15 Minuten
2-10 The ER-relational mapping (2)11 Minuten
2-11 The ER-relational mapping (3)11 Minuten
2-12 Summaries and remarks12 Minuten

1 AufgabeInsgesamt 30 Minuten

W2 Quiz30 Minuten

Write SQL to manage and analyze data in PostgreSQL. Create a Data Dictionary to document table structures, data types, and constraints. Build and modify tables using Data Definition Language (DDL) with referential integrity constraints. Construct queries to retrieve, filter, join, sort, and aggregate data for business insights. Insert, update, and delete records while maintaining data integrity.

Das ist alles enthalten

12 Videos1 Aufgabe

12 VideosInsgesamt 171 Minuten

3-1 Basic SQL Programming: An Introduction14 Minuten
3-2 The data and PostgreSQL installation17 Minuten
3-3 Data types and constraints17 Minuten
3-4 Referential triggers and table alternation17 Minuten
3-5 Data dictionary8 Minuten
3-6 Filtering, projection, and set operations (1)11 Minuten
3-7 Filtering, projection, and set operations (2)10 Minuten
3-8 Merging tables (1)16 Minuten
3-9 Merging tables (2)17 Minuten
3-10 Sorting and aggregation16 Minuten
3-11 Dealing with complex data types13 Minuten
3-12 Insertion, deletion, and updating in SQL15 Minuten

1 AufgabeInsgesamt 30 Minuten

W3 Quiz30 Minuten

Master advanced SQL techniques for deep data analysis. Construct nested queries, then refactor them for readability using Common Table Expressions (CTEs) and Views. Handle null values, implement conditional logic with CASE, and perform conditional aggregation with FILTER. Calculate rankings, running totals, and moving averages using window functions. Encapsulate reusable logic in User-Defined Functions (UDFs).

Das ist alles enthalten

13 Videos1 Aufgabe

13 VideosInsgesamt 133 Minuten

4-1 Introduction3 Minuten
4-2 Nested queries - With IN, ANY, and ALL17 Minuten
4-3 Nested queries - With EXISTS9 Minuten
4-4 Nested queries - With aliasing, and JOIN11 Minuten
4-5 Flattening nested queries using CTE17 Minuten
4-6 Flattening nested queries using Views (1)8 Minuten
4-7 Flattening nested queries using Views (2)12 Minuten
4-8 Null value manipulation9 Minuten
4-9 If-else selection8 Minuten
4-10 Conditional aggregation8 Minuten
4-11 Window functions (1)9 Minuten
4-12 Window functions (2)10 Minuten
4-13 User-defined functions13 Minuten

1 AufgabeInsgesamt 30 Minuten

W4 Quiz30 Minuten

Connect SQL skills to general-purpose programming. Compare declarative (SQL) and imperative (Pandas) paradigms to understand when each excels. Query CSVs and DataFrames directly using DuckDB within Python. Apply your skills to a real-world ambulance allocation case study, combining SQL analysis with data visualization to generate actionable insights.

Das ist alles enthalten

10 Videos1 Aufgabe

10 VideosInsgesamt 138 Minuten

5-1 Introduction3 Minuten
5-2 Other data-processing tools14 Minuten
5-3 Declarative vs. imperative programming17 Minuten
5-4 DuckDB (1)18 Minuten
5-5 DuckDB (2)16 Minuten
5-6 Case study - Missions16 Minuten
5-7 Case study - Data and Tasks13 Minuten
5-8 Case study - Analysis (1)17 Minuten
5-9 Case study - Analysis (2)17 Minuten
5-10 Case study - More Tasks6 Minuten

1 AufgabeInsgesamt 30 Minuten

W5 Quiz30 Minuten

Consolidate your learning by reviewing key concepts: ER modeling, relational schema design, basic and advanced SQL techniques, and SQL-Python integration.

Das ist alles enthalten

2 Videos1 Aufgabe

Dozent

孔令傑 (Ling-Chieh Kung)

National Taiwan University

10 Kurse114.743 Lernende

von

National Taiwan University

Mehr von Data Management entdecken

Duke University
Managing Big Data with MySQL
Kurs
Status: Kostenloser Testzeitraum
Coursera
SQL for Data Extraction and Analysis
Kurs
Status: Kostenloser Testzeitraum
Fractal Analytics
Data Analysis Using SQL
Kurs
Status: Kostenloser Testzeitraum
Coursera
SQL for Data Analysis and Business Insights
Spezialisierung
Status: Kostenloser Testzeitraum

Warum entscheiden sich Menschen für Coursera für ihre Karriere?

Felipe M.

Lernender seit 2018

„Es ist eine großartige Erfahrung, in meinem eigenen Tempo zu lernen. Ich kann lernen, wenn ich Zeit und Nerven dazu habe.“

Jennifer J.

Lernender seit 2020

„Bei einem spannenden neuen Projekt konnte ich die neuen Kenntnisse und Kompetenzen aus den Kursen direkt bei der Arbeit anwenden.“

Larry W.

Lernender seit 2021

„Wenn mir Kurse zu Themen fehlen, die meine Universität nicht anbietet, ist Coursera mit die beste Alternative.“

Chaitanya A.

„Man lernt nicht nur, um bei der Arbeit besser zu werden. Es geht noch um viel mehr. Bei Coursera kann ich ohne Grenzen lernen.“

Schalten Sie den Zugang zu mehr als 10.000 Kursen mit einem Abonnement frei
Bringen Sie Ihre Karriere mit einem Online-Abschluss voran.
Erwerben Sie einen Abschluss von erstklassigen Universitäten – 100 % online
Schließen Sie sich den über 4.700 globalen Unternehmen an, die Coursera for Business wählen

Häufig gestellte Fragen

No prior experience is needed. The course starts from the very beginning — explaining what a database is and why organizations use them — and builds progressively from foundational concepts to advanced SQL techniques. If you can use a computer and work with files, you have everything you need to start.

The primary tool is PostgreSQL, an industry-standard relational database system used for all SQL demonstrations and exercises. In the final module, you'll also work with Python, the pandas library, DuckDB, and Matplotlib as part of a real-world data analysis and visualization case study.

Most SQL tutorials stop at SELECT statements and basic JOINs. This course goes significantly further — covering advanced techniques like nested queries, Common Table Expressions, materialized Views, Window Functions for rankings and moving averages, and User-Defined Functions for reusable logic. It also covers relational data modeling using the ER model, giving you an understanding of how databases are designed from business requirements, not just how to query them.

This course builds foundational skills for roles including Data Analyst, Business Analyst, Database Administrator, and Backend Developer. SQL is one of the most consistently in-demand technical skills across industries, and the combination of relational modeling, advanced SQL, and Python integration covered here prepares you for real analytical work in any data-driven organization.

This is the first of three courses. Course 1 focuses on analysis — understanding, modeling, and querying databases. Course 2 covers architecture design, including schema normalization, transactions, concurrency control, and system implementation. Course 3 addresses efficiency optimization. Each course builds on the previous one, so completing this course prepares you fully for Course 2.

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.