Oracle

This course provides a quick start to SQL language. It covers most of the topics required for a basic understanding of SQL and along with suitable examples.

Each student in our Live Online classes receives a comprehensive set of materials, including course notes and all the class examples.
  • Batch size up to 1 to 3.
  • Access to the trainer any time for any questions and follow-ups.
  • Online in-person training.
  • Every session is followed by practical assignments.
  • Numerous assignments carefully designed on every topic by our professional trainers.
  • Guidance from experienced and professional people in software industry.
  • Assignments evaluation, feedbacks and encouragements to develop in better way.
  • Focus on hands-on training by students during sessions.

Prerequisites


Basic computer skills.


Syllabus


Duration: Min 20 hours of classroom training.
Min 25 assignments.

Introduction to Oracle Database Topic 1
  • List the features of Oracle Database 11g
  • Discuss the basic design, theoretical, and physical aspects of a relational database
  • Categorize the different types of SQL statements
  • Describe the data set used by the course
  • Log on to the database using SQL Developer environment
  • Save queries to files and use script files in SQL Developer Introduction to DBMS
Retrieve Data using the 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
Learn to 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 to sort the output of a SELECT statement
  • Sort output in descending and ascending order
Usage of Single-Row Functions to Customize Output
  • 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
Invoke 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
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
Display Data from Multiple Tables Using Joins
  • Create a simple and complex view
  • Retrieve data from views
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Create private and public synonyms
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
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
Data Manipulation Statements
  • Describe each DML statement
  • Insert rows into a table
  • Change rows in a table by the UPDATE statement
  • Delete rows from a table with the DELETE statement
  • Save and discard changes with the COMMIT and ROLLBACK statements
  • Explain read consistency
Use of DDL Statements to Create and Manage Tables
  • Categorize the main database objects
  • Review the table structure
  • List the data types available for columns
  • Create a simple table
  • Decipher how constraints can be created at table creation
  • Describe how schema objects work
Other Schema Objects
  • Create a simple and complex view
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Create private and public synonyms
Management of Schema Object
  • Add, Modify and Drop a Column
  • Add, Drop and Defer a Constraint
  • How to enable and disable a Constraint?
  • Create and Remove Indexes
Retrieve Data Using Sub-queries
  • Multiple-Column Sub queries
  • Pairwise and No pairwise Comparison
  • Scalar Sub query Expressions
  • Solve problems with Correlated Sub queries
  • Update and Delete Rows Using Correlated Sub queries
  • The EXISTS and NOT EXISTS operators
  • Invoke the WITH clause
  • The Recursive WITH clause
Sample Description