SQL

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

  • Many Modules , Online & Self-paced Learning With Experienced Trainers.

  • Get Certified, Earn Your Badge

  • Project Based Scenario.

Instructor-led live online classes

OFFER ! Pay an 'Early Bird' deposit now and save 10% on the final price!

Early Bird Offer

  • 08

    Jun

    Mon - Fri ( 15 Days )

    7:00 AM - 8:00 AM(IST)

    • 40% off

      16,667

    10,001
40% Off till 12-Jun
  • 08

    Jun

    Mon - Fri ( 15 Days )

    7:00 PM - 9:00 PM(IST)

    • 40% off

      16,667

    10,001
40% Off till 12-Jun
  • 13

    Jun

    Sat - Sun ( 4 Weeks )

    7:00 PM - 9:00 PM(IST)

    • 40% off

      16,667

    10,001
40% Off till 12-Jun

Live Classes

On-time scheduled virtual classes with limited trainer-student ratio.

Expert Trainers

Best industry experts with years of online training experience.

Tailored Course

Based on your expertise and goals we design course for you.

Flexible Schedule

Learn at your schedule , time zone and convenience.

Get Certified

Receive a certificate to confirm the level of your skills in a professional context.

×

Get A Quote

Please fill your details. Fields marked with mandatory are mandatory

(Allowed types : PDF, DOC, XLS, JPEG, GIF, PNG )

Privacy Policy : We hate SPAM and promise to keep your email address safe.