Course details

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.

Note: This course is designed for customers who are interested in learningSQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Course Outline

  • Lesson 1: Introduction to Microsoft SQL Server 2014
  • Lesson 2: Introduction to T-SQL Querying
  • Lesson 3: Writing SELECT Queries
  • Lesson 4: Querying Multiple Tables
  • Lesson 5: Sorting and Filtering Data 
  • Lesson 6: Working wit SQL Server 2014 Data Types
  • Lesson 7: Using DML to Modify Data
  • Lesson 8: Using Built-In Functions
  • Lesson 9: Grouping and Aggregating Data
  • Lesson 10: Using Subqueries
  • Lesson 11: Using Table Expressions
  • Lesson 12: Using Set Operators
  • Lesson 13: Using Window Ranking, Offset, and Aggregate Functions
  • Lesson 14: Pivoting and Grouping Sets
  • Lesson 15: Executing Stored Procedures
  • Lesson 16: Programming with T-SQL
  • Lesson 17: Implementing Error Handling
  • Lesson 18: Implementing Transactions

Prerequisites

This course requires that you meet the following prerequisites:

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
Updated on 08 November, 2015

About New Horizons Singapore

Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

See all New Horizons Singapore courses
Are you from New Horizons Singapore ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or