SQL

Why SQL, Because it is Powerful Structured Query Language (SQL) is a programming language used to communicate with databases. … SQL is most widely used for relational databases recognizing connections among stored items of information.

Analytical Edupoint is the best institute in Delhi and NCR who providing Data Analytics Training as well as SQL training. Our trainers have more than 7 – 10 years of experience in the same industry. The best part is free trial session/demo session for each course.

Introduction to SQL
•Database Models
•Some Introductory Terminology
•DBO,Table,Views,Query
•DDL,DML,DQL,DCL Concepts

Variable and Datatype
Data Types ,Variable Names Categories of SQL
 Statements Oracle Datatypes
The CREATE Statement
The DROP Command
The ALTER Command
Modifying Table to Use Constraints Working with Arrays

Date Editing
DML Statements
The SELECT Statement
The INSERT Statement
The DELETE Statement
The UPDATE Statement
More SQL*Plus Commands

SQL FUNCTIONS
The DISTINCT
Keyword Mathematical
Functions String
Functions Date Functions
Conversion Functions

Joining Tables
Joining Basics
Cartesian Product
Inner Joins and Outer Join
Equi-Join Non-Equi
Join Right & Left Outer Join
Full Outer Join Set Operator
Union & Union All Intersect SQL Subqueries

Groups
SQL Statements, GROUP BY Clause
HAVING Clause
Order of a SELECT Statement

Reports
Reporting Concept
The SET Command The COLUMN Command
The BREAK Command
The COMPUTE Command

Looping
Loop Concept, For LOOP Dual ,
For Loop While Loop

Triggers
Triggers and database events
Defining a trigger
Timing a trigger Enabling and disabling a trigger

Procedures, functions and Views
Basics of procedures
Basics of functions & Packages Package forward declaration
Package dependency Package overloading Listing package information

Error Handling
Errors in Programs Run Time Exceptions