Microsoft - MCTS SQL Server 2005

Varaktighet

Varaktighet:

Bara 5 dagar

Metod

Metod:

Klassrum / Uppkopplad / Hybrid

Nästa datum

Nästa datum:

6/2/2023 (Måndag)

Overview

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge of and expertise in the technologies with which they work. Microsoft Technology Specialists are consistently capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology..

The goal of our 5 day accelerated Microsoft SQL Server 2005 certification is to provide IT professionals with the knowledge and skills necessary to design, implement and administer Microsoft SQL Server 2005 databases. This is an accelerated, fully immersed course, designed upon the job-related tasks of a DBA.

The course is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.

The SQL Server 2005 Course is Appropriate for:

  • Database administrator
  • Database analysts
  • Database developers

Firebrand Training is unlike any other "boot camp". With Firebrand Training, you will learn more. We offer accelerated training courses that ensure professionals will emerge with thorough knowledge of the products in the shortest possible time. 

Instructors are available at all times to provide individual and group attention, lead lab exercises and practice sessions, and ensure the students' success. Our attention to detail shows in our unsurpassed instruction and customer service, our classroom and testing facilities, and our individual and corporate success stories.

From the skilful crafting of our unique curriculum and careful selection of courseware to every detail of your training comfort, Firebrand Training is the best way to obtain SQL 2005 skills. Other training providers cannot match our commitment to quality instruction-led training and top-notch educational facilities.

Här är 8 skäl varför du ska genomföra din SQL 2005 hos Firebrand Training:

  1. Du blir utbildad och certifierad på bara 5 dagar. Hos oss får du din utbildning och certifiering på rekordtid, en certifering du också genomför här på plats som en integrerad del av den intensiva, accelererade utbildningen.
  2. Allt är inkluderat. Ett engångsbelopp täcker alla kursmaterial, examen, boende och mat och erbjuder det mest kostnadseffektiva sättet att erhålla din SQL 2005 kurs och certifiering på. Och detta utan några oannonserade ytterligare kostnader.
  3. Du klarar SQL 2005 certifieringen första gången eller kan gå om kursen kostnadsfritt. Det är vår garanti. Vi är säkra på att du kommer klara din certifiering första gången. Men skulle du mot förmodan inte göra det kan du inom ett år komma tillbaks, delta i hela kursen igen, och bara betala för eventuella övernattningar och din examen. Allt annat är gratis.
  4. Du lär dig mer.Traditionella utbildningsdagar pågår kl. 09.00-16.00 med långa lunch- och fikapauser. Hos Firebrand Training får du minst 12 timmars effektiv och fokuserad kvalitetsutbildning varje dag tillsammans med din instruktör, utan vare sig privata eller arbetsrelaterade störande moment.
  5. Du lär dig SQL 2005 snabbare. Vi kombinerar de tre inlärningsmetoderna (Presentation|Övning|Diskussion) så att vi därigenom genomför kursen på ett sätt som säkerställer att du lär dig snabbare och lättare.
  6. Du är i säkra händer.Vi har utbildat och certifierat 134.561 personer, vi är auktoriserad partner med alla de stora namnen i branschen och har dessutom vunnit åtskilliga utmärkelser med bland annat ”Årets Learning Partner 2010, 2011, 2012, 2013 och 2015” från Microsoft Danmark och Gazelle priset 2013 - 1. plats för region Själland i Danmark med en tillväxt om 1.430% sedan 2009.
  7. Du lär dig inte bara teorin. Vi har vidareutvecklat SQL 2005kursen med fler praktiska övningar som ger dig det extra du behöver för att kunna lösa praktiska problemställningar och klara din certifiering.
  8. Du lär dig från de bästa. Våra instruktörer är de bästa i branschen och erbjuder en helt unik blandning av kunskap, praktisk erfarenhet och passion för att lära ut.

Benefits

So what makes SQL Server 2005 compelling? The following short list highlights some

Enhanced features

  • T-SQL enhancement
  • Performance improvements
  • Backup enhancements
  • Online-maintenance operations
  • Business-intelligence enhancements
  • Management-GUI enhancements
  • Security enhancements
  • Increased memory usage with
  • Standard Edition
  • XML enhancements
  • SSIS enhancements (formerly DTS)
  • Better e-mail handling
  • 64-bit support

New features

  • Common Language Runtime (CLR)
  • Service Broker
  • New product versions
  • High-availability features
  • Data encryption
  • Database Tuning Advisor
  • Dedicated administrator connection

So now that you have decided to upgrade to or deploy SQL Server 2005 - why educate?

As SQL Server continues to mature, more and more features are added to the base product. This is both good and bad. The plus side is that you get more than just a database engine. The down side is that you have a lot more to learn. The days of being of being an expert on every aspect of SQL Server are over -- but this doesn't mean that you can't still use these new features. If you are only using the product's base functionality you are missing out on a wealth of functions. Case in point: Analysis Services, SQL Server's business analysis tools. This product has been available for several years and most people that use SQL Server have never taken advantage or know little about it.

What are the benefits of certification?

For IT managers, certification is particularly important because it allows them to more easily identify the skills that an individual possesses. When a company has employees that possess certain skills, it can garner a competitive advantage when seeking to attract customers. Certification can also contribute to increased productivity, because studies have shown that certified individuals are generally quicker to implement and design new technologies. And of course by knowing that their employees are certified, IT managers can feel more confident about their ability to implement and support a network infrastructure.

Individuals

  • Overwhelmingly, individuals with Microsoft certifications have an advanced level of knowledge, expertise and skill, and command more professional credibility.
  • The MCDBA certification is recognized as a particularly elite indication of an database administrator's prowess and skill level, and these professionals are highly sought by employers.
  • Individual students may receive college credits to utilize tuition reimbursement programs for their IT training or to complete college coursework.

Human Resources

  • Employer-funded training and certification programs are a key to retaining skilled IT staff. Career development and advancement opportunities are shown to significantly reduce rates of employee turnover.
  • Certification Training Programs provide benchmarks for hiring and promotion decisions by accurately assessing technical skills.
  • For-certification training programs maximize educational investments through immediate validation of skills.

 Microsoft certification affords special membership benefits

  • Technical information, product information and exclusive discounts on products and services through a secured section of the Microsoft website.
  • Microsoft logos and certificate for your personal promotion to clients or potential employers.
  • Invitations to Microsoft conferences and other educational opportunities.
  • Access to the secure Microsoft Certified Professional Magazine Online website.

Curriculum

Firebrand Training provides thorough instructor-led training to ensure that you learn the fundamentals and obtain hands-on skills. You will emerge able to immediately apply your new knowledge in your career environment.

Firebrand Training has an aggressive educational schedule that thoroughly covers all essential elements necessary to become skilled as an SQL Server 2005 professional.

  • Day 1  Using Transact-SQL to retrieve data from SQL Server 2005
  • Day 2  Implementing a Microsoft SQL Server 2005 Database
  • Day 3  Maintaining a Microsoft SQL Server 2005 Database
  • Day 4  Introduction to SQL Server Services
  • Day 5  Exam - 70-431
  • Microsoft SQL Server 2005 - Implementation and Maintenance

Firebrand Training is a Microsoft Certified Partner : Learning Solutions (formerly CTEC). We specially select Microsoft Press or MOC Courseware for the highest-standard training of SQL Server 2005.

Through lecture, group discussion and hands-on lab work, you will learn how to:

  • Use the Development Tools provided with SQL Server 2005
  • Use Transact-SQL enhancements to perform database development tasks
  • Develop XML-based Solutions using SQL Server 2005
  •  Build Message-Based Services with the Service Broker
  • Implement Web Services using Native HTTP Endpoints
  • Build Notification Services Applications
  • Implement Database Functionality with Managed (.NET) Code
  • Build Client Applications with the .NET Framework
  • Build Administrative Applications with SQL Management Objects (SMO)
  • Describe the components of SQL Server 2005
  • Describe new and enhanced features for administrators in SQL Server 2005
  • Plan a SQL Server 2005 installation
  • Install SQL Server 2005
  • Maintain a SQL Server 2005 installation
  • Choose the appropriate tool or utility to perform an administrative task
  • Use SQL Server Management Studio to manage databases
  • Use SQL Server Computer Manager to manage a server
  • Use the sqlcmd utility to execute Transact-SQL from the command prompt
  • Use SQL Management Objects to script common administrative tasks
  • Use SQL Profiler to monitor SQL Server 2005
  • Use DDL triggers to respond to DDL events
  • Use event notifications to respond to database events
  • Query SQL Server metadata
  • Maintain indexes in a SQL Server 2005 database
  •  Use the Database Tuning Advisor to assist with database design
  • Maintain SQL Server 2005 databases
  • Describe the security architecture of SQL Server 2005
  • Manage securables and principals
  • Manage permissions
  • Use certificates in SQL Server 2005
  • Describe common disaster recovery enhancements in SQL Server 2005
  • Use database snapshots
  • Perform backup and restore operations
  • Describe the data availability technologies included in SQL Server 2005
  • Describe the concepts of database mirroring
  • Configure database mirroring
  • Describe the enhancements to replication functionality in SQL Server 2005
  • Describe the new types of replication available in SQL Server 2005
  • Configure replication using SQL Server 2005.

Exam Track

Microsoft Certified Technology Specialist on SQL Server 2005 candidates are required to pass Exam 70-431.

Skills Being Measured

The 70-431 certification exam measures your ability to implement and maintain a SQL Server 2005 database. This program shall prepare students in the job skills listed in the following matrix:

  • Installing and Configuring SQL Server 2005
  • Configure SQL Server 2005 instances and databases
  • Configure SQL Server security
  • Configure linked servers by using SQL Server Management Studio (SSMS)
  • Implementing High Availability and Disaster Recovery
  • Implement database mirroring
  • Implement log shipping
  • Manage database snapshots
  • Supporting Data Consumers
  • Retrieve data to support ad hoc and recurring queries
  • Manipulate relational data
  • Manage XML data
  • Implement an HTTP endpoint
  • Implement Service Broker components
  • Import and export data from a file
  • Manage replication
  • Maintaining Databases
  • Implement and maintain SQL Server Agent jobs
  • Manage databases by using Transact-SQL
  • Back up a database
  • Restore a database
  • Move a database between servers
  • Monitoring and Troubleshooting SQL Server Performance
  • Gather performance and optimization data by using the SQL Server Profiler
  • Gather performance and optimization data by using the Database Engine Tuning Advisor.
  • Monitor and resolve blocks and deadlocks
  • Diagnose and resolve database server errors
  • Monitor SQL Server Agent job history
  • Gather performance and optimization data by using DMVs
  • Creating and Implementing Database Objects
  • Implement a table
  • Implement a view
  • Implement triggers
  • Implement functions
  • Implement stored procedures
  • Implement constraints
  • Implement indexes
  • Create user-defined types
  • Implement a full-text search
  • Implement partitions.

What's Included

Our accelerated program includes the most comprehensive industry courseware available - which serves as excellent post-class reference material.

Included:

  • MCTS Training Kit: Implementing & Maintaining SQL Server 2005 Book/CD Package
    ISBN: 9780735622715

Microsoft Official Curriculum

  • MOC 2779 BC (Implementing a Microsoft SQL Server Database)
  • MOC 2780 BC (Maintaining a Microsoft SQL Server Database)

Prerequisites

Students who are successful in accelerated SQL 2005 certification training may possess

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Experience with database design

Är du redo för din Firebrand kurs?

Vi intervjuar alla potentiella deltagare om deras bakgrund, utbildning, certifiering och personliga inställning. Om du kommer igenom denna process så har du riktigt goda möjligheter att klara din certifiering.

Firebrand Training erbjuder en ambitiös utbildningsmiljö som förutsätter att du verkligen dedikerar dig till kursen. Ovanstående förkunskaper är endast vägledande, många deltagare med mindre erfarenhet men med en annan bakgrund eller kunskap har framgångsrikt genomfört sin utbildning hos Firebrand Training.

Om du funderar på huruvida du uppfyller rekommenderade förkunskaper vänligen ring oss på (0)8 52 50 01 66 och prata med en av våra utbildningsrådgivare som kan hjälpa dig.

Kundreferenser

Vi har utbildat 134.561 kursdeltagare under 12 år. Vi har bett alla göra en utvärdering av vår accelererade utbildning. För närvarande har 96,55% sagt att Firebrand överträffat deras förväntningar:

"This was a rewarding but often gruelling experience that provided a 100% focus on learning SQL Server 2008. This is the best course that I have ever attended and I will use Firebrand Training again for an equivalent Oracle course."
Steve Page, Napp Pharmaceuticals. (12/4/2010 (Måndag) till 16/4/2010 (Fredag))

"If you struggle to concentrate on your common 5 day training courses then Firebrand is the course for you! My instructor made the course. The instructor was vastly knowledgeable, yet managed to deliver the course in a style that kept you alert for the 12+ hours a day. "
Alexander Kennedy, Conde Nast Publications Ltd. (12/4/2010 (Måndag) till 16/4/2010 (Fredag))

"This is the most intensive learning I have ever done! But no matter how I learn, the lecture, practice and review structure meant that it was all taken in by the end of the week and one exam passed (very unexpectedly!!!) Coming into the course being new to SQL technology I was apprehensive about the outcome. However the quality of the teaching, and structure of the learning meant that, despite it being physically draining, it was the most well spent week of my IT career. I would thoroughly recommend this to anyone who is serious about getting this qualification and doesn't mind putting in a weeks worth of hard graft to get the result."
Neil Rutland. (9/11/2009 (Måndag) till 13/11/2009 (Fredag))

"The Firebrand Training experience is superb if you enjoy working at a fast pace. Though the days are long they really don't seem because you are constantly using your brain and learning."
Andrew Price. (9/11/2009 (Måndag) till 13/11/2009 (Fredag))

"As per usual you guys were great. Came knowing little and really only wanted to learn and wasn't that bothered with passing the exam - it was only important that I came away knowing more than I did at the start. Aced the exam though!"
Dai Williams, Howden. (9/11/2009 (Måndag) till 13/11/2009 (Fredag))

Kursdatum

Startar

Slutar

Tillgänglighet

Plats

Registrera

22/8/2022 (Måndag)

26/8/2022 (Fredag)

Avslutad - Lämna feedback

-

 

 

6/2/2023 (Måndag)

10/2/2023 (Fredag)

Begränsat antal platser

Rikstäckande

 

20/3/2023 (Måndag)

24/3/2023 (Fredag)

Platser tillgängliga

Rikstäckande

 

1/5/2023 (Måndag)

5/5/2023 (Fredag)

Platser tillgängliga

Rikstäckande

 

12/6/2023 (Måndag)

16/6/2023 (Fredag)

Platser tillgängliga

Rikstäckande

 

Senaste recensioner från våra studenter