SQL Functions | String, Data, Numeric Functions | Coalesce, Convert_TZ, Soundex, Year, Month, Cast
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- This Video as part of the SQL Programming covers the various SQL Functions with SQL Syntaxes.
String Functions
length(), locate(), soundex(), concat(), trim(), ltrim(), rtrim(), substring(), left(), right(), lower(), upper()
Date Functions
now(), current_date(), year(), month(), day(), weekday(), week(), date_add(), date_format(), str_to_date(), timestampdiff(), datediff(), interval, TimeZone concept
Numeric Function
sum(), max(), greatest(), min(), least()
Coalesce()
Cast()
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