Scope of SQL

SQL stands for Structured Query Language. SQL is used to communicate with a database.it is the standard language for relational database management systems. SQL Queries can be used to retrieve large amounts of records from a database quickly and efficiently. Using standard SQL it is easier to manage database systems without having to write substantial amount of code. By Learn SQL it will be easier for you to access and manipulate data in MySQL, SQL Server, Access, Oracle, Sybase, DB2, SAS and other database systems.
What will it cover in SQL
Introduction to database

• Database terminology
• Relational Database
• Tables, Rows and Columns
• Referential Integrity

Introduction to SQL

• SQL commands
• Data Definition Commands (DDL)
• Data Manipulation Commands (DML)
• Transaction Control Language Commands
• Data Control Language Commands (DCL)
• Oracle's Naming Convention
• Describe command

DDL COMMANDS

• Creating a Table
• Altering a Table
• Dropping a Table
• Rename
• Truncate Table

DML COMMANDS

• Insert
• Update
• Delete
• Difference between Drop, Truncate and Delete

DCL COMMANDS

• Grant
• Revoke

DATA QUERY LANGUAGE (BASIC QUERIES)

• SELECT COMMAND
• Viewing Data in a Table
• Displaying Unique Values Using the Distinct Clause
• Order By
• The Where Clause
• Using Substitution Variable
• Comparison Operator
• Like operator
• Wildcard Operators
• IN operators
• Between ...And ...Operator
• IS NULL OPERATOR
• Logical operator
• Expressions in Select Clause
• Column Aliases
• Expression In where Clause and Order by Clause

Constraints

• Primary Key
• Not Null
• Foreign Key
• Check
• Unique
SINGLE ROW FUNCTIONS

• Numeric functions
• Character Functions
• Date Functions
• Conversion Functions

GROUP FUNCTIONS

• Group functions or Multiple Rows Functions
• Group by Clause
• Having Clause

JOINS

• TYPES
• Equi-Join/Inner Join
• Non-equi Join
• Cross Join
• Natural Join
• Self-Join
• Outer Join
• Right outer
• Left outer
• Full outer
• Sub Query

OTHER DATABASE OBJECTS
SEQUENCE

• Creating a Sequence
• Generating Sequence Value

SYNONYM

• Creating a Synonym
• Public and Private

VIEWS

• Creating a view
• Removing a view
• Types
• Simple, Complex
• Classification
• Force
• NoForce

Constraints

• Read Only
• With Check Option

INDEX

• Creating index
• Types
• Implicit Explicit

TRANSACTION CONTROL LANGUAGE

• Commit
• Rollback
• Save Point

ADVANCED SQL

• Using Flashback command and Purge command
• Set Unused
• Multiple Insertion and types

Additional features

• We will provide you all kind of study material related to this Programme
• You will also get video of the class which you attended; you can grab that in you Pan Drive or any storage device. So the content of the class remain with you for life time.
• You can Attend your class by staying anywhere in the world through video conferencing.
• Life time support / Assistance from our side
• There will be provision of demo class as well.
• Assistance in searching the Job.
• Small size batches.