We Are Happy To Announce | Valuable Feedback of our Trainer |Trupti Kulkarni
Why take SQL Training?
Course Contents
Introduction to RDBMS Concepts
Drawbacks of earlier Flat File System
Relation Tables Concepts
ERD
Introduction to SQL
SQL Types
SQL Commands
Introduction to Databases
Oracle
SQL Server
DB2
Teradata
MySQL
MS Access
Retrieving Data
Filtering records through where clause using relational operators.
Logical operators AND, OR, NOT
SQL Operators LIKE, IN, Between, IS Null etc.
Sorting the rows
Single Row Functions
Numeric Functions
Date Functions
String Functions
Concatenating operators
Handling Nulls
Conditional Function Case
Summarizing Data
Aggregate functions like sum, max, min, avg, count
Group by clause
Having clause
Using Joins to query Multiple tables
Inner Join
Outer Join (Left, Right, Full)
Cross Join
Self-Join
Set Operators
Union
Union All
Intersect
Minus/Except
Working with Sub queries
Single row sub query
Multi row sub query
Multi column sub query
Nested sub queries
Correlated Sub queries
Derived Tables
Using Exists and Not Exists operators with Simple and Correlated sub queries.
Common Table Expressions
With Clause Queries
Recursive Queries
Creating and Altering Database Tables
Data types – Char, Varchar, Date, Number and many more
Creating table without & with constraints
Referential Integrity
Duplicating Tables
Altering table:
Enabling and Disabling Constraints
Changing data types
Adding, dropping columns
DML Commands
Simple Insert, Update and Delete Commands
Insert, Delete and Update commands along with sub queries
TCL Commands
Commit, Rollback and save points
Locks
Isolation Levels
ACID properties
Window or Analytical Functions
Over function
Partition by and Order By clauses within Over function
Rank, Dense_Rank and RowNumber functions
Implementing Views
Importance of Views
Simple views
Complex views
With Check Option Clause
Temporary Tables
Scenarios where Temporary Tables are used
Local & Global Temporary Tables
Data Security
Creating users
Grant and Revoke Commands
Object Level Privileges
System Level Privileges
Programmability
Using Variables
Looping
Conditional statements
Cursors
Exception handling
Stored Procedures
User Defined Functions
Triggers
Indexes
Clustered
Non-Clustered
Filtered
Index Seek / Scan / Key lookup / Include
Scheduling Jobs
Scheduling stored procedures
Scheduling SQL scripts#learning #certification #onlinetraining #analystsera #programming #elearning #vba #sql #ms #microsoft