|
Oracle 10g: Programming with SQL培訓 |
|
班級規模及環境--熱線:4008699035 手機:15921673576( 微信同號) |
每期人數限3到5人。 |
上課時間和地點 |
開課地址:【上?!客瑵髮W(滬西)/新城金郡商務樓(11號線白銀路站)【深圳分部】:電影大廈(地鐵一號線大劇院站) 【武漢分部】:佳源大廈【成都分部】:領館區1號【沈陽分部】:沈陽理工大學【鄭州分部】:錦華大廈【石家莊分部】:瑞景大廈【北京分部】:北京中山學院 【南京分部】:金港大廈
最新開班 (連續班 、周末班、晚班):2020年3月16日 |
實驗設備 |
☆資深工程師授課
☆注重質量
☆邊講邊練
☆合格學員免費推薦工作
★實驗設備請點擊這兒查看★ |
質量保障 |
1、培訓過程中,如有部分內容理解不透或消化不好,可免費在以后培訓班中重聽;
2、培訓結束后,授課老師留給學員聯系方式,保障培訓效果,免費提供課后技術支持。
3、培訓合格學員可享受免費推薦就業機會。 |
課程大綱 |
|
-
- 1. Introduction to Oracle and SQL in Oracle Database 10g
Basic principles of the relational model for databases
Use an entity relationship model to design a relational database
Main features and functions of the Oracle Database 10g release
Write basic SELECT statements for extracting data from a database
Enhance SQL statements to refine query results
Retrieve data from an Oracle 10g database using the SQL SELECT statement
Interact with script files in iSQL*Plus
Use iSQL* Plus in an Oracle 10g database to execute SQL statements and interact with script files
Use the WHERE clause to restrict the data returned by a SQL statement
Use the ORDER BY clause and substitution variables in SQL statements
2. SQL Functions in Oracle Database 10g
Use case and character-manipulation functions in SQL statements
Use number and date functions in SQL statements
Use number, character, and date functions to manipulate data values
Purpose of SQL datatype conversion functions in Oracle 10g
Use the TO_CHAR conversion function with dates and numbers
Use the TO_NUMBER and TO_DATE conversion functions
Use conversion functions to convert values in SQL statements
Use general functions in SQL statements
Use conditional expressions in SQL statements
Use general and conditional functions in SQL statements
3. Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
Retrieve records using the NATURAL JOIN and USING clauses
Retrieve data by creating joins with the ON clause
Use outer joins and generate Cartesian products
Use joins to retrieve data from multiple tables
Write SQL queries using set operators
Comply with rules for using set operators
Use the UNION, UNION ALL, INTERSECT, and MINUS operators in SQL queries
4. Group and Datetime Functions in Oracle Database 10g
Retrieve data using group functions
Write SQL queries that group and restrict output rows
Write SQL queries that use group functions, the GROUP BY clause, and the HAVING clause
Use the ROLLUP and CUBE operations and the GROUPING function in SQL queries
Use the GROUPING SETS function and specify composite columns and concatenated grouping sets
Write queries using ROLLUP and CUBE operators, GROUPING functions, and GROUPING SETS
Set time zone values and retrieve date and time values
Use date-related datatypes and date-related functions in Oracle 10g
Write SQL queries using datetime functions
5. Subqueries and Hierarchical Queries in Oracle Database 10g
Write single-row and multiple-row subqueries
Use subqueries to solve queries in an Oracle database
Write multiple-column, scalar, and correlated subqueries
Use the EXISTS, UPDATE, DELETE, and WITH clauses
Solve problems using multiple-column, correlated, and scalar subqueries and using the WITH clause
Use hierarchical queries to create tree-structured reports
Write hierarchical queries
6. Regular Expressions and User Access in Oracle Database 10g
Use regular expression support in SQL
Use regular expression functions to search, match, and replace strings
Use regular expression support to search for and manipulate strings
Create users, grant system privileges, assign roles, and
|
|
|
|
|
|