LEMBAGA PENGEMBANGAN UG

Oracle 12c Fundamental

Oracle Database 12c: SQL Workshop I
1. Introduction
2. Retrieving Data Using The SQL SELECT Statement
3. Restricting and Sorting Data
4. Using Single Row Functions to Customize Output
5. Using Conversion functions and Conditional Expressions
6. Reporting aggregated Data Using the group Function
7. Displaying Data From Multiple Tables Using Joins
8. Using Subqueries to Solve Queries
9. Using Set operators
10. Managing Tables Using DML Statements
11. Introduction To Data Definition Language

Oracle Database 12c: SQL Workshop II
1. Introduction
2. Introduction to Data Dictionary Views
3. Creating sequences, synonyms, and Indexes
4. Creating Views
5. Managing Schema Objects
6. Retrieving Data by Using Subqueries
7. Manipulating Data by Using Subqueries
8. Controlling User Access
9. Manipulating Data
10. Managing Data in Different Time Zones

Oracle 12c ADMIN

Oracle Database 12c: Administration Workshop
1 Introduction
2 Exploring Oracle Database Architecture
3 Oracle Database Management Tools
4 Managing the Database Instance
5 Configuring the Oracle Network Environment
6 Administering User Security
7 Managing Database Storage Structures
8 Managing Space
9 Managing Undo Data
10 Managing Data Concurrency
11 Implementing Oracle Database Auditing
12 Backup and Recovery: Concepts
13 Backup and Recovery: Configuration
14 Performing Database Backups
15 Performing Database Recovery
16 Moving Data
17 Database Maintenance
18 Managing Performance
19 Managing Performance: SQL Tuning
20 Using Database Resource Manager
21 Using Oracle Scheduler to Automate Tasks
22 Oracle Database Cloud Service: Overview

CCNA Route & Switch

CCNA R&S : Introduction to Networks
Chapter 0 Course Introduction
Chapter 1 Exploring the Network
Chapter 2 Configuring a Network Operating System
Chapter 3 Network Protocols and Communications
Chapter 4 Network Access
Chapter 5 Ethernet
Chapter 6 Network Layer
Chapter 7 Transport Layer
Chapter 8 IP Addressing
Chapter 9 Subnetting IP Networks
Chapter 10 Application Layer
Chapter 11 It’s a Network

CCNA R&S : Routing and Switching
Chapter 1 Introduction to Switched Networks
Chapter 2 Basic Switching Concepts and Configuration
Chapter 3 VLANs
Chapter 4 Routing Concepts
Chapter 5 Inter-VLAN Routing
Chapter 6 Static Routing
Chapter 7 Routing Dynamically
Chapter 8 Single-Area OSPF
Chapter 9 Access Control Lists
Chapter 10 DHCP
Chapter 11 Network Address Translation for IPv4