Oracle18c SQL

Catalog Home Databases, Business Intelligence & Data Science Oracle Programming

This course provides a complete, hands-on introduction to SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for users of Oracle11g and higher. A full presentation of the basics of relational databases and their use are also covered.

Before taking this course, basic computer skills are needed. A basic knowledge of databases is desired, but not required.

5 Days/Lecture & Lab

This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers, and database administrators.

  • Basic RDBMS Principles
  • The SQL Language and Tools
  • Using SQL Developer
  • SQL Query Basics
  • WHERE and ORDER BY
  • Functions
  • ANSI 92 JOINS
  • ANSI 99 JOINS
  • GROUP BY and HAVING
  • Subqueries
  • Regular Expressions
  • Analytics
  • Analytics II
  • Basic Reporting
  • Security
  • Data Import and Export
  • Data Manipulation
  • Advanced Data Manipulation
  • Introduction to Data Definition
  • Advanced Data Definition




< >

Recently Viewed Courses:

Copyright © 2019 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media