SQL SERVER Training

Posted by admin - 03/11/09 at 10:11 pm

Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL.

Section 1: SQL SERVER 2005 Express Overview and Installation

• Unit What is SSE?
• Unit Evolution of SQL Server
• Unit Hardware Requirements
• Unit Security

Section 2: SQL server Management Studio Express

• Unit A Quick overview of SSMSE
• Unit Examining SSMSE’s Options
• Unit Query Editor
• Unit Surface Area Configuration Tool

Section 3: Database Design and Creation

• Unit Defining a Database
• Unit Databases within SSE
• Unit Choosing the Database System Type
• Unit Determining the Information to Store in the Database
• Unit Building Relationships
• Unit Normalization
• Unit Creating the Sample Database

Section 4: Security

• Unit Logins
• Unit Roles
• Unit Schemas

Section 5: Defining Tables

• Unit What is a Table
• Unit Defining a Table
• Unit Columns Are More Than Simple Data Repositories
• Unit Image and Large Text storage in SSE
• Unit Creating a Table In SQL Server Management Studio Express
• Unit Defining a Table: Through Query Editor
• Unit Defining a Table: Using a Template
• Unit Creating and Altering a Template
• Unit The ALTER TABLE statement
• Unit Creating the Remaining Tables
• Unit Defining a Primary Key
• Unit Creating a Relationship
• Unit the ALTER TABLE SQL Statement

Section 6: Creating Indexes and Database programming

• Unit What is an Index
• Unit Determining What makes a Good and Bad Index
• Unit Creating an Index
• Unit The CREATE INDEX Syntax
• Unit Dropping an Index
• Unit Altering an Index in Query Editor
• Unit Diagramming the Database
• Unit The SQL Server Express Database Diagram Tool

Section 7: Database Backup, Recovery, and Maintenance

• Unit Transaction Logs
• Unit Backup Strategies
• Unit Backing the Data Up
• Unit Restoring a Database
• Unit Deatching and Attaching a Database
• Unit Producing SQL Script for the Database
• Unit Maintaining Your Database

Section 8: Working with the Data

• Unit Inserting the Data
• Unit Retrieving the Data
• Unit Updating the Data
• Unit Transactions
• Unit Deleting Data

Section 9: Building a View

• Unit What is a View?
• Unit Using Views for Security
• Unit Encrypting View Definitions
• Unit Creating a View: SSMSE
• Unit Creating a View Using a View
• Unit CREATE VIEW Syntax
• Unit Creating a View: A Query Editor Pane
• Unit Creating a View: SCHEMABINDING
• Unit Indexing a View

Section 10: Stored Procedures

• Unit What is a Stored Procedure?
• Unit CREATE PROCEDURE Syntax
• Unit Different Methods of Execution
• Unit Using Return
• Unit Controlling the Flow

Section 11: T-SQL Essentials

• Unit Using More Than One Table
• Unit Variables
• Unit Temporary Tables
• Unit Aggregations
• Unit GROUP BY
• Unit HAVING
• Unit Functions
• Unit RAISEERROR
• Unit Error-Handling
• Unit @@ERROR
• Unit TRY – CATCH

Section 12: Advanced T-SQL

• Unit Sub queries
• Unit The APPLY Operator
• Unit Common Table Expressions
• Unit Pivoting Data
• Unit Ranking Functions
• Unit Using the MAX Data Type

Section 13: Triggers

• Unit What is a Trigger?
• Unit The DML Trigger
• Unit CREATE TIGGER Syntax for DML Triggers
• Unit Checking specifying Columns
• Unit DDL Triggers
• Unit Dropping a DDL Trigger
• Unit EVENT DATA()

Section 14: SQL Server 2005 reporting services

• Unit What is a Reporting service?
• Unit Reporting service Architecture
• Unit Reporting service Architecture: A Closer Lock
• Unit Building the First Report Using Report Wizard
• Unit Building a First Report Scratch

This entry was posted on Tuesday, November 3rd, 2009 at 10:22 pm and is filed under lamp courses. The entry is tagged under Microsoft SQL Server, Microsoft SQL Server Training, SQl, SQL Server, SQL Server Online Training. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.