In this 5-day instructor-led course participants will master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. Students will learn the various techniques for combining data, filtering the results and how to control and format the statement output. Students will also gain a foundation understanding of a SQL Server database and use the tools available to discover the database definition, submit queries and view results. We teach students how to write a query the same way that SQL Server processes a SQL statement – following a step-by-step process for creating SQL queries from business requirements. This approach uses the natural way of breaking down a problem into logical steps. Each step can be validated before moving to the next step. This differs from most courses, which present SQL as a set of features. Class lectures highlight and explain Transact-SQL concepts which are reinforced with extensive follow-along demonstrations and hands-on labs.
Target Audience
This course is intended for Business Analysts, System Administrators, Database Administrators and other professionals with no programming or SQL experience. This course is valuable for anyone who needs to learn how to write a SELECT statement to access SQL Server databases.
What You'll Learn
- Use the SQL Server Management Studio tool to browse the definition of the database, find necessary object names, create database diagrams and execute a SQL query to return data rows
- Write a simple SELECT statement, returning all the columns and rows and formulate meaningful join strategy to bring together all necessary data
- Write a WHERE clause to filter the rows based on equality, a list of values, a range of values and a wildcard character condition
- Understand the impact on filtering based on implicit data conversions using data type precedence and how to create a proper search argument
- Control the display of data in a SQL SELECT including renaming columns, using simple expressions with function to change output values, conditionally change the output values using CASE expressions, sort the result set, eliminate duplicate rows and control the number of rows returned
- Write Transact-SQL queries that aggregate values across rows based a group and filter the result set based on aggregated values
- Course Number SQL101
- Course Length 5 days
- Course Fee $2,775.00
- Delivery Format vILT (Instructor Led; Virtual LIVE Online; Remote Training)
- Course Topic Business Analysis, Process and Requirements
- Vendor Microsoft
- Technology SQL Server
Need a different date? This course is also offered on these dates
| Date | Course ID | Course Name | Duration | Delivery Format | Registration | |
|---|---|---|---|---|---|---|
| 05/13/2024 | SQL101 | Introduction to Transact-SQL (SQL101) | 4 days | vILT | Register | |
| 06/24/2024 | SQL101 | Introduction to Transact-SQL (SQL101) | 5 days | vILT | Register |
About the instructorPeter Avila
Microsoft Certified TrainerPeter is a consultant specializing in the design and development of database systems using SQL Server and .Net technologies. Peter has operated a nation-wide consulting business since 1991. He was a course designer and instructor of database and software development technologies at Harvard University; UC Berkeley, and the Worcester Polytechnic Institute, and he is author of “An Intuitive Approach to Database Design; An Introduction to Data Modeling.”
Peter uses an intuitive approach to learning that applies the way we all learn in the real world and gives students experiences on which to draw when they’re back on the job applying their new skills. “Learning is the most fun, satisfying, and enduring when we have our own empirical experiences – our own AHA! moment when we experience a discovery. The classroom offers a great opportunity to create those moments in a fun and focused environment. It’s great when students tell me that the experience they had in the classroom is what allowed them to finally understand a topic and solve a tough problem at work.”
Training Location
Introduction to Transact-SQL (SQL101)
,
Register for course: SQL101
"*" indicates required fields