Oracle Database SQL PL/SQL Developer Training Course For Beginners

Course Description

oracle-basics-tutorial-course

Oracle database developer course is meant for beginners and those preparing for Oracle certifications like oca or ocp. This oracle beginners course starts at database basics and gears up to advanced database functionality and how to master the SQL language. We then proceed to take advantage of PLSQL programming language for everyday database tasks.

Participants looking at oracle certification will find this as a very useful foundation course to get started with. As there are not many online oracle classes and very few training institutes to teach oracle, we make it completely hands on teaching what participants need to know for working on the job everyday. Our oracle training starts at zero and we give them many examples at the training center to work on. You come out to be a very confident oracle sql developer after this course.

Free Career Guidance

Fee Details

Course Code Course Name Duration Course Fees
Company Sponsored
Course Fees
Self Sponsored
191

Oracle Database Basics
For Beginners SQL & PLSQL

4 Days
(32 Hrs)
$ 2400 $ 1650
191F

Oracle Database Basics
For Beginners SQL & PLSQL
(Fast Track)

[Module 1 to 11 and 15,16 only]
2 Days
(16 Hrs)
$ 1288 $ 1100
Registration & Material Fees of $S 50 Applies.
Register your interest by filling the form below

Email Me Full Details Course Content Related Courses Funding Options Corporate Clients



Get All Details About This Course Now!

Course Content

Click Here To View Fee Details
Day 1: Introduction to Database & SQL
Module 1: Features of Oracle
Introduction to Database
Explanation about RDBMS
Oracle Database Architecture and SQL
SQL Developer - Introduction
Module 2: SQL SELECT Statement
List the capabilities of SQL SELECT statements
Generate a report of data from the output of a basic SELECT statement
Select All Columns, Select Specific Columns
Use Column Heading Defaults
Use Arithmetic Operators
Understand Operator Precedence
Learn the DESCRIBE command to display the table structure
Module 3: Restrict and Sort Data
Write queries that contain a WHERE clause to limit the output retrieved
List the comparison operators and logical operators that are used in a WHERE clause
Describe the rules of precedence for comparison and logical operators
Use character string literals in the WHERE clause
Write queries that contain an ORDER BY clause sort the output of a SELECT statement
Sort output in descending and ascending order
Module 4: Single-Row Functions
Describe the differences between single row and multiple row functions
Manipulate strings with character function in the SELECT and WHERE clauses
Manipulate numbers with the ROUND, TRUNC and MOD functions
Perform arithmetic with date data
Manipulate dates with the date functions?
Module 5: Conversion Functions and Conditional Expressions
Describe implicit and explicit data type conversion
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nest multiple functions
Apply the NVL, NULLIF, and COALESCE functions to data
Use conditional IF THEN ELSE logic in a SELECT statement
Module 6: Aggregate Data Using the Group Functions
Use the aggregation functions in SELECT statements to produce meaningful reports
Divide the data in groups by using the GROUP BY clause
Exclude groups of date by using the HAVING clause
Module 7: Display Data from Multiple Tables Using Joins
Write SELECT statements to access data from more than one table
View data that generally does not meet a join condition by using outer joins
Join a table by using a self-join
Day 2: SQL Continued
Module 8: Use Sub-queries (to Solve Queries)
Describe the types of problem that sub-queries can solve
Define sub-queries
List the types of sub-queries
Write single-row and multiple-row sub-queries
Module 9: The SET Operators
Describe the SET operators
Use a SET operator to combine multiple queries into a single query
Control the order of rows returned
Module 10: Data Manipulation
Describe each DML statement
Insert rows into a table
Change rows in a table by the UPDATE statement to
Delete rows from a table with the DELETE statement
Save and discard changes with the COMMIT and ROLLBACK statements
Explain read consistency
Module 11: Create and Manage Tables
Categorize the main database objects
Review the table structure
List the data types available for columns
Create a simple table
Describe how constraints can be created at table creation
Module 12: Other Schema Objects
Create a simple and complex view
Retrieve data from views
Module 13: Manipulate Large Data Sets
Use Subqueries to Manipulate Data
Retrieve Data Using a Subquery as Source
Insert Using a Subquery as a Target
Usage of the WITH CHECK OPTION Keyword on DML Statements
List the types of Multi-table INSERT Statements
Use Multi-table INSERT Statements
Merge rows in a table
Track Changes in Data over a period
Module 14: Retrieve Data Using Sub-queries
Multiple-Column Subqueries
Pairwise and Non-Pairwise Comparison
Scalar Subquery Expressions
Solve problems with Correlated Subqueries
Update and Delete Rows Using Correlated Subqueries
The EXISTS and NOT EXISTS operators
Invoke the WITH clause
The Recursive WITH clause
Day 3: Introduction to PL/SQL
Module 15: PL/SQL Basics
The Architecture
Basics, Variables, Constants, Data-Types
Error handling
Wrapper Utility
Module 16: PL/SQL Structures
Simple blocks
Control structures
PL/SQL records
Recognizing the Basic PL/SQL Blocks and Section
Describing the Significance of Variables in PL/SQL
Distinguishing Between PL/SQL and non-PL/SQL variables
Declaring Variables and Constants
Executing a PL/SQL Block
Module 17: Boolean Logic in PL/SQL
Control Structures
Constructing an IF Statement
Constructing and Identifying different Loop Statements
Controlling Block Flow Using Nested Loops and Labels
Using Logic Tables
If-then-else structure
Testing for numbers characters and Booleans
for & while loop
Module 18: Nested Blocks in PL/SQL
Creating nested blocks
Understanding scope in nested Blocks
Module 19: PL/SQL Tables
Defining PL/SQL tables
Reasons to use PL/SQL tables
Populating a PL/SQL table
Retrieving from a PL/SQL table


Pre-Requisite

This is a fundamental course on Oracle Database and SQL and PLSQL hence we start on absolute zero and bring the participants to an intermediate level. No prior knowledge is required.

Funding For This Course

Click the course name below to get full details.

OracleTM Database PL/SQL Advanced OracleTM DBA Basics For Beginners
Unix Linux Beginners Tutorial Unix Linux Bash Shell Scripting Programming


Audience For This Course

Databases are used to store data of all systems and applications. We use applications on a daily basis from our mobile phones to ATMs to online portals. All of these use database heavily.

Most programming, support, application oriented, database developer jobs and some system administration jobs need knowledge of database.

It has become quite important to learn database in today's times and most employers expect knowledge of database basics and SQL / PLSQL.

Training Duration

Full-Time : 9.30am to 6.30pm

Part-Time : Weekdays - 10.00am - 1.00pm (or) 2.00pm - 5.00pm

Part-Time : Weekends (Saturday & Sunday) - 10.00am - 1.00pm (or) 2.00pm - 5.00pm

Training Methodology & Materials

  1. 100% hands-on Practical Job Oriented Training
  2. Well designed exercises/sessions
  3. Discussion on real life situations / problems faced on the job and their solutions
  4. Indepth Project work with each course to enhance learning and give the participant a feel of difficulty, thus ensuring they apply in realtime everything they have learnt.
  5. Task based teaching methodology where students are given tasks to do in class, as required in the real world.
  6. Assessments at the end of the course help gauge student progress and learning.

Certificate Of Attendance

Certificate Of Attendance will be awarded to participants completing the course achieving minimum 85% attendance.



View All Testimonials
View Hand-Written Feedback Forms


* Oracle is a registered trademark of Oracle Corporation and it is used here only for listing of the course; we own no rights on the Oracle trademark.