Oracle 11g Training Video

Informação importante

Curso

Online

Quando:à escolha

Descrição

A Practical 11g Training Course That Teaches Real World Skills In this project-based Learning Oracle 11g video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Oracle 11g training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Oracle 11g subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Oracle 11g tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 8 hours to complete this course 124 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Oracle 11g video based training course, through the expert tutelage of Lewis Cunningham, you will learn the basics of operating an Oracle Database server and environment. You will also discover the basics of how to manage and develop for an Oracle Database, and administer one.

This tutorial is designed for the beginner. This training will teach you the basics of what it means to administer an Oracle Database. Throughout the training, you will be able to better understand the path you can continue on from here, whether that is to become a DBA, developer or administrator of Oracle Databases. You will learn about processes and architectural concepts of a database. This video training also covers topics such as storage, data modelling, basic SQL, database tasks, and how all of these apply...

Informação importante

Requisitos: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Instalações

Instalações e datas

Início

Localização

à escolha

Online

O que se aprende nesse curso?

XML training

XML

Server

Database

SQL

Database training

Skills and Training

Programa

01. Introduction

0101 What Is Oracle

0102 What You Should Expect From This Course

0103 Download And Install Oracle

02. The Technology - OS, Middleware, And Hardware

0201 Operating Systems

0202 Middleware

0203 Hardware

03. The Technology - Database

0301 What Is A Database?

0302 What Are The Types Of Database?

0303 MySQL

0304 TimesTen

0305 BerkleyDB

0306 NoSQL

0307 Oracle Database Server

0308 Oracle Database Server Editions

0309 Documentation And Software

04. Database Architecture

0401 Operating Systems Supported

0402 Database Server

0403 The Database

0404 Database Instance

0405 Background Memory Processes

0406 User Memory Processes

0407 System Global Area

0408 Program Global Area

0409 Networking

0410 Oracle Net Listener

0411 Real Application Clusters

05. Storage

0501 Blocks

0502 Extents

0503 Segments

0504 Tablespaces

0505 Data Files

0506 Control Files

0507 Redo Log Files

0508 Parameter File

0509 Password File

0510 Fast Recovery Area

0511 Alert Logs

0512 Trace Files

0513 ASM, Grid And Cloud

06. Database Structures

0601 The Data Dictionary

0602 Schemas And Users

0603 Tables

0604 Partitions

0605 Temp Tables

0606 B-tree Indexes

0607 Index Organized Tables (IOT)

0608 Bitmap Indexes

0609 Function Based Indexes

0610 Views

0611 Primary And Unique Keys

0612 Foreign Keys

0613 Check Constraints

0614 Synonyms

0615 Table Clusters

0616 Sequences

0617 Object Statistics

0618 Performance Views

07. Oracle IDEs

0701 Oracle SQL Plus

0702 SQL Developer

0703 Oracle Universal Installer (OUI)

0704 Oracle Enterprise Manager (OEM)

0705 Oracle Database Configuration Assistant (ODCA)

08. Structured Query Language (SQL)

0801 What Is SQL

0802 Select

0803 Insert

0804 Update

0805 Joins

0806 Deletes

0807 Merge

0808 Aggregates

0809 SQL Analytics

0810 Optimizer And Explain Plan

0811 Transactions And Concurrency

09. PL/SQL

0901 What Is PL/SQL

0902 Anonymous Blocks

0903 Procedures

0904 Functions

0905 Packages

0906 Object Types

0907 Dynamic SQL

0908 Application Express (ApEx)

10. XML

1001 What Is XML

1002 What Is XMLDB

1003 XMLType

1004 SQL/XML

1005 XQuery

1006 XML Repository

1007 XML Storage Models

11.Analysis Tasks With Oracle Data Modeler

1101 Data Modelling

1102 The Conceptual Model

1103 The Logical Model

1104 The Physical Model

1105 Deploying A Data Model

1106 Reverse Engineering

12. Database Tasks

1201 Backup And Recovery

1202 Startup And Shutdown An Instance

1203 The Listener

1204 Create And Remove Users

1205 Monitor Sessions

1206 Monitor Resources

1207 Monitoring Space Usage

1208 Adding Space

1209 Freeing Space

1210 Replication And Streams

1211 Database Scheduling

13.Data Import/Export

1301 SQL Loader

1302 External Tables

1303 Data Pump

1304 SQL Plus

1305 SQL Developer

1306 ETL Tools

14. Database Security

1401 Database Security

1402 Data Control Language (DCL)

1403 System And Object Privileges

1404 Roles

1405 DBA And Developer Access

1406 Virtual Private Database (VPD)

1407 Fine Grained Auditing (FGA)

1408 Transparent Data Encryption (TDE)

1409 SQL Injection

15. Very Large Databases (VLDB)

1501 VLDB

1502 OLAP

1503 Data Mining

16. About The Author

1601 About The Author

Informação adicional

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.