SQL Server Developer & Administrator Foundation
Duration 4 days
Objectives
An introductory 4-day SQL Server Database Development and Administration course over two sessions specially prepared by Acunity. This course is unique in that it is aimed at the practical usage of SQL server, rather than the more academic approach offered by other trainer suppliers.
The overall goal is to provide the developers and administrators both with key knowledge and expertise based on commercial usage of SQL Server and an understanding of best practice in SQL Server Development and Administration.
This course can be customised to me meet private client learning requirements. Requirements
No previous commercial experience using SQL Server is required. General knowledge of databases, web technologies and the internet.
Course Outline
SQL Server Overview
• Database Architecture Essentials
• Database Design Essentials
Data Definition Language (DDL)
• Creating tables
• Defining table constraints
T-SQL
• Retrieving data
• Using Joins
• Aggregate functions
• GROUP BY clause
• UNION operator
• Manipulating data
• Advanced T-SQL topics
Transactions
• Transaction basics
• Implicit vs Explicit transactions
• Starting a transaction
• Ending a transaction
• Error trapping
• Rolling back transactions
Locking and Blocking
• Overview of SQL Server locking
• Transaction Isolation levels
• Identifying blocked processes
• Deadlocks and how to avoid them
Stored Procedures
• What are stored procedures and how are they useful
• Creating and altering stored procedures
• Using parameters and variables
• Security and stored procedures
• Inserting results of stored procedures into tables
Triggers
• Creating triggers
• Using the inserted and deleted tables in triggers
DTS
• DTS Designer
• Creating connections
• Executing packages
• Error handling and logging
Indexes
• Basic concepts
• Creating indexes
• Managing indexes
Security
• Managing server level security
• Managing database level security
• Managing object level permissions
Backing up and restoring databases
• Recovery models
• Backing up a database and/or log file
• Restoring a database and/or log file
• Restoring system databases
SQL Mail
• Configuring mail support
• Creating a mail profile
• Using xp sendmail to send an email
SQL Server Jobs
• Creating scheduled jobs
• Creating job steps
• Viewing the job history
Performance and Maintenance
• Allocating memory to SQL Server
• Notes on best practices
• Managing database files
• Managing database consistency
• Query Tuning
Wrap-up
• QandA
• Further reading and resources
• Recommended next steps
| 
