Administration of Microsoft SQL Server

forgot my password

Search:

Menu

Home

How it works?

Buy this course

	Discuss! Add a comment
	Add this course to my favorites
	Add a personal note
	RSS Feeds

Course's author:

MRBOOL

Notice, Tips and Published Articles.

Go to author's Space

Course stats:


Favorited:	0 times

no vote received

Features

	Textual content
	Video tutorial
	Exercise
	Source code
	Downloads
	Recommended post

Content

Notes

Discuss

Online course
Administration of Microsoft SQL Server

This course (Administration of Microsoft SQL Server) will show the installation of sql server and some advanced features and procedures for administering the database.

Installing Sql Server 2008

V�deo
1) Domain Services accounts
Description: In this lesson you will learn How to Promote a server to a Domain Controller and How to create a Domain Services accounts. |
[Mark this item as viewed]

V�deo
2) How to Start the Sql Server 2008 installation setup
Description: In this lesson you will learn How to Join a computer in the domain and How to Start the Sql Server 2008 installation setup. |
[Mark this item as viewed]

V�deo
3) Select the features
Description: In this lesson we are going to select the features that we are going to install, first we do a brief description of each feature |
[Mark this item as viewed]

V�deo
4) Authentication mode
Description: In this lesson we will be starting with the selection of the authentication mode, then the data directories. |
[Mark this item as viewed]

Tracking data

V�deo
5) Tracking data changes with CDC
Description: This video uses examples to explain how to enable and disable the CDC (Change Data Capture) feature of SQL Server 2008. |
[Mark this item as viewed]

V�deo
6) Passing a Table to a Stored Procedure
Description: This video shows us four approaches to overcome the lack of data structures in SQL Server. |
[Mark this item as viewed]

Traces

V�deo
7) Using traces in SQL Server 2008 without the Profiler
Description: The video uses examples to explain how to create two stored procedure that start and stop a trace via T-SQL commands. The commands inside the stored procedures are explained step by step, showing how to use the system stored procedure to create, starts and stop traces. |
[Mark this item as viewed]

Command Mode

V�deo
8) Command Mode and Table Valued Parameters
Description: In this video, the main concepts we are discussing here are: SQL Command Mode, and Table Valued Parameters. |
[Mark this item as viewed]

V�deo
9) If-exists and Schema tricks-SQL Server
Description: In this video, I am discussing couple of tricks that you need when writing sql code. First, I am going to discuss if-exists. Second, information_schema is important because it contains very helpful information about the tables, columns� |
[Mark this item as viewed]

Injection attack

V�deo
10) How to prevent a SQL Injection attack
Description: This video shows how this type of attack exploit simple SELECT statements and stored procedures. |
[Mark this item as viewed]

Dates and conversions

Recommended post
11) Working with dates and conversions
Description: In this article I will introduce the two types of data that the SQL Server has to work with values dates and time; how these types differ from one another as well as how they are stored; and how to work with these values. |
[Mark this item as viewed]

SQL Server Management Studio Express

Recommended post
12) Creating databases using SQL Server Management Studio Express
Description: Learn how to create databases using SQL Server Management Studio Express |
[Mark this item as viewed]