Free basic knowledge of Oracle database explaining video sharing!

Course Description: Database basics, Oracle's Environment architecture, Oracle Architecture, SQL Language Foundation, function usage, constraints, indexes, data dictionaries, group queries, multi-table join queries, subqueries, and more. Through a systematic explanation of Oracle database, we develop

The ability to live is as follows: in the actual work, skilled use of SQL statements for project development, can use complex SQL statements for Multi-table association query, with database data management and maintenance capabilities.

Course Catalogue:

day01_ Installing the Database software
Basic use of the DAY02_ database using the SELECL statement
Day03_ Restricting Data return
day04_ character functions, numeric functions, date functions
day05_ conversion functions, general functions, conditional expressions
day06_ multiple table joins
DAY07_ Group functions
Day08_ Sub-query
day09_ substitution Variable sqlplus environment command
Use of DAY10_DML statements
Day11_ the concept and processing of transactions
Day12_ creating tables, Managing tables
day13_ Administrative constraints
day14_ Management view
Day15_ Managing other database objects
Day16_ Managing Users
Day17_ Set operation
Day18_ the time type of the extension
Day19_ Enhanced GROUP BY
Day20_ Advanced Sub-query
Day21_ host variable anchor, cursor variable
Day22_ Exception Handling
Day23_procedure
Day24_ self-made transaction caller permissions, functions, deterministic functions
Day25_package, Trigger
Day26_ Architecture Components Overview
Day27_ managing password files and parameter files
day28_ trace File
day29_ database start three stages, stop the library four modes, manually create the database
day30_ Management Controlfile
Day31_ managing online log files and archive files
Day32_ managing temporary tablespace, managing undo Table Space
Day33_undo Automatic Management and manual management, flash back operation, space management algorithm of table space
Day34_ Section Space Manual Management
Day35_ section Space Automatic management, extent management, block space management
day36_ Configuring the boot listener, simple connection, using the listening configuration to modify the port
Day37_ failover, shared server, Database link
Day38_ Database Audit
day39_ Logical Export
day40_ logical export, write backup scripts, pipeline operations
Day41_ Transmission table space, data pump
Day42_ not fully recovered
Backup restore and restore of day43_ control files
Day44_rman image Backup and basic operation
Day45_rman backup sets, split backup slices, lost up-to-date backups, move files
Day46_ using seed Backup to restore a database, transfer example table space
Day47_ Modify database name, incremental backup, block-level repair corruption
Day48_rman incomplete recovery, flash back database
Day49_catalog database;ora-00600[2662]
day50_ Physical backup library for maximum performance

Baidu Cloud Disk Download: Http://pan.baidu.com/s/1c26FWaO

Password: ewm1

More Resources Download: Http://www.uplooking.com/bbs

Free basic knowledge of Oracle database explaining video sharing!