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.

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

जीव विज्ञान★ 7.1

SS 3 Biology

कार्टून★ 0

CoComelon - Happy Holidays

Adventures★ 6.8

Kids Songs & Cartoons of Kitten Family | Kids Cartoon for Kids | BabyBus

कार्टून★ 0

English lessons for kids - My English teacher

Data Analysis with R Programming

Ask Questions to Make Data-Driven Decisions

Process Data from Dirty to Clean

Data Visualization and Dashboards with Excel and Cognos

What is Data Science?

Introduction to Data Analytics

Excel Basics for Data Analysis

Google Data Analytics Capstone: Complete a Case Study

कार्टून★ 0

Kids Songs by CoComelon

CoComelon

कार्टून★ 0

Learn Colors with CoComelon!

अंग्रेजी★ 0

Year1 English

कार्टून★ 0

Alphabet (ABC) Songs by CoComelon

कार्टून★ 0

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

अन्य★ 0

Learn English With Disney Movies

Vehicle Adventures★ 6.8

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

Databases and SQL for Data Science with Python

Data Science Methodology

Share Data Through the Art of Visualization

Baby Learning with CoComelon - Colors, Shapes and Numbers!