SQL

SQL is the standard language for storing, manipulating, and accessing information in databases. Retrieving data is the first step on the path of analytics and modeling, and this is the reason why SQL is a must-have skill for professionals in the data science industry.

LEARNING OUTCOME

Understand the logic of transactional databases when applied to an e-commerce business model Connect different information such as customer transactions, their demographics, and product catalogues Find answers and drive insights by putting together a holistic view of the business and its customers ‎Gather the dataset needed for your machine learning project

CONTENT

Introduction

Why SQL?

RDBMS landscape

NoSQL

SQL Concepts and Basic Operations

CAP Theorem

ACID Test

Type of statements

Basic commands

String and datetime functions

Advanced Operations

Joins

Aggregations

Sub-queries

Window functions

Indexing

Optimization

Connecting to Python