Navigation

Custom Search

> > > >

Online Select Statements eLearning Training

Matching Training Programs

online course

instructor led class

learn at home

group study

self directed training

cd based training

DVD video training

printed book

e-book digital book

workshop seminar

train the trainer

computer based learning

discount pricing

online tutorial

Select Statements Training Seminars and Classes

From Serebra Learning Corporation

The Mark of a Leader

Do you feel that your people can't get along without you? If you're not available, do your people lack direction and therefore, productivity suffers? If you feel that you've been overmanaging and underleading, this course is for you. There is a strong difference between activities and roles of effective managers and those of successful leaders. You'll discover what some of those key differences more...

Occupational Health and Safety HRCI PHR

The Human Resource Certification Institute's (HRCI) certification examinations, HRCI/PHR (Professional in Human Resources certification), cover a broad range of workforce planning and employment issues, including legislation affecting employee safety and health. The (HRCI) certification examinations are widely recognized as the industry standard for evaluating Human Resource professionals' more...

Six Sigma DMAIC Defining the Problem

What's your problem? It could be said that this is one way to get to the heart of a matter. Of course, there's a better way. In this course, Six Sigma DMAIC: Defining the Problem, Six Sigma Green Belts and team members are given a systematic, objective, and measurable process for quantifying the challenges facing your organization. In lesson one, "The Project Charter," you'll learn guidelines for more...

Writing a Marketing Plan Phase 1

This course will define the marketing plan, types of plans and outline the purposes for using a marketing plan. You will then get started on writing the plan by establishing objectives and working on introductory elements. Then, you'll complete a situational analysis that evaluates the overall market, industry, internal and competitive factors pertinent to your product or service. Finally, you'll more...

Writing the Marketing Plan Creative Strategy

You've completed the first part of your marketing plan. Now it's time to write about your marketing tactics. You'll discover just how to match your product with your target market, determining exactly what the competitive advantages of your particular product are. Then you'll explore the price-setting strategies that will help make your product a success. Marketing managers, supervisors or team more...

Financial Analysis for Successful Marketing

Whether you have a "head" for numbers, or a "dread" of numbers, no strategic marketing plan will be successful without a thorough financial analysis. The final course in this series takes a user-friendly, interactive approach to help you master the numbers game. You will analyze typical financial parameters associated with setting up a financial budget as part of an overall marketing strategy. more...

Equal Employment Opportunity EEO

Think about the last time you were in an interview. Did you pay attention to the types of questions being asked? If not, you may have offered or requested information prohibited under anti-discrimination laws. It is essential to know the types of questions that can, and cannot, be asked in order to avoid charges of unfair discrimination. In this course, you will learn the Equal Employment more...

Family Medical Leave Act FMLA

Have you or a family member ever been seriously ill and needed to take medical leave? Did your employer give you the leave you deserved without it affecting your job? It is essential to understand the law of the Family and Medical Leave Act (FMLA) in order to protect yourself from losing your job or benefits. FMLA is only relevant to U.S. based employers and their U.S. based employees. In this more...

SQL Functions in Oracle 9i

To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators more...

Introduction to Oracle and SQL in Oracle Database 10g

To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators more...

Oracle9i SQL: Basic SELECT Statements

This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. more...

Oracle SQL for End Users Part 1

...designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product set. In this course the learner creates basic SQL SELECT statements and customizes these queries to restrict and sort the results. In more...

Oracle SQL: Basic SELECT Statements

This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic SQL statements; more...

Oracle9i SQL: Basic SELECT Statements

This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally this course provides an introduction to relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database. more...

Oracle SQL Specifics: Retrieving and Formatting Data

This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL more...

Oracle SQL and SQL*Plus: Advanced SELECT Statements

This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. more...

From 123-CBT Computer Based Training

Oracle SQL PL SQL Using Procedure Builder Curriculum

...our Skill Builder courses: Course 61110 Oracle SQL: Basic SELECT Statements Course 61111 Oracle SQL: Data Retrieval Techniques Course 61112 Oracle SQL: DML and DDL Course 61113 Oracle PL/SQL: Basics Certification: This curriculum will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle8i Certified more...

Oracle9i Database Admin Manage Security

...64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA more...

Oracle9i Database Admin Manage Data Storage

...-64313. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA more...

Oracle9i Database Admin Manage Storage Structures

... 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA more...

Oracle9i Database Admin Manage an Instance

Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are more...

Oracle9i SQL DML and DDL

...uired prerequisite knowledge includes Oracle9i SQL: Basic SELECT Statements 61130 and Oracle9i SQL: Data Retrieval Techniques 61131. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese, German, Spanish Total Learning Time 6 to 8 hours 61132 Objectives Unit 1: more...

Oracle9i SQL Basic SELECT Statements

...ith their descriptions. o Match the capabilities of SQL SELECT statements with their functions. o Identify the guidelines for constructing basic SQL SELECT statement. o Write a query that restricts rows returned by using the WHERE clause. o Write a WHERE clause to accommodate different datatypes. o Use comparison operators with the WHERE clause. o Identify the different categories more...

Oracle9i SQL Curriculum

The Introduction to Oracle9i: SQL Curriculum includes the following courses: Oracle9i SQL: Basic SELECT Statements Oracle9i SQL: Data Retrieval Techniques Oracle9i SQL: DML and DDL To review individual course descriptions, please return to the previous page and select the desired title(s). more...

Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum

...ulum includes the following courses: Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer: Forms Fundamentals(ID#470) Oracle Developer: Enhancing the User more...

Oracle PL SQL Database Programming

...g (CBT) courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course 61113) and Oracle PL/SQL: Procedures, Functions and Packages (course 61114). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developing Program Units Duration: 1 - 2 Hour(s) Select the more...

Oracle PL SQL Procedures Functions Packages

...ng (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Subprograms: Procedures Duration: 2 - 3 Hour(s) Match the various sections of a subprogram with their contents. Identify the components of developing environments. Identify the more...

Oracle Designer 6i Curriculum

The Complete Oracle Designer 6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements Oracle SQL: Data Retrieval Techniques Oracle SQL: DML & DDL Oracle SQL: PL/SQL: Basics Oracle Designer 6i First Class: Analysis Oracle Designer 6i First Class: Design & Generation To review individual course descriptions, please return to the previous page and select the more...

OCDBA8i Curriculum

...ulum includes the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an Instance(ID#7476) Oracle 8i more...

Oracle8i Database Admin Manage Security

...icipants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the more...

Oracle8i Database Admin Manage Data Storage

...icipants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i Database Administration: Manage more...

Oracle8i Database Admin Manage Storage Structures

Oracle8i Database Admin Create Databases

...icipants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam more...

Oracle8i Database Admin Manage an Instance

...icipants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course more...

Oracle Reports R6 Control Reports

... to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first two parts in this series: Oracle more...

Oracle Reports R6 Enhance Reports

Oracle Reports R6 Report Fundamentals

... to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Developer more...

Oracle Form Builder R6 Including Reusable Oracle Components

...ge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first five parts of the Oracle Developer series: more...

Oracle Form Builder R6 Controlling the User Interface Programmatically

Oracle Form Builder R6 Project Builder and Menu Modules

Oracle Form Builder R6 Writing and Debugging Code

Oracle Form Builder R6 Enhancing the User Interface

Oracle Form Builder R6 Forms Fundamentals

...ge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Developer: more...

Oracle8 Certified Database Administrator Curriculum

...lum consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data Storage Structures more...

Oracle Cert App Developer Track for Developer 2000 R2 Curriculum

... 2 consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form Builder: Enhancing the more...

Oracle SQL Specifics Retrieving and Formatting Data

...S). Users will learn how SQL functions can be used in SQL SELECT statements to extract data from the database and how SET operators can be used to combine multiple queries into a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between more...

Oracle SQL and SQL Plus Advanced SELECT Statements

...*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write single-row subqueries. Write multiple-row and multiple-column subqueries. Write correlated subqueries. more...

Oracle SQL and SQL Plus SQL Plus and Reporting

...een taken, course 60121 Oracle SQL and SQL*Plus: Advanced Select Statements. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: SQL*Plus Duration: 3 Hour(s) Differentiate between SQL and SQL*Plus. Match the SQL*Plus command categories with sample tasks. Write the code to display the column definitions of a given table. Complete the SELECT statement that prompts more...

SQL Server 7 0 - Implementing a Database - Part 4

... Select the ways aggregate functions handle null values. Select statements to use with the GROUP BY clause on columns. Select statements to use with the GROUP BY clause on expressions. Select when to use the HAVING clause. Perform the steps to summarize group values. Perform the steps to summarize combinations of groups. Select the characteristics of the GROUPING function. Select more...

SQL and PL SQL PL SQL Basics

...ng (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112) and Oracle 8i. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: PL/SQL: An Introduction Duration: 0.5 - 2 Hour(s) Identify the features of PL/SQL. Identify the benefits of PL/SQL. Select the actions by which a PL/SQL engine more...

SQL and PL SQL Basic SELECT

...L Duration: 1 - 2 Hour(s) List capabilities of SQL SELECT statements. Identify the mandatory elements of a SELECT statement. Identify methods for executing SELECT statements. Write a SELECT statement that displays all columns and rows of a table. Write a SELECT statement that displays specific columns from a table. Identify precedence in evaluating an arithmetic expression within a more...

SQL and PL SQL Data Retrieval Techniques

...ve taken the first part of this series, Oracle SQL: Basic SELECT Statements (61110). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2. T otal more...

SQL and PL SQL DML and DDL

...n the first two courses in this series, Oracle SQL: Basic SELECT Statements (course 61110) and Oracle SQL: Data Retrieval Techniques (61111). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and more...

Oracle SQL for End Users--Part 1

...designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the Oracle product set. In this course, the learner creates basic SQL SELECT statements and customizes these queries to restrict and sort the results. In more...

From The Virtual Training Company

Oracle Introduction to Oracle SQL and PL SQL

Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and more...