Terug naar cursusoverzicht

SQL Server Development

Block: Creating a Database and Database Objects

  • The Database
  • Tables
  • Views
  • Stored Procedures
  • Triggers
  • Functions
  • Partitions

Block: Indexes and Constraints

  • Indexes
  • Constraints
  • Indexes on Views

Block: Security

  • Authentication Mode
  • Create Logins
  • Create Users
  • Configure Securables
  • Schemas
  • Encryption

Block: T-SQL

  • Advanced features of SELECT, UPDATE, DELETE, INSERT
  • Advanced features of the FROM Clause
  • Other advanced features

Block: XML Data

  • The XML Data Type
  • Selecting Result Sets as XML Data
  • Retrieving XML Data from an XML Type Column
  • Serving Data to Applications
  • Updating XML Data
  • Converting XML Data to Relational Data
  • XML Indexes

Block: Supporting Data Consumers

  • Module: HTTP Endpoints
  • Module: Service Broker
  • Module: Full-Text Catalogs

SQL Server Database Administration

Block: Introduction

  • Why Choose SQL Server
  • What's new in the latest version?
  • Comparing Editions
  • Management Tools
  • System Requirements
  • Installing SQL Server
  • Upgrading to the New Version
  • Multiple Instances
  • Linked Servers

Block: Import and Export Data

  • Bulk-Logged Recovery Model
  • The bcp Utility
  • The BULK INSERT Statement
  • Bulk Import of XML Data
  • SQL Server Import and Export Wizard
  • Moving Databases

Block: Maintaining Databases

  • Backup and Restore
  • Manage Databases by Using T-SQL
  • Shrink Database
  • Manage Statistics
  • Check Database
  • Manage Index Fragmentation
  • SQL Server Agent Jobs
  • Maintenance Plans
  • Operators and alerts

Block: Implementing High Availability and Disaster Recovery

  • Database Mirroring
  • Snapshots
  • Log Shipping

Block: Monitoring and Troubleshooting SQL Server Performance

  • SQL Server Profiler
  • System Monitor
  • Database Engine Tuning Advisor (DTA)
  • Dynamic Management Views and Functions (DMV and DMF)
  • DAC Connection

Block: Replication

  • Pull subscriptions
  • Push subscriptions

SQL Server SSIS and SSAS


Terug naar cursusoverzicht