SQL Server 2008 Training

"My company is in the process of transitioning our software product to .NET/SQL Server. I was able to gain a lot of exposure to the functionality and tools of the software. I'll be able to build upon the solid foundation of knowledge when I return to work. It was also important to my company, and to me, for me to obtain my certification and I did."

-Mary Donahoo, Springfield, IL

Get your Training Quote

• Call (800) 611-1840 for Class Schedule

• Includes roundtrip airfare and lodging (for boot camps held in Georgia and Florida only)
• Hands-on instruction by a certified instructor
• Includes all course materials and practice exams
• Includes all certification exams
• Onsite Testing
• Breakfast and Lunch provided each day

This course will guide you through the migration from an Oracle to SQL Server 2008 database.

SQL Server 2008 helps your organization manage any data, any place, any time. Store data from structured, semi-structured, and unstructured documents, such as images and rich media, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze.

SQL Server 2008 provides the highest levels of security, reliability, and scalability for your business-critical applications. To take advantage of new opportunities in today's fast-moving business world, companies need the ability to create and deploy data-driven solutions quickly. SQL Server 2008 reduces time and cost of management and development of applications.

Course Outline

• Introduction to the Microsoft Solution Framework (MSF).
• Define the Envisioning Phase, understand your business and technical goals and assess the risks
• Develop a migration plan from Oracle on Unix to SQL Serveron Windows
• Identify the different tasks required to migrate from Oracle to Sql Server
• Define the processes required to migrate the Oracle architecture to SQL Server
• Develop and implement the steps to migrate Oracles schemas to SQL Server
• Develop and implement the steps to migrate database users from Oracle to Sql Server
• Migrate the application data from Oracle to Sql Server
• Identify and processes needed to successfully test the migrated objects from Oracle to SQL Server
• Convert the SQL and PL/SQL code from Oracle to SQL Server
• Utilize Sql Servers SSMA tool to convert your Oracle database to SQL Server 2008
• Define and automate the major steps during the migration process
• Use the assessment report to determine the size and cost of the conversion
• Convert Oracle tables, functions, stored procedures, views and sequnces
• Identify context sensitive information and provide output
• Utilize the Migration Tester in SSMA to automate all of the converted Oracle based code

CED Solutions is your best choice for SQL 2008 , SQL 2008 training, SQL 2008 certification, SQL 2008 boot camp, SQL 2008 certification training, SQL 2008 certification course, SQL 2008 course, SQL 2008 class.