|
Provided by: 123-CBT Computer Based Training Database Technologies Introduction to SQL |
 |
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).
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.
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
|
|
||||||||||
Database Technologies Introduction to SQL
--
About The Training Provider: 123-CBT Computer Based Training
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
-...
