Polish SQL Server User Group (PLSSUG)

NAZWA EGZAMINU: TS: Microsoft SQL Server 2008, Implementation and Maintenance

CERTYFIKAT: Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance

PODSTAWOWE WYMAGANIA:
Candidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles. These job roles include the following:
•IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
•IT professionals who manage systems that run SQL Server 2008
•IT professionals who work with third-party applications that are built on SQL Server 2008
•Developers who build applications that use SQL Server 2008

SZCZEGÓŁOWE WYMAGANIA:
Strona 70-432 na PLSSUG

NAZWA EGZAMINU: TS: Microsoft SQL Server 2008, Database Development

CERTYFIKAT: Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development

PODSTAWOWE WYMAGANIA:
Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:
•IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
•IT professionals who manage systems that run SQL Server 2008
•Developers who build applications that use SQL Server 2008
•IT professionals who work with third-party applications that are built on SQL Server 2008

SZCZEGÓŁOWE WYMAGANIA:
Strona 70-433 na PLSSUG

NAZWA EGZAMINU: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

CERTYFIKAT: Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance

PODSTAWOWE WYMAGANIA:
Candidates for this exam are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services. The qualified candidate for this exam typically has:
•One to two years of experience working with the Microsoft .NET Framework
•Two to three years of experience using SQL Server 2005 BI components
•Six months to one year of experience using SQL Server 2008
•Experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
•Experience using Microsoft SQL Server Management Studio (SSMS)
•Knowledge of relational and multi-dimensional database schemas
•Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
•Experience creating and deploying a data mining model in SSAS
•Experience writing relational and multi-dimensional database queries
•Experience creating and deploying SQL Server Reporting Services (SSRS) reports
•Experience authoring and deploying SQL Server Integration Services (SSIS) packages
•Experience debugging, monitoring, and troubleshooting BI solutions

SZCZEGÓŁOWE WYMAGANIA:
Strona 70-448 na PLSSUG

NAZWA EGZAMINU: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

CERTYFIKAT: Microsoft Certified IT Professional: Database Administrator 2008

PODSTAWOWE WYMAGANIA:
Candidates for this exam work in an environment in which Microsoft SQL Server 2008 is used for database solutions. Candidates should have at least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle. Candidates should also have experience with the following:
•Defining high-availability solutions
•Data distribution
•Automating administrative tasks (for example, checking db stats, backups)
•Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
•Defining security solutions
•Monitoring and troubleshooting the database server
•Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
•Designing and executing deployments
•Deployments and migration
•Defining the infrastructure (for example, storage, hardware, and number of servers or instances)

SZCZEGÓŁOWE WYMAGANIA:
Strona 70-450 na PLSSUG

NAZWA EGZAMINU: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

CERTYFIKAT: Microsoft Certified IT Professional (MCITP): Database Developer 2008

PODSTAWOWE WYMAGANIA:
Candidates for this exam typically work in an enterprise environment that has more than 500 personal computers and more than 100 servers and mostly create solutions for all types of enterprise issues. Candidates should have experience with the following:
•Writing transact SQL queries
•Programming the database
•Troubleshooting programming objects (for example, stored procedures, triggers, user-defined functions [UDFs], user-defined types [UDTs], and queries)
•Database performance tuning and optimization
•Designing databases at both the conceptual and logical levels
•Implementing databases at the physical level
•Might be involved in designing and troubleshooting the data access layer of the application
•Gathering business requirements

SZCZEGÓŁOWE WYMAGANIA:
Strona 70-451 na PLSSUG

NAZWA EGZAMINU: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

CERTYFIKAT: Microsoft Certified IT Professional (MCITP): Business Intelligence Developer 2008

PODSTAWOWE WYMAGANIA:
Candidates for this exam are IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools. The qualified candidate for this exam typically has two to three years of experience in the following:
•Working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
•Using the SQL Server 2005 and SQL Server 2008 Business Intelligence Development Studio (BIDS)
•Designing both relational and multidimensional database schemas
•Writing both relational and multidimensional queries
•Designing and building cubes
•Designing and creating reports
•Applying data mining algorithms to business problem domains
•Aggregating data from multiple sources into a data warehouse in a heterogeneous data environment
•Designing and managing enterprise-level solutions for multidimensional databases
•Collecting and interpreting business requirements

SZCZEGÓŁOWE WYMAGANIA:
Strona 70-452 na PLSSUG