This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server. Who Should Attend:
IT Professionals who will be writing queries for use with Microsoft SQL Server. Non-technical “power users” will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio. At Course Completion:
Students will be able to write queries for use with Microsoft SQL Server. |
| |
| Outline: | |
| Lesson 1: Quick Intro to SQL Query Basics |
Establish baseline knowledge required elsewhere in course
Elements of the SELECT statement
Optional clauses
Working with NULL values
Working with Dates | |
| Lesson 2: Working with Views |
Nature and purpose of views
Creating and modifying view
Limitations and cautions |
| Lesson 3: Advanced SQL Query Tactics |
Scalar and vector aggregations
Everything you need to know about JOINS
UNION queries
GROUP BY queries
Sub-queries |
| Lesson 4: Data Manipulation Statements |
Insert statements
Update statements
Delete statements
Manipulation through views and over JOINs |
| Lesson 5: Working with Procedures |
Nature and purpose of stored procedures and functions
Calling stored procedures for effect
Passing input parameters to stored procedures
Calling procedures that return data
Calling built-in functions
Calling user-defined functions | |
| Lesson 6: Task-Oriented Queries |
Finding unmatched or missing records
Finding duplicates
Calculating running sums
Changing a primary key |
Add to favorites
Email this page
On-Site Training
Seminar
