Video training,video training rapidshare.com,video training rapidshare,Video training megaupload,Video training mediafire,free ebook rapidshare,computers books rapidshare,Books rapidshare,Book rapidshare, Book mediafire, video tutorials
Friday, March 13, 2009
SQL Server 2005 Admin Video Training
Description
Author: Mark Long
Training Duration: 7 Hours
Number of Movies: 92
Tutorials included on this Training CD :
Welcome/Introduction
Introduction
SQL Server Overview
SQL Server History
Course Objeectives
Transact SQL
Course Overview
SQL Server Mystique
Installing SQL Server 2005
SQL Server 2005 Editions
Preparing To Install SQL Server 2005
Hardware Requirements
Working With Previous Versions
SQL Server 2005 Installation
Installing SQL Server 2005 Pt.1
Installing SQL Server 2005 Pt.2
Changing & Deleting SQL Server
Default & Named Instances
Getting Assistance
Administrative Tools
Management Studio Overview
Registering Servers
Object Explorer
Executing TSQL Queries
Management Studio Solutions
Server Configuration Manager
SQLCMD
SQLCMD Variables
Dedicated Administrator Connection
SQL Server Security
Securing SQL Server 2005
Authentication Modes Pt.1
Authentication Modes Pt.2
Principles
Permissions
Securables
Managing Logins
Managing Users
Schemas
Managing Schemas
Managing Permissions
Managing Server Permissions
Managing Database Permissions
TSQL Permissions
System Databases
System Databases
System Database Concerns
Sample Database
Databases
Creating A Database Pt.1
Creating A Database Pt.2
Database Properties & Options
Generating Scripts
Shrinking Database Files
Creating Tables Pt.1
Creating Tables Pt.2
Datatypes Pt.1
Datatypes Pt.2
Primary & Foreign Keys
Diagrams
Transaction Logs
How Transaction Logs Work
Transactions Explained
Explicit & Implicit Transactions
Location, Location, Location
Advantages Of Using Transactions Logs
Transaction Log Options
Data Storage
How SQL Server Stores Data
Fillfactor
DBCC Showcontig
SQL Profiler
Profiler
Using SQL Profiler Part1
Using SQL Profiler Part2
Automating SQL Server
Automation Overview
SQL Server Agent Service
Creating Operators
Creating Jobs Pt.1
Creating Jobs Pt.2
Creating Alerts
Alert Considerations
Database Backups
Backup Strategy
Database Recovery Models
Which Files and When
Performing A Backup
SQL Backup Statement
Transaction Log Backups
Backup Types
Restoring Data
SQL Server Recovery Process
Restoring A Database
The Restore Statement
High Availability
SQL Server High Availability
Clustering
Standby Servers
Log Shipping
Database Mirroring
Database Maintenance
Memory Management Basics
Maintenance Plan Creation
Course Wrap-Up
Course Wrap-Up
Credits
About The Author
Download
http://rapidshare.com/files/49165434/VTC.SQL2005rar.part1.rar
http://rapidshare.com/files/49165522/VTC.SQL2005rar.part2.rar
http://rapidshare.com/files/49165574/VTC.SQL2005rar.part3.rar
http://rapidshare.com/files/49165649/VTC.SQL2005rar.part4.rar
http://rapidshare.com/files/49165681/VTC.SQL2005rar.part5.rar
pass: namdatviet
Subscribe to:
Post Comments (Atom)
This site does not store any files on its server.We only index and link to content provided by other sites. In case of any query/objection regarding copyright or piracy, please inform us at youzhny197@gmail.com, we will immediately respond to you.
1 comment:
Thanks for the videos
Post a Comment