Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: 123-CBT Computer Based Training

Database Technologies Introduction to SQL

Click here for more information or to take this course 		123-CBT Computer Based Training
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by 123-CBT Computer Based Training

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 relational database. After taking this course, students will have a solid foundation in two basic aspects of SQL: Data Definition Language (DDL - creating databases and tables) and Data Manipulation Language (DML - adding, altering, and querying data).

Learn To:

o Identify what SQL is, why and where it is used.
o Identify how to retrieve data from a database.
o Identify how to order, limit, and group their query results using various SQL clauses, keywords, and operators.
o Identify how to use arithmetic operators, single row functions, and group functions to manipulate query data.
o Identify how to retrieve database information using subqueries and joins.
o Identify the guidelines for naming tables as well as the datatypes and constraints available for table creation.
o Identify how to create, alter, and delete database tables.
o Identify the data manipulation commands (INSERT, UPDATE, and DELETE) as well as the transaction control commands (COMMIT and ROLLBACK).
o Identify the general overview of views and indexes, including how to create these database elements.

Audience

Associate database administrators, technical support consultants, and associate programmer/analysts are some of the types of people who would benefit from this course. This course is intended for people who are relatively new to the world of corporate IT and databases. They will most likely either be new to the workforce or have recently been assigned new duties that require them to learn basi

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
cd romThis program may be available on CD
Contact 123-CBT Computer Based Training for more information
Training Presented in:English
Related Keywords:  database   fundamentals   microsoft   technologies   introduction   sql 

Training Program Details

--

About 123-CBT Computer Based Training - Training Provider

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6.10 - Access 2003 - Acrobat 6.0 - ASP - ASP.NET - C - Captivate 1.0 - Crystal Reports 8.5 - Crystal Reports v10 - Dreamweaver MX -...
More Database Fundamentals Training from 123-CBT Computer Based Training
Click here for more information or to take this course
Custom Search
Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links
Training-Classes.com by Skillbox® 07/19/08
Copyright 1998-2008 skillbox, inc. All rights reserved		 Connecting people who want to learn with people who love to teach
 Are you a Database training provider?
You could be on this page today - for FREE!
This page was last updated on sb5 - 07/19/08 at 07:10:28 - 03:55:37