Microsoft SQL Server: Querying Data for Report Developers
Duration: 3 Days
This 3 day course is intended for students who need to familiarize themselves with the various querying techniques available to retrieve data from a Microsoft SQL Server database in a report authoring environment, whether that be through an implementation of Microsoft SQL Server Reporting Services or similar reporting tool. No previous knowledge of the SQL language is assumed as the course is designed from the ground up, starting with basic queries and advancing to more complex querying concepts. The course also examines good query design and best practices by taking a look at how queries are processed by the Microsoft SQL Server database engine, and the implementation of programming objects such as Stored Procedures and User Defined Functions. On completion of the course students will be fully conversant with the SQL language and able to right effective queries for reporting purposes.
Topics Covered In This Course
Introduction to SQL Server Management Studio
Introduction to SQL and Transact-SQL (T-SQL)
Using the SELECT Statement to Retrieve Data
Retrieving Specific Rows of Data Using the WHERE Clause
Formatting and Sorting Result Sets
Querying Data from Multiple Tables by Using Joins
Summarizing Data Using Aggregate Functions
Ranking Grouped Data
Combining and Limiting Result Sets
Working with Subqueries
Performance Considerations for Writing Queries
Working with SQL Server Date and Time Data
Implementing Stored Procedures
Implementing User Defined Functions
What You Can Expect
Upon successful completion of this course, students will be able to:
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]