MOC On-Demand: Querying Microsoft SQL Server 2014

MOC On-Demand 

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Querying Microsoft SQL Server® 2014

About this course

This 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, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Audience Profile:

This course is intended for data-base administrators, data-base developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who are not necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

At Course Completion:

At the completion of this course participants will be able 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.

Additional Resources:

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: OD20461
  • Duration: 90 Days
  • Price: $1,089.00

Next Step

Enquire Now
Tell a Friend