SQL for Data Science IBM Full Course

Course Content

0: 00 Course Introduction
3: 28 Introduction to SQL, Database and DBMS
7: 08 SELECT Statement Retrieving data from a table
10: 47 COUNT, DISTINCT, LIMIT in SQL
13: 16 INSERT Statement Populating a table
15: 55 UPDATE and DELETE Statements
19: 11 Relational Database Concepts
24: 42 Types of SQL Statements DDL vs. DML
27: 07 CREATE TABLE Statement
31: 05 ALTER, DROP and TRUNCATE Tables
35: 15 How to create a Database instance on Cloud
41: 06 Using String Patterns, Ranges
45: 32 Sorting Result Sets
48: 18 Grouping Result Sets
51: 53 Built-in Database Functions
58: 05 Date and Time Built-in Function
1: 01: 14 Welcome to SUB-QUERIES and NESTED SELECTS
1: 05: 57 Working with Multiple Tables
1: 12: 19 How to Access Databases Using Python
1: 18: 19 Writing Code Using DB-API
1: 23: 55 Accessing Databases with SQL magic
1: 29: 59 Analyzing Data with Python
1: 39: 37 Connecting to a database using ibm_db API
1: 41: 48 Creating Tables, Loading Data and Querying Data
1: 45: 42 Working with Real World Datasets
1: 51: 34 Getting Table and Column Details