IBM - Databases and SQL for Data Science with Python
4.6 /5- Offered byCoursera
Databases and SQL for Data Science with Python at Coursera Overview
Databases and SQL for Data Science with Python
at Coursera
Learn to create a database instance in the cloud
Duration | 37 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Databases and SQL for Data Science with Python at Coursera Highlights
Databases and SQL for Data Science with Python
at Coursera
- Earn a certificate of completion from IBM
Databases and SQL for Data Science with Python at Coursera Course details
Databases and SQL for Data Science with Python
at Coursera
Skills you will learn
What are the course deliverables?
- Analyze data within a database using SQL and Python
- Create a relational database on Cloud and work with tables
- Compare and contrast DDL to DML
- Write SQL statements including SELECT, INSERT, UPDATE, and DELETE
More about this course
- 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
- You will work with real databases, real data science tools, and real-world datasets
- You will also learn how to access databases from Jupyter notebooks using SQL and Python
Databases and SQL for Data Science with Python at Coursera Curriculum
Databases and SQL for Data Science with Python
at Coursera
Getting Started with SQL
Welcome to SQL for Data Science
Introduction to Databases
SELECT Statement
COUNT, DISTINCT, LIMIT
INSERT Statement
UPDATE and DELETE Statements
Introduction to Relational Databases and Tables
Relational Database Concepts
How to create a Database instance on Cloud
Types of SQL statements (DDL vs. DML)
CREATE TABLE Statement
ALTER, DROP, and Truncate tables
Intermediate SQL
Using String Patterns and Ranges
Sorting Result Sets
Grouping Result Sets
Built-in Database Functions
Date and Time Built-in Functions
Sub-Queries and Nested Selects
Working with Multiple Tables
Accessing Databases using Python
How to Access Databases Using Python
Writing code using DB-API
Connecting to a database using ibm_db API
Creating tables, loading data and querying data
Analyzing data with Python
Course Assignment
Working with Real World Datasets
Getting Table and Column Details
Bonus Module: Advanced SQL for Data Engineering (Honors)
Views
Stored Procedures
ACID Transactions
Join Overview
Inner Join
Outer Joins
Databases and SQL for Data Science with Python at Coursera Faculty details
Databases and SQL for Data Science with Python
at Coursera
Rav Ahuja
Rav Ahuja is a Global Program Director at IBM. Rav leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. He is the architect for the IBM Data Science Professional Certificate and instructor for the Databases & SQL for Data Science course on Coursera. Rav co-founded Cognitive Class, an IBM led initiative to democratize skills for in demand technologies.
Hima Vasudevan
Hima Vasudevan is a Data Scientist in the Digital Business Group at IBM. She is part of the Cognitive Class team and focuses on creating skills offerings and deliver learning curriculum for the Data Science and Data Engineering professions. Hima joined IBM in 2016 as an Analytics Data Scientist Intern and worked on a data mining project to predict power outages related to storms using IBM SPSS Modeler.
Databases and SQL for Data Science with Python at Coursera Admission Process
Databases and SQL for Data Science with Python
at Coursera
Important Dates
May 25, 2024
Course Commencement Date
Other courses offered by Coursera
– / –
3 months
Beginner
View Other 6714 Courses
A
Ananthu prudhvi raj
Databases and SQL for Data Science with Python
Offered by Coursera
5
Learning Experience: The topics were explained in a very clear manner with hands on labs for every topic.
Faculty: The lectures are pre-recorded and animated but they updated the content from year to year based on real time experiences.
The course resources are from the real world data like Chicago public population distribution, crimes data etc and for hands on experience they have IBM skills network website and a free IBM account with IBM DB2 access.
Course Support: It thought the necessary skill set I needed for a job upgrade
Reviewed on 11 Feb 2023Read More
S
Shubham More
Databases and SQL for Data Science with Python
Offered by Coursera
5
Learning Experience: The course is very detailed and covers all the required basic as well, it helped me a lot in gaining knowledge and automating ETL scripts. Thanx to coursera
Faculty: Faculty was good.
Course curriculum is best.. like I already mentioned it covers all the important aspects and containd hands on labs for better practice and understanding
Reviewed on 28 Jan 2023Read More
N
Naveen Prabhakar
Databases and SQL for Data Science with Python
Offered by Coursera
5
Learning Experience: Good knowledge and experience must be learned by beginner. covered all the basic concept for developing understanding into formig queries required for daily business needs.
Faculty: All the lectures already recorded there is no live class but thre is discussion form where one can raise the question for any topic.
Course is updated. There is assignment and test after each session end one must complete in order to move for next session. structured and result oriented course.
Course Support: Its give me layout for forming the basic to advanced structured query for any problem.
Reviewed on 16 Dec 2022Read More
S
Saud Ali
Databases and SQL for Data Science with Python
Offered by Coursera
5
Learning Experience: It was a very great experience learning SQL and some fundamental concepts of Databases, understood the concept of data modelling, learnt to retrieve the data using SQL queries
Faculty: The faculty's who taught the course was very knowledgeable, delivered the content in a very professional way, and the peer group very supportive and knowledge sharing
The course curriculum had the updated course content, the assessments and assignments very much related to the course itself overall it was a great experience
Course Support: By giving hands on experience to the SQL tools and it helped with a lot in understanding the fundamentals of Data Engineering, since SQL stands as a pillar of the DE process
Reviewed on 13 Nov 2022Read More
S
Santhoshi Krishna
Databases and SQL for Data Science with Python
Offered by Coursera
4
Learning Experience: Good
Faculty: Good
Yes it is updated
Course Support: No
Reviewed on 9 Oct 2022Read More
View All 8 Reviews
Databases and SQL for Data Science with Python
at Coursera
Student Forum
Anything you would want to ask experts?