> > > 20461

Querying Microsoft SQL Server 2014 (20461)

Course Description Schedule Course Outline
 

Who should attend

  • Database Administrators
  • Database Developers
  • Business Intelligence professionals
  • Report Writers
  • Business Analysts
  • Client Application Developers

Prerequisites

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Course Objectives

  • 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

Follow On Courses

Course Content

This course teaches students to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines and helps people prepare for exam 70-461.

Note: This course is designed for customers who are interested in learning SQL 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.

Classroom Training
Modality: G

Duration 5 days

Price (excl. VAT)
  • Eastern Europe: 1,250.- €
  • SA Voucher: 5
Enroll now
E-Learning MOC on Demand
Modality: P
Price (excl. VAT)
  • Eastern Europe: US$ 995.-
Buy E-Learning
 
Click on the location to go directly to the booking pageSchedule
Slovenia

Currently there are no local training dates scheduled.  For enquiries please write to info@fastlane.si.

Fast Lane will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!