Oracle SQL & PL/SQL Training & Certification

About SQL

  • SQL is a standard language for accessing and manipulating databases.
  • SQL stands for Structured Query Language.
  • Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database.
  • SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying techniques.
  • Outcome : One would be able to clear Oracle SQL certification test ( 1Z0-061
  • Prerequisite : No Prerequisite.

About PL/SQL

  • 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.
  • PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java.
  • This course is designed for Software Professionals and IT students, who are willing to learn PL/SQL Programming Language in simple and easy steps.
  • This course will give you great understanding on PL/SQL Programming concepts, and after completing this course, you will be at intermediate level of expertise from where you can take yourself to higher level of expertise.
  • Outcome : One is able to clear Oracle PL/SQL exam ( code : 1Z0-144 )
  • Prerequisite : One should be clear on SQL concepts completely.
android


For more feedback Click here


Oracle SQL & PL/SQL

Oracle Database SQL & PL/SQL

SQL Syllabus

Introduction
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables Using Joins
Using Subqueries to Solve Queries
Managing Tables using DML statements
Introduction to Data Definition Language

For detailed syllabus click here

PL/SQL Syllabus

PL/SQL Language Fundamentals
PL/SQL Control Statement
PL/SQL Collection Types
PL/SQL Cursors
PL/SQL Errors and Exceptions
PL/SQL Stored Procedure and Function
PL/SQL Triggers
PL/SQL Dynamic SQL
PL/SQL Packages
PL/SQL Database Interaction

For detailed syllabus click here

Time Table of Oracle Database SQL & PL/SQL Dadar Batch

Batch Vacation Regular
Day Every Day Every Tuesday
Start-Date 12 nd Jun 2017 17 th Jan 2017
End-Date 5 th Jul 2017 2 nd May 2017
Timing 11:30 am - 1:30 pm 6:30 pm - 9:00 pm
Fees*# ₹ 9400 /-

Address

Time Table of Oracle Database SQL & PL/SQL Thane Batch

Batch Regular
Day Every Saturday
Start-Date 21 st Jan 2017
End-Date 6th May 2017
Timing 11:30 am - 2:00 pm
Fees*# ₹ 9400 /-

Address

Time Table of Oracle Database SQL & PL/SQL Kandivali Batch

Batch Regular
Day Every Sunday
Start-Date 22nd Jan 2017
End-Date 7th May 2017
Timing 11:15 am - 1:45 pm
Fees*# ₹ 9400 /-

Address

Download Section

Course Download

    1) Oracle Database Express Edition 12c Download

    2) Oracle Database Express Edition 11g Download

    3) Installation Steps - Oracle DB 10g/11g - By Rocky Sir Download

    4) Oracle SQL additional notes-section_2_Oracle-PL-SQLDownload

    5) Oracle SQL additional notes-section_9_Apache Hadoop Download

    6) Must Read Information about Oracle Architecture Download

    7) About a Multitenant Environment_oracle 12c Download

    9) PL/SQL Oracle Home practice _file_2 Download

    10) Oracle SQL Practice Queries Download_1 Download_2

    11) Oracle SQL & Pl/SQL and Database Interview Questions_difficult Download

    12) Sample Resume Format Download

    13) Oracle Pearson Vue centres for giving Oracle certification exams Download

MUST READ SECTION

    1) Why using bind variables in PL/SQL improves performance ? Read

    2)All, Any and Some operators in SQL - Important !! Must See Once

    3)Exists clause - Important !! Must See Once

    4)ROWSCN, UID and USER Pseudo columns - Important !! Must See Once

    5)Foreign Key Constraint Example -- important !! Must See Once

    6)How and why to create clusters ? Must See Once

    7) complete list of single row functions Must See Once

    8) complete list of Aggregate ( Group ) functions Must See Once

    9) Enhancements done in Oracle 12C over previous versions Must See Once

    10) Format models use in conversion function_Oracle_11g(same applies to 12c) Must See Once

    11) Whats new in Oracle PL/SQL ( Release 1 and 2 ) Must See Once

    12) Must Read Oracle PL/SQL Building Packages and Reference Types Must See Once

    13) Administering User Privileges, Roles, and Profiles Must See Once

Resources

For More Videos go to Our Youtube Channel


Apache HADOOP

About Hadoop

  • The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models.
  • It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.
  • Rather than rely on hardware to deliver high-availability, the library itself is designed to detect and handle failures at the application layer, so delivering a highly-available service on top of a cluster of computers, each of which may be prone to failures.   ( download Syllabus )

hadoop

Exclusive " Big Data Analysis on Hadoop " workshop with hands-on Practical (By Industry Expert) only at SCTPL Chembur & Kandivali

Batch Regular Regular
Day Sat&Sun Sat&Sun
Batch Code BDA-C1 BDA-K1
Location Chembur kandivali
Dates 4th, 5th, 11th & 12th
of Feb 2017
11st, 12th, 18th & 19th
of March 2017
Timing 10am to 4pm Sat  8am to 6pm
Sun  5pm to 9pm
Fees*# ₹ 2950 /-    ( download Syllabus )

Address

Address

Download Section

Course Download

    1) Apache Hadoop Book 1

    2) Hadoop Setup

    3) HBase Setup Notes LabWork

    4) HDFS MapReduce Notes