Transact-SQL Programming: SQL Server 2008/R2 T-SQL Video Training Course by LearnItFirst
Software Details
|
| Brand: LearnItFirst |
Media: DVD-ROM |
Hardware Platform: PC/Mac |
Operating System: Mac OS X, Windows XP, Vista, 7, Server 2008 |
Description
This is a full-blown SQL Server Programming training course that takes you from A to Z with how to write Transact-SQL for SQL Server 2008 and SQL Server 2008 R2. You start out learning about things like table and constraint design and quickly move on to topics like designing indexes, performance tuning, writing loops, and then on to stored procedures, triggers, and user defined functions (UDFs) in TSQL. If you are looking for a “soup to nuts” course on SQL programming, this is it. Visit http://www.learnitfirst.com to watch free sample videos and to learn more!
Chapter List (235 videos total)
1: Course Introduction and How to Get Started
2: T-SQL Fundamentals: Data Types, Conversion, IF, and Variables
3: Creating Tables and Other Permanent Objects
4: Views and User-Defined Functions
5: Indexes and Statistics: Design, Creation, and Maintenance
6: Inserting, Updating, and Deleting Data
7: Transactions and Locking
8: Working with DDL and DML Triggers
9: Stored Procedure Design: Returning Data
10: Stored Procedure Design: Performing Actions
11: Optimization and Performance Tuning Tips
12: Introduction to Working with XML Data
13: Introduction to CLR Programming
14: Introduction to Working with Geospatial Data
15: Introduction to Encryption in Transact-SQL
16: The Basics of Working with CLOBs and BLOBs
17: Misc Tips and Techniques
Contact us via http://www.learnitfirst.com for more information, multiple-user licenses, custom quotes and more!
About LearnItFirst: LearnItFirst is a leading video training company focused on providing training for IT professionals. Since 2004, we have delivered more than 150,000 hours of classroom-
quality training all delivered via our website (http://www.learnitfirst.com).
Platforms
Windows Server 2008, Windows Vista, Windows XP, Windows 7, Mac OS X
Product Features
- 17 chapters/51+ hours of high-quality video and audio
- Hands-on exercises (printable PDFs) and sample reports (.rdl files)
- View from DVDs or instantly download and view on your computer
- Comprehensive training from seasoned experts
- Learn more (and watch free sample videos) at http://www.learnitfirst.com
More Details
|
| Publisher: LearnItFirst.com L.. |
Category: Training & Tutorials |
Binding: DVD-ROM |
