Self Study, Tutorial Video on CD - DVD. Tutor Mark Long guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users
These Microsoft SQL Server tutorials are based around administrating the SQL server in a real life environment. This training CD is also an excellent resource for people wishing to take and pass the Microsoft 70 – 288 exam. Certified instructor Mark Long gives users an excellent insight into SQL admin, the training is presented using narrated QuickTime videos and easy to follow examples. Topics covered on this training course include: installation, file groups, data storage, using the query analyzer, enterprise manager admin tools, using the monitor and a lot more. Related titles Microsoft SQL Server . Watch our free Microsoft SQL Server Tutorial Videos by clicking the blue lesson links below.
Microsoft SQL Server Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn 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.
Benefits
- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac
Just Released This Week
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
A Few Words About SQL Server Overview General Database Information
A Few Words About SQL Server Overview General Database Information
- Main Purpose of a Database
- What Makes Up a Database
- Two Main Types of Databases
- Normalization
- Denormalization
- Database Relationships
- Indexes
- Proper Design
We hope you enjoyed the free videos above. To watch all this course including the
chapters below please purchase the CD.
General Administrative Responsibilities
$149.95
- Real World Administration
- Designing/Building Databases
- Data Maintenance/Transfer
- Backup/Restore of Data
- Security
- Minimum Hardware Requirements
- Hardware Compatibility
- Optimizing Hardware for SQL Server
- SQL Server 2000 Editions
- Licensing
- Multiple Instances
- Choosing a Security Mode
- Collation and Sort Selection
- Network Libraries
- Installation Methods
- Upgrading to SQL Server 2000
- Default Databases
- Installation
- Troubleshooting an Installation
- Security Overview
- Authentication Modes
- Roles
- Assigning Permissions
- Application Roles
- SQL Services
- SQL Services Issues
- System Databases
- Sample Databases
- How SQL Stores Data
- Fillfactor
- File and Log Location/Management
- Overview of Admin Tools
- Exam Considerations
- Microsoft Management Console
- Opening & Customizing the Enterprise Mgr
- Using the Enterprise Manager
- Opening and Exploring the QA
- Issuing Queries Using the QA
- Query Analyzer Features
- Graphical Query Plan
- Using a Select Statement
- Basic Syntax
- Select Options
- Important Select Considerations
- Using an Insert Statement
- Basic Syntax
- Insert Options/Considerations
- Using the Update Statement
- Basic Syntax/Options
- Important Update Considerations
- Using the Delete Statement
- Basic Syntax/Important Considerations
- Using the Create Database Statement
- Database Properties and Options
- Database Creation Considerations
- Managing File Growth
- Shrinking Database Files
- Sizing the Database
- Importance of Good Design
- How Transaction Logs Work
- What Transactions Look Like
- Location / Location / Location
- Advantages of Using Transaction Logs
- Transaction Log Options
- What Are Filegroups?
- Advantages of Filegroups
- Disadvantages of Filegroups
- Microsofts Recommendation on Filegroups
- RAID Basics
- SQL and RAID
- What SQL Profiler Does
- Opening SQL Profiler
- Using SQL Profiler
- What are Operators?
- Creating an Operator
- Considerations When Using Operators
- Automating SQL Server
- Mail Enabling SQL Server 2000
- Creating a New Job
- Scheduling a Job
- Job Notifications
- Starting/Stopping a Job
- Multi Server Jobs
- Viewing Job History
- What are Alerts
- Performance Alerts
- User Defined Alerts
- Disabling Alerts
- Considerations When Using Alerts
- Using SQL In a Distributed Environment
- Referring to SQL Server Objects
- Setting Up a Linked Server Relationship
- Backup Strategy
- Database Recovery Models
- SQL Server Backup
- Who When and Where
- System Databases
- User Databases
- Performing a Backup
- Using Multiple Devices
- SQL Backup Statement
- Tape Backup
- Backup Types
- Transaction Log Backups
- File and Filegroup Backups
- Full Backup Strategy
- Differential Backup Strategy
- Backup Review
- SQL Server Recovery Process
- Preparing to Restore a Database
- The SQL Restore Statement
- Restore Options
- Restoring Transaction Logs
- Restoring System Databases
- Bottom Line on Restoring Data
- Determining Requirements
- Clustering
- Standby Servers
- Log Shipping
- Importing and Exporting Data
- SQL Data Transport Tools
- DTS Overview
- Creating a DTS Package
- More DTS Package Functionality
- Defining Transformation Tasks Creating
- Using DTS in Various Ways
- Performance Issues
- Monitoring and Tuning Basics
- Improving Performance
- Common Monitoring Tasks and Tools
- What To Monitor
- Locks
- Dealing With Distributed Data
- SQL Server Replication
- SQL Server Replication Types
- SQL Server Replication Models
- Replication Agents
- Web Based Data Applications
- SQL Server Replication Notes
- Value of SQL Server knowledge
- Microsofts MCDBA Certification
About this Microsoft SQL Server Training CD
| Title : | Microsoft SQL Server |
|---|---|
| Tutor : | Mark Long
Other tutorials by Mark Long |
| Videos : | 154 Lessons- Video run time: 10 Hours |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2002 |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
138 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 $695
10 Multi User $695 Why use this method of video training?
- Learn Microsoft SQL Server from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application from basics to advanced 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.
- It's cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
Associated Tutorials:
Microsoft SQL Server | ASP.NET | Microsoft Visual Basic .NET | Microsoft Visual Studio .Net | Microsoft SQL Reporting Services | Crystal Reports | Microsoft Visual Basic 2008
Microsoft SQL Server Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your free 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 learn as much as you like.
When you're finished, cancelling is easy. Just click the cancel button - that's it, no questions - you're in total control.
