SQL Programming for Data Scientists
15 videos • 1,392 views • by Rajesh Jakhotia SQL Programming Complete Course This Playlist on SQL Programming and it covers the following Database Basics -- What is Database? -- What is Schema? -- SQL Programming & ANSI Standards -- Applications of Database (OLTP & OLAP) -- ACID Properties Introduction to SQL Programming -- Types of SQL Queries: DDL, DML, DCL -- DDL – Data Definition Language -- DML – Data Manipulation Language -- DCL – Data Control Language Data Types: Character, Numeric, Date, Boolean, BLOB Data Definition Language -- CREATE, ALTER, and DROP -- Primary Key, Foreign Key, and Unique Key -- Null, Not Null, and Check Constraints -- Default Value -- Auto Increment Column -- Indexes Data Modeling Concepts -- Conceptual, Logical, and Physical Data Model -- ER Model & Normalization (OLTP) -- Dimensional Model & Denormalization (OLAP) -- Star & Snowflake Schema Data Manipulation Language -- INSERT, UPDATE, DELETE Queries -- SELECT Queries, Sub-Queries, and Common Table Expressions -- Commonly used String, Date, and Math Functions -- Dimensions and Measures Concept in SQL Group By Aggregation queries -- Commonly used aggregation functions: count(), sum(), min(), max(), and avg() -- TRUNCATE Table -- Usage of IN, NOT IN, EXISTS & NOT EXISTS in SELECT Queries Indexes and their importance in SELECT Query -- Clustered Index -- Non-Clustered Index JOINS -- Inner, Full Outer, Left, and Right Outer Join Semi & Anti Join Window Functions -- row_number(), rank(), dense_rank() -- lag(), lead() -- Partition By, Order By, Rows Preceding and Following Overview of Advanced Topics -- Views, User Defined Functions, Stored Procedures, Cursors, and Triggers Capstone Project Course Link on our website - https://www.k2analytics.co.in/data-sc... Blog link: https://k2analytics.co.in/blog Email: ar.jakhotia@k2analytics.co.in