Dry goods sharing: Oracle database basics intensive video!
Course introduction: Database basics, Oracle environment construction, Oracle architecture, SQL language basics, function usage, constraints, indexes, data dictionaries, packet queries, multi-table join queries, subqueries, etc. Through a detailed explanation of the Oracle database, cultivate science
The students' abilities are as follows: in practical work, proficient in using SQL statements for project development; Ability to use complex SQL statements for multi-table association queries; Have the ability to manage and maintain database data.
Course Catalog:
day01_ install database software
day02_ the basic use of the database using the selecl statement
day03_ limit data return
day04_ character function, number function, date function
day05_ Transform functions, generic functions, conditional expressions
day06_ multi-table joining
day07_ set of functions
day08_ subquery
day09_ the alternate variable SQLplus environment command
Use of day10_DML statements
day11_ the concept of transactions and handling transactions
day12_ create tables and manage tables
day13_ management constraints
day14_ Admin view
day15_ manage other database objects
day16_ manage users
day17_ set operations
day18_ the type of time that expands
day19_ enhanced Group by
day20_ high-level subqueries
day21_ host variable anchoring and vernier variable
day22_ exception handling
day23_procedure
day24_ custom transaction caller permissions, functions, and deterministic functions
day25_package、trigger
day26_ Overview of Architecture Components
day27_ manage password files and parameter files
day28_ tracking files
day29_ database starts in three stages, stops the database in four modes, and creates the database manually
day30_ manage controlfiles
day31_ manage online log files and archive files
day32_ manage temporary tablespaces and manage undo tablespaces
day33_undo spatial management algorithms for automatic and manual management, flashback operations, and tablespace
day34_ section of space is managed manually
day35_ automatic space management, Extend management, and Block space management
Start listening day36_ configuration, connect simply, and modify ports using listening configurations
day37_ failover, shared servers, database links
day38_ database audits
day39_ logical export
day40_ logical exports, writing backup scripts, pipeline operations
day41_ Transfer Table Space, Data Pump
day42_ not fully recovered
day43_ control the backup restore and recovery of files
day44_Rman image backup and basic operations
day45_Rman backup sets, split backup slices, lose the latest backup, move files
day46_ use a seed backup to restore the database and transfer the Example tablespace
day47_ modify database names, incremental backups, block level repair corruption
day48_rman incomplete recovery, flashback 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:Tourists, if you want to see the hidden content of this post, please Reply
|
Posted on 8/16/2017 10:45:59 AM
|
|
|
Posted on 8/17/2017 3:36:56 PM
|
