課程大綱： Oracle SQL for beginners培訓(xùn)
Relational database models
The structure of a relational database
Connection types of tables
The normalization and denormalization database
Relational Operators
Download the data
Rules for writing SQL queries
The syntax for the SELECT
Selecting all columns
Inquiries from arithmetic operations
Aliases columns
Literals
Concatenation operator
Limiting results
The WHERE clause
Comparison operators
LIKE Condition
Prerequisite BETWEEN ... AND
IS NULL condition
Condition IN
Boolean operators AND, OR and NOT
Many of the conditions in the WHERE clause
The order of the operators.
DISTINCT clause
Sorting Data
The ORDER BY clause
Sorting by multiple columns or expressions
SQL functions
The differences between the functions of one and multilines
Features text, numeric, date,
Explicit and implicit conversion
Conversion functions
Nesting functions
Viewing the performance of the functions - dual table
Getting the current date function SYSDATE
Handling of NULL values
Aggregating data using the grouping
Grouping functions
How grouping functions treat NULL values
Create groups of data - the GROUP BY clause
Grouping multiple columns
Limiting the function result grouping - the HAVING clause
Retrieving data from multiple tables
Types of connectors
The use NATURAL JOIN
Aliases tables
Joins in the WHERE clause
INNER JOIN Inner join
External Merge LEFT, RIGHT, FULL OUTER JOIN
Cartesian product
Subqueries
Place subqueries in the SELECT command
Subqueries single and multi-lineage
Operators Subqueries single-line
Features grouping in subquery
Operators Subqueries multi-IN, ALL, ANY
How NULL values ??are treated in subqueries
Operators collective
UNION operator
UNION ALL operator
INTERSECT operator
MINUS operator
Insert, update, and delete data
INSERT command
Copy data from another table
UPDATE command
DELETE command
TRUNCATE command
Transactions
Commands COMMIT, ROLLBACK, and SAVEPOINT
DDL commands
The main database objects
Rules for naming objects
Creating tables
The data types available for columns
DEFAULT option
Option NULL and NOT NULL
Managing tables
Referential integrity CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE
Create a table by the query
Delete a table DROP TABLE
DESCRIBE command
Other schema objects
Sequences
Synonyms
Views
加入高級會員獲得助教答疑
