Training Course:Introduction to SQLSchool/Trainer:Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.
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).
Who Should Attend : Database Designers, Application Developers, Database Administrators, End Users
...''
Please go to the school's official website for training price and schedule:
http://www.sybase.com
Phone:1-800-8-SYBASE (800-879-2273)
School Address:
14800 Quorum
Suite 505
Dallas, Texas 75240
United States
8755 West Higgins Road
Suite 1100
Chicago, IL 60631
The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036
Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland
561 Virginia Rd.
Concord, MA 01742
(978) 287-1500
3820 Mansell Road
Suite 100
Alpharetta , GA 30022
19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612
Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Other training courses offered by Sybase, Inc.:
Implementing EDI Solutions: X12 for Healthcare Mapping
Implementing EDI Solutions: HIPAA Accelerator
Implementing EDI Solutions: EC Gateway Server Managing EDI Message Delivery
Migrating Impact to e-Biz Impact 5.3
Afaria 5.1 System Administration
Afaria Advanced Functionality
RemoteWare System Administration
Upgrading to RemoteWare® 4.x from RemoteWare® 3.x
RemoteWare Advanced Functionality
Advanced Client/Server Development Techniques using PowerBuilder 10
Quick-Start for ASE Administrators of SAP/BusinessOne
Adaptive Server Anywhere 8.0 Fundamentals
High Availability: Adaptive Server Enterprise 12.0 Companion Server
Fast Track to Dynamic Archiving
Powering Up with Adaptive Server Enterprise 12.5
Powering Up with ASE 12.5.2
Managing and Tuning tempdb
Using Abstract Query Plans
Dynamic Reconfiguration for Managing Memory Nonstop Optimal Performance
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:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent. |
|
|
