Arcus
Chennai
+91 93 82 72 97 97
Bangalore
+91 93 42 32 97 97
Hyderabad
+91 93 92 82 97 97

SQL & PL / SQL

SQL stands for Structured Query Language. SQL is a simple, yet powerful, language used to create, access, and manipulate data and structure in the database.

PL/SQL stands for Procedural Language/SQL. PL/SQL is Oracle's Procedural Language extension to SQL. PL/SQL expands SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL.


Course Details

Eligibility

BE,B.TECH, M.Sc, MCA, M.TECH.

Duration

Two Months

Project

One Month

Classes

Monday -Friday

Training

Weeks

Batch Timing

2hrs per day

Our Recent Placements

Arcus infotech organizes trained fresher interview slots with leading MNCs .dedicated placement cell provides complete placement support for successfully course completed students.Arcus infotech candidates are currently working in IBM , Accenture , Capgemini , Wipro , CTS , ACS , DELL,PEROT etc.

Job Opportunities in SQL & PL / SQL

SQL is a non-procedural language and PL/SQL is Oracle's procedural language extension to SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java.PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL.

Placement Records

1

Hot Openings

Click Here

2

Placed Candidates List

Click Here

3

Placement Photos

Click Here

4

Job offers

Click Here

COURSE DETAILS


Demo Image
Overly

The database environment

  • Reviewing basic DB architecture concepts

Demo Image
Overly

Basic SQL*PLUS commands

  • Using script files
  • START, @
  • GET, SAVE
  • LIST, PROMPT
  • PAUSE, ACCEPT
  • DEFINE, SPOOL

Demo Image
Overly

Basic SELECT Statement

  • Writing the statement in sqlplus
  • Running the SELECT statement

Demo Image
Overly

Ordering the output

  • Single Column
  • Descending order
  • Multiple column sort

Demo Image
Overly

Conditional retrieval of data

  • Working with complex conditions
  • AND OR NOT LIKE BETWEEN

Demo Image
Overly

Working with variables

  • Creating and using variables
  • Command substitution

Demo Image
Overly

Pseudo columns and functions

  • Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table
  • Working with character functions
  • UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE
  • Working with date functions
  • TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

Demo Image
Overly

Using non-character function

  • ROUND()
  • TRUNC()
  • SIGN()
  • Working with multiple tables
  • Different type of Joins
  • Writing Outer Joins

Demo Image
Overly

Using the SET operators

  • Union
  • Intersect
  • Minus

Demo Image
Overly

Creating Subqueries

  • Single Row subqueries
  • Multiple row Subqueries

Demo Image
Overly
Demo Image
Overly

Transaction Control Language

  • Rollback
  • Commit
  • Savepoint

Demo Image
Overly

Processing hierarchies

  • Creating the Tree structure
  • LEVEL
  • CONNECT BY

Demo Image
Overly

Data Manipulation Language

  • INSERT
  • UPDATE
  • DELETE

Demo Image
Overly

Data Definition Language

  • CREATE
  • TRUNCATE
  • ALTER
  • DROP
  • RENAME
  • DESCRIBE

Demo Image
Overly

Using Declarative Constraints

  • Not Null Constraint
  • Check Constraint
  • Unique Constraint
  • Primary Key Constraint
  • References Constraint
  • On Delete Cascade
  • On Delete Set Null

Demo Image
Overly

Other Database Objects

  • Views
  • Sequences
  • Synonyms
  • Indexes
  • USER_TABLES
  • USER_TAB_COLUMNS
  • USER_OBJECTS
  • USER_IND_COLUMNS
  • USER_UPDATEABLE_COLUMNS
  • Materialized Views
  • Other Data dictionary views

Demo Image
Overly

Database Security

  • Object Privileges
  • Granting access to objects

Demo Image
Overly

Improving query performance

  • Planning and managing the tuning process
  • Employing tuning tools
  • Running EXPLAIN PLAN and autotrace
  • SQL Trace and TKPROF output
  • Optimizer concepts
  • Fundamentals of access paths
  • Gathering object and system statistics with DBMS_STATS
  • Utilizing hints and optimizer mode
  • Specifying first-rows optimization
  • Determining the driving table

Demo Image
Overly

Other Concepts

  • The Relational Database Model
  • The system Development Lifecycle
  • Overview of normalization

Demo Image
Overly

PL/SQL - Blocks

  • Structure
  • Writing Anoyomous Blocks

Demo Image
Overly

Variables

  • Oracle Datatypes
  • TYPE and ROWTYPE declarations
  • Value assignments

Demo Image
Overly

Control structures

  • IF ELSE ENDIF statement
  • IF ELSIF ELSE ENDIF statement
  • LOOP END
  • LOOP statement
  • WHILE condition
  • FOR condition

Demo Image
Overly

Cursors

  • Implicit and Explicit Cursors
  • Cursor Manipulation statements
  • OPEN FETCH CLOSE EXIT WHEN

Demo Image
Overly

Error Handling

  • Predefined Exceptions
  • Non-Predefined Excecptions
  • User Defined Exceptions

Demo Image
Overly

Procedures

  • Creating and Calling Procedures

Demo Image
Overly

Functions

  • Creating and Calling Functions

Demo Image
Overly

Packages

  • Package Header
  • Package Body

Demo Image
Overly

Design Tips and Techniques

  • Format of standard packages in an application
  • Spec and Body
  • NOCOPY hint

Demo Image
Overly

Triggers

  • Database triggers
  • CALLing procedures from triggers

Demo Image
Overly

Dynamic SQL

  • EXECUTE IMMEDIATE
  • DBMS_SQL package

Demo Image
Overly

Oracle Supplied packages

  • DBMS_OUTPUT
  • UTL_FILE

Demo Image
Overly

Collection datatypes

  • Associative Arrays
  • Nested tables
  • VARRAYs

Margo | Home
Training Methedology

Contact Us


#16,Padmanaban Street, North Usman Road, T.Nagar,Near Mahalingapuram Flyover, Kodambakkam Railway Station, Chennai, Tamil Nadu 600017 . 044-4852-8006 / 044-4858-0353/ 9382929797 iswarya@myarcus.com

#320, Lakshmi complex, CMH Road, Near Indira Nagar Metro Station, opp. to HDFC Bank, Bangalore-560038. 080-4156 6363 41216363 / 9342329797 deepak@myarcus.com

#302,3rd Floor. Lal Bungalow, Ameerpet, Near Green Park Hotel. Hyderabad-16 040-40033838/23418787 sandhya@myarcus.com