Training : FUJITSU United States

> Training > Course Details

Name: SQL Workshop
Course Code: RS003
Duration: 2

Scheduled Dates for RS003

The SQL Workshop is a practical, two-day, classroom seminar for database users and developers, covering all of the essential elements of the standard Structured Query Language (SQL). Students learn to query, maintain, and define tables in a relational database through a carefully balanced combination of lectures, demonstrations, and hands-on exercises. Two levels of exercises are provided, one to instruct the novice user, and the other to challenge those with more experience. All class exercises are executed on an actual SQL database system.

Target Audience
This course is designed for both database users and developers. Individuals using Rapid Application Development (RAD) tools and spreadsheets linked to corporate data will also benefit from this course.

Key Topics

Single table queries

Selecting columns

Ordering columns

Formulating basic comparisons

Selecting rows

Sorting rows

Eliminating duplicate rows

Specifying advanced comparisons

Using arithmetic expressions

Applying statistical functions

Creating column aliases

Modifying tables

Objectives

Formulate and execute queries against a relational database

Determine the column and row sequence of query results

Specify alternate names for selected columns in a query

Combine the rows and/or columns of two or more tables

Produce calculated information via expressions and statistical functions

Insert, update, and delete information in a multi-user environment

Define new tables with primary key, foreign key, and other constraints

Add indices to improve query performance

Create views to make complex queries easier to write and to maintain

Gain important insights regarding SQL's history, purpose, and limitations, enabling them to properly apply this technology in situations where it is appropriate

Required Skills/Experience