Course Outline
Introduction
Installing and Configuring Microsoft SQL Server
Overview of Microsoft SQL Server Features
Overview of Transact-SQL Concepts
Querying a Database using SELECT
Filtering the Data with WHERE
Sorting the Data with ORDER BY
Querying Multiple Tables with Joins
Grouping Data with GROUP BY
Using Aggregate Functions to Perform Calculations on Resulting Data
Filtering Groups with HAVING
Creating a New Database
Understanding the Database Model
Optimizing the Database through Normalization
Enhancing your Queries with Procedures
Writing Functions and Sub-routines
Using Conditions to Control the Flow
Connecting to Microsoft SQL Server through Excel
Troubleshooting
Summary and Conclusion
Requirements
- NO previous SQL or database experience is required.
Testimonials (2)
The training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.
