Online Basic Sql Statements eLearning
Basic Sql Statements Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle Database 11g PL SQL Variables Attributes and Executable Statements

Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements Oracle
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
more...
Oracle Database 11g PL SQL Variables Attributes and Executable Statements
Introduction to Oracle and SQL in Oracle Database 10g

Introduction to Oracle and SQL in Oracle Database 10g Oracle
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements
more...
Running Queries Manipulating Data in SQL Server 2008

Running Queries & Manipulating Data in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
SQL Server 2008 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query
more...
Oracle Database 11g Getting Started with PL SQL

Oracle Database 11g: Getting Started with PL/SQL Oracle
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
more...
Introduction to Oracle and SQL in Oracle9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements
more...
Oracle Database 10g SQL Fundamentals I Part 1

...
Identify uses of various SQL statements.
Unit 2: Basic SQL Statements
Identify the SQL statement to retrieve data from tables.
Identify arithmetic expressions used to perform operations on data.
Identify operators used to format results in SQL statements.
Identify the use of the WHERE clause in restricting the result set of an SQL query.
Identify the uses of the
more...
Oracle Database Administration Workshop I Part 2

Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed
more...
Oracle SQL Specifics Retrieving and Formatting Data

Course Overview
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
more...
Oracle SQL and SQL Plus Advanced SELECT Statements

Course Overview
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.
L earn To:
Write
more...
Oracle SQL and SQL Plus SQL Plus and Reporting

Course Overview
This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output.
L earn To:
Identify the fundamental concepts of SQL*Plus and write queries
more...
Oracle Cert App Developer Track for Developer 2000 R2 Curriculum

NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle Certified Application Developer Track for Developer/2000 Release 2 consists of the following courses:
more...
Oracle8 Certified Database Administrator Curriculum

NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT
more...
Oracle Form Builder R6 Forms Fundamentals

Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of
more...
Oracle Form Builder R6 Enhancing the User Interface

Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to
more...
Oracle Form Builder R6 Writing and Debugging Code

Course Overview This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the
more...
Oracle Form Builder R6 Project Builder and Menu Modules

Course Overview This course is the fourth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes the features and benefits of Oracle Project Builder, how to create and deliver projects, and how to create new file types. In addition, the course describes how to create and manipulate menu modules, and how to manage menu modules. L earn To:
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically

Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:
more...
Oracle Form Builder R6 Including Reusable Oracle Components

Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to
more...
Oracle Reports R6 Report Fundamentals

Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate
more...
Oracle Reports R6 Enhance Reports

Course Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to
more...
Oracle Reports R6 Control Reports

Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and
more...
SQL and PL SQL PL SQL Basics

Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
more...
SQL and PL SQL Basic SELECT

...lational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. L earn To: Identify relational database concepts and properties. Describe database design processes by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database
more...
SQL and PL SQL Data Retrieval Techniques

...es. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a format specified by the user will be covered. L earn To: Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that contain common group functions.
more...
SQL and PL SQL DML and DDL

Course Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify
more...
Oracle8i Database Admin Create Databases

Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:
more...
Oracle8i Database Admin Manage Storage Structures

Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify
more...
Oracle8i Database Admin Manage Data Storage

Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L
more...
Oracle8i Database Admin Manage Security

Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and
more...
OCDBA8i Curriculum

The Complete OCDBA8i Curriculum 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
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...
Oracle PL SQL Procedures Functions Packages

61114 Course Overview This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create
more...
Oracle PL SQL Database Programming

Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored
more...
Oracle SQL for End Users--Part 1

...se with the information they contain. Unit 2: Writing Basic SQL Statements Duration: 1 - 2 Hour(s) Match the capabilities of SQL SELECT statements with their definitions. Match SQL statement elements with their descriptions. Write a SELECT statement that displays columns and rows from a table. Write a SQL statement that includes an arithmetic expression. Assign an alias to a
more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server

Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify
more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data

Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements.
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...
Oracle9i SQL Basic SELECT Statements

...lational 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. Learn To: o Identify the components of the relational model. o Match the
more...
Oracle9i SQL DML and DDL

The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.
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 Database Admin Manage Storage Structures

Course Overview The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo
more...
Oracle9i Database Admin Manage Data Storage

Course Overview This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. Learn To Identify the row storage method used by the various tables and the
more...
Oracle9i Database Admin Manage Security

Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To Define and maintain the five components of the security domain of a user in a given
more...
Oracle SQL PL SQL Using Procedure Builder Curriculum

The courses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum
more...
Database Technologies Introduction to SQL

The second in a two-part series, this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course, this course teaches students the essential SQL statements, and associated variations, needed to perform fundamental data access and manipulation
more...
Visual Basic NET-Web Based Development Part 3

Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security
more...
Visual Basic NET-Web Based Development Part 3

Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3

Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential
more...
Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3

Course Overview This is the third course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions. L earn To: Identify features of SQL Server and select the data integrity to implement in a given situation. Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets,
more...
Oracle8i Database Admin Manage an Instance

Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:
more...
Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum

The Complete Oracle Internet App. Dev. Track for Forms Developer R6/6i Curriculum 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:
more...
CIW Dynamic Server Pages Part 1

Course Overview This is the first course in a three part series that introduces students to PHP Hypertext Processor and provides the foundational knowledge for the course series. Additionally, this course will cover an introduction to PHP, PHP fundamentals, string manipulation and file input/output, and PHP and databases. Learn To Identify PHP. Identify the basic and
more...
CIW Database Specialist Part 3 Database Interaction JDBC

This is the third course in a four part series that teaches students about SQL, relational algebra, transactions and database security, and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins,
more...
CIW Database Specialist Part 4 Advanced JDBC

This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and
more...
From Software Training Academy, Inc
JDBC Programming Rev 5

This one-day course covers the fundamentals of database programming in Java using JDBC (Java Database connectivity) in an incremental fashion, to get the programmer up to speed quickly and then to layer a deeper understanding of JDBC upon that foundation. This course has been designed to work with any of these relational database management systems:
Apache Derby, version 10.1
MySQL, version
more...
From Serebra Learning Corporation
Visual Basic 6 0 Database Access Part I
This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing
more...
Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I
This course discusses database security implementations to aid a developer in correctly programming components that access data without compromising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course
more...
ADO NET Connections and Commands
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
XML Data Access in VB NET
To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
more...
Introduction to Oracle and SQL in Oracle 9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements 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...
Manipulating Data with DB2 UDB
To execute queries using SQL Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification
more...
Getting Started with Access 2003
The Getting Started with Access 2003 course is the first course in the Microsoft Access 2003 curriculum. The course familiarizes users with basic database concepts and the features in Access. It describes the concepts and processes involved in creation and design of databases and tables in Access 2003. In addition, this course guides users to efficiently relate, manage, and customize database
more...
IBM DB2 UDB Essentials Part 3 - SQL Fundamentals
This course introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the
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
Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is 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
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...
Oracle SQL: Data Retrieval Techniques
This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to
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...
Database Technologies Part 2: Introduction to SQL


The second in a two-part series this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course this course teaches students the essential SQL statements and associated variations needed to perform fundamental data access and manipulation on a
more...
SQL Basic Skills
This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements.
more...
