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.3

SS 2 Chemistry

الفيزياء★ 7.6

SS 3 Physics

الفيزياء★ 7.6

SS 2 Physics

Mathematics★ 7.8

JS 3 Mathematics

What is Data Science?

Introduction to Data Analytics

Google Data Analytics Capstone: Complete a Case Study

Data Analysis with R Programming

Mathematics★ 7.8

Primary 1 Mathematics

تمويل الأعمال التجارية★ 7.6

SS 1 Business & Finance

الفيزياء★ 7.3

SS 2 Physical

إنجليزي★ 7.2

SS 2 English

CoComelon Lane | NEW Netflix Kids Show

التعلم★ 0

ABC Videos: Write the Letter - Alphabet Writing Lessons for Children

الرسوم المتحركة★ 0

CoComelon | Netflix Jr

Computer Basics★ 0

Introduction to Artificial Intelligence (AI)

Excel Basics for Data Analysis

Databases and SQL for Data Science with Python

Data Science Methodology

الرسوم المتحركة★ 0

Kids Songs by CoComelon

Share Data Through the Art of Visualization

أغاني الأطفال★ 6.5

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

أغاني الأطفال★ 6.9

Best Nursery Rhymes & Kids Songs - by BabyBus

إنجليزي★ 0

Learn English with Movies