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.
The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment.
The emphasis in this course is on hands-on and practical learning . As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python.
No prior knowledge of databases, SQL, Python, or programming is required.
Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course.
LIMITED TIME OFFER: Subscription is only $39 USD per month for access to graded materials and a certificate.
Databases and SQL for Data Science
proposé par
IBM
À propos de ce cours
4.7
2,562 notes
Ce que vous allez apprendre
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
Compétences que vous acquerrez
Cloud DatabasesPython ProgrammingIpythonRelational Database Management System (RDBMS)SQL
Programme du cours : ce que vous apprendrez dans ce cours
Semaine
13 heures pour terminer
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.
11 vidéos (Total 36 min), 7 lectures, 5 quiz
11 vidéos
Introduction to Databases4 min
How to create a Database instance on Cloud?4 min
CREATE Table Statement2 min
SELECT Statement3 min
INSERT Statement2 min
UPDATE and DELETE Statements3 min
Information and Data Models4 min
Types of Relationships3 min
Mapping Entities to Tables1 min
Relational Model Concepts2 min
7 lectures
Hands-on LAB: Provision a Cloud hosted Database instance30 min
Examples to CREATE and DROP tables5 min
SELECT statement examples5 min
Count, Distinct, Limit5 min
Hands-on LAB: Composing and Running basic SQL queries45 min
About this Optional lesson2 min
Additional Reading10 min
4 exercices pour s'entraîner
Databases15 min
Basic SQL15 min
Practice Quiz: Review of Relational Database Concepts10 min
Optional Not Graded Quiz on Relational Concepts15 min
Semaine
24 heures pour terminer
Week 2 - Advanced SQL
By the end of this module you will: (1) earn how to use string patterns and ranges to search data, how to sort and group data in result sets, as well as (2) learn how to work with multiple tables in a relational database using join operations.
5 vidéos (Total 18 min), 8 lectures, 4 quiz
5 vidéos
Sorting Result Sets2 min
Grouping Result Sets3 min
Relational Model Constraints2 min
Relational Model Constraints - Advanced4 min
8 lectures
Hands-on LAB: String Patterns, Sorting & Groupings
Built-in Functions, Dates, Timestamps10 min
Hands-on Lab: Built-in functions20 min
Sub-Queries and Nested Selects10 min
Working with Multiple Tables10 min
Hands-on Lab: Sub-queries, Multiple Tables30 min
About this Optional lesson2 min
Additional Information on Keys and Constraints5 min
4 exercices pour s'entraîner
String Patterns, Ranges, Sorting and Grouping15 min
Functions, Sub-Queries, Multiple Tables15 min
Practice Quiz: Review of Database Constraints10 min
Optional Not Graded Quiz on Constraints8 min
Semaine
34 heures pour terminer
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
10 vidéos (Total 45 min), 3 lectures, 6 quiz
10 vidéos
Writing code using DB-API4 min
Connecting to a database using ibm_db API2 min
Creating tables, loading data and querying data3 min
Analyzing data with Python9 min
Join Overview3 min
Inner Join3 min
Left Outer Join5 min
Right Outer Join4 min
Full Outer Join2 min
3 lectures
Lab 0: Create Database Credentials10 min
About this Optional Section2 min
Hands-on LAB: JOINs45 min
2 exercices pour s'entraîner
Database access from Python15 min
JOIN operations15 min
Semaine
44 heures pour terminer
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.
2 lectures, 3 quiz
2 lectures
Working with real-world data sets10 min
IBM Digital Badge2 min
4.7
274 avis41%
a commencé une nouvelle carrière après avoir terminé ces cours
34%
a bénéficié d'un avantage concret dans sa carrière grâce à ce cours
Meilleurs avis
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.
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.
Enseignant
Rav Ahuja
Data Science Program ManagerIBM
À propos de 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.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
Une fois que vous êtes inscrit(e) pour un Certificat, vous pouvez accéder à toutes les vidéos de cours, et à tous les quiz et exercices de programmation (le cas échéant). Vous pouvez soumettre des devoirs à examiner par vos pairs et en examiner vous-même uniquement après le début de votre session. Si vous préférez explorer le cours sans l'acheter, vous ne serez peut-être pas en mesure d'accéder à certains devoirs.
À quoi ai-je droit si je m'abonne à ce Certificat ?
Lorsque vous vous inscrivez au cours, vous bénéficiez d'un accès à tous les cours du Certificat, et vous obtenez un Certificat lorsque vous avez réussi. Votre Certificat électronique est alors ajouté à votre page Accomplissements. À partir de cette page, vous pouvez imprimer votre Certificat ou l'ajouter à votre profil LinkedIn. Si vous souhaitez seulement lire et visualiser le contenu du cours, vous pouvez accéder gratuitement au cours en tant qu'auditeur libre.
Quelle est la politique de remboursement ?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2019 Coursera Inc. Tous droits réservés.
