Databases and SQL for Data Science with Python

Databases and SQL for Data Science with Python

Year

2018

Genre

Data

Now playing EEP 1 of 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

Databases and SQL for Data Science with Python

Google Data Analytics Capstone: Complete a Case Study

Data Science Methodology

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

Foundations: Data, Data, Everywhere

Tools for Data Science

Analyze Data to Answer Questions

Prepare Data for Exploration

Accelerate Your Job Search with AI

Share Data Through the Art of Visualization

Mathematics★ 7.8

Primary 1 Mathematics

Learn English with Movies

Adventures★ 6.9

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

PrePrimary English

Business & Finance★ 7.5

SS 3 Business & Finance

Learn With Ms Rachel - Learn To Talk - Baby, Toddler and Preschool Learning

Arts & Design★ 0

Expressive Arts and Design

Live Content★ 7.0

BabyBus Popular Compilations | for TV | Kids at Home | Kids Live Stream | Living Room | Nursery Rhymes & Kids Songs

KS4 English

Preschool Videos with Ms Rachel

Learn English with PODCASTS