SharePoint
Introduction to Microsoft T-SQL
Writing SQL Queries
In this 3-day workshop you will understand how to write SQL Server 2005 queries efficiently and accurately. You will learn how to write queries using build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages to build database objects. This class includes many hands-on exercises to internalize the concepts.
SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. The final two modules are important for developers to go beyond simply writing queries as they will require stored procedures at some point.
Who Should Attend
The workshop material is aimed for those who require a knowledge in writing queries against an SQL Server relational database.
Workshop Objectives
- Understand basic database design principles and how to implement them in SQL Server.
- How to create complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less?
- What the different data types are and how to handle the common problems you run into with various types of data?
- How to take advantage of powerful backend database features like views, scripts, stored procedures, and triggers?
- Understand the differences between view, stored procedures, triggers, and user-defined functions.Utilize SQL Server transactions to insure data integrity.
- The basics of database design and implementation using SQL DDL statements or the new Management Studio.
