10 of 10 on the basis of 3445 Review
Login Failed

Invalid login/password combination. You may wish to or


We could not find any active order with id or e-mail mentioned. Try again

Customer Login

Order Id / E-mail

Password Reminder

Enter your E-mail or Order Id. After clicking submit button check you e-mail box for further instructions.
Order Id / E-mail
Store Home  /  Video Tutorials  /  Product Details

Product Details

Lynda.com - SQL Server 2008 Essential Training

Lynda.com - SQL Server 2008 Essential Training
See All
  • en


SQL Server 2008 Essential Training with Simon Allardice

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.

Topics include:

  • Using T-SQL (Transact-SQL)

  • Managing databases with SQL Server Management Studio

  • Understanding database normalization

  • Using SELECT statements

  • Building indexes

  • Monitoring database size and integrity

  • Backing up and restoring databases

  • Creating functions and stored procedures

  • Managing database permissions

  • Creating and formatting reports

  • Adding charts to reports

  • Creating and executing a simple SSIS package


  • Subjects: Business, Developer, Servers, Databases
  • Software: SQL Server
  • Author: Simon Allardice

System Requirements

  • Codecs and player for playing mov-files.
Featured BrandsAll
Software Categories