Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price Enroll
Weekend
40 Hrs Weekend Morning-Batch USD 350 300

Enroll Now
Weekend
40 Hrs Weekend Evening-Batch USD 350 300

Enroll Now
Weekdays
40 Hrs Weekdays Morning-Batch USD 350 300

Enroll Now
Weekdays
40 Hrs Weekdays Evening-Batch USD 350 300

Enroll Now

About Course

The best suited audience to attend this course can be -

Application Developers
System Analysts
Business Analysts
Database Administrators
Data Warehouse Administrator
Business / Project Heads
This course is designed to provide the SQL training which will help you to understand how to write queries using SQL with Oracle Database. In this course you will also learn to write sub-queries, combining multiple queries, aggregation and other functions which are already defined in SQL. The key points which will focused during the SQL Fundamental training can be-

To learn the basic concepts of RDBMS.
To run and execute Data Manipulation Statements (DML).
To manage schema objects and data dictionary views.
To retrieve data from tables and controlling users.
To generate reports using different functions.
After completing this course you will be able to handle a RDBMS in an effective way by ensuring reliability, security and high performance. You will learn how to optimize workloads of a RDBMS and how to deliver a higher service quality. This course will help you to learn -

Working with report generation from database and data aggregation.
Storing records in database tables and retrieving records from database tables
Using Data Manipulation Statements (DML).
Controlling and managing schema objects
Employing various pre-defined SQL functions
There is no formal perquisite to attend this course but a fundamental knowledge about Data Processing Concepts/Techniques can help you to understand this course in-depth.

CURRICULUM

SQL

  • 1.1 Limit the rows that are retrieved by a query
  • 1.2 Sort the rows that are retrieved by a query
  • 1.3 Use substitution variables
  • 1.4 Use the SQL row limiting clause
  • 1.5 Create queries using the PIVOT and UNPIVOT clause
  • 1.6 Use pattern matching to recognize patterns across multiple rows in a table
  • 2.1 Describe various types of functions that are available in SQL
  • 2.2 Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements
  • 2.3 Use conversion functions
  • 3.1 Identify the available group functions
  • 3.2 Use group functions
  • 3.3 Group data by using the GROUP BY clause
  • 3.4 Include or exclude grouped rows by using the HAVING clause
  • 4.1 Use equijoins and nonequijoins
  • 4.2 Use a self-join
  • 4.3 Use outer joins
  • 4.4 Generate a Cartesian product of all rows from two or more tables
  • 4.5 Use the cross_outer_apply_clause
  • 5.1 Use subqueries
  • 5.2 List the types of subqueries
  • 5.3 Use single-row and multiple-row subqueries
  • 5.4 Create a lateral inline view in a query
  • 6.1 Explain set operators
  • 6.2 Use a set operator to combine multiple queries into a single query
  • 6.3 Control the order of rows returned
  • 7.1 Describe the DML statements
  • 7.2 Insert rows into a table
  • 7.3 Update rows in a table
  • 7.4 Delete rows from a table
  • 7.5 Control transactions
  • 8.1 Categorize the main database objects
  • 8.2 Review the table structure
  • 8.3 Describe the data types that are available for columns
  • 8.4 Create tables
  • 8.5 Create constraints for tables
  • 8.6 Describe how schema objects work
  • 8.7 Truncate tables, and recursively truncate child tables
  • 8.8 Use 12c enhancements to the DEFAULT clause, invisible columns, virtual columns and identity columns in table creation/alteration
  • 9.1 Create simple and complex views with visible/invisible columns
  • 9.2 Retrieve data from views
  • 9.3 Create, maintain and use sequences
  • 9.4 Create private and public synonyms
  • 10.1 Query various data dictionary views
  • 11.1 Differentiate system privileges from object privileges
  • 11.2 Grant privileges on tables and on a user
  • 11.3 View privileges in the data dictionary
  • 11.4 Grant roles
  • 11.5 Distinguish between privileges and roles
  • 12.1 Manage constraints
  • 12.2 Create and maintain indexes including invisible indexes and multiple indexes on the same columns
  • 12.3 Create indexes using the CREATE TABLE statement
  • 12.4 Create function-based indexes
  • 12.5 Drop columns and set column UNUSED
  • 12.6 Perform flashback operations
  • 12.7 Create and use external tables
  • 13.1 Manipulate data using subqueries
  • 13.2 Describe the features of multitable INSERTs
  • 13.3 Use multitable inserts
  • 13.4 Unconditional INSERT
  • 13.5 Pivoting INSERT
  • 13.6 Conditional ALL INSERT
  • 13.7 Conditional FIRST INSERT
  • 13.8 Merge rows in a table
  • 13.9 Track the changes to data over a period of time
  • 13.10 Use explicit default values in INSERT and UPDATE statements
  • 14.1 Use the ROLLUP operation to produce subtotal values
  • 14.2 Use the CUBE operation to produce crosstabulation values
  • 14.3 Use the GROUPING function to identify the row values created by ROLLUP or CUBE
  • 14.4 Use GROUPING SETS to produce a single result set
  • 15.1 TZ_OFFSET
  • 15.2 FROM_TZ
  • 15.3 TO_TIMESTAMP
  • 15.4 TO_TIMESTAMP_TZ
  • 15.5 TO_YMINTERVAL
  • 15.6 TO_DSINTERVAL
  • 15.7 CURRENT_DATE
  • 15.8 CURRENT_TIMESTAMP
  • 15.9 LOCALTIMESTAMP
  • 15.10 DBTIMEZONE
  • 15.11 SESSIONTIMEZONE
  • 15.12 EXTRACT
  • 16.1 Use multiple-column subqueries
  • 16.2 Use scalar subqueries
  • 16.3 Use correlated subqueries
  • 16.4 Update and delete rows using correlated subqueries
  • 16.5 Use the EXISTS and NOT EXISTS operators
  • 16.6 Use the WITH clause
  • 17.1 Interpret the concept of a hierarchical query
  • 17.2 Create a tree-structured report
  • 17.3 Format hierarchical data
  • 17.4 Exclude branches from the tree structure
  • 18.1 Use meta Characters
  • 18.2 Use regular expression functions to search, match and replace
  • 18.3 Use replacing patterns
  • 18.4 Use regular expressions and check constraints

Exam & Certification

This exam Oracle Database SQL Certified Expert is designed to validate and measure the skills of individuals who are working or looking for a career in Oracle Database Administration or Development.
Exam Number: 1Z0-047
Duration: 120 minutes
Number of Questions: 75
Passing Score: 66%
Associated Certifications: Oracle Database SQL Certified Expert
Validated Against: This exam has been validated against Oracle Database 10g, Oracle Database 11g, Oracle Database 11g Release 2, and Oracle Database 12c Release 1.
Exam Format: Multiple Choice
Disclaimer

** The above course information is taken from Oracle.

* Money Back Guarantee till demo and 1st class of the course.

Enhance your Skill

Drop us a Query


Copyright © 2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.