SQL Training

This course is aimed at providing practical, in-depth SQL training. This training is meant to provide knowledge from the basic to the advanced level. SQL Training is for all the databases, i.e Oracle, SQL Server, etc. We prepare students for real-time scenarios.

Introduction to SQL

Introduction to Course

•  Introduction to Database
• Restricting Data (Using Clauses)
• Operators- Arithmetic
• Logical Operators(AND,OR,NOT)
• Operators- Comparison
• Operators: Set (UNION,UNION ALL,INTERSECT,MINUS)
• Concatenation Operator
• General Operators (LIKE, IN, Between, Exist)

Functions

Single-row functions

• Character
• Number
• Date

Multiple Row Functions

• Avg()
• Min()
• Max()
• Count()
• Sum()
• Using Rollup, Cube
• Usage of Having , Group by Clause
• Having vs Where Clause

Categories of Commands

Learn how to manipulate and create database objects. This section is very important from interview point of view because Categories of commands are basic of SQL and are a must if you want to proceed

• DDL (Create, Drop, Alter, Rename, Add, Modify)
• DML (Insert, Update, Delete, Select)
• DCL(Grant, Revoke)
• DDL VS DML
• Creating Tables, Indexes, Constraints Sequences, Synonyms and Views
• Dropping Tables, Indexes, Constraints, Sequences, Synonyms and Views
• Modifying Tables, Indexes, Constraints Sequences, Synonyms and Views

Joins

Learn how to fetch data from more than one table. Today, you will not find every detail in one table, so joins are very useful to extract data from different tables simultaneously

Oracle Joins

• Equi Join
• Non-Equity Join
• Self Join
• Outer Join

SQL Server Joins

• Inner Join
• Natural Join
• Cross Join
• Outer Join (Left Outer Join, Right Outer Join, Full Outer Join)

Sub Queries

Learn how to fetch data, depending upon indirect conditions.

• Single-row subqueries
• Multiple-row subqueries
• Complex subqueries
• Correlated subqueries

Constraints

Learn how to restrict the type of data to be inserted in a column. At the time of database design and planning, we always focus on table design to determine which data should be allowed or not allowed in a column.Not Null Constraint

• Modifying
• Dropping
• Implementation when table is already Exists
• Column-Level Implementation

Check Constraint

• Adding
• Dropping
• Implementation when table is already Exists
• Table and Column Level Implementation

Unique Key Constraint

• Adding
• Dropping
• Implementation when table is already Exists
• Table and Column Level Implementation

Primary Key Constraint

• Adding
• Dropping
• Implementation when table is already Exists
• Table and Column Level Implementation
• Differentiating Unique and Primary Key

Foreign Key Constraint

• Adding
• Dropping
• Implementation when table is already Exists
• Table and Column Level Implementation
• Differentiating Unique and Primary Key

Database Objects

Database objects: what are their uses and how to create them? Database objects are Views, indexes, synonyms, sequences, and tables Views

• Creating read-only views
• Creating Views with CHECK Option
• Creating Force Views
• Modifying Views

Indexes

• Internal Working of Indexes
• Creating B-Tree, Bitmap, Unique, and Functional Indexes
• Creating Index On Multiple Columns

Synonyms

• Public Synonym
• Accessing Different Schemas
• Dropping

Sequences

• Creating Sequences
• Nextval and Currval functions
• Implementing Sequence on Tables

Table

• Advance-level operations on Table