Objectives
Course Outline
Upon completing this course, the learner will be able to meet these overall objectives:

  • Build and manage SQL Server databases
  • Retrieve and manipulate data with SQL queries
  • Integrate SQL Server with .NET, Microsoft Office and XML
  • Secure and monitor databases with Management Studio
  • Replicate data over multiple servers with merge replication
  • Transform data into strategic information using business intelligence processes
  • Course Overview
  • SQL Server components and tools
  • Constructing the Database
  • Creating a database
  • Protecting data with constraints
  • Data retrieval with Transact-SQL
  • Integrating with Client Applications
  • Connecting to SQL Server
  • Leveraging XML and .NET features
  • Securing the database infrastructure
  • Monitoring SQL Server activity
  • Sharing Data through Replication
  • Configuring merge replication
  • Transforming data with Integration Services
  • Producing information with Analysis Services
  • Information delivery with Reporting Services