Scribd
Upload
11 views12 pages

Comprehensive SQL Guide and Techniques

The document outlines various SQL concepts and commands across multiple chapters, including constraints, select statements, aggregate functions, and data manipulation commands such as insert, update, and delete. It also covers advanced topics like joins, subqueries, views, and indexes. The content is designed to provide a comprehensive understanding of SQL for database management.

Uploaded by

MEHRAJ UD DIN
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views12 pages

Comprehensive SQL Guide and Techniques

The document outlines various SQL concepts and commands across multiple chapters, including constraints, select statements, aggregate functions, and data manipulation commands such as insert, update, and delete. It also covers advanced topics like joins, subqueries, views, and indexes. The content is designed to provide a comprehensive understanding of SQL for database management.

Uploaded by

MEHRAJ UD DIN
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Chapter 5

MySQL constraints
01 Primary Key Constraint

02 Foreign Key Constraint

03 Unique Constraint

04 Default Constraint

05 Not Null Constraint


Chapter 6

SQL Select Statement


01 Select From

02 Where

03 And, Or, Operator Precedence

04 In – Not in, Like - Not Like

05 Wildcard Characters

06 Between – And, Is Not Null – Is Null

07 Select Distinct
Chapter 7

Introduction to Aggregate
Functions
01 Order By

02 Group By

03 Using Aliases

04 Having

05 Where Vs Having

06 Limit
Chapter 8

SQL Insert Statement


01 The Insert Statement

02 Inserting data into a new Table


Chapter 9

SQL Update Statement


01 TCL’s Commit and Rollback

02 The Update Statement

03 Rollback
Chapter 10

SQL Delete Statement


01 Delete Statement

02 Drop

03 Truncate

04 Drop vs Truncate
Chapter 10

SQL Delete Statement


01 Delete Statement

02 Drop

03 Truncate

04 Drop vs Truncate
Chapter 11

Aggregate Functions
01 Count(), Sum()

02 Min() & Max()

03 Avg()

04 Round()

05 Coalesce()

06 Isnull() & Coalesce()


Chapter 12

SQL Joins
01 Introduction to Joins

02 Inner Join, Left, Right & Outer Join

03 Duplicate Records

04 Join & Where Used together

05 Cross Join

06 Aggregate Functions with Join

07 Join more than 2 tables and self join

08 Union vs Union All


Chapter 13

SQL Subqueries
01 SQL subqueries with in nested inside where

02 SQL subqueries nested in select & from


Chapter 14

Advanced SQL Topics


01 Views

02 MySQL Indexes

03 The Case Statement

04 MYSQL Triggers

05 Row_Num()

06 Rank()

_____________________________________
Congratulations for Completing the SQL
_____________________________________
CONNECTING
SQL &
POWERBI

Created by
Kanav Taneja
[Link]

You might also like