Contact US

Latest Courses

Login

Retrieve Password
Back to login/register

Overview

SQL is a structured query language developed by IBM. SQL was designed to perform database operations like database creation, deletion, updating etc. In present scenario SQL is must to have skill set for every programmer. To become a perfect programmer its important that you understand the data very well. Knowledge of SQL basically help you to understand data quickly and you can also perform data base related operations. It is best time to take SQL Online Training from http://coursedroid.com/

  • Customized Study material
  • Access to recorded sessions
  • Exercise after each session
  • Live Project

Prerequisites

  • Must have basic knowledge of business intelligence concepts.
  • Must have understanding of DBMS and Sql concepts
  • Experience on any business intelligence tool will be helpful

Training Format:

  • Online Training Instructor Lead Online classes &Interactive sessions.
  • Certification of the course Completion.
  • Life Time Access to Online video tutorial.
  • Exercise after class
  • Live Project to provide the real time project experience
  • Evaluation Test
  • Course Completion Certification

SQL

  • What is SQL?
  • Why SQL?
  • History
  • Sql Process
  • Implementation of Data Integrity & Integrity Constraints
  • Normalization

SQL RDBMS concepts

  • RDBMS Rules (Codd’s Rules)
  • MYSQL,SQLSERVER,Oracle,MSAccess
  • System Tables & Data Dictionary
  • What is Field
  • Record or Row
  • Column
  • Null value

SQL Data Types

  • Numeric
  • Date
  • String
  • Binary
  • Misc

SQL Commands

  • DDL
  • CREATE,ALTER,DROP.
  • DML Commands
  • Insert, Update, Delete
  • DCL
  • Grant,revoke
  • DQL
  • Select
  • TCL
  • COMMIT,ROLLBACK,SAVEPOINT,SET

 SQL Constraints

  • Not Null
  • Default
  • Unique
  • Primary
  • Foreign
  • Check
  • index

SQL Operators

  • Arithmetic Operators
  • Relational Operators
  • Logical Operators
  • Set Operators

SQL Functions

  • Single Row Functions
  • Group functions
  • Arithmetic Functions
  • String Manipulation Functions
  • Date Manipulation Functions
  • Data conversion Functions
  • List of Functions /Misc.Functions

SQL Join Types

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • SELF JOIN
  • CARTESIAN JOIN
  • SQL Unions
  • SQL Intersect
  • SQL Except
  • Handling NULL values

Sub Queries

  • Simple /complex sub queries
  • Co-related sub query
  • Filters/Set operator usage

Database Objects

  • Index
  • Types of Indexes
  • Unique Index
  • Non Unique Index
  • Function Bases Index

Database Operations

 Views

  • Types of views
  • Forced views
  • Rules for DML on Views
  • In –Line Views

 Synonyms

  • Types of synonyms
  • Private synonym
  • Public synonym
  • Security aspect

Sequence

  • Usage of varies clauses
  • Pseudo columns

Data Control Language

  • GRANT
  • REVOKE
  • Create New User
  • Assign Privileges For User
  • What are privileges?
  • What is role?
  • Grant privileges
  • Cascading privileges
  • Password Change
  • Select Clause all detail Scenarios like where,group by,order by,like,AND OR,Distinct,Top
  • DROP vs Delete vs Truncate
  • WHERE vs Having
  • SQL Injection
  • Oracle Explain Plan
  • Oracle Auto Trace

PL/SQL

  • Introduction to PL/SQL
  • Key benefits of PL/SQL over SQL
  • Architecture of PL/SQL
  • PL/SQL block Structure
  • Constructs of PL/SQL
  • Data type support in PL/SQL
  • Variables /Constants of PL/SQL
  • Flow control Statement Types
  • If /Nested if .. / Exit/Go to/Raise
  • Instructive statement types
  • Simple loop (infinite loop)
  • While loop
  • For loop
  • Reverse For loop

Embedded SQL

  • What is Embedded SQL
  • Need of Embedded SQL
  • Constructs of Embedded SQL
  • Transactions through Embedded SQL
  • Valid statements of SQL
  • Dynamic SQL

Exception Handling

  • What is Exception?
  • Type of Exceptions
  • Uses Defined Exceptions
  • Use of raise and its Scope
  • Raise – Application-Error ( )
  • PRAGMA EXCEPTION_INIT ( )

Attribute data types

  • Description
  • Advantages
  • Types of variables of PL/SQL
  • Record type of PL/SQL

Cursors

  • Instruction to Cursor Management
  • Pictorial view of cursor Diagram
  • Implicit curser
  • Explicit curser
  • Cursor Attributes
  • Cursors using simple loop
  • Cursor for loops
  • Cursor Exceptions
  • Cursor Parameters
  • Reference cursors

Sub programs

  • Types of PL/SQL blocks
  • Anonymous PL/SQL block
  • Named PL/SQL block
  • Stored PL/SQL
  • Procedures
  • Type of parameters
  • Procedures Using In Parameter
  • Procedures Using Out Parameter
  • Procedures Using InOut Parameters
  • Functions

Packages

  • Description
  • Advantages over Stand alone Schema objects
  • Encapsulation
  • Package over loading
  • Packages Create Using Global Variables
  • Packages Create Using Record Types
  • Packages Create Using Cursors
  • Packages Create Using Ref Cursors
  • Packages Create Using plsql Table Types
  • Packages Create Using Procedures
  • Packages Create Using Functions

DB Triggers

  • Types of Triggers
  • Triggering events
  • Usage of Old & New reference
  • View Trigger instead of Trigger Cascading /firing
  • Table mutation error
  • Bind variable support
  • Special clauses of Triggers
  • Statement Level Triggers
  • Row Level Triggers

Object Concepts

  • Object Types
  • Create Object Tables

Collections

  • Create Nested Tables
  • Index By Tables / Associative Array
  • Varray

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • $250 $200
  • UNLIMITED ACCESS
104 STUDENTS ENROLLED

    Enroll For Demo Class






    Key Features

    Online Classes: 45 hrs
    Project:

    Support:
    Lifetime Access:

    All Rights Reserved © Coursedroid