SQL for Data Science IBM Full Course, SQL Tutorial for Data Science

Description:

SQL for Data Science IBM Full Course, SQL Tutorial for Data Science #sqlfordatascience #sqlbasics #ibmdatascience #sqltutorial 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