UrbanPro
true

Oracle 12C SQL,PLSQL Training

LIVE
40 Hours

Course offered by Skill Sigma

29 reviews

This course will Intro to SQL training and concepts of relational databases and the SQL programming language. You'll gain skills to write queries against single & multipletables, manipulate data in tables & create database objects.

This PL/SQL training shows you how to develop stored procedures, functions,
packages and database triggers. You'll learn to manage PL/SQL program units and dependencies.

Learn To:

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.
  • Conditionally control code flow (loops, control structures).
  • Create stored procedures and functions.
  • Use PL/SQL packages to group and contain related constructs.
  • Create triggers to solve business challenges.
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
  • Create custom packages for applications.
  • Write Dynamic SQL code for applications.

Prerequisites

  • Knoweldge of DBMS
  • Data processing

Audience

  • Working Professionals : Application Developers, System Analysts, Forms Developers, PLSQL Developers
  • Freshers / New to Programming

Gallery (32)

Intro Video

+25 more

About the Trainer

4.6 Avg Rating

29 Reviews

90 Students

19 Courses

Skill Sigma

MSc Statistics, Oracle Certified Professional

She is a technocrat with over 14 years of rich experience as a trainer and currently is the competency head at The Skill Enhancers in the Oracle, DBA and BI. She has imparted high quality training in technologies like Oracle, Teradata, MySQL, Informatica, ABinitio and COGNOS.

Areas of Expertise:
Databases (DBA) :
Oracle 8i / 9i / 10g / 11g/ 12c: SQL, PLSQL, Administration, Performance Tuning, SQL Statement Tuning, New Features, Streams, ASM, Dataguard, Real Application Clusters
Teradata Versions 11/12/13: Basics, SQL, Architecture, BTEQ & Utilities, SQL Statement Tuning
My SQL: Development and Administration
ETL: Oracle 11g : Warehouse Builder (OWB), Informatica 9 / 8.x , COGNOS, Ab Initio
Business Intelligence : Cognos 8 , Oracle OBIEE

Professional Experience:
Head Technology at The Skill Enhancers (TSE). In the past, she has worked for Wilshire Software Technologies, Software Technology International Ltd, Software Solution Integrated Ltd. and Compusoft in different technical positions involving Systems analysis, design, development and implementation of application software and training.
More than 500 programs executed for various corporates on the database, data-warehousing, Business Intelligence and Analytics.

Education:
MSc in Mathematics from Osmania University
Diploma in Citation in Application Programming.
Corporate Training conducted
Associated with more than 150 corporates, some note-worthy clients are Accenture India, Capgemini, CA, CISCO Systems, Deloitte Consulting, JDA, Oracle India, Oracle University, Wipro Technologies, Infosys Technologies, Societe Generale, Verizon, SUMTOTAL, GENPACT

Students also enrolled in these courses

LIVE

Course offered by Raju

1 review
LIVE

Course offered by Nivedith

0 review
LIVE

Course offered by Raju

1 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Oracle 12C SQL,PLSQL Training by Skill Sigma

Lakshmi Padmasree picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Oracle 12C SQL,PLSQL Training by Skill Sigma

Lakshmi Padmasree picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more