This course shows you how to manipulate data returned from a query using calculated fields and functions.

Audience :

This series is for anyone who wants to use Structured Query Language (SQL) in a Windows Environment.

Time :

Objectives :

• Concatenate fields in your queries
• Perform mathematical calculations in your queries
• Use text and numeric functions in your queries
• Use date and time functions in your queries

Features :

• Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
• Activities allow learners to apply course concepts in an interactive questioning environment.
• Exercises allow learners to practice in the actual application being studied.
• Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, in a dictionary, or in MindLeaders Reference Library (for subscribers). n addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks a learner's progress in a course.

Prerequisites :

• None