Microsoft SQL Server 2008 for Developers

מק"ט: #7047 | משך קורס: 40 שעות אק'

In this course, you will learn about the steps to install, and/or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply 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.
SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You will learn 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.

הקורס פעיל לקבוצות מטעם ארגונים בלבד, ניתן לשלוח פנייה רק אם מדובר בקבוצה
*שדות חובה
PDF version

מטרות הקורס

After completing this course, students will be able to:

  • Understand views, stored procedures, triggers, and user-defined functions
  • Write and use stored procedures to provide a safe, controlled, efficient way to execute Transact-SQL code to access and update data and database objects
  • Explore the various types of user-defined functions & how to support reusable database code
  • Discover how transactions can protect the integrity of your data
  • Handle errors that occur when code executes
  • Use advanced querying techniques for grouping aggregated data, executing multiple actions with the MERGE statement, and others
  • Understand the complex data types in SQL Server
  • Partition data to store data in ways that improve the efficiency of queries
  • See how the Visual Studio Team System for Database Professionals edition supports designing, creating, and deploying databases in a collaborative environment
  • Investigate the XML data type and its properties and methods, and how it supports both free form and relational data
  • Understand Business Intelligence to add reporting and analysis capabilities to your databases and applications

תנאי קדם

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.
The course is taught from a developer's perspective


Module 1: Creating Views

  • What Is a View?
  • Creating Views
  • Updating Data Using a View
  • Using Computed Columns
  • Indexed Views
  • Partitioned Views


Module 2: Creating Stored Procedures and Triggers

  • Creating Stored Procedures
  • Creating Triggers


Module 3: Creating User-Defined Functions

  • User-Defined Functions Overview
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Using Functions, Views, and Stored Procedures


Module 4: Transactions and Error Handling

  • Transaction Concepts
  • Applications and Transactions
  • Creating Explicit Transactions
  • Using TRY/CATCH Error Handling


Module 5: Using .NET Code in SQL Server

  • Introduction
  • Writing SQLCLR Code
  • SQLCLR Code Modules
  • SQLCLR Security
  • T-SQL vs .NET Code


Module 6: Advanced SQLCLR Code Techniques

  • Advanced SQLCLR Code Modules
  • Managing Code Modules

Module 7: Advanced Query Techniques

  • Full-Text Search
  • Advanced T-SQL Techniques
  • Executing Dynamic SQL


Module 8: Advanced Data Types

  • Introduction
  • The HierarchyID Data Type
  • Sparse Columns and Column Sets
  • FILESTREAM Storage
  • Spatial Data


Module 9: Implementing Partitions

  • SQL Server Partitions
  • Creating Partitioned Tables
  • Querying Patitions
  • Managing Partitions


Module 10: Complex Querying

  • Complex Queries
  • Ranking
  • Correlated SubQueries
  • Common Table Expressions


Module 11: Advanced Techniques

  • Complex Data and Structures
  • Efficient Queries
  • Working with Complex Queries
  • Maintaining Query Files


Module 12: Design and Deployment with Visual Studio

  • Team System for Database Professionals
  • Creating Databases and Managing Projects
  • Database and Project Management


Module 13: Working with XML

  • XML Data Type
  • XML Schema Collections
  • Querying XML
  • Best Practices


Module 14: Business Intelligence Services

  • Introduction to Business Intelligence Services
  • Using Integration Services
  • Using Analysis Services
  • Using Reporting Services


לפי יצרן: