SQL

Register For SQLSQLIT Training Program @ Adams

Empowering you one @ a time

ADAMS MIS offers:

Oracle Certified Associate

Prerequisite:

Familiarity with basic computer operation

Course Description

This course focuses on the fundamental concepts of Oracle SQL to prepare students for Oracle SQL Fundamentals I exam, 1z0-051. Opportunities for hands on exercises will be provided. Concepts will be reinforced by giving homework and exercises.

 

Course Goals/Objectives

After completing this course, you should be able to:

  1. Retrieving Data Using the SQL SELECT Statement
  2. Restricting and Sorting Data
  3. Using Single-Row Functions to Customize Output
  4. Using Conversion Functions and Conditional Expressions
  5. Reporting Aggregated Data Using the Group Functions
  6. Displaying Data from Multiple Tables
  7. Using Sub-queries to Solve Queries
  8. Using the Set operators
  9. Manipulating Data
  10. Using DDL (Data Definition Language) Statements to Create and Manage Tables
  11. Creating Other Schema Objects

Duration of this class is 8 weeks, 3 hours per session.

Class meets every Sunday in ADAMS main center room 107

For more information please email us at training@adamscenter.us

*100% of the tuition is due on the first class.

Register For Class