SQL

Sybase USA
Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' An excellent refresher for entry-level programmers and database administrators. Gain practical, hands-on experience writing database queries that retrieve, organize, and summarize data managed by an Adaptive Server. Learn to construct simple and complex queries using both ANSI-89 standard SQL and Transact-SQL extensions.
Course Objectives :
Upon completion of this course, you will be able to:
Describe the basic concepts surrounding a relational database
Access an Adaptive Server database using ASE client software
Write a simple query that returns data from a database
Write a qualified query that returns a specific subset of information
Use aggregates to perform mathematical analyses of data
Query data from more than one table using joins
Query data from more than one table using subqueries
Course Topics :
Relational database concepts, client/server architecture, simple queries (queries that retrieve all data from a given table), queries (queries that retrieve only data that matches a given condition), aggregates (simple functions that summarize data), joins (queries that retrieve data from multiple tables), and subqueries (queries nested inside other queries). ...''

Elements of this syllabus are subject to change.

Phone:1-800-8-SYBASE

School Address:

Manhattan Learning Center
The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Irvine Learning Center
19800 MacArthur Blvd. Suite 855
Irvine, CA 92612


Jobs & Resumes: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Houses & Roommates: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Travel Agencies: Atlanta, Chicago, Dallas,

Search other schools for SQL training resources.

ASE 15 MIGRATION FOR DEVELOPERS
ASE 15.0 Query Optimization
SYBASE IQ 15 MIGRATION
Migrating to Sybase IQ 15
POWERDESIGNER 15 MIGRATION
POWERBUILDER 11.5 MIGRATION
Moving to PowerBuilder 11.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server Enterprise
Troubleshooting Adaptive Server Data Structures
Quick-Start for ASE Administrators of SAP/BusinessOne
High Availability: Adaptive Server Enterprise 12.0 Companion Server
Performance & Tuning using MDA Tables
Open Client Programming Using Client Library
Open Server Programming
Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Implementing ASE Cluster Edition
M-Business Anywhere Fundamentals

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.