تفاصيل الدورة

This instructor led 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. This course helps people prepare for exam 70-461. Many of the exercises in this course are SQL Azure enabled.

After completing this course, students will be able to:

  • Write SELECT Queries
  • Query Multiple Tables
  • Use Built-In Functions
  • Use Subqueries
  • Execute Stored Procedures
  • Use Set Operators
  • Implement Error Handling
  • mplementing Transactions
  • Use Table Expressions
  • Sort and Filter Data
  • se Window Ranking, Offset and Aggregate Functions
  • Query SQL Server Metadata
  • Program with T-SQL
  • Improve Query Performance
تحديث بتاريخ 06 November, 2018

نبذة عن معهد NetAssist

As the forerunner of infocomm technologies, we are committed to providing the highest quality of training to IT professionals, both novice and experienced. We are an advanced IT training and professional certification provider and have, since established in year 1999, provided the most comprehensive classroom education in the industry. Training with us provides you with valuable hands-on learning and in-depth instruction in a highly structured environment. Our experts are there to support you in the sharpening of your technical skills. 

عرض الجميع دورات NetAssist
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على SQL Server ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

لم تجد ما كنت تبحث عنه؟

أو