sql server t-sql with advanced topics

global knowledge canada
calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg, canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' in this course, you’ll start by learning about the basic features available in sql server, including how to design anda database and how to build queries using transact-sql, the language of sql server. then, you’ll learn to build effective views, stored procedures, triggers, and user-defined functions using transact-sql. explore the new enhancements to the transact-sql programming language, including improved support for error handling and hierarchical queries and how programmers can now use .net languages like c# and visual basic to build database objects. you will also examine enhancements made to sql server for handling complex data structures, using partitioning, and working with xml.

what you’ll learn


basic database design principles and how to implement them in sql server
fundamentals of writing transact-sql queries that retrieve or modify data
differences between view, stored procedures, triggers, and user-defined functions
use the new commonexpressions for creating hierarchical queries
perform calculations with visual basic and visual c# code rather than t-sql
discover partitioning with sql server
examine new ranking functions, commonexpressions, and learn techniques for dealing with complex queries
explore advanced techniques for working with complex data
discover new xml capabilities in sql server 2005
course outline


1. a tour of sql server 2005
sql server 2005 editions, components, and tools
using sql server management studio (ssms)
working with tables and queries
new transact-sql features
business intelligence services
2. designing and creating a database
relational database design principles
implementing the design
3. data selection queries
understanding transact-sql
the select statement
the where clause
using order by to sort data
the group by clause
joining tables
4. modifying data
inserting data
updating data
deleting data
understanding transaction isolation
5. working with sql server management studio
getting started with ssms
exploring the object explorer
working with the query editor
using sql server books online
6. transact-sql programming
overview of transact-sql
using built-in functions
controlling flow
ranking results
7. transactions and error handling
transaction concepts
applications and transactions
creating explicit transactions
using try/catch error handling
8. creating views
what is a view?
creating views
updating data using a view
using computed columns
indexed views
partitioned views
9. creating stored procedures and triggers
creating stored procedures
creating triggers
10. creating user-defined functions
user-defined function overview
scalar functions
inline table-valued functions
multi-statement table-valued functions
using functions, views, and stored procedures
11. using .net code in sql server 2005
introduction
writing sqlclr code
sqlclr code modules
managing code modules
sqlclr security
t-sql vs. .net code
12. advanced query techniques
full-text search
generating xml with for xml
using apply
creating recursive queries
creating pivot queries
executing dynamic sql
13. implementing sql server partitions
overview of table-based partitioning
creating partitioned tables
querying partitions
managing partitions
14. complex querying
working with null values
ranking grouped data
writing correlated subqueries
using commonexpressions
15. advanced techniques
complex data and structures
writing more efficient queries
working with complex queries
maintaining query files
16. working with xml
the xml data type
xml schema collections
querying xml
best practices
labs


lab - course topic 2: designing and creating a database
lab - course topic 3: data selection queries
lab - course topic 4: modifying data
lab - course topic 5: working with sql server management studio
lab - course topic 6: transact-sql programming
lab - course topic 7: transactions and error handling
lab - course topic 8: creating views
lab - course topic 9: creating stored procedures and triggers
lab - course topic 10: creating user-defined functions
lab - course topic 11: using .net code in sql server 2005
lab - course topic 12: advanced query techniques
lab - course topic 13: implementing sql server partitions
lab - course topic 14: complex querying
lab - course topic 15: advanced techniques
lab - course topic 16: working with xml ...''

Elements of this syllabus are subject to change.

Phone:1-800-courses

School Address:

global knowledge - canada
535 legget drive
suite 200
kanata, on k2k 3b8 canada



Jobs & Resumes: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Houses & Roommates: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Travel Agencies: calgary, montreal, ottawa, toronto, vancouver, winnipeg

Search other schools for sql server t-sql with advanced topics training resources.

microsoft sql server 2008 reporting services
SQL Server 2008
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
microsoft sql server 2005 reporting services
Database Administrator
SQL Server 2005 Administration
sql server 2005 for business intelligence
SQL Server 2005 for Developers
sql server 2005 for reporting services
Check Point NGX CCSA/CCSE
CISA Prep
CISSP Prep
Essentials of Information Security
voip security
certified ethical hacker
Foundstone Ultimate Hacking
Foundstone Ultimate Hacking: Expert

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.