67310 - Oracle Database 10g: SQL Fundamentals I Part 1Course OverviewIn this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To • Match the different phases of system development life cycle (SDLC) with their features • Identify features of an Entity Relationship (ER) model • Identify features of Relational Database Management System (RDBMS) • Identify the SQL statement to retrieve data from tables • Identify arithmetic expressions used to perform operations on data • Identify operators used to format results in SQL statements • Identify features of single-row functions • Match the character functions with their uses • Match the number functions with their purpose • Identify the use of natural joins to retrieve data from multiple tables • Identify the use of an equijoin to retrieve data from multiple tables • Identify the use of self-join to retrieve data from a table Audience The audience for this course includes PL/SQL Developers, System Analysts, Technical Consultants, Forms Developers, Portal Developers, and Database Administrators. Total Learning Time 8 hours Objectives Unit 1: Database Management in Oracle 10g 2 hours • Match the different phases of system development life cycle (SDLC) with their features • Identify features of an Entity Relationship (ER) model • Identify features of Relational Database Management System (RDBMS) • Identify the structural components of Oracle 10g • Identify features of iSQL*Plus • Identify options available in iSQL*Plus that help interacting with a script file • Identify uses of various SQL statements Unit 2: Basic SQL Statements 2 hours • Identify the SQL statement to retrieve data from tables • Identify arithmetic expressions used to perform operations on data • Identify operators used to format results in SQL statements • Identify the use of the WHERE clause in restricting the result set of an SQL query • Identify the uses of the comparison operators used in a WHERE clause to restrict the query results • Identify the operators used in logical conditions to restrict query results • Identify the rules of precedence associated with the WHERE clause • Identify methods of sorting the result set of a query by using the ORDER BY clause • Identify substitution variables that are used while retrieving data by using SQL statements Unit 3: SQL Functions 2 hours • Identify features of single-row functions • Match the character functions with their uses • Match the number functions with their purpose • Identify features of the date functions • Identify features the functions used to convert data types • Identify the use of nested functions in retrieving data from tables • Identify features of general functions • Identify features of conditional functions • Identify features of types of group functions • Identify guidelines for using the GROUP BY clause Unit 4: Advanced SQL Statements 2 hours • Identify the use of natural joins to retrieve data from multiple tables • Identify the use of an equijoin to retrieve data from multiple tables • Identify the use of self-join to retrieve data from a table • Identify the use of outer joins to retrieve data from multiple tables • Identify the use of non-equijoins to retrieve data from multiple tables • Identify features of Cartesian products • Identify features of subqueries • Identify the use of single-row subqueries to retrieve data from multiple tables • Identify the use of multiple-row subqueries to retrieve data from multiple tables • Identify features of the different types of set operators 67311 - Oracle Database 10g: SQL Fundamentals I Part 2Course OverviewIn this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. Learn To • Identify the code for using the INSERT statement • Identify the code for using the UPDATE statement • Identify the code for using the DELETE statement • Identify tasks to be performed for granting system privileges • Identify tasks to be performed for granting object privileges • Identify syntax for performing various tasks for maintaining columns • Identify the code for retrieving data hierarchically from a table • Identify the code for formatting hierarchical reports • Identify features of regular expression functions Audience The audience for this course includes PL/SQL Developers, System Analysts, Technical Consultants, Forms Developers, Portal Developers, and Database Administrators. Total Learning Time 8 hours Objectives Unit 1: DML and Schema Objects 2 hours • Identify the code for using the INSERT statement • Identify the code for using the UPDATE statement • Identify the code for using the DELETE statement • Identify the code for using the MERGE statement for updating or inserting data into a table • Identify ways of controlling transactions in SQL • Identify guidelines for naming database objects • Identify the syntax for creating a table • Identify the syntax for defining constraints • Identify the syntax for altering and dropping a table • Identify features of views • Identify syntax for performing various tasks for managing views • Identify the syntax for creating a sequence • Identify the syntax for modifying a sequence • Identify the syntax for creating and dropping synonyms • Identify features of indexes • Identify the syntax for creating and dropping indexes • Identify features of the data dictionary • Identify the contents and usage of data dictionary views Unit 2: Objects and Data Management 3 hours • Identify tasks to be performed for granting system privileges • Identify tasks to be performed for granting object privileges • Identify syntax for performing various tasks for maintaining columns • Identify syntax for performing various tasks for managing constraints • Identify the syntax of the FLASHBACK TABLE statement • Identify the syntax for creating external tables • Identify syntax for manipulating data using subqueries • Identify features of Flashback Version Query that help in tracking data changes • Identify the syntax of the unconditional INSERT ALL statement • Identify the syntax of the conditional INSERT ALL statement • Identify the syntax of the conditional INSERT FIRST statement • Identify the syntax of the pivoting INSERT statement • Identify features of the ROLLUP operator • Identify features of the CUBE operator • Identify features of the GROUPING function • Identify features of the GROUPING SETS clause • Identify features of a composite column • Identify features of concatenated groupings • Identify syntax for displaying dates in different formats • Identify syntax for performing datetime conversions • Identify syntax for performing multiple-column subqueries • Identify syntax for performing scalar subqueries • Identify the syntax for using correlated subqueries • Identify the code for testing the existence and nonexistence of rows in the result set of a subquery • Identify the syntax for performing correlated operations • Identify features of the WITH clause used to perform correlated subqueries Unit 3: Data Retrieval 3 hours • Identify the code for retrieving data hierarchically from a table • Identify the code for formatting hierarchical reports • Identify features of regular expression functions |
**Register Today and Save $$ with Planetlearn.com**
Prices are for single user. If you are looking for internet/intranet or LAN solutions and have specific training needs not listed, please call 207-671-1666 or E-Mail sales@planetlearn.com
Partner Sites
Planetlearn Order securely online or call 207-671-1666 |