Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price Enroll
Weekend
40 Hrs Weekend Morning-Batch USD 350 300
INR 17999 14999
Enroll Now
Weekend
40 Hrs Weekend Evening-Batch USD 350 300
INR 17999 14999
Enroll Now
Weekdays
40 Hrs Weekdays Morning-Batch USD 350 300
INR 17999 14999
Enroll Now
Weekdays
40 Hrs Weekdays Evening-Batch USD 350 300
INR 17999 14999
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

POWER OF CHOOSING YOUR TRAINER - TAKE DEMO FROM 3 TRAINERS AND SELECT


Sanjay Kumar singh
BE Computer Science
From
Professional Experience

Subject Expertise
Oracle

Certification

Profile
Developed IVR application using 3rd party service(plivo)- Moving IVR from third party service to in-house FreeSwitch- Defined design of payment gateway services.
RATING & REVIEWS
Pooja Agarwal
Sanjay is an extremely hard-working and dedicated person with a tremendous zeal to learn new things. He is one of the few people that i know who loves to be thrown into challenging work and comes out with flying colors always. As a person also, he has an easy-going and co-operating approach, which makes him the best team mate to have.
Alok Sharma
Sanjay has a good eye for detail. He is very enthusiastic and keen to earn new challanges. With the power of very clear basics, he is really clear in his thoughts and logics. With sound motivational and team retention skills i see him as a very good manager in the near future.
Sujit Singh
Sanjay worked for me as an IT resource. He was very conscientious, responsible, and delivered on time.
Peeyush Sharma
MCA
From
Professional Experience

Subject Expertise
Database

Certification

Profile
I. As Core SQL Production DBA II. Up gradation of Database from SQL Server 2000 to 2005 and 2008/R2
RATING & REVIEWS
Venkata B
MS CSC
From
Professional Experience

Subject Expertise
Database

Certification

Profile
I am a full stack developer, Iam an expert level developer in Oracle SQL PL/SQL, Python, Unix Shell ScriptingMid level developer in Java, PHP, JS,MySQL.
RATING & REVIEWS
Rammohan
B.tech(cs)
From
Professional Experience

Subject Expertise
Database

Certification

Profile
He is having 6+ years of experience.
RATING & REVIEWS
Bhavesh Kavar
B.E. I.T.
From
Professional Experience

Subject Expertise
Java

Certification

Profile
A Passionate, Hands-on Professional, I have over 4 months of experience in Java Development covering multiple technologies.
RATING & REVIEWS
Sajal Agarwal
MCA
From
Professional Experience

Subject Expertise
Oracle ERP

Certification

Profile
I have 4+ yrs exp in SQL,PL/SQL and Oracle Apps Development. I have good knowledge in SQL, PL/SQL,AdvancePL/SQL,Oracle Apps technical, Interface and workflow and form personalization.
RATING & REVIEWS
Ridam Chopra
B.Tech
From
Professional Experience

Subject Expertise
ASP.NET

Certification

Profile
Specialties: I like programming in ASP.NET and Oracle I work in the Business Development department and try to bring projects related mainly to Web Designing/Development and I-Phone Applications through freelance websites.
RATING & REVIEWS
Jamil Ahmed
BS Computer Science
From
Professional Experience

Subject Expertise
Database

Certification

Profile
Application Development , Integration , Administration, Data Migration and Application Support. Also familiar with Project Management and ability to participate as a key team Player with different teams. Have a background of different industries such as Banking, Port and Shipping / Logistics and Life/General Insurance.
RATING & REVIEWS
Mousam Jaiswal
B.Tech
From
Professional Experience

Subject Expertise
Java

Certification

Profile
RATING & REVIEWS
Rizwan Saeed
Master in computer science
From
Professional Experience

Subject Expertise
Android

Certification

Profile
RATING & REVIEWS
Vivek Agarwal
Msc IT
From
Professional Experience

Subject Expertise
Data Structure

Certification

Profile
Corporate Trainer cum Consultant Corporate Trainer Skills : RDBMS Oracle 11g DBA Oracle 12c DBA PLSQL 11g PLSQL 12c SQL LINUX ADMIN Unix Shell Script Oracle RAC MySQL Development MSSQL DBA POSTGRESQL DBA
RATING & REVIEWS
Praveen Madupu
Masters in Computer Applications
From
Professional Experience

Subject Expertise
Microsoft SQL Server

Certification

Profile
RATING & REVIEWS
Dr. Kamal Gulati
Ph. D., M.Sc. (Computer Science), M.C.A.
From
Professional Experience

Subject Expertise
AWS

Certification

Profile
A dedicated and astute professor with 13+ of experience in Teaching, Research, Corporate Trainings, Student Management and Coordination with various Academic & Corporate Institute. - Currently working with Amity University, Noida as Assistant Professor, Grade-III – Information Technology & Management. - Worked as Sr. Lecturer with G.L. Bajaj Institute of Technology and Management, Greater Noida. - Worked as I.T Instructor with Bahrain Training Institute, Kingdom of Bahrain (Gulf). - Result oriented, excellent communication, strong interpersonal skills and the ability to relate to students at all levels across the organization; possess stupendous skills for teaching, mentoring, guiding and controlling the students. - Possess knowledge about the internal administrative tasks that are performed within institutions.
RATING & REVIEWS
Pushpjeet Cholkar
BE Computer Science & Engineering
From
Professional Experience

Subject Expertise
Oracle DBA

Certification

Profile
He has having 6+ year of Experience. Consultation/Training for ORACLE SQL,PLSQL,FORMS AND REPORT ,ADVANCE PLSQ,DATABASE ADMINISTRATION, BACKUP AND RECOVERY, ASM,DATAGAURD,RAC,GOLDEN GATE,DATA WAREHOUSING AND R&D IN DATABASE,LINUX,UNIX,SOLARIS.
RATING & REVIEWS
Harvinder Kaur
B.tech Computer Science
From
Professional Experience

Subject Expertise
C, C++

Certification

Profile
Corporate Trainer in Oracle Developer and Business Intelligence.. Possess an experience of more than 1 year in the field of training industry. Delivered successful training for academic students and international corporate employees Delivered successful training on SQL PLSQL Advance PLSQL , Business intelligence , Data warehouse. Command over many programming like C,C++, Core java Fluency in English and good hold over the language. Excellent communication ad interpersonal skills.
RATING & REVIEWS
Koteswara Rao Ummaneni
Master of Computer Science (MCA)
From
Professional Experience

Subject Expertise
Oracle EAM

Certification

Profile
RATING & REVIEWS
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.