| |
|
Cloud Accelerate
Partner
|
|
|
|
|
|
Querying and Processing SQL Server Data with Transact SQL Statements
| | | | Course Number: | ALTO-2778 | | Length: | 2 Day |  | | Price: | $1,195.00 | | | |
Or Register by Phone 1-888-600-ALTO (2586) |
|
|
|
|
|
| Start Date | End Date | Location |
|---|
| 06/25/2012 | 06/26/2012 | | | 08/20/2012 | 08/21/2012 | | | 10/15/2012 | 10/16/2012 | |
|
|
|
|
| | | By the end of this course you will:
• Be familiar with the tools used to interact with SQL Server databases.
• Be comfortable with basic SELECT statement syntax and be able to write queries that extract records from a single table.
• Understand enough about the more advanced SELECT statement syntax that you can figure out what the statement is doing and where to go to learn more.
• Be able to safely make changes to records in tables, using INSERT, UPDATE and DELETE statements.
• Be able to create and alter VIEWs.
• Be able to find text patterns in data using the LIKE operator and full text searching. |
|
|
|
|
|
1. Tools and Techniques
- Motivation
- Tools
- Connection Settings
2. Basic SELECT Queries
- SELECT as Foundation
- WHERE
- ORDER BY
- Delimiters and Symbols
- Working with NULL
- Multi-Part Names
3. Expressions
- What Are Expressions
- Data Types
- Working with Character Strings
- Working with Dates
- The CASE Operator
4. JOIN and UNION
- What is a Join?
- Equi-Joins
- Primary and Foreign Keys
- Multiple Table Joins
- Left and Right Outer Joins
- Self-Joins
- UNION
- EXCEPT and INTERSECT
5. Updating
- Experimenting?Do No Damage!
- INSERT
- UPDATE
- DELETE
- Updating over JOIN
6. Aggregations
- Scaler Aggregates
- Vector Aggregates (GROUP BY and HAVING)
- COMPLETE, ROLLUP and CUBE
7. Advanced Queries
- The Singleton
- Sub-Queries with the IN Function
- The EXISTS Operator
8. Working with Views
- Nature and Purpose of Views
- Creating and Modifying Views
- Using Views
- Updating Views
9. Import Export with SSMS
- The Import Wizard
- Working with Excel
- The Export Wizard
- SQL Server Integration Services (SSIS)
|
|
|
|
| Or Register by Phone 1-888-600-ALTO (2586) |
|
|
|
|
|
|
|
|
|
|
|
| |
|