SQL Server Essentials

Course

In Worcester

£ 680 + VAT

Description

  • Type

    Course

  • Location

    Worcester

  • Duration

    2 Days

Suitable for: Personnel who need to understand the basic concepts of SQL Server, from an administration or development viewpoint. The course is also suitable for application developers (Visual Basic, C++, etc.) who need a solid grounding in SQL Server.

Facilities

Location

Start date

Worcester (Worcestershire)
See map
8-10 The Moors, WR1 3EE

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

THE COURSE
An introduction to the important features of both relational databases and specifically SQL Server. The course will involve a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including the Management Studio; and database implementation basics, with an introduction to T-SQL and data integrity.

WHO SHOULD ATTEND
Personnel who need to understand the basic concepts of SQL Server, from an administration or development viewpoint. The course is also suitable for application developers (Visual Basic, C++, etc.) who need a solid grounding in SQL Server.

PRE-REQUISITES
Delegates should have a working knowledge of Windows. No previous experience of SQL Server or relational databases is required. It is not necessary to attend this course if you have attended our SQL Server Introduction course.

COURSE TOPICS

RELATIONAL DATABASE CONCEPTS
What is a Database?
Logical and Physical Design
The Relational Database
Primary Keys & Foreign Keys
Entity Relationship Diagrams
Design Normalisation

RELATIONAL DATABASE ARCHITECTURE
The RDBMS
Structured Query Language - SQL
Stored Queries
Indexes
Transactions and Log Files
Client-Server and Middleware Architectures

SQL SERVER FEATURES AND ARCHITECTURE
Overview of SQL Server
Server Fundamentals
Users and Security
Networked Architecture
SQL Server Installation

SQL SERVER TOOLS
SQL 2008 (and 2005) Tools
SQL Management Studio
SQL Server Configuration Tool
SQL Server Books Online
SQL Server Surface Area Configuration (2005 Only)
Profiler
Data Engine Tuning Advisor
Performance Monitor
SQL Server Installation Centre (2008 Only)
Network Utilities
SQL Server Enterprise Manager
Query Analyser

VIEWING DATA
Accessing Data within Database Tables
The SELECT Statement
Manipulating Data
Selecting Rows
Sorting Data using ORDER BY
Aggregate Functions
Querying Multiple Tables Using Joins

DATABASES AND TABLE STRUCTURES
Creating Databases using SQL Server and T-SQL
Creating Tables in SQL Server
Entering and Editing Data
Creating Tables and Columns in T-SQL
Modifying Tables and Columns
Computed Columns
Database Diagrams
Creating Database Diagrams

MANIPULATING DATA
Modifying Data in Tables
The INSERT Statement
The DELETE Statement
The UPDATE Statement

ENFORCING DATA INTEGRITY
Types of Data Integrity
Constraints
Ensuring Integrity with Triggers

IMPROVING DATA ACCESS
Using Views
Speeding up Data Access with Indexes
Application Development Environment

SQL Server Essentials

£ 680 + VAT