Databases and SQL for Data Science with Python

Databases and SQL for Data Science with Python

Année

2018

Genre

Data

En cours : EP 1 / 6

Full

Now Playing

Databases and SQL for Data Science with Python

DataData

Année

2018

Durée

137m

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.

Vous aimerez aussi

La biologie★ 7.8

SS 2 Biology

Mathématiques★ 7.2

JS 2 Mathematics

Nursery Rhymes | Words & Sounds

Learn English with Movies

Compilations★ 7.1

Animation & Kids Songs collections For Babies | BabyBus

Learn English with Akili and Me!

La physique★ 7.0

SS 3 Physical

Technologie scientifique★ 7.3

JS 3 Science & Technology

Learn With Ms Rachel - Learn To Talk - Baby, Toddler and Preschool Learning

Learn To Talk with Ms Rachel

Mathématiques★ 7.6

KS2 Maths

Comptines pour enfants★ 0

Songs for Kids

Learn English with Music

La biologie★ 0

Animal Videos

Learn To Read with Ms Rachel

Learn Colors, Numbers, Shapes and Letters with Ms Rachel

Grade 3 English

Learn British English with TV Series

Comptines pour enfants★ 0

Nursery Rhymes & Kids Songs

Baby Learning with Ms Rachel - Videos for Babies

English spelling★ 7.7

KS2 English spelling

Engineering

English Fluency Coaching Lessons

Dessin animé★ 0

30+ Blippi Wonders | Fun and Educational Cartoons For Kids |