Ementorhub

What you'll learn

Analyze data within a database using SQL and Python.

Create a relational database and work with multiple tables using DDL commands.

Construct basic to intermediate level SQL queries using DML commands.

Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

Skills you'll gain

SQL

Data Manipulation

Pandas (Python Package)

Stored Procedure

Data Analysis

Relational Databases

Jupyter

Transaction Processing

Query Languages

Databases

There are 6 modules in this course

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.

Introduction to Relational Databases and Tables

Intermediate SQL

Accessing Databases using Python

Course Assignment

Bonus Module: Advanced SQL for Data Engineers