Course details

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Course Outline

  • Lesson 1: Introduction to Microsoft SQL Server 2012
  • Lesson 2: Getting Started with SQL Azure
  • Lesson 3: Introduction to T-SQL Querying Lesson 4: Writing SELECT Queries
  • Lesson 5: Querying Multiple Tables
  • Lesson 6: Sorting and Filtering Data
  • Lesson 7: Working with SQL Server 2012 Data Types
  • 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: Querying SQL Server Metadat
  • Lesson 16: Executing Stored Procedures
  • Lesson 17: Programming with T-SQL 
  • Lesson 18: Implementing Error Handling
  • Lesson 19: Implementing Transactions
  • Lesson 20: Improving Query Performance

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