Course Detail

Course Description

Want to learn SQL and PL/SQL in Gurgaon? Talent++ has the best professional trainer offering practical PL/SQL course in our Gurgaon center. Our experienced working professional trainer will give you the best PL/SQL training in Gurgaon at an affordable course fee lowest in entire NCR Delhi and NOIDA.

Why to learn SQL, PL/SQL?

• SQL PL/SQL can be used to retrieve large amounts of records from a database quickly and efficiently.
• SQL is widely used for relational databases.
• SQL mainly consists of English statements and it is very easy to learn and understand a SQL query.
• SQL is used to create databases, manage security of a database, hence it is the need of each and every business.
• SQL PL/SQL is used for linking front end computers and back end databases, so it will help to understand business easily.
• SQL is the database language which is used by businesses and enterprises throughout the globe. For an enterprise application it is a perfect language for a database.
• SQL can do both the jobs of being a programming as well as an interactive language at the same time.

Benefits after learning SQL/PLSQL?

• SQL integrates with Java also by using an API known as JDBC
• Calculationsin PL/SQL done quickly and efficiently without using Oracle engines
• It runs in local systems, intranet and internet. Databases using SQL can be moved from device to another without any problems.
• SQL supports the latest object based programming and is highly flexible.
• PL/SQL have agreat functionality to display multiple records from the multiple tables at the same time.
• PL/SQL iscapable to send entire block of statements and execute it in the Oracle engine at once.
• Applications are written in PL/SQL areportable in any Operating system. PL/SQL applications are independence program to run any computer.

Call us at +91-9911449111 or write to us as Gurgaon@TalentPlusPlus.com

SQL Topics-    

  Basic SQL

1. Select Command
2. Operator Precedence
3. Column Aliases
4. Concatenation Operator
5. Eliminating Duplicate rows
6. Where clause
7. Comparison Conditions
8. BETWEEN, IN, LIKE, NULL conditions
9. AND, OR, NOT Operators
10. ORDER BY clause

Single Row Functions

1. SQL Functions
2. Types of SQL Functions
3. Single Row Functions
4. Character Functions
5. Number Functions
6. ROUND, TRUNC, MOD Functions
7. Date Functions
8. Data-Type Conversion
9. Nesting Functions
10. General Functions
11. NVL, NVL2, NULLIF, COALESCE, DECODE Functions
12. Conditional Expressions
13. CASE Expression

Joins

1. Cartesian Product
2. Types of Joins
3. Inner, Outer, Self, Cross, Natural Joins
4. USING, ON Clause

Group Functions

1. Group Functions
2. Types of Group Functions
3. AVG, SUM, MIN, MAX, COUNT Functions
4. DISTINCT keyword
5. GROUP BY, HAVING Clause

Subqueries

1. Subquery Syntax
2. Types of Subqueries
3. Single Row Subqueries
4. EXISTS, NOT EXISTS Operators
5. Group Functions, HAVING Clause with Subqueries
6. Multiple Row Subqueries
7. ANY, ALL Operator in Multiple Row Subqueries

Data Manipulation

1. INSERT, UPDATE, DELETE, MERGE Statements
2. COMMIT, ROLLBACK Commands
3. Locking

Table Creation

1. CREATE, ALTER, DROP, TRUNCATE Statements
2. Data Types

Views

1. View Uses
2. Simple and Complex View
3. View Creation
4. Inline View
5. Top-n Analysis

Other Database Objects

1. Sequence
2. Synonym
3. Index

SET Operators

1. SET, UNION, UNION ALL, MINUS, INTERSECT Operator

PL/SQL Topics

Variable Declaration

1. PL/SQL Block Structure
2. Types of Variables
3. Variable Declaration
4. Data Types
5. %TYPE Attribute
6. Composite, Bind Variables

Control Structures

1. IF-THE-ELSE Statement
2. CASE Expression
3. BASIC, WHILE FOR Loops

Composite Data Types

1. Types
2. PL/SQL Records
3. INDEX BY Tables
4. INDEX BY Table of Records

Explicit Cursors

1. Declaring, Opening, Fetching, Closing Cursors
2. Explicit Cursor Attributes
3. FOR UPDATE, WHERE CURRENT OF Clause

Exceptions

1. Types of Exceptions
2. Predefined Exceptions
3. User Defined Exceptions
4. RAISE_APPLICATION_ERROR Procedure

Procedures

1. PL/SQL Subprograms
2. Syntax for creating Procedures
3. Formal V/S Actual Parameters
4. Procedural Parameter Modes
5. IN, OUT, IN OUT Parameters
6. Invoking a procedure from an Anonymous Block
7. Invoking a procedure from Another Procedure

Functions

1. Function Creation
2. Procedure V/S Functions

Packages

1. Overview of Package
2. Components of Package
3. Package Creation
4. Public and Private Constructs
5. Advantages of Package
6. Overloading
7. Forward Declaration

Oracle Supplied Packages

1. DBMS_OUTPUT Package
2. UTL_FILE Package
3. EXECUTE IMMEDITAE Statement

Triggers

1. Types of Triggers
2. DML Triggers
3. OLD and NEW Qualifiers
4. INSTEAD of Trigger
5. DROP TRIGGER Syntax

Note:  Basics of Oracle Reports and Oracle Forms and introduction of Oracle Applications are also taken care under this course.