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

 

לפי יצרן: 
תגיות