Oracle Database 12c SQL Fundamentals (1Z0-071) & (1Z0-072) Video Training Courses & PDF Guides DOWNLOAD
 
Duration : 20 + Hours
 
Size: 7.7 GB ( 3 Courses )
 
Oracle Database 12c SQL Fundamentals (1Z0-071)
 
1 - Oracle Database 12c_ SQL Fundamentals (1Z0-071)
2 - Oracle Database Architecture
3 - Oracle Network Environment Configuration
4 - Creating and Managing Tablespaces
5 - Managing UNDO Data
6 - Backup and Recovery Concepts
7 - Managing Database Instances
8 - Administering User Security
9 - Manage Storage Space with Oracle
10 - Moving Data
11 - Monitoring and Tuning Database Performance
12 - Using Oracle Database Cloud Service
 
 
Oracle Database 12cR2 Administration (1Z0-072)
 
1 - Oracle Database Architecture
2 - Oracle Network Environment Configuration
3 - Creating and Managing Tablespaces
4 - Managing UNDO Data
5 - Backup and Recovery Concepts
6 - Managing Database Instances
7 - Administering User Security
8 - Manage Storage Space with Oracle
9 - Moving Data
10 - Monitoring and Tuning Database Performance
11 - Using Oracle Database Cloud Service
 
 
 
Oracle Database-12c SQL Certified Associate 1Z0-071
 
1. Introduction
10. Displaying Data from multiple tables using joins
11. Using Subqueries to Solve Queries
12. Using the Set Operators
13. Managing tables using DML Statments
14. Introduction to Data Definition Language
15. Tips you Should know
16. Exam 1Z0-061  Oracle Database 12c SQL Fundamentals
17. Introduction to Data Dictionary Views
18. Creating sequences, synonyms, and indexes
19. Creating Views
2. Live SQL & Download Install
20. Managing Schema Objects
21. Retrieving Data By Using Subqueries
22. Manipulating Data By Using Subqueries
23. Controlling User Access
24. Manipulating Data
25. Managing Data in Different Time Zones
26. Exam 1Z0-071 for SQL Certified Associate
27. Bonus Section
28. What next it is time for PLSQL
3. Connecting to the Database
4. Retrieving data using the select statement
5. Restricting and Sorting Data
6. Substitution Variables
7. Using Single-Row Functions to Customize Output
8. Using Conversion Functions and Conditional Expressions
9. Reporting Aggregated Data Using the Group Functions
 
&
 
 
PDF Guides