Oracle Database 12c SQL Fundamentals

Course

Online

Save 49%

Special Emagister price

£ 99 £ 195 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

"Course Description

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 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. You can start learning right away with an initial payment of £32.50 by using our 6 month interest-free payment plan.

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

Important information

Price for Emagister users:

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

"Who Is This Course For?

The course is designed for IT support technicians who wish to manage and maintain Windows 8, including the various apps, cloud and mobile environment. It is also ideal for professionals who wish to upgrade their knowledge on the working of Windows 8.

After completing this course you will learn the skills and knowledge required to work effectively in a professional IT environment and prepared for the Microsoft 70-688 exams. Get the skills employers are currently looking for, enrol today!

By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you."

"Requirements

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player."

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Benefits
  • Database
  • SQL
  • Database training
  • Hacking
  • Data Protection
  • Computer Engineering
  • Systems
  • Technology
  • IT Security
  • Data security
  • Computer Systems
  • IT Systems
  • Computer Science
  • Network Engineering
  • Computering

Course programme

"

Course Outline


Course Outline

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


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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

    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

  • "

    Oracle Database 12c SQL Fundamentals

    Special Emagister price

    £ 99 £ 195 VAT inc.