Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price # Enroll Book free demo
40 Hrs Weekend Morning-Batch USD 350
INR 17999
Enroll Now Book free demo class
40 Hrs Weekend Evening-Batch USD 350
INR 17999
Enroll Now Book free demo class
40 Hrs Weekdays Morning-Batch USD 350
INR 17999
Enroll Now Book free demo class
40 Hrs Weekdays Evening-Batch USD 350
INR 17999
Enroll Now Book free demo class

# Cloud lab charges will be extra. Our technical consultant will share actual lab charges with you.

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.



  • 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.10 DBTIMEZONE
  • 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

Select Trainer for Demo

Ajaz Ahmed
Professional Experience
Training Experience

Bachelor of Science

Oracle 9i, 10g, 11i, 12c , Oracle DBA, Oracle e-Business Suit , Oracle Fusion, Oracle SOA, PL/SQl, SQL, WebLogic, Oracle BI Foundation, Oracle DB 10g, Oracle DB 11g, Oracle DB 12c, Oracle Exalytics, Oracle Forms, Oracle Fusion Middleware home,

Brief about yourself
Akul Ardhala
Certification: Big Data Analytics
Professional Experience
Training Experience


Business Intelligence, Qlik Sense, QlikView, SQL, Tableau,

• 10+ years Experience in Business Intelligence, Data Analytics & Consumer Insights and has over all 12+ years of IT experience. • Past 4 years Working in a client-facing role to design and develop QlikView, QlikSense and Tableau data models and dashboards to support our client needs. • Complete comprehension of enterprise data models and utilization of both relational and dimensional data sources. • Extensive experience in QlikView design and development with in-depth understanding of BI and reporting. • Experience with Business Intelligence and Web Analytics domain in both B2B and B2C business models with wide knowledge of Qlikview usability. • Proven experience in delivering Business Intelligence solutions with Qlikview,QlikSense & Tableau dashboard design and delivery. • Extensive Knowledge of BI reporting and visualization tool architectures, functions and features. • Design and deliver BI (Business Intelligence) applications using QlikView / QlikSense / Tableau software. • Ability to translate business questions and requirements into reports, views, and BI query objects • Complete understanding of SQL, Relational and Multidimensional designs. Read More...
kamel khlifi
Mr Akul Ardhala is an enthusiastic and helpful person and a great teacher.He is exceptionally brilliant and sincere worker.He knows his subject and well manages his profession. I wish him success in all his endeavors.
Bhawna Gunwani
Professional Experience
Training Experience


.NET, ADO.NET, ASP.NET, ASP.NET MVC, C#.NET , C, C++ , Data Structure, Database, HTML5, JQuery , JSON, Node.js, Oracle, Oracle 9i, 10g, 11i, 12c , Oracle DBA, PL/SQl, Python, SQL, WCF, WPF,

6+ Years of Experience in Training Industry with a clear and depth understanding of student handling, learning needs, data analysis, content delivery, content management and process orientation. Specialties Programming and Technologies : C, C++, Data Structure, C#.Net, VB.Net, Asp.Net, Asp.Net MVC, WCF, WPF, Entity Framework, NHibernate, Web Services, Web API, AngularJS, AJAX, JavaScript. RDBMS : Oracle SQL and PL/SQL, Oracle DBA Workshop I and II, OBIEE, Microsoft SQL Server and T-SQL, SQL DBA etc. Read More...
Dr. Kamal Gulati
Certification: CCNA , MCP , Willey Certified Big Data Analyst (WCBDA)
Professional Experience
Training Experience

Ph. D., M.Sc. (Computer Science), M.C.A.

AWS, Big Data, CCNA, Database, Hadoop , HTML, MongoDB, MS Office, MySQL , Networking , QlikView, SAAS , SQL, Tableau, VBA Macros, Data Science,

A dedicated and astute professor with 13+ of exper ience 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. Read More...
Sasidhar Mukthinuthalapati
It is my privilege to recommend Dr. Gulati who taught me I.T. Project Management (SOF – 501). He is an excellent Professor in the university of CSIT Department. Due to his real world experience, he was able to use business examples to supplement textbooks in class. He is truly an extremely intelligent and dedicated professional in all his endeavors with good communication and collaboration skill. I highly recommend him.
Vishwanath Lingamurthy
It is my privilege to write feedback regarding your Knowledge in the subject, teaching capabilities, interaction with students and enlightening them in subject as a CSIT Visiting Scholar Stratford University. Sir your knowledge in the in IT project management is extremely appreciated by all the student community. I was always amazed by the interest you show to motivate to acquire more knowledge and leverage it in research and teaching. I have not seen any situation that you do not have proper answer whenever I ask any questions, relevant or irrelevant, regarding my subject. I am really impressed by the depth of knowledge you have in IT project management. Sir you have got very good communication skills in explaining the subject in a simple and systematic way, which will make any student comfortable and confident about the subject. Your way of presenting simple and friendly lectures helped me a lot to get up to the speed and excel in my work and studies. Dr. Gulati, you show enormously great patience to make anybody comfortable in the subject. As I said earlier, you have spent so many hours with us to explain various techniques which made me thorough in what I am doing in class. Dr. Gulati you are not only friendly but also is gauging our needs as graduate students. You display a genuine concern for the advancement of his students. As a mentor you freely share your knowledge and experience and helps us to be confident in the chosen field of subject. I am sublimating with great pleasure that you are Master in molding me as dynamic and enthusiastic towards the subject. You are the instrumental to ensure the students get quality education they deserve. It is really an honor to the University to have Dr. Gulati a well-qualified and dedicate CIST Scholar sir. I can state with absolute certainty that you are an exceptional teacher I ever seen in my career. Dr. Gulati sir you are one on the best teachers and mentors I ever had in my life and I strongly believe that you w
Dr. Shakir Ullah Khan
Dr. Kamal Gulati is an enthusiastic and helpful person and a great teacher. He has received a very positive feedback from his students at Stratford University. He is committed to excellence. I am sure will be a valuable asset for any university.
Avishek Chakrabarty
I consider myself extremely privileged to have received my education in the field of Computer Sciences from Dr. Kamal Gulati during my MBA, at Amity University. With excellent knowledge and command over the subject, Prof. Kamal always gave his 100% so that we could receive the best education. He was not just a professor to us, but also a friend who was always there for his students whenever we needed him. I thank you sir, for always guiding us in the best possible way.
billy Mwamba
dr kamal gulaty was one of my best faculty in amity university... he thought me two subjects from whrere i learnt many things... proud to have a such of faculty...speaks well teach very... all the best
Kapil Dhingra
Kamal is an ace professional. He is calm, focused & has an eye for detail. He has the ability to work under tight deadlines and has the willingness to take on challenges and achieve his objectives within the given timelines which is what makes him a perfect professional... Wish you luck!!!
Neha Malhotra
I have had the pleasure of knowing Dr. Kamal since 2009. Ambitious professor. Always maintains very good relation with students.Dr. Kamal is an intelligent, achievement oriented, independent and careful teacher. He is not only a multi-skilled and proactive professional but also an inspiring person.
Rajesh. C. Bhatnagar
He is highly qualified both academically and professionally. He has shown extra ordinary competencies in problem resolutions in our department. He has rich experience of Industry working. For last 7 years he has working as a member of faculty at Amity University, Noida he is well known and recognized for his teaching and administrative skills. He is apt in Multi tasking and has dis-changed his administrative duties with excellence in performance. He is held in high esteem by his colleagues, seniors and students. He has qualities of head and heart which have endeared him to his students and colleagues. He will be an asset for any organization he works for. I wish him all success in life.
Praveen Telu
Very fortunate to study under a faculty like you sir. The inputs, support and encouragement you gave me has changed my student career, Whatever I am now it is all coz of you. Thank you sir and hoping that my next batch students will also get benefited with the indepth knowledge of IT skills you have.
Dr. Kamal Gulati is a dedicated, committed & intelligent faculty member who can handle any matter given with full competency. His approach to solve any problem is very innovative and out of box. He is an asset to any organisation on account of his positive approach & problem solving skill.
Kamal is a gem and one among the best teachers I have worked with and is a passionate teacher.
shantanu Chakraborty
He is Hardworking ,Committed and Extremely focused on whatever assignment he undertakes.He had an ability to explore new idea and is very flexible.He easily adopt him selves to different roles and responsibility assigned to him
B R Singh
I have been working with Prof Kamal Gulati for the last 5 years and during this period I obsereved that he is highly dedicated Professional, carrier oriented person. He is good team performer and also a good team manager. I can safely vouch, he is an asset to any organization - education provider or otherwise
Aparna Datt
Kamal has been an excellent person to work with. His in depth knowledge about E-commerce, CRM and other aspects of IT combined with management is commendable. He is a thorough and dedicated professional who is always ready to help and a wonderful human being to work with.
Pranav Gupta
u r the best.....
Inderjit Jain
An energatic young man with commitments,convictions and simple habits. Always availble to help others with a smile. I wish him all the success in life
Suddhendu Biswas
He is exceptionally brilliant and sincere worker.He knows his subject and well manages his profession. I wish him success in all his endeavors.
Priyanka Bhagat
Mr. Kamal Gulati was my IT teacher in MBA (G.L.Bajaj Institute of Technology & Management. along with our syllabus ,he gave us a lots of extra knowledge which is useful in day to day activities.He has a vast knowledge of subject he teaches.Any query he use to solve on same day and always helped us whenever we asked for notes etc.
Professional Experience
Training Experience


.NET, ADO.NET, Angular JS, ASP.NET, ASP.NET MVC, C#.NET , CSS3, HTML, JQuery , Node.js, SQL, VB.Net, WCF, WPF, Entity Framework, MVC 6,

Brief about yourselfA Dynamic and dedicated profes sional with a strong passion for training and web development, equipped with a Microsoft Certified specialization in web technologies. Enhanced with extensive knowledge on planning, organizing and directing, wide range of learning and development activities, I aspire to invoke the thirst for knowledge in eager minds. And always, love to be a life long learner. Read More...
Certification: RHCSA , RHCE
Professional Experience
Training Experience


C, C++ , Java Script, MongoDB, Oracle 9i, 10g, 11i, 12c , PL/SQl, Red Hat , Redhat Gluster, SQL, RHCE, RHCSA,

Over 15 years of experience in Training and 12+ ye ars of experience in corporate training for Oracle and RedHat certification program. Read More...
Pankaj Singh
Professional Experience
Training Experience


.NET, ADO.NET, AJAX, Android, Android NDK, Angular JS, Apache Cordova, ASP.NET, ASP.NET MVC, C#.NET , C, C++ , IIS, J2SE, Java , Java Script, Java SE, JDBC , JQuery , JSON, JSP , Linux , MariaDB, Microsoft Access , Microsoft Visual Studio, Microsoft Windows , MongoDB, MS Office, MVC, MySQL , Netbeans, Node.js, PHP, PL/SQl, Postgre SQL, Python, SHELL, SQL, SQLite, SQLyog, Swift, Ubuntu, UNIX, VB.Net, VISUAL BASIC, Web Development, Windows Mobile, WPF, X-Code, Xamarin,

Good Exp. in .Net Training include webform s, Mvc,ajax,,c#,ef,store apps and xamarin apps. I used to give training in c#,,,wpf,wcf,mvc 5 and mvc 6,entity framework,silverlight, Windows Store Apps. Read More...
Prashant Shinde
Professional Experience
Training Experience

Certified Agile Coach, Scrum Certified Trainer, Scrum, Kanban, XP, DevOps

ADO.NET, Agile , Agile and Scrum Master, ASP.NET MVC, Automation, Certified Scrum Master (CSM), Database, Jenkins, JIRA, SQL, TFS, VersionOne, Conflict Management, DevOps, Kaizen, Presentation Skill,

Having a clear vision of how an agile organization could be Organizational structure and design using LeSS / SAFe / Scrum / Kanban / ScrumBan / XP. He loves to discover “code/design smells”. Places where code/design could be improved. Read More...
Richa Goel
Professional Experience
Training Experience


Bootstrap, HP ALM, HP QC, HP Quality Center, HTML, HTML5, Manual Testing, MS Office, MySQL , QTP, Quality Management, Software Testing, Software Testing Tools, SQL, LoadRunner,

I have more than 12 years of experience in Softwar e Industry specializing in the Manual, Automation and Performance Testing. I am a quick learner and always keen to learn new things. I have worked in Finance, Health Insurance and Education domains.
I have imparted internal trainings on Quality Concepts, Quality Processes, Software Testing – Manual, Performance Testing, HTML5/CSS3, PHP-MySQL, Quality Center, Software Engineering etc. and has imparting successful external trainings for companies like NIIT Technologies, AON Hewitt, Adobe, Wipro, Headstrong, Nucleus Software, Path Infotech, RSystems, Protiviti Consulting etc. with excellent feedback. Imparted multiple training in Management Institutes like APIM (Asia Pacific Institute of Management), Delhi.
Himjit Singh
Richa is a fantastic Personality with great blend of Professional & Personal Abilities a hard and sincere worker. A passionate QA resource with excellent analytical power and good communication skill. She keeps a very positive approach towards things and strives for ONLY the best. She is a Balanced and lively person. Keeps the accountability of assigned tasks and finishes it on time with perfection. I wish her all the best in her upcoming ventures in life
Sandya Sapru
Richa is very intelligent person. She possesses very good skills related to Time Management , Team building and Work Management. She can go in-depth to provide solution to any problem. She takes any task very deligently. She is very excellent person I have worked with as a Lead so far. I wish success and happiness to her.
Vivek Srivastava
Richa is a thorough professional with great observation skills and remarkable dedication. The desire in her to learn new things and to constantly re-invent herself is applauding. She is an asset to any team or organization, as a professional as well as individual and I wish her good luck in his future endeavors
Deepali Shahabadi
She is a good team member also who gels well in the team and make the work environment work for. I have worked with Richa in the same team as a teammate. She is a very thorough QA professional. She has always executed at a high standard with enthusiasm and commitment.
Bharat Kakkar
Richa is a proactive and tireless contributor who would make a great addition to any team.
Saurabh Vohra
I got a chance to work with Richa in the Mitchell Project. She is an extremely diligent worker with an eye towards minutest details in her work. I was impressed by both her technical knowledge and leadership qualities. You can expect her to go to any length to achieve the objective. I wish her good luck in her career ahead.”
Pankaj Bansal
She is sincere and posses good domain knowedge of the projects she has worked on. She used to clarify the functional queires of our team at one go. She had a command over the fucntional area to which she was asssigned. I will prefer to endorse her for any suitable job related to her in future. Kudos to Richa for her achivements.
Rajesh Mathur
I worked with Richa in two different organizations. She is an outgoing performer and a good worker. I haver seen her working on her projects with due deligence. She is a good team player and has good inter-personal & communication skills. My best wishes to her for a bright Future.
Sourabh Sharma
Richa is very enthusiastic, creative, process oriented, and articulate. It was a fun working with her. She has all the ELEMENTS required for a Quality Associate. She could be an asset to any organization. My all best wishes for her!
Rohit Chhibber
Richa was fantastic at her work. She was excellent with managing process and other activity like Build, testing etc. Her reporting and monitoring skills were excellent. Best of luck Richa.
Nitin Arora
I know Richa from a long time (almost 4-5 years now) ad i tuely admin that she is a nice human being, a dedicate person to her work and commitments. She always lives upto the mark and exceeds the expectations manier times. A nice person to work with and a great friend.
Sudhir Anandd
Richa is sincere to her work. She is very dedicated and estimates her time well. She completes her work on time and is always devoted to give a quality product. She is fun loving and caring to others. She is good team player, manages good balance between the QA and Dev, which is most conflicting for a manager to resolve.
Namit Karlekar
Until a while ago, I have been working with Richa for a couple of months at NIIT Ltd. I found her to be consistently pleasant, tackling all assignments with dedication and a smile. Besides being a joy to work with, Richa is a take-charge person who is able to present creative ideas and communicate the benefits. Though she was an asset to our testing team, Richa was also extraordinarily helpful in other areas of the company.
Professional Experience
Training Experience


Adobe Flash, Adobe PhotoShop, HTML5, Java , JQuery , Microsoft Dynamics CRM, SAP FI, SharePoint , Skype, SQL, XML,

My business cards say such things as Instructional designer, Technical Writer and E-Learning Developer. But when you get right down to it, I’m much more—I’m a digital marketer, an entrepreneur, a web developer, a graphic designer and a technical geek. I have over 15 years of experience in learning and development. During this time I have worked on projects involving development of WBTs, vILTs, producing video tutorials and managing LMS, along with that i have proven track record of training management in IT and education sector. Read More...
Satish Reddy
Certification: Microsoft Certified Trainer (MCT) , Microsoft Dynamics CRM
Professional Experience
Training Experience

B Tech

.NET, ASP.NET MVC, CRM, Microsoft Dynamics CRM, SQL,

Dynamics CRM architect and MCT certified trainer a uthorized to deliver CRM official curriculum from Microsoft. Conducted onsite instructor led trainings for 1. Microsoft 2. Infosys 3. TCS 4. HP 5. SA Global 6. Syntel 7. SFW 8. Capgemini 9. Nitor etc. 10. AllState, Chicago. 11. Hitachi Consulting. 12. Tata Technologies 13. CGI 14. Tata Technologies 15. Ericsson Read More...
Thania Kruger
Satish has a number of strengths to offer, communicates well with clients and co-workers and is very well organized and dependable. Always interacted well with the team and is reliable and shows good judgment. He will go the extra mile to ensure a job is done and well done.
Santosh Artham
Satish is very good at designing and implementing business solutions in Dynamics CRM, his in-depth knowledge in CRM helps him in delivering efficient solutions. i personally gained lot of CRM concepts by working with him.
Manu Kapoor
I worked with Satish very closely a few years ago. I thoroughly enjoyed working with him and valued him deeply as a team member. He has a very good attitude towards learning new things and going deep into the subject. He always had a solution to any technical problem and his can-do attitude made it very easy to work with him. I wish him all the best in his future endeavors and I am sure he will continue to shine wherever he goes.
Ravi Prakash Reddy Lonka
Satish has natural talent and skills that he has carried from the college days.

** The above course information is taken from Oracle.

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

Copyright ©2015, 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.