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

Описание:

The video begins with a course introduction at 0:00, followed by an overview of SQL, databases, and DBMS at 3:28. It then dives into SELECT statements for retrieving data at 7:08, covers aggregate functions like COUNT, DISTINCT, and LIMIT at 10:47, and demonstrates INSERT, UPDATE, and DELETE operations at 13:16, 15:55, and 19:11 respectively. The lesson continues with relational database concepts at 19:11, types of SQL statements (DDL vs. DML) at 24:42, and table creation at 27:07. It explains altering, dropping, and truncating tables at 31:05, and shows how to create a database instance on the cloud at 35:15. The course then explores string patterns and ranges at 41:06, sorting and grouping result sets at 45:32 and 48:18, built‑in database functions at 51:53, and date/time functions at 58:05. At 1:01:14 it introduces sub‑queries and nested selects, followed by working with multiple tables at 1:05:57. The video covers accessing databases using Python at 1:12:19, writing code with the DB‑API at 1:18:19, and using SQL magic at 1:23:55. It then demonstrates data analysis with Python at 1:29:59, connecting to a database via the ibm_db API at 1:39:37, creating tables, loading data, and querying at 1:41:48, working with real‑world datasets at 1:45:42, and retrieving table and column details at 1:51:34.