Online Clause eLearning

SQL Server 2008 Security Management SQL Server 2008: Security Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) Microsoft SQL Server 2008 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified  more...

Performing Advanced Query Techniques in SQL Server 2008 Performing Advanced Query Techniques in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing ...tatements where literal values are provided for the WHERE clause conditions, you get results in many versions of almost identical SQL to be stored in the library cache. If, instead of issuing different statements for each literal, you use a bind variable, then in theory that extra parse activity is eliminated. Listing the benefits of using bind variables, as well as using bind peeking and  more...

Quality-minded Management ...its Quality Management System (QMS) model into four major clauses: Management Responsibility, Resource Management, Product Realization, and Measurement, Analysis, and Improvement. This course provides an overview of the clause "Management Responsibility." It details management's role in establishing a quality policy and its responsibility to support and administer the organization's quality  more...

Oracle Database 10g SQL Fundamentals I Part 2 In 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  more...

Oracle Database 10g PL SQL Fundamentals Part 1 In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as  more...

Oracle Database 10g SQL Fundamentals I Part 1 ...sults 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  more...

Oracle SQL Specifics Retrieving and Formatting Data ... pseudocolumn. Identify the components of a basic WHERE clause. Use the WHERE clause to query for a character string or a date. Match each type of operator to the correct label. Identify which operators can be used to find rows that do not meet a condition. Perform a query using a SQL operator. Use the ORDER BY clause to sort query results. Use a join to query data from multiple  more...

Oracle SQL Specifics Creating and Managing Database Objects ...constraints. Use the ALTER TABLE statement with the ADD clause to add a column to a table. Use the ALTER TABLE statement with the MODIFY clause to modify a column definition. Use the ALTER TABLE statement with the ADD clause to add a constraint to a table. Use the ALTER TABLE statement with the DROP clause to drop a constraint from a table. Use the ALTER TABLE statement with the  more...

Oracle SQL and SQL Plus Advanced SELECT Statements Course Overview This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write  more...

Oracle Form Builder Including Reusable Oracle Components ... operations on data blocks. Base a data block on a FROM clause query by using the Property Palette. Write the code to base a data block on a stored procedure that returns a Ref cursor. Write the code to base a data block on a stored procedure that returns a table of records. Identify the properties of a data block based on a stored procedure. Identify the performance implications  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...OCK_BUFFERS initialization parameter. Select the proper clause to obtain the size of each object. Sequence the steps to determine the number of blocks required for objects in the RECYCLE pool. Perform the steps to determine if there have been waits for buffers using the V$SESSION_WAIT view. Perform the steps to enable caching during full table scans using the CACHE clause. Perform the  more...

Oracle Form Builder R6 Including Reusable Oracle Components ...ources used for data blocks. Base a data block on a FROM clause query. Create a data block based on a stored procedure that returns a REF cursor by using the Data Block Wizard. Create a data block based on the stored procedure that returns a table of records by using the Data Block Wizard. Identify the properties of a data block based on a stored procedure. Identify the performance  more...

SQL Server 7 0 - Implementing a Database - Part 4 ... null values. Select statements to use with the GROUP BY clause on columns. Select statements to use with the GROUP BY clause on expressions. Select when to use the HAVING clause. Perform the steps to summarize group values. Perform the steps to summarize combinations of groups. Select the characteristics of the GROUPING function. Select guidelines for using the COMPUTE clause. Select  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ... Retrieve data by using the SELECT statement with a WHERE clause. Aggregate data by using the aggregation functions. Group the aggregated data by using the GROUP BY keyword. Retrieve specific groups of the aggregated data by using the HAVING keyword. Calculate totals and subtotals of the groups in the aggregated data by using the ROLLUP keyword. Calculate totals and subtotals for all  more...

SQL and PL SQL Basic SELECT Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic  more...

SQL and PL SQL Data Retrieval Techniques ...s course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a format specified by the user will be covered. L earn To: Retrieve rows from multiple tables by using an  more...

Oracle Database 10g New Features for Administrators Part 2 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor  more...

Oracle SQL for End Users--Part 1 ... and SQL*Plus. Write basic SQL SELECT statements. Add clauses to basic SQL SELECT statements to restrict and sort data retrieved by a query. Write SQL statements that contain a variety of single-row functions. C ontent Emphasis Skills-Based A udience End users are the targeted audience for this course. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:  more...

Oracle SQL for End Users--Part 2 ...ons in an equijoin by using the AND operator in the WHERE clause. Retrieve rows from two tables by using a non-equijoin. Retrieve rows within the same table by using a self join. Retrieve rows from more than two tables by using an equijoin. Unit 2: Group Functions Duration: 1 - 2 Hour(s) Identify the features of a group function. Return the minimum and maximum values from a group  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data ...hin a table. Identify the guidelines for using the WHERE clause to retrieve rows in a table. Retrieve specific columns from a table. Identify the characteristics of aggregate functions. Identify the considerations for using the GROUP BY clause. Identify the guidelines for using the GROUP BY clause with the HAVING clause Audience Candidates for this course operate in medium to very  more...

Oracle9i SQL Basic SELECT Statements ...e a query that restricts rows returned by using the WHERE clause. o Write a WHERE clause to accommodate different datatypes. o Use comparison operators with the WHERE clause. o Identify the different categories of datatypes. o Match the character datatypes with their descriptions. o Identify the features of the NUMBER datatype. Audience The target audience for this course includes  more...

Oracle9i SQL Data Retrieval Techniques ...rite a single-row subquery to return one row in the WHERE clause of a SELECT statement. o Identify the characteristics of substitution variables. o Prompt the user for a number value at run time by using a substitution variable. o Prompt the user for a character value at run time by using a substitution variable. Audience The audience includes database administrators, designers,  more...

C Programming for the Microsoft NET Platform Part 2 ...atement. • Identify characteristics of the finally clause. • Match the syntax used to check for arithmetic overflow with their descriptions. Unit 2: Methods and Parameters 2 - 3 hours • Identify the syntax used to define a method. • Identify the syntax used to call a method. • Identify the syntax used to declare local variables in methods. •  more...

CIW Database Specialist Part 3 Database Interaction JDBC This is the third course in a four part series that teaches students about SQL, relational algebra, transactions and database security, and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins,  more...

ISO 9001 2000 Implementing Standards ... Implementing Standards you learn about the principal ISO Clauses, new ISO requirements and the documentation and potential auditing pitfalls associated with each one. The Clauses are summarized and explained in real-world situations, enabling the learner to achieve the maximum benefit from experiencing a quality management system operate most efficiently. Learn To  more...

Spanish- Introduction to OSHA and OSHA Act ... and Health (OSH) Act Explain how the General Duty Clause affects employers Identify the different types of OSHA violations Explain how OSHA conducts inspections Understand OSHAa ™s requirements Understand employersa ™ and workersa ™ rights REGULATORY REQUIREMENT: Please see the state/ regulatory requirement from the course catalog page.  more...