Course Course Summary Section 1 Content Section 1 Content Left Section 1 Content Right Credit Type: Course ACE ID: SKIL-0202 Organization: SkillSoft Corporation Location: Online Length: Self-paced, 18 hours Dates Offered: 6/1/2023 - 5/31/2026 10/1/2019 - 5/31/2023 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Lower-Division Baccalaureate 3 Relational Databases or Sql Description Section 3 Content Section 3 Content Left Section 3 Content Right Objective: The course objective is to help prepare learners for the Oracle Database 12c R2 SQL (1Z0-071) certification exam. Learning Outcomes: Use SQL to query a database Use SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings Write SQL queries using set operators including UNION, UNION ALL, and INTERSECT Describe the DDL database objects and the associated naming rules Selectively return only a subset of rows, sorted and customized using various SQL clauses and statements Insert, update, delete, and truncate rows using associated SQL statements Use conversion functions and conditional expressions including, TO_CHAR, TO_NUMBER TO_DATE, NULLIF and COALESCE Use join statements to view information across multiple tables Use data dictionary views such as USER OBJECTS and ALL_OBJECTS Use the CREATE TABLE SQL command to create new tables in the database Define constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK Use various SQL*Plus commands Use group functions such as AVG, SUM, MIN, MAX, COUNT, and COUNT DISTINCT Use subqueries Create users and grant privileges General Topics: Oracle Database 12c R2 SQL: Using Structured Query Language (SQL) Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language Oracle Database 12c R2 SQL: Using Basic SELECT statements Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables Oracle Database 12c R2 SQL: Using the Set Operators Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views Oracle Database 12c R2 SQL: Managing Schema Objects Oracle Database 12c R2 SQL: Data Definition Language (DDL) Oracle Database 12c R2 SQL: SQL*Plus Oracle Database 12c R2 SQL: Restricting and Sorting Data Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output Oracle Database 12c R2 SQL: Reporting Aggregated Data Using the Group Functions Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries Oracle Database 12c R2 SQL: Creating Other Schema Objects Oracle Database 12c R2 SQL: Controlling User Access Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries Instruction & Assessment Section 4 Content Section 4 Content Left Section 4 Content Right Instructional Strategies: Computer Based Training Practical Exercises Methods of Assessment: Examinations Quizzes Minimum Passing Score: 70% Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Other offerings from SkillSoft Corporation Agile for Software Development (SKIL-0216) AI Apprentice to AI Architect (SKIL-0210) Application Developer to Blockchain Solutions Architect (SKIL-0209) Apprentice Java Developer to Senior Java Developer (SKIL-0229) Apprentice Programmer Journey - Novice and Apprentice Programmer (SKIL-0214) Apprentice Programmer Journey - Web Programmer and Web Apps Developer (SKIL-0213) AWS Certified Solutions Architect - Associate (SKIL-0252) AWS Certified Solutions Architect - Professional (SKIL-0253) Business Analyst to Data Analyst (SKIL-0227) C Programming Proficiency (SKIL-0262) View All Courses Page Content