Online Grouping Sets eLearning Training

IBM DB2 Universal Database V6 1--App Development ...tions. Create different levels of aggregation data using GROUPING SETS operations. Identify characteristics of STAR schemas for table design and index design. Code combined SQL statements using compound SQL. Create a local temporary table that can be referenced in an SQL statement using a common table expression. Retrieve data with logical conditions using a CASE expression in a given more...

IBM DB2 Universal Database V6 1--App Development ...tions. Create different levels of aggregation data using GROUPING SETS operations. Identify characteristics of STAR schemas for table design and index design. Code combined SQL statements using compound SQL. Create a local temporary table that can be referenced in an SQL statement using a common table expression. Retrieve data with logical conditions using a CASE expression in a given 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 the more...