Live Search

Run Into Every Story

Databases and SQL for Data Science with Python

Databases and SQL for Data Science with Python

Year

2018

Genre

Data

Now Playing: EP 1 / 6

Full

Now Playing

Databases and SQL for Data Science with Python

DataData

Year

2018

Duration

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.

You Might Also Like

Primary 1 English

CoComelon - Happy Holidays

Educational Videos for Children - Lingokids

Vehicle Adventures★ 6.8

BabyBus | Learning Vehicles Song | Car Songs | Cars for Kids | Nursery Rhymes | Baby Cartoon

CoComelon For Journeys

CoComelon Dance Party | Dance Along & Kids Songs

Primary 2 English

Nursery Rhymes by CoComelon

Mathematics★ 7.1

Primary 2 Mathematics

Nursery Rhymes★ 6.5

BabyBus Best Nursery Rhymes, Kids Songs, and Cartoon for Kids!

Nursery Rhymes★ 6.9

Best Nursery Rhymes & Kids Songs - by BabyBus

Baby Learning with CoComelon - Colors, Shapes and Numbers!

Mathematics★ 7.9

Primary 4 Mathematics

SS 1 English

Adventures★ 6.9

BabyBus | Super Panda Rescue Team | Cartoon for Kids | Kids Animation

JJ & Friends by CoComelon

Compilations★ 7.1

Animation & Kids Songs collections For Babies | BabyBus

Year4 English

Computer Basics★ 0

Programming in Python

Science & Technology★ 7.3

JS 3 Science & Technology

Science & Technology★ 7.6

JS 1 Science & Technology

ABC Songs for Kids - CoComelon Nursery Rhymes

Business & Finance★ 7.9

SS 1 Business & Finance

Computer Basics★ 0

HTML and CSS in depth

Stream Databases and SQL for Data Science with Python Online Free in HD | MovieBoxRun