->
Lynda - SQL Server 2008 Essential Training - 71929
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

  • Introduction
  • 1. Getting Started
  • 2. Installing SQL Server 2008 R2
  • 3. Tools and System Databases
  • 4. Creating Databases
  • 5. Importing Existing Data
  • 6. Retrieving Data with SQL
  • 7. Inserting and Updating Data
  • 8. SQL Functions
  • 9. Stored Procedures and Transactions
  • 10. Core Administration Tasks
  • 11. Backing Up and Restoring
  • 12. Security Features
  • 13. Reporting Services
  • 14. Integration Services
  • Conclusion
  • Lynda - SQL Server 2008 Essential Training


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss