Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Oracle 12c OCP 1Z0-061: SQL Fundamentals

E-COURSE:

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Instructor-led, video based E-Learning course.
Overview

Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning.

This course will provide the learner with everything that is needed to pass the Oracle 12c OCP 1Z0-061: SQL Fundamentals. The course has been designed to give you real-world knowledge that you can put to use from day one. It's highly flexible, so you can set your own timetable and study at your own pace.

Objectives
  • Understand data control language
  • Understand SQL functions and subqueries
  • Understand combining queries
  • Understand data definition language
Target Audience
  • The course is for students who want to prepare for the Oracle 12c certification exam.
  • The course is for the student are interested in Oracle 12c SQL Fundamentals
  • This is Science & Technology Professionals

Module 1: Introduction To Oracle 12c SQL

1.1 Introduction To Course

1.2 Intro To Oracle 12c SQL Fundamentals

1.3 Structure Of SQL

1.4 Basic Select Statements

1.5 Basic Select Statements Demo

Module 2: Retrieving Data

2.1 Modifying Reported Output

2.2 The Where Clause

2.3 The Order By Clause

2.4 Left And Right Outer Joins

2.5 The Where Clause Demo

2.6 Multi­Table Selection Demo

Module 3: SQL Functions

3.1 Single Row Functions

3.2 Aggregate Functions

3.3 Single­Row Functions Demo

3.4 Multi­Row Functions Demo

3.5 Group By

3.6 Grouping Demo

3.7 Conversion Functions

3.8 Conversion Functions Demo

3.9 Date­time Functions

3.10 Date­time Functions Demo

Module 4: Subqueries

4.1 Single­Row Subqueries

4.2 Single­Row Subqueries Demo

4.3 Multi­Row Subqueries

4.4 Multi­Row Subqueries Demo

4.5 Other Subquery Types

4.6 Other Subquery Types Demo

Module 5: Data Manipulation Language

5.1 Adding Data

5.2 Changing Data

5.3 Deleting Data

5.4 DML Demo

Module 6: Data Control Language

6.1 Security

6.2 Object Privileges

6.3 DCL Demo

Module 7: Data Definition Language

7.1 Creating Objects In The Database

7.2 Creating Objects In The Database Demo

7.3 Sequences

7.4 Sequenced Demo

7.5 Indexes

7.6 Views

Module 8: Combining Queries

8.1 Combining Queries

Module 9: Oracle 12C SQL Fundamentals

9.1 Oracle 12c SQL Fundamentals Review - Part 1

9.2 Oracle 12c SQL Fundamentals Review - Part 2

9.3 Oracle 12c SQL Fundamentals Review - Part 3

9.4 Conclusion

E-COURSE E-Learning Instructor-led, video based E-Learning course.
USD 59
  • 15:47:02
    + Hours Of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top