<thead id="fflbj"><font id="fflbj"><cite id="fflbj"></cite></font></thead>
    <progress id="fflbj"><thead id="fflbj"><font id="fflbj"></font></thead></progress>

            曙海教育集團
            全國報名免費熱線:4008699035 微信:shuhaipeixun
            或15921673576(微信同號) QQ:1299983702
            首頁 課程表 在線聊 報名 講師 品牌 QQ聊 活動 就業
             
            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
             
              備案號:備案號:滬ICP備08026168號-1 .(2024年07月24日)....................
            538在线视频二三区视视频