Self Study, SQL Server 2005 Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.
These Microsoft SQL Server 2005 tutorials are an excellent way for users to learn how to unleash the full power of this application. Taught by Microsoft Certified trainer Mark Long users will find learning even the more complex issues of SQL Server simple, the lessons are presented via narrated QuickTime tutorials that bring a degree of clarity that no other form of training can match. For comprehensive details of all topics covered on this training CD and a free demo see the list below. .
SQL Server 2005 Tutorial CD / DVD
Creates the perfect self-paced learning environmenton your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Try for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.
Problems Playing the Demos?
Benefits
- Professional Tuition by expert
- Free Certificate with each Tutorial
- Works on PC or Mac
Topics Covered on this Training Video Include:
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
We hope you enjoyed the free videos above. To watch all this course including the
chapters below please purchase the CD.
$99.95
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
About this SQL Server 2005 Training CD
| Title : | SQL Server 2005 |
|---|---|
| Tutor : | Mark Long
Other tutorials by Mark Long |
| Videos : | 92 Lessons- Video run time: 7 Hours |
| Availability : | Immediate Dispatch |
| Compatibility: | Vista, 98, 2000, NT, XP, Mac OS, OSX |
| Released | 2006-03-16 |
| Work files | Yes |
| Price US / Canadian Sales | $99.95   |
164 In Stock
Purchase Orders: from Schools, Colleges, Government and Military accepted
Multi User Network Version Available
This training is also available in Multi User format for Schools and Corporate users.
10 Multi User $500
10 Multi User $500 Why use this method of video training ?
- Learn SQL Server 2005 from an accredited expert in days.
- Ideal for beginners, easy to follow videos that offer visual clarity.
- Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you
- Cost effective tuition from leading expert tutors
- You control the pace, training can be stopped, rewound or fast forwarded as required.
- High Quality Tutorial Videos on CD / DVD or Online. PC / Mac Compatible. Great tuition at an affordable price
Want to hear what our customers say about our products?
Associated Tutorials:
Microsoft Transact SQL | CompTIA A+ Certification | CompTIA Network + Certification | Linux Professional Institute LPIC | Transact SQL | Microsoft Project 2003 | Adobe Dreamweaver CS4
SQL Server 2005 Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a SQL Server 2005 training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your SQL Server 2005 certificate without delay.
Instant Online Access all the Training Videos for only $30.00
Unlimited Accesss to 60,000 Training Video only $30.
Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract , No minimum period, and no commitment on your part.
You can have access to every title we list on this site for just $30 per month. When you sign up you get instant access with absolutely no restrictions or limits. Log on from any location and watch as much as you like.
When your finished cancelling is easy, just click the cancel button, that's it, no questions, your in total control.
