Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print Page
View related coursesTransact SQL (T-SQL) Server 2008 for Developers
Description:
This course covers an overview tour of SQL Server 2008 including its editions, components, and tools. Participants will learn about the steps to install, and/or upgrade to SQL Server 2008 and configuring the server. The principles of database design are used in creating databases and then applying server tables to them. The course continues with SQL Server Management Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to use .NET languages like Visual C# and Visual Basic to build database objects. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks and how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration servers, implementing security, and Microsoft's new Business Intelligence (BI) suite
- Cost: €1695.00
- Duration: 4 Days
- Cork Date:
- Limerick Date:
- Dublin Date: Feb 20-23, Apr 23-26, Jun 25-28
- This course is also available as a customised client specific course.
Prerequisites:
To get the most out of the Microsoft SQL Server 2008 course, you should have a solid understanding of relational databases and the concepts of SQL Server. No particular programming experience is required, but the course is taught from a developer's perspective
A Tour of SQL Server 2008:
• SQL Server 2008 Editions, Components, and Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, and Views
• Business Intelligence Services
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, and Views
• Business Intelligence Services
Installing SQL Server 2008:
• Preparing for Installation
• Upgrading an Earlier Version
• Installation Steps
• Configuring the Server
• Upgrading an Earlier Version
• Installation Steps
• Configuring the Server
Designing and Creating a Database:
• Relational Database Design Principles
• Implementing the Design
• Create a SQL Server Database
• Create SQL Server Tables
• Creating Relationships Using a Database Diagram
• Implementing the Design
• Create a SQL Server Database
• Create SQL Server Tables
• Creating Relationships Using a Database Diagram
Data Selection:
• Understanding Transact-SQL
• The SELECT Statement
• The WHERE Clause
• Using ORDER BY to Sort Data
• The GROUP BY Clause
• Joining Tables
• The SELECT Statement
• The WHERE Clause
• Using ORDER BY to Sort Data
• The GROUP BY Clause
• Joining Tables
Modifying Data:
• Modifying DAta with Transact-SQL
• Inserting Data
• Updating Data
• Understanding Transaction Isolation
• Inserting Data
• Updating Data
• Understanding Transaction Isolation
Working with SQL Server Management Studio:
• Getting Started with Management Studio
• Exploring the Object Explorer
• Working with the Query Editor
• Using SQL Server Books Online
• Exploring the Object Explorer
• Working with the Query Editor
• Using SQL Server Books Online
Transact-SQL Programming:
• Overview of Transact-SQL
• Using Built-In Functions
• Using Control of Flow Constructs
• Using Built-In Functions
• Using Control of Flow Constructs
Understanding and Implementing Security:
• Security Overview
• Authentication
• Authorization
• Data Encryption
• Security Epilog
• Authentication
• Authorization
• Data Encryption
• Security Epilog
Creating Views:
• What Is a View?
• Creating Views
• Updating Data Using a View
• Using Computed Columns
• Indexed Views
• Partitioned Views
• Creating Views
• Updating Data Using a View
• Using Computed Columns
• Indexed Views
• Partitioned Views
Creating Stored Procedures and Triggers:
• Creating Stored Procedures
• Creating Triggers
• Creating Triggers
Creating User-Defined Functions:
• User-Defined Function Overview
• Scalar Functions
• Inline Table-Valued Functions
• Multi-Statement Table-Valued Functions
• Using Functions, Views, and Stored Procedures
• Scalar Functions
• Inline Table-Valued Functions
• Multi-Statement Table-Valued Functions
• Using Functions, Views, and Stored Procedures
Transactions and Error Handling:
• Transaction Concepts
• Applications and Transactions
• Creating Explicit Transactions
• Using TRY/CATCH Error Handling
• Applications and Transactions
• Creating Explicit Transactions
• Using TRY/CATCH Error Handling
Using .NET Code in SQL Server:
• Introduction
• Writing SQLCLR Code
• SQLCLR Code Modules
• SQLCLR Security
• T-SQL vs. .NET Code
• Writing SQLCLR Code
• SQLCLR Code Modules
• SQLCLR Security
• T-SQL vs. .NET Code
Advanced SQLCLR Code Techniques:
• Advanced SQLCLR Code Modules
• Managing Code Modules
• Managing Code Modules
Advanced Query Techniques:
• Full-Text Search
• Advanced T-SQL Techniques
• Executing Dynamic SQL
• Advanced T-SQL Techniques
• Executing Dynamic SQL
Advanced Data Types:
• Introduction
• The HierarchyID Data Type
• Sparse Columns and Column Sets
• FILESTREAM Storage
• Spatial Data
• The HierarchyID Data Type
• Sparse Columns and Column Sets
• FILESTREAM Storage
• Spatial Data
Implementing Partitions:
• SQL Server Partitions
• Creating Partitioned Tables
• Querying Partitions
• Managing Partitions
• Creating Partitioned Tables
• Querying Partitions
• Managing Partitions
Complex Querying:
• Complex Queries
• Ranking
• Correlated SubQueries
• Common Table Expressions
• Ranking
• Correlated SubQueries
• Common Table Expressions
Advanced Techniques:
• Complex Data and Structures
• Efficient Queries
• Working with Complex Queries
• Maintaining Query Files
• Efficient Queries
• Working with Complex Queries
• Maintaining Query Files
Design and Deployment with Visual Studio:
• Team System for Database Professionals
• Creating Databases and Managing Projects
• Database and Project Management
• Creating Databases and Managing Projects
• Database and Project Management
Working with XML:
• XML Data Type
• XML Schema Collections
• Querying XML
• Best Practices
• XML Schema Collections
• Querying XML
• Best Practices
Business Intelligence Services:
• Introduction to Business Intelligence Services
• Using Integration Services
• Using Analysis Services
• Using Reporting Services
• Using Integration Services
• Using Analysis Services
• Using Reporting Services