Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft SQL SERVER - 2 weeks

Training Courses

Would you like to see more Databases courses?

Training course summary

Sponsored links

*** NO OBLIGATION TASTER SESSION - first 3 hours of the course offered for only £20! *** Only 2-3 Students per class! *** Pay for courses in instalments! *** SDS College London is a renowned IT training institute providing education to candidates around the world. As our student, you will receive training from highly experienced and qualified tutors. You will receive the best guidance on applying for jobs and starting your successful IT career. Our courses are tailored to give you practical real world commercial knowledge that will prove vital in gaining that first lucrative job. We ensure our class sizes are small, usually around 2-3 students. This enables our students to get the full attention of the tutor. To ensure absolute peace of mind, we offer a NO OBLIGATION TASTER SESSION where the first 3 hours of the course are offered for only £20. We also take payments for courses in instalments, where after paying the initial £60 booking fee the remaining balance is spread through the duration of the course. If you have any further queries, please email info@sharpdevelopment.co.uk or call 0208 980 4465. Further information about course structure and start dates can be obtained from www.sharpdevelopment.co.uk . You can also come into our office : Sharp Development Solutions, 125 Roman Road, Bethnal Green, London , E2 0QN. We look forward to hearing from you soon. The SDS Team.

Regions:
  • London
  • South East England
  • All Areas
Delivery:
  • In House
  • Distance
Category:
Difficulty:
  • Intermediate

Further Details

MODES : Evening, Weekend, Bootcamp, Distance - COST (£) : 360 (Evening, Weekend, Bootcamp, Distance) - DURATION: 2 Week - (Wed, Thu, Fri 18:30-21:30 or Sat 10:00-17:00 Sun 10:00-13:00) - SUMMARY: Learn about Microsoft SQL Server and Databases. CAREER PROSPECTS: Application Developer, Web Developer, Database Administrator --- MODULES: Microsoft SQL Server 1. What’s New in Microsoft SQL Server 2. Microsoft SQL Server 2005 Editions, Capacity Limits, and Licensing 3. Roles and Responsibilities of the Microsoft SQL Server DBA 4. I/O Subsystem Planning and RAID Configuration 5. 32-Bit Versus 64-Bit Platforms and Microsoft SQL Server 2005 6. Capacity Planning 7. Choosing a Storage System for Microsoft SQL Server 2005 8. Installing and Upgrading Microsoft SQL Server 2005 9. Configuring Microsoft SQL Server 2005 on the Network 10. Creating Databases and Database Snapshots 11. Creating Tables and Views 12. Creating Indexes for Performance 13. Enforcing Data Integrity 14. Backup Fundamentals 15. Restoring Data 16. User and Security Management 17. Transactions and Locking 18. Microsoft SQL Server 2005 Memory Configuration 19. Data Partitioning 20. Replication 21. Integration Services 22. Analysis Services 23. Reporting Services 24. Notification Services and Service Broker 25. Disaster Recovery Solutions 26. Failover Clustering Installation and Configuration 27. Log Shipping and Database Mirroring 28. Troubleshooting, Problem Solving, and Tuning Methodologies 29. Database System Tuning 30. Using Profiler, Management Studio, and Database Engine Tuning Advisor 31. Dynamic Management Views 32. Microsoft SQL Server 2005 Scalability Options 33. Tuning Queries Using Hints and Plan Guides

Guide price

£360

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net