Lynda - SQL Server 2008 Essential Training
In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course.
Table of Contents
Introduction1. Getting Started2. Installing SQL Server 2008 R23. Tools and System Databases4. Creating Databases5. Importing Existing Data6. Retrieving Data with SQL7. Inserting and Updating Data8. SQL Functions9. Stored Procedures and Transactions10. Core Administration Tasks11. Backing Up and Restoring12. Security Features13. Reporting Services14. Integration ServicesConclusion