Microsoft Exam 70-433 (part 3)

I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433.  Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008.  I’m going to list the topics covered in several posts, each one will include links to details to those topics.  If you have any questions, let me know!

Working with Query Fundamentals (21 percent)

• Query data by using SELECT statements.
  This objective may include but is not limited to: LIKE, WHERE, ORDER BY, INTO
• Modify data by using INSERT, UPDATE, and DELETE statements.
  This objective may include but is not limited to: row constructors, DELETE FROM FROM, UPDATE FROM, TRUNCATE TABLE
• Return data by using the OUTPUT clause.
  This objective may include but is not limited to: INSERTED, DELETED, INTO
• Modify data by using MERGE statements.
  This objective may include but is not limited to: INSERTED, DELETED, OUTPUT
• Implement aggregate queries.
  This objective may include but is not limited to: built-in aggregate functions, GROUPING SETS, GROUP BY, HAVING
• Combine datasets.
  This objective may include but is not limited to: CROSS APPLY, OUTER APPLY, all join types; UNION, UNION ALL, INTERSECT, EXCEPT
• Apply built-in scalar functions.
  This objective may include but is not limited to: CAST and CONVERT; REPLACE; LEN and DATALENGTH; PATINDEX and CHARINDEX