Course overview 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. Example training video not from this course 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 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....
Brand: Learn365
Course overview with oracle database 12c: sql fundamentals, you experience the benefits of an oracle database that is re-engineered for cloud computing. Multitenant architecture brings