Oracle10G Introduction to SQL Programming Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 433
Course Abstract:	In this class, participants will learn how to create, retrieve, and manipulate objects in Oracle10g Structured Query Language (SQL). Participants will also be introduced to Oracle10g database features and tools.
Audience:	This course is designed for application developers, database administrators, system administrators and users who write applications and procedures that access an Oracle10g database.
Duration:	2 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Use Oracle SQL*Plus > Use SQL Functions > Define Tables > Create Views
Course Topics:	Review of Relational Database Terminology Relational Database Management Systems Introduction to SQL Oracle Versioning and History Logical and Physical Storage Structures Connecting to a SQL Database Datatypes Sample Database Using Oracle SQLPlus SQLPlus The SQL Buffer Buffer Manipulation Commands Running SQLPlus Scripts Tailoring Your SQLPlus Environment Viewing Table Characteristics SQLPlus Substitution Variables Interactive SQLPlus Scripts Using iSQL*Plus SQL Queries - The SELECT Statement The SELECT Statement The CASE...WHEN Statement Choosing Rows with the WHERE Clause NULL Values Compound Expressions IN and BETWEEN The LIKE Operator Creating Some Order Scalar Functions SQL Functions Using SQL Functions String Functions Numeric Functions Date Functions Conversion Functions Date Formats Oracle Pseudocolumns SQL Queries - Joins Selecting from Multiple Tables Joining Tables Self Joins Outer Joins Types of Outer Joins Aggregate Functions and Advanced Techniques Subqueries Correlated Subqueries The EXISTS Operator The Aggregate Functions Grouping Rows Combining SELECT Statements Data Manipulation and Transactions The INSERT Statement The UPDATE Statement The DELETE Statement Transaction Management Concurrency Explicit Locking Data Inconsistencies Loading Tables From External Sources Data Definition and Control Statements Standard Datatypes Defining Tables Constraints Inline Constraints Modifying Table Definitions Deleting a Table Definition Controlling Access to Your Tables Other Database Objects Views Creating Views Updateable Views Sequences Synonyms Appendix A - The Data Dictionary Introducing the Data Dictionary DBA, ALL, and USER Data Dictionary Views Some Useful Data Dictionary Queries
Prerequisites:	None

Oracle10G Introduction to SQL Programming Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology