Resume Videos... Projects... Certificates... More...

Mike M Eghtebas
Database Development, Web Programming




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.

Sample questions I have answered at online:arrow
SQL Update QueryUser control event firing multiple times c#SQL Server 2008 R2 - Strip most all text but keep specific textMVC - combining two field in a drop down from joint tableMysql, ordering results by the highest score (inner query)Values only change when i use the mouseSQL Query SyntaxAccess 2003 query, long list of "or" not workingSQL Script helpLink two temp tables to get a result setHow to Club Rows in One Row As Others - SQL ServerSelect first occurrence of record in SQL ServerTRIM ; out of a text Fieldfind duplicate column within a groupInsert Record if no records found - SQLTOP N BY GROUPIIF to include Null Values from TableHow to remove, then re-add table constrainsql DateDiff helpT-SQL CTE for finding Parent, Prior Peer, Next Peer, ChildSQL 2005 - Exclude records from SelectSQL Server Transpose , partially at leastUser Defined Function