Price: $397.00  ISBN #: Format: CD Courseware

If you want to develop hands-on experience as a SQL Server 2008 developer or prepare for the 70-433 exam, this course is for you! Our SQL Server 2008 Database Development Training teaches you T-SQL, .NET/CLR development, data partitioning, advanced query techniques and much more.

A database can utilize many different elements and is no longer used to simply store data. With that in mind, this course is designed to teach you how to design databases, design applications and build the functionality that best supports your end users and ultimately supports a business as a whole.

Database development is one of the few jobs that seems to always be in demand. Follow along with the many real world examples in this course to develop your own databases and applications and lay the foundation towards becoming a database developer.

Video 1: Introduction
Learn about your instructor and find out what is included the course.

Video 2: Designing and Developing a SQL Server 2008 Database Application
Learn the basics of what application development is and you will get your first look at the scenario we will be using throughout the course.

Video 3: Transact-Structured Query Language (T-SQL)
Learn how and when to properly use the basic statements and clauses you will encounter when constructing your database.

Video 4: Constraints and Triggers
Learn about data integrity and how constraints and triggers enforce data integrity.

Video 5: User Defined Functions (UDFs)
Discover how to create User Defined Functions and you will discover the rules that are associated with UDFs.

Video 6: Advanced Query Techniques
Go beyond the basics of query techniques. You will see how to use common table expressions, ranking and built-in functions, and we will work hands-on with examples of how and when
to use these expressions and functions.

Video 7: Stored Procedures
Work hands on to create simple and more complicated Stored Procedures. Plus, we will take a detailed look at how to view and modify stored procedures.

Video 8 Handling Errors:
It is inevitable that you will encounter certian types of errors in your SQL Server. In this video, you'll discover the different types of errors, how to properly use an error
handler, and you will work hands on to create transactions.

Video 9 .NET/CLR Development
Discover the differences between CLR and T-SQL. Plus, you will create, load and run your own .NET application in SQL Server.

Video 10: Data Partitioning
Learn how to create your own partitioned database tables and indexes, and you will learn how to verify data distribution.

Video 11: Application Performance
Discover how to properly utilize the Database Engine Tuning Advisor (DTA) to analyze queries, how to use trace output for analysis, and you will see how to use two different
statements to view query performance.

Video 12: Working with XML Data
Learn how to retrieve SQL Server relational data as XML. Plus, you will learn how to "Shred" and Store XML in your SQL Server.

Video 13: Database Mail
Learn the steps you will need to take to create a SMTP server, create Database Mail profiles, and create Database Mail accounts.

Video 14: Full-Text Search
Create your own Full-Text Catalog and Full-Text Index. Plus, you will learn how to use these objects to perform Full-Text Queries.

Video 15: PowerShell in SQL Server 2008
Learn several of the key aspects of PowerShell that you should be able to take advantage of as a SQL Server 2008 Developer.

Video 16: Service Broker
Discover how to utilize Service Broker to send messages between SQL Server boxes, which will allow you to trigger functionality on other servers.

Video 17: Introduction to Integration Services
Learn how to use SQL Server Integration Services to perform simple transformations in SQL Server.

Video 18: Introduction to Reporting Services
Learn how to access the Reporting Services Configuration Manager. Plus, you will work to create your own simple reports under SQL Server Reporting Services (SSRS) using both
Report Builder and Report Designer.

Video 19: Certification 101
The path to certification will be clear once you watch this SQL Server 2008 certification road map.

19 videos will be provided in high-quality .AVI and .WMV format. In other words, you get perfect quality and replication of your instructors' screens. An easy-to-use table of
contents allows you to navigate to key areas you wish to focus on.

19 iPod video files to watch Train Signal on the go! A popular request amongst our students who wish to study while they commute (i.e. train, plane, bus). These 320x240 M4V files are compressed versions of the original course, and play on any iPod that supports video. Also great for reviewing and refreshing your mind "on the job."

19 MP3 audio files to listen to Train Signal anytime, anywhere. Some of our students have requested this option. Now, you can listen in the car or while working out. Our MP3 files can be burnt to a CD or copied to a portable device.

Instructor Notes – These PDF documents, which can be printed out, contain the slides used by the instructors throughout the videos. These documents allow the user a quick easy reference to the instructors’ notes on the slides, and provides a place to make additional notes.

Plus, you'll receive a FREE full version of Transcender’s SQL Server 2008 Database Development Practice Exam -- a $99 value!