Provided by

  • Sector IT
  • Course Type Online
  • Duration Part-time
  • Ref LE-ORACLE12C
  • Price £150.00 use code Jobstoday10 to get 10% discount

Enquire about this course

About the 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. 


Module 1 Introduction To Oracle 12c SQL


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


Module 8 Combining Queries

8.1 Combining Queries

Module 9 Oracle 12C SQL Fundamentals


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


Start date Location / delivery
No fixed date Online Book now

Related article

Bag yourself a course this Black Friday