Events

TEXT SIZE: Enlarge Reduce

New Elearning Course - SQL Server 2008
August 26th, 2013

Dear Users,

 

We invite you to participate in the new course about SQL Server 2008, Microsoft database engine on which SoftGuard operates. For those who have previously taken part in the SQL SERVER LEVEL 1 course (version 2000), this new course will refresh your knowledge and allow you to better maintain your system using the latest tools to improve how data is managed. For those users who have never taken part in a course about SQL SERVER, we highly recommend that you do so at this time.

 

E-LEARNING : SQL SERVER 2008 (for system Administrators)

AVAILABILITY DATE : 15/08/2013

 

PURPOSE

To provide the knowledge of the skill required to realize the common tasks of a user and administrator in SQL Server 2008 database and get the most out of your SoftGuard alarm Monitoring system.

 

Content of the Modules:



MODULE 1

INTRODUCTION TO SQL SERVER 2008 

Definition and History 

The Concept of Microsoft SQL 

ANSI SQL 

What is a Database? 

Database relations 

Client Technology / Server 

SQL Sessions 

INSTALLING MICROSOFT SQL SERVER 2008 

General Requirements

Configuring the Installation of Microsoft SQL Server 

Setup Support Rules 

Setup Role 

Feature Selection 

Installation Rules 

Instance Configuration 

Disk Space Requirements 

Server configuration 

Database Engine Configuration 

Changing the Status of Services 

SQL Server Management Studio 2008 

MODULE 2 

DATABASE ADMINISTRATION 

File and FileGroup Architectures 

FileGroups 

Structure of a Database 

Physical Structure 

Logical Structure 

Tables 

Fields – Registrations 

Indexes 

Restrictions 

Views 

Saved Procedures

MODULE 3 

PLANNING A BACKUP STRATEGY 

Recovery Models 

Full 

Simple

Bulk Logged

Types of Backup

Complete

Differential

Filegroup

Detach/Attach

MODULE 4

SAFETY ADMINISTRATION

Authentication Process

Windows Authentication Mode

Mixed Authentication Mode

Logins - Users

Creating a user and assigning permission

Role of Server Levels

Predetermined SQL Server Roles

MODULE 5 

MONITORING THE SQL SERVER  

Supervising the SQL Server

Defining Supervision Objectives.

Select the appropriate tool.

Identifying the components you wish to supervise

Select metrics for said components

Supervising the Server.

Analyze data.

Monitor SQL Server Management Studio Activity

SQL  Profiler

Using Traces

MODULE 6

AUTOMATION OF JOBS – SQL Server Agent

Creating a new job. (Job)

Monitor Job Activity.

Configuring the Database Mail Service

MODULE 7

SQL LANGUAGE

DDL - DCL – DML Sentences

SQL Components

Logical Operators

Operator Comparisons

Adding Functions

Language Characteristics

Manipulation of data - DML        

SELECT Command

Sentence Syntaxes

INSERT Example command

Sentence Syntaxes

Example command UPDATE

Sentence Syntaxes

Example command DELETE

Sentence Syntaxes

Example existence test (EXISTS)

Sentence Syntaxes

Example COUNT

Sentence Syntaxes

Example GROUP BY

Sentence Syntaxes

Example ORDER BY

Sentence Syntaxes

Example INNER JOIN

Sentence syntaxes

Example

Result exportation

 

TESTS: An online test at the end of each module

METHODOLOGY AND REQUESTS :  E-learning allows the student to take the course online, train online and study in their free time. Any questions can be expressed to the tutor weekly through email, chat or the forum weekly.

 

 

CERTIFICATES: All students who pass all of the tests will receive an individual certificate.

 

 

PRICES:



YOU WILL RECEIVE A 20% DISCOUNT BY MAKING YOUR PAYMENTE BEFORE 8/16/13



- For SG user with active support plan

1st Student = u$s 300

Payment before 8/16/13 Price = u$s 240.-

 

- For SG users without active support

1st Student = u$s 600

Payment before 8/16/13 precio = u$s 480.-

 

(Additional fees not included)

 

Sign Up Now!!

TEXT SIZE: Enlarge Reduce
< Go to EVENTS