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 or 1Z0-051
  • 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


Sql/PlSql

Practical based Training by Rocky sir on oracle database(sql,plsql) is exceptional. The preparation material provided during the course is extremely helpful. All the tracks designed by Rocky sir keeping in mind what actually industry needs. If fresh graduates has confusion "what next"? then this is the right place. Thank you Simran ma'am, Rocky sir and SCTPL team for putting in so much effort that i got trained and placed..

Mr.Shivaji Nana Patil { Bsc IT, Mumbai University }

Selected at Eclinical Works as Interface Implementation Engineer Salary : 2.0 LPA For many more feedbacks see here
web

We found "Suven Consultants" as one of the best Technology training company. We have been hiring PL/SQL developers { in Oracle Database technology }. I think they are one of the best companies to connect for skilled fresher requirements.

HR, Open Radix Software

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

Course PL/SQL   (Only at DADAR)
Batch Vacation
Day Every Monday
Start-Date 21 st January 2019
End-Date 25 th March 2019
Timing 6:00 pm - 9:00 pm
Fees PL/SQL ₹ 5950 /- ( *before batch start date )
₹ 6950 /- ( After batch starts )
{ **Includes Exam cost of SCTPL }

Address

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

Course SQL  @ Thane
Batch Regular
Day Every Sat + PH
Start-Date 19 th January 2019
End-Date 9 th March 2019
Timing 11:30 am - 2:00 pm
Fees SQL ₹ 3950 ( *before batch start date )
₹ 4950 ( After batch starts )
{ **Includes Exam cost of SCTPL }

Address

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

Course SQL  @ Kandivali
Batch Regular
Day Every Sun + PH
Start-Date 20 th January 2019
End-Date 10 th March 2019
Timing 11:30 am - 2:00 pm
Fees SQL ₹ 3950 ( *before batch start date )
₹ 4950 ( After batch starts )
{ **Includes Exam cost of SCTPL }

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) One-full-day(8 hrs) - 100% Practical Microsoft SQL Server Workshop

    • E_book_1 : Microsoft SQL Server Class_Notes Download
    • E_book_2 : Microsoft SQL Server Pracs Download

    6) Must Read Information about Oracle Architecture Download

    7) About a Multitenant Environment_oracle 12c Download

    8) PL/SQL Oracle Home practice _file_1 Download

    9) PL/SQL Oracle Home practice _file_2 Download

    10) Oracle SQL Practice Queries Download_1 Download_2

    11) Oracle PL/SQL Practice Queries Download_1 Download_2

    12) Solution (by Rocky Sir) to HackerRank > SQL problems Download    ReadMe.txt

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

    14) Sample Resume Format Download 1         Download 2

    15) 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

    14) SQL - A Practical Introduction Must See Once

Resources

For More Videos go to Our Youtube Channel


Data analytics using R

Data Analytics Using R

  • What is Data analytics?
    Data analysis, also known as analysis of data or data analytics, is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different business, science, and social science domains.
  • Data mining is a particular data analysis technique that focuses on modeling and knowledge discovery for predictive rather than purely descriptive purposes, while business intelligence covers data analysis that relies heavily on aggregation, focusing on business information.
  • For above data analysis i.e data mining and business intelligence we need learn frameworks like Apache Hadoop and languages like R.
  • What is Apache 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.
  • What is R ?
    R is an open source programming language and software environment for statistical computing and graphics that is supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and data miners for developing statistical software and data analysis.
  • download complete syllabus...

hadoop

hadoop

Exclusive Batches (By Industry Expert) only at SCTPL Chembur & Kandivali

Batch AngularJs-Bootstrap Python-Django JSP & Servlets Data Analytics Using R
Duration 40 hours 40 hours 30 hours 36 hours
( 4 days , 9hrs per day)
Timing & Dates Click Here Click Here Click Here
Fees ₹ 3950 /- ₹ 3950 /- ₹ 2950 /- ₹ 3950 /-
** Avail ₹ 500 /- Discount for Python Students
Interview dates Immediately after Completion of Respective Placement Track

Address

Address

Download Section

Course Download

    1) Apache Hadoop Book 1

    2) Hadoop Setup

    3) M/c learning and R-Programming Notes

    • 3.a>
    • 3.b>
    • 3.c>

    4) HDFS MapReduce Notes

    5) One Month Internship Project

    • 5.a>
    • 5.b>


Machine Learning , Deep Learning and base to AI using Python

  • What is Machine learning { called ML } ?

    Machine learning is an application of artificial intelligence (AI) that provides systems the ability to automatically learn and improve from experience without being explicitly programmed. Machine learning focuses on the development of computer programs that can access data and use it learn for themselves.

    The process of learning begins with observations or data, such as examples, direct experience, or instruction, in order to look for patterns in data and make better decisions in the future based on the examples that we provide. The primary aim is to allow the computers learn automatically without human intervention or assistance and adjust actions accordingly.

  • What is Deep Learning { called DL } ?

    Deep learning is a machine learning technique that teaches computers to do what comes naturally to humans: learn by example. Deep learning is a key technology behind driverless cars, enabling them to recognize a stop sign, or to distinguish a pedestrian from a lamppost. It is the key to voice control in consumer devices like phones, tablets, TVs, and hands-free speakers. Deep learning is getting lots of attention lately and for good reason. It’s achieving results that were not possible before.

    In deep learning, a computer model learns to perform classification tasks directly from images, text, or sound. Deep learning models can achieve state-of-the-art accuracy, sometimes exceeding human-level performance. Models are trained by using a large set of labeled data and neural network architectures that contain many layers.

  • Applications of ML and DL :

    • Banking & Insurance
    • Defense & Intelligence
    • Public Administration
    • Life Science & Pharma
    • Oil & Gas
    • Media & Publishing

hadoop