Querying and Processing SQL Server Data with SQL Statements
Course ID:ATL-2778
Duration: 2 Days
Contact Intertech To Schedule
Description
This two-day, hands-on course covers everything database administrators and developers need to know to query SQL Server databases using SELECT statements ranging from simple to complex, and use INSERT, UPDATE and DELETE statements to modify and maintain data. Creating and using of VIEWS is also covered, along with accessing data through stored procedures and user-defined functions.
Audience
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
Learn More
Course Outline
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)
