Coding SQL Statements Seminar training classes conferences & workshops presented by Connect Learning register for training on FindaSeminar.com

Home

Add your seminars

Training Calendar Creator Seminar Venues Training Provider Directory
 

New Seminar Search:  

 

Helpful links

find similar training...
Search by state...
Customer Support


Do you need help finding the right class, date, or location or other assistance?

Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request and receive a prompt reply.

We guarantee this Connect Learning training seminar

We are an authorized partner of Connect Learning

 

Price protection. The price to attend Coding SQL Statements is set by the training providerThere is no added charge for our services.

We honor most training provider coupons
*.   Call  a representative to see if your discount coupon applies.


Privacy. Your personal information won't be shared with anyone but the training provider Connect Learning.


Security. When you register for this seminar on FindaSeminar.com your personal data and payment information is safely collected and processed using secure SSL encryption technology.

Flexibility. FindaSeminar.com offers you three ways to register for Coding SQL Statements seminar by Connect Learning.
Register online, by phone (800) 349-1935,or fax (800) 712-5569
Who should attend Coding SQL Statements
Learn with other professionals, new to SQL, to establish a foundation for the dynamic use of Dreamweaver, Flash, and Cold Fusion. You?ll need to know Windows, and keyboarding skills are a plus.
Reviews
Write and read Connect Learning reviews and reviews about the training seminar Coding SQL Statements on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Coding SQL Statements

 
Find Training Near You
Use our clickable map to find training near you
Use Our Clickmap
 
hotel seminars meeting space directory
hotel meeting space training facilities restaurant and lodging

 
 
 

request on site training details for the Coding SQL Statements seminarRequest on site training

Coding SQL Statements  

 Email information about this seminar Coding SQL Statements by Connect Learning to yourself your manager or associatesEmail this event... View and register for other training seminars like Coding SQL Statements by Connect Learning on FindaSeminar.com See similar training.. Find and register for other training seminars by Connect Learning on FindaSeminar.com Other seminars from Connect Learning

By:

training seminars by Connect Learning Connect Learning   

For:

Learn with other professionals, new to SQL, to establish a foundation for the dynamic use of Dreamweaver, Flash, and Cold Fusion. You?ll need to know Windows, and keyboarding skills are a plus.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

Slice and dice your data with SQL to get and receive information. (see full course description)

 
 
 

 Seminar / Training class dates & locations

 

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search


 

 
 

print the agenda print agenda for the Coding SQL Statements seminar

 

Training Course Syllabus:


We've designed this course to prepare participants for our database-related workshops, such as Fast Track to Macromedia Cold Fusion MX and Dreamweaver 2004: Dynamic Appllications. In this class, you'll learn the fundamental concepts behind Structured Query Language or SQL. Class exercises will teach you slice and dice your data any way you need it.

AGENDA

Unit 1: Understanding SQL
  • Database Basics
  • What is SQL
Unit 2: Retrieving Data
  • The SELECT statement
  • Retrieving individual columns
  • Retrieving multiple colums
  • Retrieving all columns
Unit 3: Sorting Retrieved Data
  • Sorting data
  • Sorting by multiple columns
  • Sorting by column position
  • Specifying Sort direction
Unit 4: Filtering Data
  • Using the WHERE clause
  • The WHERE clause operators
Unit 5: Advanced Data Filtering
  • Using the IN Operator
  • Using the NOT operator
Unit 6 Using Wildcard Filtering
  • Using the LIKE Operator
  • Tips for using Wildcards
Unit 7: Creating Calculated Fields
  • Understanding Calculated fields
  • Concatenating fields
  • Performing mathematical calculation
  • Unit 8: Using Data Manipulation Functions
    • Understanding functions
    • Using functions
    Unit 9: Summarizing Data
    • Using aggregate functions
    • Aggregates on distinct values
    • Combining aggregate functions
    Unit 10: Grouping Data
    • Understanding data grouping
    • Creating groups
    • Filtering groups
    • Grouping and sorting
    • SELECT clause ordering
    Unit 11: Working with Subqueries
    • Understanding subqueries
    • Filtering by Subquery
    • Using subqueries as calculated fields
    Unit 12: Joining Tables
    • Understanding joins
    • Creating a join
    Unit 13: Creating Advanced Joins
    • Using table aliases
    • Join types
    • Using joins with aggregate functions
    • Using joins and join conditions
    Unit 14: Combining Queries
    • Updating data
    • Deleting data
    • Guidelines for updating and deleting data
    Unit 15: Inserting Data
    • Understanding data insertion
    • Copying from one table to another
    Unit 16: Updating and Deleting Data
    • Updating data
    • Deleting data
    • Guidelines for updating and deleting data
    Unit 17: Creating and Manipulating Tables
    • Creating tables
    • Updating tables
    • Deleting tables
    • Renaming tables

    Seminar Summary:

    Slice and dice your data with SQL to get and receive information. (see full course description)

    print this agenda print agenda for the Coding SQL Statements training seminar

     view dates and locations for this seminar

     

     
     
     Connect Learning training and seminar course catalog

    Click any title to view upcoming Connect Learning training event dates and locations, class syllabus and other seminar details

     

         
     

     
         

     

      Also try the advanced seminar search tool

       FindaSeminar HomeComputer Training

    unix training
    training classes

     © 2002-2018 FindaSeminar.comô All Rights Reserved.  Terms of Use |  Privacy Policy |  Training News Network