In this 5-day instructor-led course participants will establish a solid foundational understanding of database concepts and terminology. Then master the use of various Microsoft tools to submit queries to quickly and efficiently get the results needed. 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. Finally, students will learn to harness the power of using T-SQL statements inside common database objects like Views, Stored Procedures and User-Defined Functions. Class lectures highlight and explain Transact-SQL concepts which are reinforced with extensive follow-along demonstrations and hands-on labs. Note: before attending this course, students should have familiarity with programming and developing software using any language.
Target Audience
This course is intended for SQL Server Developers, Database Administrators, and System Engineers who are responsible for writing T-SQL queries for an application.
What You'll Learn
- Describe the objects that make up a database, data relationships within the database and how databases guarantee uniqueness of defined objects
- Understand different sublanguages of SQL
- Use the SQL Server Management Studio
- Write a simple SELECT statement, returning all the columns and rows
- Formulate and write a meaningful join strategy to bring together all necessary data
- Utilize a subquery to reshape data before using it in a query
- Write a WHERE clause to filter the rows
- Control the display of data
- Write Transact-SQL queries and aggregated values
- Define the attributes of a database transaction and generate a result set
- Create a database view and in-line table value functions and execute simple scalar/multi-statement user-defined functions
- Write procedural logic for Stored Procedures and User-defined Functions
- Course Number SQL250
- 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
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
Transact-SQL for Developers (SQL250)
,
Register for course: SQL250
"*" indicates required fields