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

SQL for Data Science IBM Full Course, SQL Tutorial for Data Science videosi uchun yuklab olish ma'lumotlari va tafsilotlari
Muallif:
Data Learning StuffChop etilgan sana:
30/01/2025Ko'rishlar soni:
93Tavsif:
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.
O'xshash videolar: SQL for Data Science IBM Full Course

Learn Python for Data Science | Python Basic for Data Science IBM Full Course

SQL for Data Analytics - Learn SQL in 4 Hours

Data Science Tools IBM Full Course, Data Science Tools and Techniques

Databases In-Depth – Complete Course

MySQL Database - Full Course

