Blog Archives

The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers. Also see course SQL250: Transact-SQL for Developers

In this course, you’ll establish a solid foundational understanding of database concepts and terminology. Then you’ll master the use of various Microsoft tools to submit queries quickly and efficiently get the results you want. We teach students how to write a query the same way that SQL Server processes a SQL statement – following a … Continue reading SQL250: Transact-SQL for Developers

In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output. You’ll gain a foundation understanding of a SQL Server database and use the tools available to … Continue reading SQL101: Introduction to Transact SQL