Oracle 12c OCP 1Z0-061: SQL Fundamentals

(4 customer reviews)
Sale!

Leading the way

Oracle 12c OCP 1Z0-061: SQL Fundamentals

(4 customer reviews)

| Total Course Video Hours: 16 Hrs 21 Min
|  Videos: 45
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute
|  International Certification (optional): Oracle Database 12c: SQL Fundamentals

Course Fee:

R1600,00

Current Special Ends in:

  • 00Days
  • 00Hours
  • 00Min
  • 00Sec

Overview

With 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. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace.

Claim your FREE R500 Gift Voucher

FREE R500 gift voucher, especially for you 🎁

Join our mailing list and get your free exclusive R500 discount voucher.

This Voucher can be used for any of our Bundle Courses.

Curriculum

Module 1 Introduction To Oracle 12c SQL Fundamentals
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 MultiTable Selection Demo

 

Module 3 SQL Functions
3.1 Single Row Functions
3.2 Aggregate Functions
3.3 SingleRow Functions Demo
3.4 MultiRow Functions Demo
3.5 Group By
3.6 Grouping Demo
3.7 Conversion Functions
3.8 Conversion Functions Demo
3.9 Datetime Functions
3.10 Datetime Functions Demo

 

Module 4 Subqueries
4.1 SingleRow Subqueries
4.2 SingleRow Subqueries Demo
4.3 MultiRow Subqueries
4.4 MultiRow 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 Review
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

 

4 reviews for Oracle 12c OCP 1Z0-061: SQL Fundamentals

  1. Jelani

    I aced my exam on the first attempt, all thanks to you. You’re the best!

  2. Abigail

    You guys are rock stars. Thank you for an incredible experience!

  3. Chloe

    Thank you for an awesome course

  4. Tafari

    The course provided a solid foundation in the subject matter, equipping me with the knowledge I needed to excel in my field.

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.