ORACLE 12C OCP 1Z0-061: SQL FUNDAMENTALS

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. 

COURSE OUTLINE„

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

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.