23 Tips on Database Learning (Classic collection)

By learning about the basic knowledge of Oracle database, we will finally work out the knowledge that must be mastered first, whether you are a database development, management, optimization, designer, or a developer in Java or C. Then the author will further refine the most useful content of this part of the knowledge, concentrate the most essential parts, share to everyone. This part of the knowledge is Oracle's common additions and deletions, tables, indexes, views and other five parts.

Reading is a classic, no shortcut in the shortest way. Recommend some good classical learning materials:
1. Oracle's official learning materials
2. Oracle Official OCP Guide, for 11g is SQL Fundamentals I, administration Workshop I and Ii.
3. Master Thomas Kyte:
-Expert Oracle Database Architecture Oracle Database 9i, 10g and 11g programming techniques and Solutions, translated as: Oracle Da Tabase 9i/10g/11g Programming Art
-Effective Oracle By design and Build high-performance Oracle Applications: Oracle Efficient Design
-Expert one-on-one Oracle with a translation: Oracle Advanced Programming
4. OCP/OCA Certification Exam Guide All Oracle Database 11g:1z0-051, 1z0-052, 1z0-053
5. Oracle Database 11g

Learning Oracle can refer to this picture:

Oracle 11g Best Practice Video Learning:

The first chapter begins

Learn what Oracle is, what the application type network architecture is, and where Oracle uses it in real-world work. What kind of person is suitable for learning Oracle and Oracle's complete certification system.

Chapter II Deployment of Linux systems 1

Learn more about Enterprise platform Linux systems and the software prerequisites required for database servers.

Chapter III Deployment of Linux systems 2

Installing grid software and ASM disk groups

Fourth. Deployment ORACLE11G1

Install Oracle software and build libraries to successfully deploy Oracle database on LINUX5 version

Fifth. Deployment Oracle11g2

Oracle database connection mode and Oracle database pre-boot, common base commands HELLP INDEX.

Sixth. Oracle database links and tools Common command operations

Seventh chapter EM Enterprise Manager installation and use and Sqldeveloper installation

Eighth. SQL Statement Basics First part

SQL Statement Basics First part: SELECT Statement Basics

Nineth. The second part of the SQL Statement Foundation limitation and ordering

Usage of the WHERE statement and order by

Tenth. SQL Statement Foundation third part variable simple function

Single-line function Concat,substr,length,instr,lpad | Rpad,replace, such as statement and time format RR format/yy format.

11th. SQL Statement Foundation Part IV transformation function and conditional expression

To_date/to_char/to_number conversion Functions, NVL,NVL2,NULLIF,COALESCE statements and CASE statements and decode statements

The 12th chapter of the SQL statement basic part of the group summary

Avg,sum,min,max,count (*), COUNT (field name) statement, GROUP BY statement and where and have difference

13th. SQL Statement Foundation Part VI connection Query

Natural join (natural join), join Using (conditional), join on (inner join), left join on (outer join), full join on SQL 99 Standard and Oracle private notation

14th. SQL Statement Base Seventh Molecular query

Deep understanding of the actual use of subqueries, the results of the query to do the conditions used

The 15th chapter of the SQL statement basic part set operation

Set Operation Union/union All,intersect,minus in the work of general use and advanced use.

16th the foundation of the ninth part of the SQL Statement Foundation

The definition of the base value of the built table, the date definition, the character definition

17th. SQL Statement Foundation Tenth part table constraint

Non-null/unique/PRIMARY key/FOREIGN key/CHECK constraint how to use the actual work

18th. SQL Statement Basics 11th Add Delete Modify constraint

19th. SQL Statement Basics Part 12th Update Data deletion data and rollback basic concepts in tables

20th. SQL Statement Basis 13th Part View index sequence synonyms

21st. SQL Statement Foundation 13th part role and System object permissions

22nd. SQL Statement Foundation 14th Part deferred deletion delay constrained index advanced Utilization Temp Table

Deferred deletion, delay constraint, advanced utilization of indexes (table space is used for tables and indexes) Temporal table (Session level, thing level)

23rd. SQL Statement Basics part 15th Operations Large data

Course Address: http://edu.51cto.com/course/course_id-3812.html

23 Tips on Database Learning (Classic collection)