Course description
Oracle 12c OCP 1Z0-061: SQL Fundamentals Online 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 phasize the full set of skills that DBAs need in today's competitive marketplace.
Upcoming start dates
Training Course Content
Module 1 Introduction To Oracle 12c SQLFundamentals
- 1.1 Introduction To Course
- 1.2 Intro To Oracle 12c SQL Fundamentals
- 1.3 Structure Of SQL
- 1.4 Basic Select Statents
- 1.5 Basic Select Statents Do
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 Do
- 2.6 Multiå_Table Selection Do
Module 3 SQL Functions
- 3.1 Single Row Functions
- 3.2 Aggregate Functions
- 3.3 Singleå_Row Functions Do
- 3.4 Multiå_Row Functions Do
- 3.5 Group By
- 3.6 Grouping Do
- 3.7 Conversion Functions
- 3.8 Conversion Functions Do
- 3.9 Date-time Functions
- 3.10 Date-time Functions Do
Module 4 Subqueries
- 4.1 Single-Row Subqueries
- 4.2 Single-Row Subqueries Do
- 4.3 Multi-Row Subqueries
- 4.4 Multi-Row Subqueries Do
- 4.5 Other Subquery Types
- 4.6 Other Subquery Types Do
Module 5 Data Manipulation Language
- 5.1 Adding Data
- 5.2 Changing Data
- 5.3 Deleting Data
- 5.4 DML Do
Module 6 Data Control Language
- 6.1 Security
- 6.2 Object Privileges
- 6.3 DCL Do
Module 7 Data Definition Language
- 7.1 Creating Objects In The Database
- 7.2 Creating Objects In The Database Do
- 7.3 Sequences
- 7.4 Sequenced Do
- 7.5 Indexes
- 7.6 Views
Module 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 Conclusion
Why choose Learning247
Gain a New Qualification - Get a verifiable qualification with Learning247 and improve your career prospects. Most of our courses CPD Accredited.
Wide Range of Courses - With over 800+ courses to choose from you're sure to find a course that interests you.
Study Anywhere & Any time - All of our online courses can be studied from your PC, MacBook , tablet or smart phone device.
Request info
Learning247
As one of the market-leaders in distance-learning and self-study multimedia-based training, Learning247 provides the most cost-effective route to enable you to update and improve upon your skills; and all without the massive prices that are regularly seen throughout the training...