Coursera Certificate 0

Databases and SQL for Data Science with Python

Name: Databases and SQL for Data Science with Python
Price: 39 USD
Availability: InStock

About this course

Working knowledge of SQL (or Structured Query Language) is a must for data professionals like Data Scientists, Data Analysts and Data Engineers. Much of the world's data resides in databases. SQL is a powerful language used for communicating with and extracting data from databases. In this course you will learn SQL inside out- from the very basics of Select statements to advanced concepts like JOINs. You will: -write foundational SQL statements like: SELECT, INSERT, UPDATE, and DELETE -filter result sets, use WHERE, COUNT, DISTINCT, and LIMIT clauses -differentiate between DML & DDL -CREATE, ALTER, DROP and load tables -use string patterns and ranges; ORDER and GROUP result sets, and built-in database functions -build sub-queries and query data from multiple tables -access databases as a data scientist using Jupyter notebooks with SQL and Python -work with advanced concepts like Stored Procedures, Views, ACID Transactions, Inner & Outer JOINs through hands-on labs and projects You will practice building SQL queries, work with real databases on the Cloud, and use real data science tools. In the final project you’ll analyze multiple real-world datasets to demonstrate your skills.

68/100

CourseAsk score

What the provider tells you: 32/45
Who stands behind it: 20/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

write foundational SQL statements including SELECT, INSERT, UPDATE, and DELETE
filter results using WHERE, COUNT, DISTINCT, and LIMIT clauses
differentiate between DML and DDL
use advanced SQL functions such as Stored Procedures and Views
analyze real-world datasets using SQL and Python

Data Analysis #python #data visualization #cloud databases #data manipulation #data analysis #sql #data science #databases #querying #joins #data querying #jupyter notebooks #sub-queries #acidi transactions

$39.00

Price shown by Coursera — confirm on their site.

Enroll on Coursera

You'll be redirected to Coursera to complete enrollment.