SQL Server Essentials

Quanta Training
In Worcester

£680
+ VAT
Want to speak to an Advisor about this course?

Important information

Typology Course
Location Worcester
Duration 2 Days
  • Course
  • Worcester
  • Duration:
    2 Days
Description


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.

Venues

Where and when

Starts Location
On request
Worcester
8-10 The Moors, WR1 3EE, Worcestershire, England
See map
Starts On request
Location
Worcester
8-10 The Moors, WR1 3EE, Worcestershire, England
See map

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


Students that were interested in this course also looked at...
See all