Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist.
von
IBM
Über diesen Kurs
1,075,394 kürzliche Aufrufe
Karriereergebnisse der Lernenden
38%
nahm einen neuen Beruf nach Abschluss dieser Kurse auf
33%
ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs
Was Sie lernen werden
Create and access a database instance on cloud
Write basic SQL statements: CREATE, DROP, SELECT, INSERT, UPDATE, DELETE
Filter, sort, group results, use built-in functions, access multiple tables
Access databases from Jupyter using Python and work with real world datasets
Kompetenzen, die Sie erwerben
Cloud DatabasesPython ProgrammingIpythonRelational Database Management System (RDBMS)SQL
Karriereergebnisse der Lernenden
38%
nahm einen neuen Beruf nach Abschluss dieser Kurse auf
33%
ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs
Zertifikat zur Vorlage
Erhalten Sie nach Abschluss ein Zertifikat
100 % online
Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.
Flexible Fristen
Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.
Stufe „Anfänger“
Ca. 13 Stunden zum Abschließen
Empfohlen: 4 weeks of study, 2-4 hours/week.
Englisch
Untertitel: Englisch, Koreanisch, Arabischer Raum
Lehrplan - Was Sie in diesem Kurs lernen werden
3 Stunden zum Abschließen
Week 1 - Introduction to Databases and Basic SQL
In Week 1 you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.
3 Stunden zum Abschließen
12 Videos (Gesamt 38 min), 6 Lektüren, 4 Quiz
12 Videos
Introduction to Databases4m
How to create a Database instance on Cloud3m
CREATE Table Statement2m
SELECT Statement3m
COUNT, DISTINCT, LIMIT2m
INSERT Statement2m
UPDATE and DELETE Statements3m
Information and Data Models4m
Types of Relationships3m
Mapping Entities to Tables1m
Relational Model Concepts2m
6 Lektüren
Hands-on LAB: Provision a Cloud Hosted Database Instance30m
Examples to CREATE and DROP tables5m
SELECT statement examples5m
Hands-on LAB: Composing and Running basic SQL queries45m
About this Optional lesson2m
Additional Reading10m
4 praktische Übungen
Databases15m
Basic SQL15m
Practice Quiz: Review of Relational Database Concepts10m
Optional Not Graded Quiz on Relational Concepts15m
3 Stunden zum Abschließen
Week 2 - Advanced SQL
By the end of this module, you will learn the following: (1) Learn how to use string patterns and ranges to search data and how to sort and group data in result sets. (2) Learn how to work with multiple tables in a relational database using join operations.
3 Stunden zum Abschließen
9 Videos (Gesamt 38 min), 5 Lektüren, 4 Quiz
9 Videos
Sorting Result Sets2m
Grouping Result Sets3m
Built-in Database Functions6m
Date and Time Built-in Functions2m
Sub-Queries and Nested Selects4m
Working with Multiple Tables6m
Relational Model Constraints2m
Relational Model Constraints - Advanced4m
5 Lektüren
Hands-on LAB: String Patterns, Sorting & Grouping1h
Hands-on Lab: Built-in functions20m
Hands-on Lab: Sub-queries, Multiple Tables30m
About this Optional lesson2m
Additional Information on Keys and Constraints5m
4 praktische Übungen
String Patterns, Ranges, Sorting and Grouping15m
Functions, Sub-Queries, Multiple Tables15m
Practice Quiz: Review of Database Constraints10m
Optional Not Graded Quiz on Constraints8m
4 Stunden zum Abschließen
Week 3 - Accessing Databases using Python
After completing the lessons in this week, you will learn how to explain the basic concepts related to using Python to connect to databases and then create tables, load data, query data using SQL, and analyze data using Python
4 Stunden zum Abschließen
10 Videos (Gesamt 45 min), 3 Lektüren, 6 Quiz
10 Videos
Writing code using DB-API4m
Connecting to a database using ibm_db API2m
Creating tables, loading data and querying data3m
Analyzing data with Python9m
Join Overview3m
Inner Join3m
Left Outer Join5m
Right Outer Join4m
Full Outer Join2m
3 Lektüren
Lab 0: Create Database Credentials10m
About this Optional Section2m
Hands-on LAB: JOINs45m
2 praktische Übungen
Database access from Python15m
JOIN operations15m
4 Stunden zum Abschließen
Week 4: Course Assignment
As a hands-on Data Science assignment, you will be working with multiple real world datasets for the city of Chicago. You will be asked questions that will help you understand the data just like a data scientist would. You will be assessed both on the correctness of your SQL queries and results.
4 Stunden zum Abschließen
2 Videos (Gesamt 13 min), 2 Lektüren, 4 Quiz
2 Lektüren
LOADing Data3m
IBM Digital Badge2m
1 praktische Übung
Opt-in to receive your badge!
Bewertungen
Top-Bewertungen von DATABASES AND SQL FOR DATA SCIENCE
von DEDec 27, 2019
Course is god enough. However the last assessment is not. Misprints and not clear questions lead to disappointing marks in the end. Also other students marked assessments based on their understanding.
von ATFeb 26, 2020
A very useful course with some very interesting datasets/Jupyter notebooks to work through/practice your skills. Offers a good balanced blend between theory and practical/practice. Very good course!
von TPOct 24, 2018
Practice lab assignments were excellent in reinforcing my learning, they were just the right kind of challenging. This course has been the best one in the Data Science Professional series by far.
von SGDec 24, 2019
One of the best course I completed on Coursera. All the learning material is well organised and easy to understand. Also the non-graded sections regarding relational databases are interesting.
von JMFeb 27, 2019
Clear, thorough, well-designed. Labs give useful practice, assignments and quizzes test the actual instructional content. This course is by far the best in the IBM Data Science specialization.
von ABNov 1, 2018
Covers the basics, but might be a little difficult for a complete beginner. Manageable, but difficult. Needs more help using SQL within a Jupyter Notebook which should be in the earlier labs.
von YMMar 21, 2020
Great introduction to basic manipulation of SQL tables and working with the IBM DB2 databases by connecting to them with iPython. Very straightforward explanations and very enjoyable tasks.
von DAOct 1, 2019
Course was well organized, I found the lab exercise to be useful in learning the material. The quizzes and final project were fair and tested my knowledge of the concepts. Great course!
von DTJun 16, 2019
This is a great review of an important topic. If I knew how much this mattered for the advanced capstone course I would have paid more attention. As it was, I came back here frequently.
von SSJun 30, 2019
I liked the way this course is structured and I am really happy with the kind of exercise it contains. It would be really great if more details regarding the python script was provided
von MRNov 25, 2019
Really right to the point and efficient. Good examples and short direct videos. I had no idea about SQL before and now I can run good queries and have enough tools to learn even more.
von JCApr 4, 2019
Excellent class. The quizzes are easy, but there are plenty of opportunities to explore the tools and material and learn more. Optional sections are excellent and highly recommended.
von LGMar 5, 2019
I really liked this course and it is worth it for learning basic SQL queries with Python. I wish we could have more practical exercises but on the whole this was an excellent course.
von MAOct 25, 2019
This course is designed very well to get hands on experience with SQL queries for beginners. The exercises were very helpful in applying what I learned. Definitely recommend this.
von ACJul 13, 2019
The course starts from the basics but progresses to intermediate level concepts in SQL, like joins and subqueries, which are required for day to day work in the Software industry.
von CAJan 8, 2019
A rewarding experience because I have been able to learn very valuable information. It is an excellent course. It has helped me in the personal and professional field. Thank you.
von PHMar 27, 2019
It was a very useful immersion to Databases and SQL. The IBM Cloud platform is amazing and a very easy to use environment which fully supported the objectives of this course.
von PSApr 9, 2019
A good start for beginners . it has various labs which will push you practice a lot and eventually you will develop a better understanding of different query types in sql
von VMApr 23, 2019
need to to updated. details regarding IBM cloud is messy and outdated. take to long to connect the cloud. videos slides are of bad resolution. instructor voice not clear
von ARApr 22, 2019
A very solid introduction to SQL with a set of hands-on exercises that make it easy for a complete newbie like me to understand the core concepts and learn the basics.
von
IBM
IBM offers a wide range of technology and consulting services; a broad portfolio of middleware for collaboration, predictive analytics, software development and systems management; and the world's most advanced servers and supercomputers. Utilizing its business consulting, technology and R&D expertise, IBM helps clients become "smarter" as the planet becomes more digitally interconnected. IBM invests more than $6 billion a year in R&D, just completing its 21st year of patent leadership. IBM Research has received recognition beyond any commercial technology research organization and is home to 5 Nobel Laureates, 9 US National Medals of Technology, 5 US National Medals of Science, 6 Turing Awards, and 10 Inductees in US Inventors Hall of Fame.
Häufig gestellte Fragen
Wann erhalte ich Zugang zu den Vorträgen und Aufgaben?
Sobald Sie sich für ein Zertifikat angemeldet haben, haben Sie Zugriff auf alle Videos, Quizspiele und Programmieraufgaben (falls zutreffend). Aufgaben, die von anderen Kursteilnehmern bewertet werden, können erst dann eingereicht und überprüft werden, wenn Ihr Unterricht begonnen hat. Wenn Sie sich den Kurs anschauen möchten, ohne ihn zu kaufen, können Sie womöglich auf bestimmte Aufgaben nicht zugreifen.
Was bekomme ich, wenn ich dieses Zertifikat abonniere?
Wenn Sie sich für den Kurs anmelden, erhalten Sie Zugriff auf alle Kurse des Zertifikats und Sie erhalten nach Abschluss aller Arbeiten ein Zertifikat. Ihr elektronisches Zertifikat wird zu Ihrer Seite „Errungenschaften“ hinzugefügt – von dort können Sie Ihr Zertifikat ausdrucken oder es zu Ihrem LinkedIn-Profil hinzufügen. Wenn Sie lediglich den Inhalt des Kurses lesen und anzeigen möchten, können Sie kostenlos als Gast an dem Kurs teilnehmen.
Wie erfolgen Rückerstattungen?
Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..