Basic Querying and Programming in SQL Server
This course introduces SQL Server to people who are new to this environment and need to query SQL Server databases. In this course, students will get to know the various client tools available in SQL Server, and how to work with them efficiently. The students will also learn how to write Transact-SQL queries against tables and other objects in SQL Server, for various purposes: reporting, testing, data analysis, and more.
The course includes a lot of exercises, so that the students will be able to experience what they learn. At the end of this course the students will be able to work in a SQL Server environment and write efficient queries against database objects.
The course is based on SQL Server 2014, but it is relevant also for SQL Server 2005/2008/2012.