SQL

Introduction

• What Are Relational Databases?
• RDBMS Benefits and Limitations
• SQL vs NoSQL
•  

Basic SQL Syntax

• SQL keywords
• Data Types
• Operators
• Operators
• SELECT
• INSERT
• UPDATE
• DELETE

Data Definition Language (DDL)

• Create Table
• Alter Table
• Truncate Table

Data Manipulation Language (DML)

SELECT

• FROM
• WHERE
• ORDER BY
• GROUP BY
• HAVING
• JOINs
• INSERT
• UPDATE
• DELETE

 

Aggregate Queries

                SELECT

• SUM
• COUNT
• AVG

 

• MIN
• MAX

Aggregate Queries

• GROUP BY
• HAVING

Data Constraints

• Primary Key
• Foreign Key
• Unique
• NOT NULL
• CHECK

JOIN Queries

• SQL JOIN Queries
• INNER JOIN
• LEFT JOIN
• FULL OUTER JOIN
• Self Join
• Cross Join
•  
• Creating Views
• Modifying Views

 

Indexes

• Managing Indexes
• Query Optimization

Sub Queries

• Types of Sub Queries
  • Table
  • Row
  • Column
  • Nested Subqueries
  • Correlated Subqueries

 

 

Advanced SQL Functions

Numeric

• CEILING
• ROUND
• MOD
• ABS
• FLOOR

 

Advanced SQL Functions

Conditional

• NULLIF
• CASE

Date and Time

• TIME
• DATE
• DATEADD

 

Transactions

• BEGIN
• COMMIT
• ROLLBACK
• SAVEPOINT

Transactions

• Transaction Isolation Levels

Transactions

• Transaction Isolation Levels

 

Data Integrity and Security

• Data Integrity Constraints
• GRANT and REVOKE
• Database Security Best Practices

 

Data Integrity and Security

• Stored Procedures and Functions

 

Data Integrity and Security

• Performance Optimization

 

• Query Optimization Techniques
  • Using Indexes
  • Optimizing Joins
  • Reducing Subqueries
• Selective Projection

 

Query Analysis Techniques

Advanced SQL Concepts

• Recursive Queries
• Pivot and Unpivot Operations
• Window Functions
  • dense_rank
  • rank
  • Row_number
  • Lead
  • lag
• CTEs (Common Table Expressions)
• Dynamic SQL

 

Advanced SQL Concepts

 

 

 

 

 

 

 

 

 

 

دانش و مهارت استفاده از کامپیوتر و اینترنت