Querying Microsoft SQL Server 2014


Introduction

This five-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Data-base Administration, Data-base Development and Business Intelligence. This course helps people prepare for exam 70-461.

Outcomes

After completing this course, students will gain the skills to:

  • describe the basic architecture and concepts of Microsoft SQL Server 2014
  • understand the similarities and differences between Transact-SQL and other computer languages
  • write SELECT queries
  • query multiple tables
  • sort and filter data
  • describe the use of data types in SQL Server
  • modify data using Transact-SQL
  • use built-in functions
  • group and aggregate data
  • use subqueries
  • use table expressions
  • use set operators
  • use window ranking, offset and aggregate functions
  • implement pivoting and grouping sets
  • execute stored procedures
  • program with T-SQL
  • implement error handling
  • implement transactions.

Additional Resources:

Onsite training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.




User Reviews

Good Stuff (Rating based on 11 reviews)

82%
of respondents recommend this course to a friend.


Reviewd by 11 participants
« previous12next »

Good foundation to build upon

Rating


Comment:
A lot of information is provided in the course which improved my knowledge of SQL programming however skills require further development in real life applications.

I recommend this course.

by LL
Date: 2015-11-13 16:08:37




Very informative course

Rating


Comment:
All good

I recommend this course.

by CAH
Date: 2015-11-13 15:51:44




nice course

Rating


Comment:
learnt a lot

I recommend this course.

by Ke Chen(DBA) from Sportsbet
Date: 2015-03-27 14:24:02




Good course

Rating


Comment:
Interesting Course

I recommend this course.

by
Date: 2015-02-13 16:11:38




Great course, I wish I had it earlier

Rating


Comment:
I really enjoyed the class with regards to understand the potentials and tools available for dealing with data

I recommend this course.

by A_M from Public Transport Victoria
Date: 2015-02-13 16:07:25




Course Info


Next Step

Enquire Now
Tell a Friend
Email Course Outline