Home > Computer > Databases and SQL > Serebra Learning Corporation > SQL Queries
Provided by: Serebra Learning Corporation

SQL Queries

SQL

 Serebra Learning Corporation
Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
study at homeThis course may be available for home-study
web-based,online cbt,cdweb-based,online cbt,cd
Duration:5 hours
Training Presented in:English
Training Provided by Serebra Learning Corporation
Click here for more information or to take this course
  • C asked: What is the cost of the SQL Queries course?
  • C asked: I would like to know the cost of your SQL Queries online class? Thanks,
  • U asked: how to delete duplicate rows how to relate exel sheet to SQL queries
  • E asked: how do we schedule web based training (is it done with a class/group or individualy?) thx Eric
  • C asked: pricing
  • asked: Pricing
  • K asked: Looking for information on SQL training.
  • H asked: sql-training center
  • S asked: I have one table named as "table" and inside table, i have columns with data then i have one more table named as "table", in the table of column, i want to merge all data from four columns from table and manage it inside one column of "table"
  • R asked: Please send me information you have about on-line or at home courses.
  • F asked: I am working for a company that is looking to offer a SQL Query CBT online for about of their employees. How do you price for something like that?
SQL Queries
SQL Queries
Course Code FC490

Outline

  1. Contents
  2. Description
  3. Audience
  4. Prerequisites
  5. Topics Include
  6. Duration
  7. Minimum Requirements
  8. Media

Description

Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.

Audience

End users, programmers, DBAs, analysts and systems designers

Prerequisites

An understanding of database structures and principles.

Topics Include

Relational Concepts

  • Relational Databases
  • Rows and Columns
  • Relationship: SQL to Relational Databases
  • What SQL Can Do

Simple SQL Queries

  • All Columns from a Single Table
  • Specific Columns from a Single Table
  • Reporting Selected Columns in a Specified Order

Selecting Rows

  • Comparison Operators
  • The LIKE Operator
  • Logical Operators AND, OR
  • Inclusion Operators IN and BETWEEN
  • Single Character and String Wildcards

Functions and Grouping

  • The GROUP BY Clause
  • The HAVING Clause
  • Aggregate Functions: MIN, MAX, SUM, AVG, CNT, CNT (DISTINCT)

Joining/Merging Tables

  • Join Columns from more than One Table
  • Nested Queries (sub-queries)
  • Merge Data from more than One Column based on a Common Column

Duration

5 hrs

Minimum Requirements

VGA Color Monitor; 640K RAM; 3.3MB Hard Disk Space; DOS 3.3 or Higher

Media

Diskette
CDROM
Web Based Training

© Copyright Serebra Learning Corp., 2002

About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Click here for more information or to take this course
Home > Computer > Databases and SQL > Serebra Learning Corporation > SQL Queries
Advertise With Us
Want to market your column training?
Custom Search
tcw11-v473M-08/30/11-22:02:26-()[B]-[B]-[B] -04:03:28