• My account
  • Cart
English courses / USD

Oracle Database 12c SQL Fundamentals

Regular Price: $697

Special Price: $275

  • 2 students have purchased
  • Express
Centre
My Training Academy
Town
Potters Bar
Address
Maple House High Street, Potters Bar Hertfordshire United Kingdom, EN6 5BS EN6 5BS See in Google maps
Contact
sales@mytrainingacademy.org.uk
http://www.mytrainingacademy.org.uk/
Map
Description
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 and part time, from home and work and on the move; online and on 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.

Benefits

  • 12 Months unlimited access
  • Make your own study schedule and take advantage of online tutoring hours
  • Obtain a certified diploma once you finish the course.

Details

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.

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 DemoModule 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 DemoModule 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 DemoModule 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 DemoModule 5 Data Manipulation Language
5.1 Adding Data
5.2 Changing Data
5.3 Deleting Data
5.4 DML DemoModule 6 Data Control Language
6.1 Security
6.2 Object Privileges
6.3 DCL DemoModule 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 ViewsModule 8 Combining Queries
8.1 Combining Queries Module 9 Oracle 12C SQL FundamentalsReview
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 ConclusionMULTI-USER TRAINING PACKAGESThis 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.

Conditions

Thanks to this offer, valid exclusively for one person, you will obtain an Oracle Database 12c SQL Fundamentals Online Course.

How to register

By buying the course in Emagister Express, you will obtain an access coupon. We will send you the codes and keys to the coupon. Send the coupon code and the key to info@mytrainingacademy.org.uk. The training provider will then give you access to the course.

This course has not been reviewed yet
Hi! According to your location, we have changed your payment currency to USD.
You can change to other currency by using the option on the header.