1. Training
  2. Education & Training Catalog
  3. Global Institute of Technology (GIT) Services
  4. SQL Fundamentals

SQL Fundamentals

This Oracle Database 11g/12c: SQL Fundamentals I - Course is designed to teach you the fundamentals of SQL using Oracle Database 11g/12c database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

Course Overview

Overall Proficiency Level
1 - Basic
Course Prerequisites

Computer Knowledge

Training Purpose
Skill Development
Specific Audience
Contractor
Federal Employee
Delivery Method
Classroom
Online, Instructor-Led
Course Location

4100 Lafayette Center Dr.
Suite 115 B
Chantilly, VA 20151

Course Location Map
  • Your Location
  • Providers
  • Courses
  • Course and Provider Quantity
  • Classroom
  • Online, Instructor-Led

Learning Objectives

  • Retrieve row and column data from tables with the SELECT statement
  • Create reports of sorted and restricted data
  • Employ SQL functions to generate and retrieve customized data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Create reports of aggregated data
  • Use the SET operators to create subsets of data
  • Run data manipulation statements (DML) to update data in the Oracle Database 11g
  • Run data definition language (DDL) statements to create and manage schema objects
  • Identify the major structural components of the Oracle Database 11g

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Competency Areas

Feedback

If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov. Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.

Last Published Date: