Курс M2783: Разработка уровня данных для Microsoft SQL Server 2005
Цена для физических лиц, р.: 14800 Цена для юридических лиц, р.: 16500
Продолжительность курса (дней): 3
Даты (день):
Даты (вечер):
Цель: Дать слушателям знания и навыки, необходимые для разработки уровня данных в Microsoft SQL Server 2005.
Необходимая подготовка: для успешного усвоения материалов данного курса необходим навык чтения текстов на английском языке, а также следующие знания и навыки:
• Have experience reading user requirements and business-need documents. For
example, development project vision/mission statements or business analysis
reports.
• Have basic knowledge of the Microsoft .NET Framework, .NET concepts, and
service oriented architecture (SOA).
• Be familiar with the tasks that application developers typically perform.
• Understand Transact-SQL syntax and programming logic.
• Be able to design a database to third normal form (3NF) and know the trade
offs when backing out of the fully normalized design (denormalization) and
designing for performance and business requirements in addition to being
familiar with design models, such as Star and Snowflake schemas.
• Have basic monitoring and troubleshooting skills. Specifically, how to use SQL
Profiler and dynamic management views.
• Have basic knowledge of the operating system and platform. That is, how the
operating system integrates with the database, what the platform or operating
system can do, and how interaction between the operating system and the database
works.
• Have basic knowledge of application architecture. That is, how applications
can be designed in three layers, what applications can do, how interaction
between the application and the database works, and how the interaction between
the database and the platform or operating system works.
• Know how to use a data modeling tool.
• Be familiar with SQL Server 2005 features, tools, and technologies.
• Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005
credential - or equivalent experience.
In addition, it is recommended, but not required, that students have
completed:
• Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
• курс
2779 Implementing a Microsoft SQL Server 2005 Database.
• курс
2780 Maintaining a Microsoft SQL Server 2005 Database.
О нас