This course is a soup-to-nuts course that will teach you everything you need to configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure solution. You'll learn how to automate daily, weekly, and hourly tasks (like backups), the details of security, SQL Server clustering, replication, disaster recovery, and using jobs and database maintenance tasks. This course features more than 250 videos organized in ten chapters and totals more than 45 hours of instructor-led training for SQL Server 2008.

Our SQL Server 2008 Integration Services is a comprehensive A-Z course that covers exactly what you want in an SSIS course: data flow, data flow, and more data flow. You will learn about transformations, common design patterns used in SSIS, how to manage task execution with precedence constraints and much more. Also covered are best practices, performance tuning, security, package management and many real world situations that almost all SSIS developers must be able to handle. This course features 210 videos in nine chapters and totals more than 42 hours of instructor-led training for SSIS 2008.

This course is a comprehensive query writing course for Microsoft SQL Server versions 2005, 2008, and 2008 R2. If you struggle with knowing the difference between an INNER and an OUTER JOIN, when to use a LEFT vs. a RIGHT JOIN, and things like the 'how and why' of subqueries then this is an ideal course for you. This is not a beginners course: this course is for someone with at least a basic understanding of the SELECT statement. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the .sql files containing both the problems and the solutions). NOTE: This course is being released as it is finished. All together it will have seven chapters with the first four chapters being released in February, 2010 and the final four chapters released throughout February, 2010.

This course is an online SQL Server programming course for Microsoft SQL Server versions 2008 and 2008 R2. This course features comprehensive coverage of nearly all things SQL programming related including stored procedures, data types, variables, triggers, views, and functions. We also cover hot topics like object-relational modeling (ORM), common database design issues, and working with .NET and the CLR. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the .sql files containing both the problems and the solutions). NOTE: This course is being released as it is finished. The first chapters being released in April/May, 2010 and the final chapters released throughout May/June, 2010.

This course is a comprehensive course for Microsoft SQL Server 2008 Reporting Services. This course features coverage of the two main sides of Reporting Services: Creating reports and Administering a Reporting Services installation. Coverage includes extensive content for working with SQL Server 2008's Report Builder 2.0 as well as how to create everything from simple reports to complex reports. We also cover administrative topics like installation, security, and backup and recovery. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the .sql files containing both the problems and the solutions). NOTE: This course is in ACTIVE development and chapters are being released as they are finished. The first chapters being released in March, 2010 and the final chapters released throughout April, 2010.

This course is an introductory course for Microsoft SQL Server Analysis Services for versions 2008 and 2008 R2. This course features coverage of the basics of business intelligence in the Microsoft world, understanding data warehousing, creating and populating Analysis Services cubes using SQL Server Integration Services (SSIS), and more. We cover the basics of writing MDX statements, doing backup and recovery for SSAS, and database management as well. You will also explore various cube browsers and techniques for wiring applications to your SSAS databases. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the files containing both the problems and the solutions). NOTE: This course is being released as it is finished. The first chapters being released in April, 2010 and the final chapters released throughout April and May, 2010.

This course is a soup-to-nuts course that will teach you everything you need to configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure solution. You'll learn how to automate daily, weekly, and hourly tasks (like backups), the details of security, SQL Server clustering, replication, disaster recovery, and using jobs and database maintenance tasks. This course features more than 150 videos organized in 13 chapters and totals more than 30 hours of instructor-led training for SQL Server 2005.

Our SQL Server 2005 Integration Services (SSIS) training course is one of our most popular courses. Master trainer Scott Whigham takes you through the steps you need to migrate data to and fro. You'll learn package management, creation, configuration, security, debugging and much more! This course features more than 160 videos organized in nine chapters and totals more than 31 hours of instructor-led training for SSIS 2005.

Learn SQL Server 2005 Reporting Services (SSRS) online with this training course from master trainer Scott Whigham. This course will teach you how to create your own reports (charts, graphs and more) as well as help you master Reporting Services administration, installation, configuration, and security. This course features nearly 100 videos organized in eight chapters and totals more than 17 hours of instructor-led training for SQL Reporting Services 2005.

This course is a comprehensive course for Microsoft SQL Server 2008 Reporting Services. This course features coverage of the two main sides of Reporting Services: Creating reports and Administering a Reporting Services installation. Coverage includes extensive content for working with SQL Server 2008's Report Builder 2.0 as well as how to create everything from simple reports to complex reports. We also cover administrative topics like installation, security, and backup and recovery. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the .sql files containing both the problems and the solutions). NOTE: This course is in ACTIVE development and chapters are being released as they are finished. The first chapters being released in March, 2010 and the final chapters released throughout April, 2010.

This course is an online SQL Server programming course for Microsoft SQL Server versions 2008 and 2008 R2. This course features comprehensive coverage of nearly all things SQL programming related including stored procedures, data types, variables, triggers, views, and functions. We also cover hot topics like object-relational modeling (ORM), common database design issues, and working with .NET and the CLR. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the .sql files containing both the problems and the solutions). NOTE: This course is being released as it is finished. The first chapters being released in April/May, 2010 and the final chapters released throughout May/June, 2010.

This course is a comprehensive query writing course for Microsoft SQL Server versions 2005, 2008, and 2008 R2. If you struggle with knowing the difference between an INNER and an OUTER JOIN, when to use a LEFT vs. a RIGHT JOIN, and things like the 'how and why' of subqueries then this is an ideal course for you. This is not a beginners course: this course is for someone with at least a basic understanding of the SELECT statement. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the .sql files containing both the problems and the solutions). NOTE: This course is being released as it is finished. All together it will have seven chapters with the first four chapters being released in February, 2010 and the final four chapters released throughout February, 2010.

This course is an introductory course for Microsoft SQL Server Analysis Services for versions 2008 and 2008 R2. This course features coverage of the basics of business intelligence in the Microsoft world, understanding data warehousing, creating and populating Analysis Services cubes using SQL Server Integration Services (SSIS), and more. We cover the basics of writing MDX statements, doing backup and recovery for SSAS, and database management as well. You will also explore various cube browsers and techniques for wiring applications to your SSAS databases. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the files containing both the problems and the solutions). NOTE: This course is being released as it is finished. The first chapters being released in April, 2010 and the final chapters released throughout April and May, 2010.

Our online SQL Server programming course features more than 30 hours of SQL Server 2005 and SQL Server 2000 query writing, stored procedure training, and more. You'll learn the ins and outs of SQL data types, how to use and write your own functions, writing joins and subqueries, how to write triggers and stored procedures and much, much more. This course features nearly 190 videos organized in 17 chapters and totals more than 37 hours of instructor-led training for writing queries and programming for SQL Server 2000 and 2005.

This course is a soup-to-nuts course that will teach you how to choose your edition, install, configure and manage any edition of SQL Server 2000. You'll learn the details of security, backup and recovery, replication, disaster recovery, and server automation using jobs and database maintenance tasks. Also included are overviews of using Integration Services and much more!

This course offers complete coverage of SQL Server 2000's DTS. Whether you are a complete beginner to DTS or an experienced DBA looking to sharpen your data transformation skills, this course can help. Also included are overviews of migrating to SQL Server 2005/2008 Integration Services!

Our online SQL Server programming course features more than 30 hours of SQL Server 2005 and SQL Server 2000 query writing, stored procedure training, and more. You'll learn the ins and outs of SQL data types, how to use and write your own functions, writing joins and subqueries, how to write triggers and stored procedures and much, much more. This course features nearly 190 videos organized in 17 chapters and totals more than 37 hours of instructor-led training for writing queries and programming for SQL Server 2000 and 2005.