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.
Schenken Sie Ihrer Karriere Coursera Plus mit einem Rabatt von $160 , der jährlich abgerechnet wird. Sparen Sie heute.
(20 Bewertungen)
Empfohlene Erfahrung
Was Sie lernen werden
Describe what relational databases are, and how they are used.
Master the Relational Database Model.
Demonstrate comprehensive SQL skills.
Kompetenzen, die Sie erwerben
- Kategorie: Data Model
- Kategorie: Relational Algebra
- Kategorie: Relational Database
- Kategorie: SQL
- Kategorie: Database Theory
Wichtige Details
Zu Ihrem LinkedIn-Profil hinzufügen
21 Aufgaben
Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.
Erwerben Sie ein Karrierezertifikat.
Fügen Sie diese Qualifikation zur Ihrem LinkedIn-Profil oder Ihrem Lebenslauf hinzu.
Teilen Sie es in den sozialen Medien und in Ihrer Leistungsbeurteilung.
In diesem Kurs gibt es 4 Module
Welcome to Introduction to Relational Databases! In this course, we will cover the topics of: Database Overview, Relational Algebra, SQL. This learning module provides a comprehensive introduction to relational databases, their applications, and components. Starting with an introduction to databases and their diverse applications, the module discusses the components of relational database schemas, including relations, attributes, and keys. Students will learn to design simple database schemas and understand key database concepts such as records, data retrieval and modification, and primary/foreign keys. The module includes real-world examples for practical understanding.
Das ist alles enthalten
7 Videos9 Lektüren6 Aufgaben1 Diskussionsthema
This learning module explores the fundamental concepts and operations of relational algebra, the theoretical foundation of relational databases. It introduces basic relational algebra concepts such as 'relation', 'tuple', and 'operation', and then dives into fundamental relational algebra operations, including selection, projection, and union. Students will also learn about more advanced operations like joins and division, expanding their understanding of how complex data relationships can be managed. Further, the module will cover composite and aggregation operations to handle more intricate data manipulations, as well as operations for modifying relations. This module gives students a firm theoretical foundation to work with relational databases.
Das ist alles enthalten
7 Videos5 Lektüren6 Aufgaben
This learning module provides an in-depth understanding of SQL (Structured Query Language), the standardized language used for managing relational databases. Starting with the fundamentals, students will learn to utilize SELECT and set operations to extract relevant information from database tables. The module then transitions into more complex queries involving joins, enabling students to locate and amalgamate information from multiple database tables. It further delves into modifying database tables, defining their structures, creating referential integrity constraints to maintain database consistency, and controlling user database access via SQL commands. Learning SQL will equip students with the knowledge and skills necessary to effectively manage and manipulate data in relational databases .
Das ist alles enthalten
12 Videos6 Lektüren8 Aufgaben
This module contains the summative course assessment that has been designed to evaluate your understanding of the course material and assess your ability to apply the knowledge you have acquired throughout the course. Be sure to review the course material thoroughly before taking the assessment.
Das ist alles enthalten
1 Aufgabe
Empfohlen, wenn Sie sich für Data Analysis interessieren
Whizlabs
Tableau Learning Partner
DeepLearning.AI
Auf einen Abschluss hinarbeiten
Dieses Kurs ist Teil des/der folgenden Studiengangs/Studiengänge, die von Illinois Techangeboten werden. Wenn Sie zugelassen werden und sich immatrikulieren, können Ihre abgeschlossenen Kurse auf Ihren Studienabschluss angerechnet werden und Ihre Fortschritte können mit Ihnen übertragen werden.¹
Warum entscheiden sich Menschen für Coursera für ihre Karriere?
Neue Karrieremöglichkeiten mit Coursera Plus
Unbegrenzter Zugang zu über 7.000 erstklassigen Kursen, praktischen Projekten und Zertifikatsprogrammen, die Sie auf den Beruf vorbereiten – alles in Ihrem Abonnement enthalten
Bringen Sie Ihre Karriere mit einem Online-Abschluss voran.
Erwerben Sie einen Abschluss von erstklassigen Universitäten – 100 % online
Schließen Sie sich mehr als 3.400 Unternehmen in aller Welt an, die sich für Coursera for Business entschieden haben.
Schulen Sie Ihre Mitarbeiter*innen, um sich in der digitalen Wirtschaft zu behaupten.
Häufig gestellte Fragen
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
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. If you only want to read and view the course content, you can audit the course for free.
You will be eligible for a full refund until two weeks after your payment date, or (for courses that have just launched) until two weeks after the first session of the course begins, whichever is later. You cannot receive a refund once you’ve earned a Course Certificate, even if you complete the course within the two-week refund period. See our full refund policy.