Lynda.COM SQL Server 2008 Essential Training

Author:
Simon Allardice

Duration:
06h 54m

Released on:
12/15/2010

Exercise files:
Yes

Software works on:
Windows only


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



Introduction
Welcome           01m 19s
Using the exercise files           01m 02s

1. Getting Started
SQL Server core concepts           09m 04s
SQL Server editions           03m 08s
Applications included with SQL Server           05m 46s

2. Installing SQL Server 2008 R2
Preparing for installation           03m 44s
Creating service accounts           02m 33s
Installing SQL Server           11m 42s
Post-installation checks           03m 09s
Installing sample databases           04m 53s

3. Tools and System Databases
Introduction to SQL Server Management Studio           08m 07s
Introduction to SQL Server Books Online           03m 06s
SQL Server system databases           02m 22s

4. Creating Databases
Planning your database           09m 39s
Creating a SQL Server database           04m 07s
Creating tables           07m 51s
Data types in SQL Server           12m 25s
Defining keys           08m 09s
Creating default values           04m 39s
Creating check constraints           02m 25s
Creating unique constraints           04m 34s
Introduction to relationships and foreign keys           09m 51s
Creating relationships in SQL Server Management Studio           08m 14s
Database normalization           11m 47s
Creating computed columns           03m 10s

5. Importing Existing Data
Using the SQL Server Import and Export Wizard           03m 58s
Importing Excel files into SQL Server           06m 11s
Importing CSV files into SQL Server           05m 27s
Importing Access databases into SQL Server           07m 35s

6. Retrieving Data with SQL
Introduction to Transact-SQL           03m 43s
Using SELECT statements           07m 16s
Changing the default database           02m 21s
Creating conditions in SQL           08m 10s
Sorting your output           03m 23s
Using aggregate functions           07m 12s
Finding unique values           02m 14s
Joining multiple tables together           08m 00s
Using subqueries           09m 33s
Viewing execution plans           03m 37s

7. Inserting and Updating Data
Writing INSERT statements           05m 47s
Writing UPDATE statements           04m 38s
Writing DELETE statements           02m 54s
Using the OUTPUT clause to return inserted keys and GUIDs           06m 17s

8. SQL Functions
Introduction to SQL functions           06m 26s
Using SQL configuration functions           02m 14s
Using string functions           07m 26s
Using date functions           06m 27s
Creating user-defined functions           10m 19s

9. Stored Procedures and Transactions
Introduction to stored procedures           04m 23s
Creating stored procedures           11m 23s
Introducing transactions           04m 23s
Creating transactions           08m 37s

10. Core Administration Tasks
Understanding and creating indexes           06m 32s
Monitoring and rebuilding indexes           06m 00s
Monitoring database size and integrity           04m 07s

11. Backing Up and Restoring
Creating backups           04m 21s
Creating differential backups and using backup compression           03m 40s
Restoring databases           03m 40s

12. Security Features
Introduction to SQL Server security and permissions           05m 54s
Adding a Windows user to the database           05m 07s
Creating SQL Server logins and switching authentication modes           06m 39s

13. Reporting Services
Introduction to SQL Server Reporting Services           02m 52s
Connecting to the Report Manager           04m 29s
Using Report Builder           12m 04s
Formatting values in reports           04m 17s
Adding indicators to reports           05m 11s
Adding charts to reports           03m 54s
Working with report security           03m 54s

14. Integration Services
Introduction to SQL Server Integration Services (SSIS)           01m 57s
Using Business Intelligence Development Studio (BIDS)           06m 59s
Creating and executing a simple SSIS package           07m 35s
Importing packages into SQL Server Management Studio           03m 21s
Scheduling jobs with SQL Server Agent           04m 49s

Conclusion
Goodbye           00m 31s