課程名稱：Oracle AI Database SQL Associate 認證課程
- 簡稱：SQL Training Course (提供 7x24 實習器材) |
Relational Database Concepts
- Explain the theoretical and physical aspects of a relational database
- Describe how to relate clauses in SQL Select Statement to Components of an ERD
- Describe the relationship between a database and SQL
- Retrieving Data using the SQL SELECT Statement and Restricting and Sorting Data
Demonstrate how to use column aliases
- Describe using The SQL SELECT statement
- Apply knowledge of how to use the concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
- Calculate output using Arithmetic expressions and NULL values in the SELECT statement
- Demonstrate how to use rules of precedence for operators in an expression
- Identify how to limit rows returned in a SQL statement
- Recognize how to use Substitution Variables
- Describe using the DEFINE and VERIFY commands
- Utilize concepts to sort data
Using Functions
- Apply character functions to manipulate strings in SELECT and WHERE clauses
- Show how to use arithmetic with date data
- Use the ROUND, TRUNC and MOD functions
- Use DATE functions
- Apply the NVL, NULLIF, and COALESCE functions to data
- Explain implicit and explicit data type conversion
- Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Describe nesting multiple functions
- Show restricting group results
- Explain creating groups of data and using group functions
Displaying Data from Multiple Tables
- Use SELF-JOINS
- Use various types of joins
- Use NON EQUIJOINS
- Use OUTER joins
- Show understanding of using CARTESIAN PRODUCTS
Using Subqueries to Solve Queries
- Use single row subqueries
- Use multiple row subqueries
- Show how to update and delete rows using correlated subqueries
Using SET Operators
- Demonstrate matching the SELECT statements
- Use the ORDER BY clause in set operations
- Use the INTERSECT, MINUS, UNION and UNION ALL operators
Managing Tables using DML statements
- Apply managing database transactions and controlling transactions
- Execute Insert, Update and Delete operations
- Execute multi table Inserts and Merge statements
Managing Indexes Synonyms and Sequences
- Manage indexes
- Manage synonyms
- Manage sequences
Use DDL to manage tables and their relationships
- Describe working with tables
- Describe working with columns and data types
- Use CREATE TABLE statements
- Demonstrate dropping columns and setting column UNUSED
- Explain the TRUNCATE TABLE statement
- Create and use temporary tables
- Create and use external tables
- Apply how to manage constraints
- Explain managing views
Controlling User Access
- Contrast system privileges and object privileges
- Apply granting privileges on tables
- Demonstrate how to grant privileges and create roles
Managing Objects with Data Dictionary Views and Data in Different Time Zones
- Use data dictionary views
- Use CURRENT_DATE,CURRENT_TIMESTAMP,and LOCALTIMESTAMP
- Explain how to use the INTERVAL data types
|
