> > > 20461

Querying Microsoft SQL Server 2014 (20461)

Course Description Kurs tarihleri Course Outline
 

Kimler katılmalı

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

önkoşullar

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

Kurs hedefi

  • 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

Kurs içeriği

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.

 
Reservasyon için şehir adını tıklayınKurs tarihleri
Türkiye

Currently no local training dates available.  For enquiries please write to info@fastlane.si.

Fast Lane bütün garanti Kurs tarihlerini katılımcı sayısı her ne olursa olsun gerçekleştirmektedir. Mücbir sebepler veya diğer öngörülemeyen olaylar, kaza yada hastalık gibi durumlarda bir dersin uygulanması imkansız.
Instructor-led Online Training WebEx aracılığıyla VoIP ortamında gerçekleştirilir. Herhangi bir online kurslar hakkında sorularınız varsa, bize bu numaradan +49 (0)40 25334610 ulaşabilir veya e-mail ile info@flane.de iletişime geçebilirsiniz.
This is a FLEX course, which is delivered both virtually and in the classroom.
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!