Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: England
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
|
