Course Outline
The full 5-day Comprehensive Upgrade, primarily aimed at SQL Server Developers and Database Administrators will give delegates intensive hands-on experience of utilising the new features of SQL Server 2008. Relational Database professionals from backgrounds such as Oracle and Sybase should also gain a lot from this course.
Course Content
This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email sales@jbinternational.co.uk
SQL Server 2008 Comprehensive DBA & Programming Upgrade Training Course Outline
SQL Server 2008 Overview
SQL Server 2008 Editions
SQL Server Requirements
Upgrading to SQL Server 2008
Enterprise Data Platform
Policy Management
Needs Addressed by Policy Management
Policy Management Components
Sample Policies
Policy Management Administration
High Availability
High Availability Defined
Database Mirroring
Database Snapshots and Mirroring
Windows Clustering in SQL Server
SQL Server Replication
Reducing Planned Downtime
Performance
Managing and Monitoring Resources
Data Collector
Resource Governor
Optimising Storage
Back-up Compression
Data Compression
Improving Query Performance
Security
Disabled Database Engine Features
Remote Connections
.NET Framework
Database and SQLMail
Service Broker
Principals and Securables
Permissions
Types of Permissions
Managing Permissions
Code Access Security
Imperative and Declarative CAS
Auditing in SQL Server 2008
SQL Server Encryption
Encryption Keys
Transparent Data Encryption
Extensible Key Management
Encryption Without Keys
Hashing and Signing Data
Security Catalogue Views
Query Efficiency
Automation and Monitoring
SQL Server Agent
Maintenance Plans
SQLCMD
PowerShell for SQL Server
Database Mail
SQL Profiler
Extended Events
Service Broker
What is Service Broker?
Architecture
Scenarios
Creating Service Broker Applications
Service Broker Routing and Security
Message Priorities
Troubleshooting using SSBDiagnose
Integrated Full-Text Search
Creating Full-Test Catalogues and Indexes
Querying with iFTS
Managing Thesaurus Files
Using Stoplists
Searching Documents
Managing iFTS
New Datatypes in SQL Server 2008
Spatial Support in SQL Server 2008
GEOMETRY type
GEOGRAPHY type
How Time Has Changed in SQL Server
New Hierarchical Datatype
Filestream Support
T-SQL Enhancement for Developers
Notable DML Features
General Development
T-SQL Enhancements for DBAs
Locking Enhancements
Metadata Views
Notable SQL Server Performance Monitor Counters
DDL Triggers
Indexing and Performance Enhancements
Snapshots
Data-Integrity Enhancements
.NET Integration
Introduction to SQL Server .NET Integration
SQL Server .NET Programming Model
Deploying CLR Routines
Programming Assemblies
CLR User-Defined Types
CLR User-Defined Functions
CLR User-Defined Aggregates
CLR User-Defined Triggers
Managing Assemblies
SQL Server and XML
What is XML?
What Are Xpath and the XMLDOM?
Getting XML into the Database
Getting XML out of the Database
Working with XML Data
Programming SQLXML for .NET and COM
SQL Server XML and XQuery Support
Using the XML Datatype
Inserting Data into XML Columns
Querying XML Data
Modifying XML Data
Indexing XML for Performance
Full-Text Search and the XML Datatype
Catalogue Views and XML
Applications and XML
XML Web Services Support
LINQ to SQL
Object/Relational Mapping
Entity-Generation Tools
Rnning LINQ Queries
The DataContext Class
Reporting Services
Reporting Services Components
Building a Basic Report
Report Design Advanced Features
Visual Studio Integration and ReportViewer Controls
Sharepoint Integration
End-User Ad Hoc Query and Reporting
Report Rendering
Data Regions
Analysis Services
New Analysis Service Features in SQL Server 2008
Analysis Service Fundamentals
OLAP, OLTP and Data Warehouses
Analysis Services Projects
Working with Cubes
Analysis Services Projects
Working with Cubes
Using Analysis Services Scripting Language
Integration Services
Overview of SSIS features
What’s new in SSIS
The SSIS Integrated Development Environment
Connecting to SSIS in Management Studio
Creating a New SSIS Project in BIDS
SSIS Fundamentals
Control Flow and Data Flow Designer Tasks
Control Flow Containers and Tasks
Data Flow Designer Tasks
Change Data Capture
Enabling Change Data Capture
Extracting Change Data with SSIS
Logging
Dynamic Package Configuration
Variables
Precedence Constraints
Checkpoints
Transactions
Debugging
Control Flow and Data Flow Visual Debugging
DataViewers
Breakpoints
SSIS Package Handling
The SSIS Package Deployment Utility
Scheduling an SSIS Package
