Course Description:
This 5 day course dives into SQL Server 2008 including the new features, components, and tools. You will learn the steps to install and/or upgrade to SQL Server 2008 as well as configuring the server. Explore the principals of database design when used in creating databases, how to apply server tables to them, 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, how to take advantage of the user-friendly management console and SQL Server's tools for analyzing and tuning your databases. You'll also cover integration servers, implementing security, and Microsoft's new Business Intelligence (BI) suite.
Course Technology
This course uses Microsoft Windows 7 and Microsoft SQL Server 2008.
At the end of the course you will:
- Install or upgrade from an earlier version of SQL Server.
- Configure SQL 2008 Server to meet your needs.
- Apply relational database design principles.
- Create a SQL Server database and tables.
- Understand T-SQL, the SELECT statement and the WHERE Clause.
- Use SQL Server Management Studio (SSMS).
- Implement security with authentication, authorization and encryption.
- Understand the differences between views, stored procedures, triggers, and user-defined functions.
- Explore the various types of user-defined functions and how they support reusable database code.
- Learn why using .NET code, using either C# or Visual Basic, in the database overcomes many Transact-SQL limitations,
and how SQL Server protects itself from misbehaving code.
- Understand the complex data types in SQL Server, such as for spatial and hierarchical data, and how they support
complex data operations.
- How to partition data to store data in ways that improves the efficiency of queries.
- Understand Business Intelligence to add reporting and analysis capabilities to your databases and applications.
Course Outline
- A Tour of SQL Server 2008
- Installing SQL Server 2008
- Designing and Creating a Database
- Data Selection
- Modifying Data
- Working with SQL Server Management Studio
- Transact-SQL Programming
- Understanding and Implementing Security
- Creating Views
- Creating Stored Procedures and Triggers
- Creating User-Defined Functions
- Transactions and Error Handling
- Using .NET Code in SQL Server
- Advanced SQLCLR Code Techniques
- Advanced Query Techniques
- Advanced Data Types
- Implementing Partitions
- Complex Querying
- Advanced Techniques
- Design and Deployment with Visual Studio
- Working with XML
- Business Intelligence Services
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.
Contact Us For More Information