Oracle Database 12c SQL Fundamentals

Oracle Database technology is used by the world\'s leading companies to manage critical business functions, systems and processes.

• Oracle Database is the number one database in the world.
• Over 305,000 top companies trust their critical systems to Oracle Database.
• Oracle Database is the number one embedded database technology.

Over 50,000 IT professionals per year become certified on Oracle Database.

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.

This course will provide learners with everything that is needed to pass the Oracle 12c OCP 1Z0-061: SQL Fundamentals.

The great thing about our Oracle Database 12c SQL Fundamentals course is that you are in charge of your start and finish date, with no deadline pressures!

We train our students to the very best standards, offering expert instructor-led training via our state of the art eLearning platform.

By achieving the Oracle Database 12c SQL Fundamentals certification, you will create more career opportunities and be better positioned when applying for work.

Enrol today and prepare for a future you deserve.

WHY STUDY WITH MY TRAINING ACADEMY?

• Flexible training - study anytime, anywhere and from any device.
• Expert Instructor-Led Training – our courses are delivered by the finest instructors with a minimum of 15 years real-world experience and are subject matter experts in their field, which is why we have a 97.4% pass rate.
• Visual Demonstrations & Multimedia Presentations – allows students to develop their skills based on real world scenarios explained by the instructor.
• Quizzes & Exam Simulators – custom practice exams to prepare students for their final exams. We offer practice quizzes after each module to ensure students are confident before proceeding to the next topic.
• Social Learning & Networking – world class learning management system allows students to interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.
• Flash Cards & Educational Games – allows students to train in ways that keep them engaged and focus.
• Navigation & Controls – allows you to study at your own pace.

HOW MUCH TIME DO I NEED? Our unique, flexible approach to learning means you don\'t have to put your life on hold to get certified.

MTA students structure their study to fit in with jobs, families, friends and leisure time. They study full time and part time; from home and work and on the move; online and on mobile devices.

Certificate of Completion

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 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

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

MULTI-USER TRAINING PACKAGES This online course can be integrated in your professional training plan. M.T.A. can provide you with a tailored learning solution, that can be customised to meet each team member’s requirements. Choosing a multi-user training package, you can get significant discounts for 5+ users and even further discounts for 10+ users – and an excellent return on your investment.

OUR MISSION: Our mission is to help you learn the skills you need to reach your full potential.

WHO WE ARE: We are one of the fastest growing online training providers. We offer engaging, effective and flexible online training solutions to both individuals and businesses.

We develop courses that help individuals to prepare for and complete their certification exams with ease. Our unique, flexible approach to learning means you don’t have to put your life on hold to get certified. You can study full time or part time, from home or work or on the move; either on your PC or on your mobile devices.

We provide world class education developed by highly skilled and experienced instructors. Our courses are upgraded regularly to ensure our learners are up-to-date with the latest industry requirements and best practices.

WHAT WE BELIEVE: We believe technology has paved the way for individuals and businesses all over the world to tap into high quality learning at their fingertips, in order to build new skills, update their expertise in a particular area, or develop their workforce to gain a competitive edge within the market place.

Select a course now and prepare for the future you deserve.