Microsoft

Microsoft Technology Associate, MTA 98-364

MTA Database track, data platyform adminstration and business intelligence. Passed on January 2015. MTA 98-364

Querying Microsoft SQL Server 2012

Querying Microsoft SQL Server 2012
Recived Certificate of Completion for course 20-461 covering:
Create database objects (tables, views, indexes, constraints, etc.)
Queries (select, sub-queries, implement data types, aggregate queries, xml data)
Scheduled to pass Microsoft Exam 70-461 on December 22, 2015.

Expert Exchange.com

Master 50,000 points (count: 11)

Guru 150,000 points (count: 3)

Wizard 300,000 points (count: 1)

Microsoft Access Database

Sage 500,000 points (count: 1)

Microsoft Access Database

Genius 1,000,000 points (count: 1)

Microsoft Access Database

Sample questions I have answered at experts-exchange.com online:

• SQL Update Query
• User control event firing multiple times asp.net c#
• SQL Server 2008 R2 - Strip most all text but keep specific text		
• MVC - combining two field in a drop down from joint table
• Mysql, ordering results by the highest score (inner query)

• Values only change when i use the mouse
• SQL Query Syntax
• Access 2003 query, long list of "or" not working
• SQL Script help
• Link two temp tables to get a result set

• How to Club Rows in One Row As Others - SQL Server
• Select first occurrence of record in SQL Server
• TRIM ; out of a text Field
• find duplicate column within a group
• Insert Record if no records found - SQL
				
• TOP N BY GROUP
• IIF to include Null Values from Table
• How to remove, then re-add table constrain
• sql DateDiff help
• T-SQL CTE for finding Parent, Prior Peer, Next Peer, Child

• SQL 2005 - Exclude records from Select
• SQL Server Transpose , partially at least
• User Defined Function