Cauta cursuri
Vezi toate categoriile

Course 6232B : Implementing a Microsoft SQL Server 2008 Database

535 EURO
482 EURO
+ TVA
Reducere prin Studentie.ro 10%
  Curs cu prezenta
  40 ore
Predare in limba: Romana
Date incepere curs: 27 Mai 2013
Diploma de participare: DA
Examen certificare inclus: NU
Reducere :
• 20% pentru grup de 5 si mai multe persoane

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

 

Before attending this course, students must have:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.

• Working knowledge of Transact-SQL.

• Working knowledge of relational databases.

• Some experience with database design.
 

 

Obiective invatare / Abilitati dobandite

After completing this course, students will be able to:
•Understand the product, its components, and basic configuration.
•Work with the data types supported by SQL Server.
•Design and implement tables and work with schemas.
•Design and implement views and partitioned views.
•Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
•Identify the appropriate table structures and implement clustered indexes and heaps.
•Describe and capture execution plans.
•Design and implement non-clustered indexes, covering indexes, and included columns.
•Design and implement stored procedures.
•Implement table types, table valued parameters, and the MERGE statement.
•Describe transactions, transaction isolation levels, and application design patterns for highly-concurrent applications.
•Design and implement T-SQL error handling and structured exception handling.
•Design and implement scalar and table-valued functions.
•Design and implement constraints.
•Design and implement triggers.
•Describe and implement target use cases of SQL CLR integration.
•Describe and implement XML data and schema in SQL Server.
•Use FOR XML and XPath queries.
•Describe and use spatial data types in SQL Server.
•Implement and query full-text indexes.

Trainer

Bogdan Tarla

Bogdan Tarla este unul dintre primii profesionisti IT care si-a dezvoltat cariera alaturi si impreuna cu Pro Management, facand parte din echipa de elita a trainerilor nostri de peste 10 ani.Expertiza sa tehnica si pasiunea pentru lucrul bine facut garanteaza ca absolventii sai pleaca din sala de curs cu experienta unui training de “top quality”. Printre specializarile sale se numara: Microsoft Visual Studio .Net, 2005 / 2008, SQL Server 2000/2005/2008, Microsoft Office 2003/2007, Project 2003/2007, dar si tehnologii altele decat Microsoft:Oracle, DB2, Cristal Reports. Bogdan este deasemenea unul dintre primii MVP pentru Romania cu competenta Visual Studio Tools for Office si unul din speaker-ii prezenti constant la evenimentele anuale organizate de Microsoft Romania (MSDN Briefing si Technet ) sau cele exceptionale organizate cu prilejul lansarii de noi produse. Bogdan a fost prezent an de an la sesiunile internationale“Train the Trainers” precum si la conferintele internationale Microsoft TechEd . Certificari: Microsoft Certified IT Professional, Microsoft Certified Technology Specialist, Microsoft Certified Professional Web / Windows / Enterprise Applications Developer SQL Server 2005, Microsoft Certified Database Administrator, Microsoft Certified Trainer, Microsoft Office Specialist Master Instructor, Microsoft Most Valuable Professional (VSTO).
Structura cursului

 

 
Cui se adreseaza?

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Adresa / Locatie desfasurare curs
Str. Dr. Raureanu, Nr. 1, Et. 1, Sector 5 (Pe Calea Victoriei, vis a vis de Muzeul National de Istorie)