A guide to SQL Server courses and certification by bns26590

VIEWS: 16 PAGES: 4

									             A guide to SQL Server
             courses and certification


Excellence



Experience



   Results




                                         Contact us on:
                                         0844 871 2080
                                         info@qa.com
                                         www.qa.com
Microsoft SQL Server 2008
                                                                                                                                                                                           Learning Solutions
                                                                                                                                                                                           Information Worker Solutions
                                                                                                                                                                                           Advanced Infrastructure Solutions
                                                                                                                                                                                           Security Solutions




Certification and Course Roadmap
Course for professionals new to SQL Server
M2778
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL, 3 days



Courses for existing SQL Server Professionals
            Database                                        Database                         Business Intelligence
          Administrator                                     Developer                             Developer
COURSES                                        COURSES                                   COURSES
M6231                                          M6232                                     M6234
Maintaining a Microsoft SQL Server 2008        Implementing a Microsoft SQL Server       Implementing and Maintaining Microsoft
Database, 5 days                               2008 Database, 5 days                     SQL Server 2008 Analysis Services,
                                                                                         3 days
M6232 (Optional)                               M6231 (Optional)
Implementing a Microsoft SQL Server            Maintaining a Microsoft SQL Server 2008   M6235
2008 Database, 5 days                          Database, 5 days                          Implementing and Maintaining Microsoft
                                                                                         SQL Server 2008 Integration Services,
                                                                                         3 days
EXAM                                           EXAM
                                                                                         M6236
70-432                                         70-433                                    Implementing and Maintaining Microsoft
Microsoft SQL Server 2008                      Microsoft SQL Server 2008, Database       SQL Server 2008 Reporting Services,
Implementation and Maintenance                 Development                               3 days


                                                                                         EXAM
                                                                                         70-448
                                                                                         SQL Server 2008, Business Intelligence
                                                                                         Development and Maintenance


                                                                                                           Microsoft SQL Server 2008
                  SQL Server 2008
                                                                 SQL Server 2008                           Business Intelligence
                  Implementation and
                                                                 Database Development                      Development and
                  Maintenance
                                                                                                           Maintenance




COURSES                                        COURSES                                   COURSES                                        ADDITIONAL LEARNING
M6315                                          M6316                                     M6314                                          QASQLBI08           Microsoft Business Intelligence End to End, 5 days
(In development by Microsoft)                  (In development by Microsoft)             (In development by Microsoft)
                                                                                                                                        MSQLBIED            Microsoft SQL Server 2008 Business Intelligence
Designing, Optimising and Maintaining a        Designing, Developing and Optimising      Designing SQL Server 2008 Business
                                                                                                                                                            Essentials for Developers, 2 days
Database Server Infrastructure using           SQL Server 2008 Databases, 5 days         Intelligence Solutions, 5 days
Microsoft SQL Server 2005, 5 days                                                                                                       MSQLBI              Microsoft SQL Server 2008 Business Intelligence
                                                                                                                                                            Introduction, 3 days
                                               EXAM                                      EXAM
                                                                                                                                        MSQLDBIS            Microsoft SQL Server 2008 Database Infrastructure
EXAM
                                               70-451                                    70-452                                                             and Scalability, 3 days
70-450                                         PRO: Designing Database Solutions and     PRO: Designing a Business Intelligence         MSQLDEV             Microsoft SQL Server 2008 Essentials for
PRO: Designing, Optimising and                 Data Access Using Microsoft SQL Server    Infrastructure Using Microsoft SQL Server                          Developers, 2 days
Maintaining a Database Administrative          2008                                      2008
                                                                                                                                        M6158               Updating your SQL Server 2005 Skills to SQL Server
Solution Using Microsoft SQL Server
                                                                                                                                                            2008, 3 days
2008
                                                                                                                                        M6317               Upgrading Your SQL Server 2000 Database
                                                                                                                                                            Administration (DBA) Skills to SQL Server 2008
                                                                                                                                                            DBA Skills, 3 days

                  Database                                       Database                                  Business Intelligence        For a comprehensive guide to all our courses please visit:
                  Administrator 2008                             Developer 2008                            Developer 2008               www.qa.com/microsoft or call 0844 871 2080 for more details.




                                                                                                                                   Contact us on:
                                                                                                                                   0844 871 2080
                                                                                                                                   info@qa.com
                                                                                                                                   www.qa.com
Version 1.0 – March 2009
Microsoft SQL Server 2005
Certification and Course Roadmap
Course for professionals new to SQL Server

M50027
Querying and Processing SQL Server 2005 Data with SQL Statements



Courses for existing SQL Server Professionals

          Database Administrator                                                                                                 Business Intelligence
          and Database Developer                                                                                                      Developer
COURSES                                                                                                               COURSES
M2780                                                                                                                 M2791
Maintaining a Microsoft SQL Server 2005 Database, 5 days                                                              Implementing and Maintaining Microsoft SQL Server 2005
M2779                                                                                                                 Analysis Services, 3 days
Implementing a Microsoft SQL Server 2005 Database,                                                                    M2792
5 days                                                                                                                Implementing and Maintaining Microsoft SQL Server
                                                                                                                      2005 Integration Services, 3 days
EXAM                                                                                                                  M2793
70-431                                                                                                                Implementing and Maintaining Microsoft SQL Server 2005
Microsoft SQL Server 2005, Implementation and                                                                         Reporting Services, 3 days
Maintenance
                                                                                                                      EXAM
                                                                                                                      70-445
                                                                                                                      Microsoft SQL Server 2005 Business Intelligence –
                                                                                                                      Implementation and Maintenance

                                                                                                                                               SQL Server 2005
                          SQL Server 2005
                                                                                                                                               Business Intelligence –
                          Implementation and
                                                                                                                                               Implementation and
                          Maintenance
                                                                                                                                               Maintenance




          Database Administrator                                        Database Developer                                Business Intelligence Developer
COURSES                                                    COURSES                                                    COURSES
M2786                                                      M2781                                                      M2794
Designing a Microsoft SQL Server 2005 Infrastructure,      Designing Microsoft SQL Server 2005 Server-Side            Designing a Business Intelligence Solution for the
2 days                                                     Solutions, 3 days                                          Enterprise Using Microsoft SQL Server 2005, 2 days
M2788                                                      M2782                                                      M2795
Designing High Availability Database Solutions Using       Designing Microsoft SQL Server 2005 Databases, 2 days      Designing an ETL Solution Architecture Using Microsoft
Microsoft SQL Server 2005, 3 days                                                                                     SQL Server 2005 Integration Services, 2 days

EXAM                                                       EXAM                                                       M2796
70-443                                                                                                                Designing an Analysis Solution Architecture Using
                                                           70-441                                                     Microsoft SQL Server 2005 Analysis Services, 3 days
PRO: Designing a Database Server Infrastructure by Using   PRO: Designing Database Solutions by Using Microsoft
Microsoft SQL Server 2005                                  SQL Server 2005                                            M2797
                                                                                                                      Designing a Reporting Solution Architecture Using
AND THEN                                                                                                              Microsoft SQL Server 2005 Reporting Services, 2 days
M2787
                                                           AND THEN
Designing Security for Microsoft SQL Server 2005, 2 days   M2783                                                      EXAM
M2789                                                      Designing the Data Tier for Microsoft SQL Server 2005,
                                                           1 day                                                      70-446
Administering and Automating Microsoft SQL Server 2005
                                                                                                                      PRO: Designing a Business Intelligence Infrastructure by
Databases and Servers, 1 day
                                                           M2784                                                      Using Microsoft SQL Server 2005
M2790                                                      Tuning and Optimising Queries using Microsoft SQL Server
Troubleshooting and Optimising Database Servers Using      2005, 3 days
Microsoft SQL Server 2005, 2 days

EXAM                                                       EXAM
70-444                                                     70-442
PRO: Optimising and Maintaining a Database                 PRO: Designing and Optimising Data Access by Using
Administration Solution by Using Microsoft SQL Server      Microsoft SQL Server 2005
2005


                          Database Administrator                                     Database Developer                                         Business Intelligence
                          SQL Server 2005                                            SQL Server 2005                                            Developer SQL Server 2005
SQL Server 2005 to SQL Server 2008
Certification Upgrade Paths
If you hold an MCITP certification on SQL Server 2005 you will be able to take advantage of a one-exam upgrade path to transition
your skills to SQL Server 2008.
Each upgrade path will earn you two certifications.


                                                                                                                                    Earn both these certifications

                                                    Exam 70-453                                                             SQL Server 2008
                Database Administrator                                                                                                                               Database
                                                   Upgrade: Transition your MCITP Database Administrator Skills             Implementation and
                SQL Server 2005                                                                                                                                      Administrator 2008
                                                   to MCITP Database Administrator 2008                                     Maintenance




                                                                                                                                    Earn both these certifications

                                                    Exam 70-454
                Database Developer                                                                                          SQL Server 2008                          Database
                SQL Server 2005                    Upgrade: Transition your MCITP Database Developer Skills to              Database Development                     Developer 2008
                                                   MCITP Database Developer 2008


                                                                                                                                    Earn both these certifications

                                                                                                                            Microsoft SQL Server 2008
                                                    Exam 70-455
                Business Intelligence                                                                                       Business Intelligence                    Business Intelligence
                Developer SQL Server 2005          Upgrade: Transition your MCITP Business Intelligence Developer           Development and                          Developer 2008
                                                   Skills to MCITP Business Intelligence Developer 2008                     Maintenance




 ADDITIONAL LEARNING
 M6158 Updating your SQL Server 2005 Skills to SQL Server 2008, 3 days

 For a comprehensive guide to all our courses please visit:
 www.qa.com/microsoft or call 0844 871 2080 for more details.




                                                                                                                    Contact us on:
                                                                                                                    0844 871 2080
                                                                                                                    info@qa.com
                                                                                                                    www.qa.com

								
To top