0

Querying Microsoft SQL Server 2012

Participants on this training course learn how to write Transact-SQL queries for Microsoft SQL Server 2012. The course forms the basis for all SQL Server-related training in areas such as database administration, database development, and business intelligence.



5 days

target group

  • Database administrators
  • Database developers
  • Business intelligence professionals

Contents (new)

  • Introduction to Microsoft SQL Server 2012
  • Introduction to SQL Azure
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Writing Queries over Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2012 Data Types
  • Using the Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server Metadata
  • Executing Stored Procedures
  • Programming with T-SQL
  • Inserting Error Handling
  • Inserting Transactions
  • Tuning the Query Performance


Administering Microsoft SQL Server 2012 Databases (M-10775)
Implementing a Data Warehouse with Microsoft SQL Server 2014 (M-20463)


The training course comprises 60% theory and 40% practise, and includes tips, tricks, and best practices.




  • Experience with Windows Server 2008 or 2012
  • Experience with relational databases

Our Quality Promise

Contact to our service center

DE+49 (0) 711 90363245

CH+41 (0) 584 595795

AT+43 (01) 33 2353160

FR+41 (0) 584 595454

EN+49 (0) 711 90363245

DA+49 (0) 711 90363245


We offer you this training course exclusively as an in-house course!
We will be glad to advise you personally about this topic. You can contact us directly at training@trivadis.com or by calling 0800 87 48 23 47. Simply fill in the form below (* required field), and we will get back to you without delay.
back to trainings
0

Contact now

Trivadis, Bernd Rössler, Head of Training

Bernd Rössler

Solution Manager Trivadis Training


trivadis training satisfaction guarantee

Guarantee of quality

Following completion by the participants, every single training course is assessed at the levels

  • suitability of the training room,
  • suitability of the workplace,
  • functionality of the technical equipment, and
  • satisfaction throughout the entire course / seminar,

and recorded in our "TRIVALUATION" feedback system for quality assurance purposes. This enables us to consistently ensure the high quality and satisfaction of our valued customers. We really appreciate the overall rating of 9.3 from 10 points awarded by our many enthusiastic customers.


trivadis training success guarantee

Success guarantee

Trivadis guarantees the success of your training. Having completed the course / seminar, do you have any questions about the practical aspects? Would you like to repeat any of the exercises in the lab environment?

Our success guarantee allows you to repeat individual days, or even the entire training course, free of charge for up to 6 months after attending a training course. You bring with you the course materials from the previous training course.