SQL SERVER 2008 Database Developer (Skills measured by Exam 70-433)

•Ø  Implementing Tables and Views

•·         Create and alter tables.

•o   computed and persisted columns

•o    schemas

•o   Manage Permissions

•·         Create and alter Views

•o   Using views with INSERT, UPDATE and DELETE statements

•o   WITH ENCRYPTION OPTION

•o   SCHEMABINDING clause

•o   Manage permissions

•·         Create and alter indexes

•o   Clustered Indexes

•o   Non-Clustered indexes

•o   INCLUDE option

•o   FILLFACTOR option

•·         Create and modify constraints

•o   PRIMARY KEY

•o   UNIQUE KEY

•o   FOREIGN KEY

•o   Cascading referential integrity

•o   Check Constraints

•o   Default constraints

•o   Using NOCHECK

•o   Using IDENTITY

•·         Implement data types

•o   Using FILESTREAM

•Ø  Implement Programming Objects

•·         Create and alter stored procedures

•o   Procedural extensions

•o   EXECUTE AS

•o   OUTPUT parameter

•o   RECOMPILE

•o   WITH ENCRYPTION

•o   Manage permissions

•·         Create and alter user defined functions

•o   EXECUTE AS

•o   Manage permissions

•·         Create and alter DML triggers

•o   INSERTED and DELETED

•o   INSTEAD OF

•o   EXECUTE AS

•·         Create alter CLR based objects

•o   CLR based SQL function

•o   Permission sets

•·         Create and alter DDL triggers

•o   Enable and disable triggers

•·         Implement error handling

•o   TRY/CATCH

•o   RAISEERROR

•o   Custom error messages

•o   Retrieving error information

•o   @@ERROR

•·         Manage transactions

•o   BEGIN TRANSACTION

•o   COMMIT

•o   ROLLBACK

•Ø  Working with query fundamentals

•·         Query data by using SELECT statement

•o   WHERE

•o   LIKE

•o   IN and BETWEEN

•o   ORDER BY

•o   INTO

•·         Modify data by using INSERT, UPDATE and DELETE statements

•o   Inserting data from a stored procedure call

•o   Row constructors

•o   TRUNCATE TABLE

•·         Return data by using OUTPUT clause

•o   INSERTED

•o   DELETED

•o   INTO

•·         Modify data by using MERGE statement

•·         Implement aggregate queries

•o   Convenient aggregate functions

•o   GROUP BY

•o   GROUPING SETS

•o   HAVING

•·         Combine datasets

•o   All JOIN types

•o   CROSS APPLY

•o   OUTER APPLY

•o   UNION

•o   UNION ALL

•o   INTERSECT and EXCEPT

•·         Apply built-in scalar functions

•o   CAST and CONVERT

•o   REPLACE

•o   LEN and DATALENGTH

•o   CHARINDEX

•o   PATINDEX

•Ø  Applying additional query techniques

•·         Sub queries

•o   Self-contained

•o   Correlated

•·         Implement Common Table Expressions

•o   Non-Recursive

•o   Recursive

•·         Apply ranking functions

•o   ROW_NUMBER

•o   RANK

•o   DENSE RANK

•o   NTILE

•·         Manage international considerations

•o   Collations

•o   Column collation

•o   Database collation

•Ø  Working with additional SQL Server Components

•·         Implement full-text search

•o   FREETEXT

•o   CONTAINS

•o   FREETEXTTABLE

•o   CONTAINSTABLE

•o   STOPLIST

•·         Implement service broker solutions

•o   Message types

•o   Contracts

•o   Services

•o   Messages

•o   Queues

•·         Track data changes

•o   Change tracking

•o   CHANGETABLE

•Ø  Working with XML data

•·         Retrieve relational data as XML

•o   FOR XML

•·         Transform XML data into relational data

•o   OPENXML

•o   Sp_xml_preparedocument

•o   Sp_xml_removedocument

•·         Query XML data

•o   XQUERY

•·         Manage XML data

•o   XML data types

•o   XML indexes

•Ø  Gathering performance information

•·         Capture execution plans

•o   SHOWPLAN

 For Details Contact Central Office Cochin :-

Ms. Angel / Ms. Athira

     Mobile: +91 9947422200/9744166610
Land phone: 91-484-4049001 / 03
Email id: mailto:enquiry@logicindia.net
Chat ids :- Yahoo : logicchat
            Skype : logicenquiry
            GTalk : enquiry@logicindia.net