SQL Server 2008 Essential Training

6h 54m Beginner Dec 15, 2010

VIDEO QUALITY: 540*960

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