Oracle Database SQL Training
Oracle Database SQL course is an online course that assists you in preparing ng for the OCP exam. We offer a diverse oracle database SQL exam. This course covers all the features of SQL like editing and making running, running reports, transactional writing, writing short p, programs, and more. We have a batch of certified oracle trainers to assist you. It is a practically based SQL online course to help you have a full grip on Oracle database SQL.
Restricting and Sorting Data
- Limit the rows that are retrieved by a query
- Sort the rows that are retrieved by a query
- Use substitution variables
- Use the SQL row limiting clause
- Create queries using the PIVOT and UNPIVOT clause
- Use pattern matching to recognize patterns across multiple rows in a table
Using the Set Operators
- Explain set operators
- Use a set operator to combine multiple queries into a single query
- Control the order of rows returned
Using Single-Row Functions to Customize Output
- Describe various types of functions that are available in SQL
- Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements
- Use conversion functions
Manipulating Data
- Describe the DML statements
- Insert rows into a table
- Update rows in a table
- Delete rows from a table
- Control transactions
Reporting Aggregated Data Using the Group Functions
- Identify the available group functions
- Use group functions
- Group data by using the GROUP BY clause
- Include or exclude grouped rows by using the HAVING clause
Using DDL Statements to Create and Manage Tables
- Categorize the main database objects
- Review the table structure
- Describe the data types that are available for columns
- Create tables
- Create constraints for tables
- Describe how schema objects work
- Truncate tables, and recursively truncate child tables
- Use 12c enhancements to the DEFAULT clause, invisible columns, virtual columns and identity columns in table creation/alteration
Displaying Data from Multiple Tables
- Use equijoins and nonequijoins
- Use a self-join
- Use outer joins
- Generate a Cartesian product of all rows from two or more tables
- Use the cross outer apply clause
Creating Other Schema Objects
- Create simple and complex views with visible/invisible columns
- Retrieve data from views
- Create, maintain and use sequences
- Create private and public synonyms
Using Subqueries to Solve Queries
- Use subqueries
- List the types of subqueries
- Use single-row and multiple-row subqueries
- Create a lateral inline view in a query
Managing Objects with Data Dictionary Views
- Query various data dictionary views
EXTRACT Managing Schema Objects
- Manage constraints
- Create and maintain indexes including invisible indexes and multiple indexes on the same columns
- Create indexes using the CREATE TABLE statement
- Create function-based indexes
- Drop columns and set column UNUSED
- Perform flashback operations
- Create and use external tables
Controlling User Access
- Differentiate system privileges from object privileges
- Grant privileges on tables and on a user
- View privileges in the data dictionary
- Grant roles
- Distinguish between privileges and roles
Manipulating Large Data Sets
- Manipulate data using subqueries
- Describe the features of multitable INSERTs
- Use multitable inserts
- Unconditional INSERT
- Pivoting INSERT
- Conditional ALL INSERT
- Conditional FIRST INSERT
- Merge rows in a table
- Track the changes to data over a period of time
- Use explicit default values in INSERT and UPDATE statements
Managing Data in Different Time Zones
- Use various date time functions
- Tz_offset
- from_tz
- to_timestamp
- to_timestamp_tz
- to_yminterval
- to_dsinterval
- current_date
- current_timestamp
- localtimestamp
- dbtimezone
- sessiontimezone
Generating Reports by Grouping Related Data
- Use the ROLLUP operation to produce subtotal values
- Use the CUBE operation to produce crosstabulation values
- Use the GROUPING function to identify the row values created by ROLLUP or CUBE
- Use GROUPING SETS to produce a single result set
Retrieving Data Using Subqueries
- Use multiple-column subqueries
- Use scalar subqueries
- Use correlated subqueries
- Update and delete rows using correlated subqueries
- Use the EXISTS and NOT EXISTS operators
- Use the WITH clause
Hierarchical Retrieval
- Interpret the concept of a hierarchical query
- Create a tree-structured report
- Format hierarchical data
- Exclude branches from the tree structure
Regular Expression Support
- Use meta Characters
- Use regular expression functions to search, match and replace
- Use replacing patterns
- Use regular expressions and check constraints
International Student Fee : 300 USD | 395 CAD | 1,125 AED | 1,125 SAR
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training