After completing Sybase: Querying Databases with T-SQL
the user should be able to:
 | Create queries |
 | Use functions in queries |
 | Modify query results |
 | Order and group query results |
 | Use queries through views |
 | Combine query results |
|
Introduction to Queries
 | Creating queries |
 | Querying data using conditions |
Using Functions in Queries
 | System functions |
 | String manipulation functions |
 | Date functions |
 | Mathematical functions |
Manipulating Query Data
 | Conversion functions |
 | Summarizing data |
Ordering and Grouping Query Results
 | Ordering results |
 | Grouping results |
 | Computing results |
Combining Queries and View Queries
 | Combining query results |
 | Querying through views |
|
This course has the following features:
 | Exercises that allow users to practice in SQL Server |
 | A file containing the text of the exercises |
 | Simulations that allow users to practice course skills
even if they don't have access to Sybase SQL Server |
 | A glossary |
 | A Skill Assessment |
|