Memorial Day Sale | 30% Off Sitewide
Join us in honoring our heroes this Memorial Day.  Take an extra 30% off sitewide on any order of $49 or more.
Just add any item to your shopping cart to see the discount!

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Oracle Database 12c: SQL Fundamentals provides a multitude of advantages from the re-engineered Oracle Database for Cloud computing. The architecture ensures hardware and software efficiency, superior performance, manageability benefits that lead to quick and effortless cloud provisioning.

$49.00

Buy This Course

$49.00

You can get access to this training and over 2,500 hours of on-demand content with our All Access Monthly Subscription.  Start today for 7 free days with no obligation.  You can cancel anytime.

7 Free Days / $0.00 due today / $39.00 monthly 

16  Training Hours
45 Videos
9  Topics
245 Practice Questions

Course Description

Note: Although this course is based on an older version, it remains to be a beneficial resource for educating and training.

About our online course:

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.

Who is this Oracle 12c OCP 1Z0-061: SQL Fundamentals training course for?

Perfect for IT professionals and Oracle administrators seeking to advance their skill level, this Oracle Database 12c Administration program is especially tailored for those aiming to enhance their database language proficiency. After completing the course, attendees will have acquired an unparalleled understanding of the latest version of Oracle that can be applied in both rising IT careers as well as established ones looking to validate their expertise.

Course Outline

Oracle 12c OCP 1Z0-061: SQL Fundamentals Course Outline

Module 1: Introduction To Oracle 12c SQL Fundamentals
  •    Introduction
  •    Intro To Oracle 12c-SQL Fundamentals
  •    Structure Of SQL
  •    Basic Select Statements
  •    Basic Select Statements Demo
Module 2: Retrieving Data
  •    Modifying Reported Output
  •    The Where Clause
  •    The Order By Clause
  •    Left And Right Outer Joins
  •    The Where Clause Demo
  •    Multi-Table Selection Demo
Module 3: SQL Functions
  •    Single Row Functions
  •    Aggregate Functions
  •    Single Row Functions Demo
  •    Muiltrow Functions Demo
  •    Group By
  •    Grouping Demo
  •    Conversion Functions
  •    Conversion Functions Demo
  •    Datetime Functions
  •    Datetime Functions Demo
Module 4: Subqueries
  •    Single-Row Subqueries
  •    Single-Row Subqueries Demo
  •    Multi-Row Subqueries
  •    Multi-Row Subqueries Demo
  •    Other Subquery Types
  •    Other Subquery Types Demo
Module 5: Data Manipulation Language
  •    Adding Data
  •    Changing Data
  •    Deleting Data
  •    DML Demo
Module 6: Data Control Language
  •    Security
  •    Object Privileges
  •    DCL Demo
Module 7: Data Definition Language
  •    Creating Objects In The Database
  •    Creating Objects In The Database Demo
  •    Sequences
  •    Sequenced Demo
  •    Indexes
  •    Views
Module 8: Combining Queries
  •    Combining Queries
Module 9: Oracle 12C SQL Fundamentals Review
  •    Oracle 12c SQL Fundamentals Review - Part 1
  •    Oracle 12c SQL Fundamentals Review - Part 2
  •    Oracle 12c SQL Fundamentals Review - Part 3
  •    Conclusion
Oracle 12c OCP 1Z0-061: SQL Fundamentals
Oracle 12c OCP 1Z0-061: SQL Fundamentals

$49.00

Oracle Database 12c: SQL Fundamentals provides a multitude of advantages from the re-engineered Oracle Database for Cloud computing. The architecture ensures hardware and software efficiency, superior performance, manageability benefits that lead to quick and effortless cloud provisioning.

Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$39.00

Become a Microsoft SQL Server expert with our Microsoft 70-461: Querying SQL Server online training. Enroll now and advance your SQL skills today!

In this Microsoft 70-461: Querying SQL Server course you will learn the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 which is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

$39.00

Learn how to develop cutting-edge web applications with Microsoft .NET 4.5 Programming and HTML5. Enroll now and get certified!

In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform.

$15.00

Gain expertise in designing BI solutions with SQL Server with our Microsoft 70-467 training course. Become an expert in BI solutions design today!

In this online training course you will learn how to plan and design a business intelligence (BI) infrastructure by designing a reporting solution, designing BI data models and designing an ETL solution. This course will teach business intelligence (BI) architects the overall design of a BI infrastructure and how it relates to other data systems in use.

$49.00

Learn Java programming language with our online course and gain skills to build robust applications. Join now and get certified!

You should Learn Java as it is a must-have technology for a range of applications and websites, including business solutions, data centers, game consoles, utilities, desktop computers (as well as laptops and smartphones). That’s why this online training course explores the whole spectrum of Java Programming from beginner to advanced. With it you can confidently tackle any challenge that comes your way!