|
SQ8K2ESS
2 Days
|
|
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
Course Outline v1.0 |
|
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. |