Bel ons nu!
040-2924747
MCTS Microsoft SQL Server 2008 - Database Development Microsoft SQL MCTS Microsoft SQL Server 2008 - Database Development Microsoft Software Development MCTS Microsoft SQL Server 2008 - Database Development M70-433 MCTS Microsoft SQL Server 2008 - Database Development Duur: 3 lesdagen Besparing tot € 700,00 Doorlooptijd: 3 weken Prijs: € 1.475,00 Tijdwinst: 2 lesdagen Samenvatting M70-433 is een “Blended” cursus van in totaal 3 dagen klassikale training in combinatie met zelfstudie. De cursus bestaat uit drie trainingsdagen die verdeeld zijn over drie weken. Iedere week is er een klassikale lesdag en besteedt de cursist 4 tot 6 uur aan zelfstudie. In de zelfstudie tijd kunnen de cursisten aan de hand van de studieprogrammering de theoretische elementen bestuderen. De cursus Miles70-433 behandelt de stof van de MOC cursus 6232 Implementing a Microsoft SQL 2008 Database. Officieel beslaat deze cursus 5 lesdagen. Naast de geselecteerde onderwerpen uit het officiële Microsoft MOC cursusmateriaal krijgen de cursisten de beschikking over de MSPress trainingkit - MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development, E-learning: - Implementing and Maintaining a Microsoft SQL 2008 Database - en het Transcender proefexamen. Een professioneel opgezette studieplanner faciliteert de leidraad voor de studie en de voorbereiding op het Microsoft exam 70-433 TS: Microsoft SQL Server 2008, Database Development Short Description This three-day instructor-led course provides students with product knowledge and skills needed 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 database development. After completing this course, students will be able to: Create databases and database files. Create data types and tables. Use XML-related features in Microsoft SQL Server 2008. Plan, create, and optimize indexes. Implement data integrity in Microsoft SQL Server 2008 databases by using constraints. Implement data integrity in Microsoft SQL Server 2008 databases by using triggers. Implement views. Implement stored procedures. Implement functions. Implement managed code in the database. Manage transactions and locks. Use Service Broker to build a messaging-based solution Extra studiemateriaal MOC workbook MSPress Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development E-learning E-Mentoring Tips & tricks Proefexamen Studieplanner Download hier de volledige cursusomschrijving: Before attending this course, students must have: Working knowledge of Transact-SQL Working knowledge of Relational databases. Core Windows Server skills. Database design skills. SQL Server skills - ability to write Transact-SQL queries or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. Onderwerpen Creating Databases and Database Files MDF/LDF Tables, Relationships, Columns, Datatypes (new in 2008), Collation Filestreams Filegroups Partitioning Views Select, Group By, Join, Having, Sub Queries Union, intersect, except Delete, Insert, Update, Truncate Output, Merge T-SQL Intro T-SQL programming/syntax (Variables, loops, if then) Stored Procedures, User Defined Functions, Triggers (DML) Cursors, Temp tables Advanced T-SQL CTE, recursive queries APPLY (CROSS/ OUTER) Pivot/ unpivot Rank Functions: RANK, ROW_NUMBER, Fulltext Functions: CONTAINS, FREETEXT, STOPLIST Error handling Management scripting Temp tables System Functions System Stored Procedures Dynamic Management Views + Catalog Views DBCC XML XML datatype XSD, XPath, XQuery Indexes Clustered, non-clustered, include columns, indexed views Index management (Reorganize, rebuild, DBCC) Sparse columns Table and index compression SOA DDL triggers Event notifications Service Broker HTTP Webservices Microsoft exam 70-433 TS: Microsoft SQL Server 2008 – Database Development
Pagina wordt geladen...
