Overview
-
Explores all the major features of SQL Server 2008, beginning with core concepts.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- SQL Server core concepts
- SQL Server editions
- Applications included with SQL Server
- Preparing for installation
- Creating service accounts
- Installing SQL Server
- Post-installation checks
- Installing sample databases
- Introduction to SQL Server Management Studio
- Introduction to SQL Server Books Online
- SQL Server system databases
- Planning your database
- Creating a SQL Server database
- Creating tables
- Data types in SQL Server
- Defining keys
- Creating default values
- Creating check constraints
- Creating unique constraints
- Introduction to relationships and foreign keys
- Creating relationships in SQL Server Management Studio
- Database normalization
- Creating computed columns
- Using the SQL Server Import and Export Wizard
- Importing Excel files into SQL Server
- Importing CSV files into SQL Server
- Importing Access databases into SQL Server
- Introduction to Transact-SQL
- Using SELECT statements
- Changing the default database
- Creating conditions in SQL
- Sorting your output
- Using aggregate functions
- Finding unique values
- Joining multiple tables together
- Using subqueries
- Viewing execution plans
- Writing INSERT statements
- Writing UPDATE statements
- Writing DELETE statements
- Using the OUTPUT clause to return inserted keys and GUIDs
- Introduction to SQL functions
- Using SQL configuration functions
- Using string functions
- Using date functions
- Creating user-defined functions
- Introduction to stored procedures
- Creating stored procedures
- Introducing transactions
- Creating transactions
- Understanding and creating indexes
- Monitoring and rebuilding indexes
- Monitoring database size and integrity
- Creating backups
- Creating differential backups and using backup compression
- Restoring databases
- Introduction to SQL Server security and permissions
- Adding a Windows user to the database
- Creating SQL Server logins and switching authentication modes
- Introduction to SQL Server Reporting Services
- Connecting to the Report Manager
- Using Report Builder
- Formatting values in reports
- Adding indicators to reports
- Adding charts to reports
- Working with report security
- Introduction to SQL Server Integration Services (SSIS)
- Using Business Intelligence Development Studio (BIDS)
- Creating and executing a simple SSIS package
- Importing packages into SQL Server Management Studio
- Scheduling jobs with SQL Server Agent
- Goodbye
