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

EP 1

Now Playing

Databases and SQL for Data Science with Python

DataDataEn cours : EP 1 / 6

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

Dessin animé★ 0

Kids Songs by CoComelon

CoComelon Lane | NEW Netflix Kids Show

Computer Basics★ 0

Programming in Python

Dessin animé★ 0

Mighty Little Bheem | Netflix Jr.

Dessin animé★ 0

Princess Songs and Nursery Rhymes for Babies - CoComelon Kids Songs

Year2 English

Dessin animé★ 0

Numbers Songs by StoryBots

Dessin animé★ 0

Counting & Numbers Songs by CoComelon

Kids Songs & Nursery Rhymes | CoComelon, Blippi & Little Angel

Dessin animé★ 0

Kids Songs

All New Akili & Me

Dessin animé★ 0

CoComelon | Netflix Jr

Dessin animé★ 0

March 2024 KIDS Songs from LooLoo Kids

Dessin animé★ 0

CoComelon Learn ABCs #Shorts!

Dessin animé★ 0

Happy Holidays from Netflix Jr!

Compilations★ 6.9

BabyBus | Top Songs & Animations for Kids | Kids Cartoon, Nursery Rhymes

Dessin animé★ 0

Yes Yes Songs! CoComelon Nursery Rhymes Mix

Primary 1 English

Dessin animé★ 0

Alphabet (ABC) Songs by CoComelon

CoComelon

Dessin animé★ 0

CocoMelon | Little Baby Bum | Blippi - Nursery Rhymes & Kids TV Shows

Dessin animé★ 0

The Original CoComelon Alphabet Series

Dessin animé★ 0

CoComelon For Journeys

Dessin animé★ 0

ABC Songs for Kids - CoComelon Nursery Rhymes