Databases and SQL for Data Science with Python

Databases and SQL for Data Science with Python

वर्ष

2018

शैली

Data

अभी चल रहा है: EP 1 / 6

Full

Now Playing

Databases and SQL for Data Science with Python

DataData

वर्ष

2018

अवधि

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.

आपको ये भी पसंद आ सकते हैं

Data Analysis with R Programming

ड्रामा7.2

KS3 Drama

भौतिकी7.7

SS 1 Physics

गणित7.8

Primary 1 Mathematics

कार्टून0

Kids Songs by CoComelon

CoComelon

Baby Learning with CoComelon - Colors, Shapes and Numbers!

कहानी0

English Fairy Tales @EnglishFairyTales

ड्रामा7.9

KS2 Drama

कार्टून0

Alphabet (ABC) Songs by CoComelon

रसायन विज्ञान7.3

SS 2 Chemistry

कार्टून0

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

What is Data Science?

Introduction to Data Analytics

Excel Basics for Data Analysis

Databases and SQL for Data Science with Python

Google Data Analytics Capstone: Complete a Case Study

Safety Adventures6.2

Sheriff Labrador - Kids Cartoon | Safety Cartoon for Kids

Learn English With Disney Movies

नर्सरी राइम्स6.9

Nursery Rhymes & Kids Cartoon (All!!) | Kiki and Miumiu | Baby Shark | Fire Truck | Top Playlist - Nursery Rhymes & Kids Songs by BabyBus

Vehicle Adventures6.8

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

गणित7.2

JS 2 Mathematics

गणित7.8

JS 3 Mathematics

अंग्रेजी7.5

Primary 4 English