Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Microsoft Training Courses

SQL Server 2000/2005: Introduction for Beginners

Course Code: MSQ-IN      Days: 2
Show all Microsoft Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
England
Worcestershire
Worcester (WR1) 15/12/08 £ 680
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

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.

Audience

Personnel who need to understand the basic concepts of SQL Server, from an administration or development viewpoint. Application developers (Visual Basic, C++, etc.) who need a solid grounding in SQL Server.

Prerequisites

Delegates should have a working knowledge of Windows. It is not necessary to attend this course if you have attended our SQL Server Introduction course.

Course Outline

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
  • Users and Security
  • Networked Architecture
  • SQL Server Installation

SQL SERVER TOOLS

  • Administrative Tools
  • SQL Management Studio
  • SQL Server Configuration Tool
  • SQL Server Books Online
  • SQL Server Surface Area Configuration
  • Profiler
  • Performance Monitor
  • Books Online
  • System Environmental Tools
  • SQL Server Enterprise Manager
  • Query Analyser

VIEWING DATA

  • Controlling Data within Database Tables
  • The SELECT Statement
  • Manipulating Data
  • Selecting Rows
  • Sorting Data using ORDER BY
  • Aggregate Functions
  • Joins - Querying Multiple Tables

DATABASES AND TABLE STRUCTURES

  • Creating a Database using SQL Server 2005
  • Creating a Database using SQL Server 2000
  • Adding Tables and Columns - Overview
  • Tables and Columns in Management Studio
  • Modifying Tables and Columns
  • Computed Columns
  • Database Diagrams

MANIPULATING DATA

  • Action Queries
  • 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


How to make a booking for the MSQ-IN course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership