|
| AUDIENCE: |
This course is for support personnel who need to understand the basic concepts of SQL Server 2000 and 2005, from an administration or development viewpoint. This includes application developers (Visual Basic, C++, etc.) who need a basic grounding in SQL Server 2000 or 2005. |
| PREREQUISITES: |
No previous knowledge of the program is assumed although a working knowledge of Windows 2000/2003 Server/XP will be useful. |
| DURATION: |
2 days. Hands on. |
| OBJECTIVES: |
This course provides an introduction to the important features of both relational databases and specifically Microsoft's SQL Server product up to version 2005. The course will involve a terminology guide; installation of the server; a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyser and database implementation basics, with an introduction to T-SQL and SQL Server security. |
| COURSE CONTENT: |
SQL Server 2005 Architecture
RDBMS Characteristics
SQL Database Architecture
Relational Database Design
The Relational Database
Structured Query Language
Enforcing Data Integrity
Client-Server Architecture
Replication Architecture
Installing SQL Server
Pre-Installation Check-List
Installed SQL Server Components
Installing SQL Server
SQL Server Tools
Using the SQL Server Tools
Creating a Database
Creating Tables
Administration Architecture
Wizards
Application Development Architecture
Working with SQL Server Databases and Tables
Structure Query Language
Generating Database Information
Setting Database Options
Removing Databases
Enforcing Data Integrity
Defining Table Columns
Using INSERT VALUES
Using Database Queries
The SELECT Statement
Manipulating Data
Selecting Rows
Sorting Data with ORDER BY
Aggregate Functions
Implementing Joins
Deleting Data with DELETE
Updating Data with UPDATE
Accessing Data with Views
Stored Procedures
Ensuring Database Integrity with Triggers
Implementing SQL Server Security
Accessing SQL Server
Fixed Server Roles
Fixed Database Roles
What are User-Defined Roles?
Application Roles
Database Permissions |
|
© 2007 Verhoef Training
|
