SQL Server Course Descriptions
SF 8001 - RDBMS Concepts
Course Length: 40 hours
This course is designed to give the student a review of RDBMS concepts.
- Introduction to Database Management System
- The Relational Model
- Data Modeling
- Normalization
- Data Integrity
- Advanced Database Objects
SF 8002 - Writing Queries using MS SQL Server 2008 T-SQL
Course Length: 40 hours
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- Querying and Filtering Data
- Grouping and Summarizing Data
- Joining Data from Multiple Tables
- Working with Subqueries
- Modifying Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
- Using Programming Objects for Data Retrieval
- Using Advanced Querying Techniques
SF 8003 - Implementing a Microsoft SQL Server 2008 Database
Course Length: 40 hours
This SQL Server training class provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The class focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
- Create databases and database files
- Create data types and tables
- Creating and Tuning Indexes
- Implementing Data Integrity by Using Constraints and Triggers
- Using XML
- Implementing Views
- Implementing Stored Procedures
- Implementing Functions
- Implementing Managed Code in the Database
- Managing Transactions and Locks
- Using Service Broker
SF 8005 - Advanced SQL Querying and Programming
Course Length: 40 hours
The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2008. In this course you will learn the details and capabilities of T-SQL.
- SQL 2005 new features workshop
- SQL 2008 new features workshop
- Hierarchies and recursive querying
- Working with dates
- Concurrency and locking
- Query performance tuning
- Database security and encryption
- Spatial data
SF 8014 - SetFocus - Microsoft SQL Server 2008 Integration Services
Course Length: 40 hours
This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.
SF8015 - SetFocus – Microsoft SQL Server 2008 Reporting Services
Course Length: 40 hours
In this course, you will learn how to use SQL Server 2008 Reporting Services, explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you’ll be building Matrix reports and charts then explore the use of Reporting Services gauges. The Deployment of Reporting Services projects follow using a variety of formats and client-side printing. You’ll gain knowledge of SSRS Security in managing of user roles and accounts. You’ll also discover how to view reports using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you’ll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.
For details and pricing information,click here.