課程目錄:ORACLE SQL Fundamentals培訓
4401 人關注
(78637/99817)
課程大綱:

         ORACLE SQL Fundamentals培訓

 

 

 

Introduction
Overview
Aims and Objectives
Sample Data
Schedule
Introductions
Pre-requisites
Responsibilities
Relational Databases
The Database
The Relational Database
Tables
Rows and Columns
Sample Database
Selecting Rows
Supplier Table
Saleord Table
Primary Key Index
Secondary Indexes
Relationships
Analogy
Foreign Key
Foreign Key
Joining Tables
Referential Integrity
Types of Relationship
Many to Many Relationship
Resolving a Many-to-Many Relationship
One to One Relationship
Completing the Design
Resolving Relationships
Microsoft Access - Relationships
Entity Relationship Diagram
Data Modelling
CASE Tools
Sample Diagram
The RDBMS
Advantages of an RDBMS
Structured Query Language
DDL - Data Definition Language
DML - Data Manipulation Language
DCL - Data Control Language
Why Use SQL?
Course Tables Handout
Data Retrieval
SQL Developer
SQL Developer - Connection
Viewing Table Information
Using SQL, Where Clause
Using Comments
Character Data
Users and Schemas
AND and OR Clause
Using Brackets
Date Fields
Using Dates
Formatting Dates
Date Formats
TO_DATE
TRUNC
Date Display
Order By Clause
DUAL Table
Concatenation
Selecting Text
IN Operator
BETWEEN Operator
LIKE Operator
Common Errors
UPPER Function
Single Quotes
Finding Metacharacters
Regular Expressions
REGEXP_LIKE Operator
Null Values
IS NULL Operator
NVL
Accepting User Input
Using Functions
TO_CHAR
TO_NUMBER
LPAD
RPAD
NVL
NVL2 Function
DISTINCT Option
SUBSTR
INSTR
Date Functions
Aggregate Functions
COUNT
Group By Clause
Rollup and Cube Modifiers
Having Clause
Grouping By Functions
DECODE
CASE
Workshop
Sub-Query & Union
Single Row Sub-queries
Union
Union - All
Intersect and Minus
Multiple Row Sub-queries
Union – Checking Data
Outer Join
More On Joins
Joins
Cross Join or Cartesian Product
Inner Join
Implicit Join Notation
Explicit Join Notation
Natural Join
Equi-Join
Cross Join
Outer Joins
Left Outer Join
Right Outer Join
Full Outer Join
Using UNION
Join Algorithms
Nested Loop
Merge Join
Hash Join
Reflexive or Self Join
Single Table Join
Workshop
Advanced Queries
ROWNUM and ROWID
Top N Analysis
Inline View
Exists and Not Exists
Correlated Sub-queries
Correlated Sub-queries with Functions
Correlated Update
Snapshot Recovery
Flashback Recovery
All
Any and Some Operators
Insert ALL
Merge
Sample Data
ORDER Tables
FILM Tables
EMPLOYEE Tables
The ORDER Tables
The FILM Tables
Utilities
What is a Utility?
Export Utility
Using Parameters
Using a Parameter file
Import Utility
Using Parameters
Using a Parameter file
Unloading Data
Batch Runs
SQL*Loader Utility
Running the Utility
Appending Data

主站蜘蛛池模板: 久久综合中文字幕| 色综合久久88色综合天天| 亚洲 自拍 另类小说综合图区| 亚洲欧美国产∧v精品综合网 | 日韩亚洲欧美久久久www综合网| 色综合合久久天天综合绕视看| 少妇人妻综合久久中文字幕| 国产成人精品综合网站| 激情伊人五月天久久综合| 乱欧美综合| 鲁一鲁一鲁一鲁一曰综合网| 亚洲国产综合精品中文字幕| 色综合合久久天天给综看| 天天综合天天做天天综合| 亚洲精品综合久久| 久久狠狠一本精品综合网| 五月天激情综合网| 99久久亚洲综合精品成人| 久久久久久久综合综合狠狠| 一本色道久久综合狠狠躁篇| 久久久久综合中文字幕| 综合三区后入内射国产馆| 亚洲国产欧美国产综合一区 | 色天使久久综合网天天| 免费精品99久久国产综合精品| 狠狠色狠狠色综合曰曰| 欧美综合缴情五月丁香六月婷 | 久久综合丁香激情久久| 激情综合色五月丁香六月亚洲| 99久久婷婷国产综合亚洲| 久久一日本道色综合久久| 久久涩综合| 国产成人综合亚洲欧美天堂| 亚洲综合熟女久久久30p| 亚洲乱码中文字幕综合234| 狠狠色噜噜狠狠狠狠色综合久| 久久天天日天天操综合伊人av| 国产亚洲综合一区柠檬导航| 天堂无码久久综合东京热| 亚洲精品第一综合99久久| 97久久久精品综合88久久|