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: 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 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 group functions such as AVG, SUM, MIN, MAX, COUNT, and COUNT DISTINCT Use subqueries 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 Use the CREATE TABLE SQL command to create new tables in the database Use SQL to query a database 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 Define constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK Use various SQL*Plus commands Create users and grant privileges General Topics: Using Structured Query Language (SQL) Data Manipulation Language and Transaction Control Language Using Basic SELECT statements Conversion Functions and Conditional Expressions Displaying Data from Multiple Tables Using the Set Operators Managing Objects with Data Dictionary Views Managing Schema Objects Data Definition Language (DDL) SQL*Plus Restricting and Sorting Data Using Single-Row Functions to Customize Output Reporting Aggregated Data Using the Group Functions Using Subqueries to Solve Queries Creating Other Schema Objects Controlling User Access 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 Apprentice Java Developer to Senior Java Developer (SKIL-0229) AWS Certified Solutions Architect - Associate (SKIL-0252) AWS Certified Solutions Architect - Professional (SKIL-0253) C Programming Proficiency (SKIL-0262) Certified Business Analysis Professional (CBAP) (SKIL-0172) Certified Information Systems Security Professional (CISSP) 2021 Training (SKIL-0241) Cloud Computing for Decision-makers and Leaders (SKIL-0269) CloudOps Apprentice to CloudOps Engineer (SKIL-0237) CompTIA Linux+ (SKIL-0257) CompTIA Network+ (SKIL-0256) View All Courses Page Content