SQL Window (Analytical) Functions Part 2 | lag, lead, preceding, following | k2analytics.co.in
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- This Video as part of the SQL Programming covers the various SQL Functions with SQL Syntaxes.
Window Functions / Analytical Functions
Rank()
Dense_Rank()
Row_Number()
Lag()
Lead()
Ntile()
Cume_Dist()
First_Value()
Last_Value()
Clauses of Window Functions - Over(), Partition By Order By, Asc / Desc, Preceding, Following
The code file SQL_courses_example_data_preparation.sql to create the tables and dummy records used in the training course can be downloaded from the Complimentary Resources section of our website - elearning.k2an...
SQL Programming Complete Course Outline
This Playlist on SQL Programming is designed to give you a complete hands-on experience with SQL.
Course Link on our website - www.k2analytic...
Course Outline:
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
Blog link: k2analytics.co...
Email: ar.jakhotia@k2analytics.co.in