0(0)

MCSA: SQL Sever 2016 Database Development

  • Course level: Intermediate
  • Categories Microsoft
  • Total Enrolled 0
  • Last Update February 20, 2021

Description

SQL Server 2016 Development course from VEGA aims to provide participants with core knowledge on Transact-SQL. The Transact-SQL language is used by all SQL Server disciplines including Database Management, Business Intelligence and Database Development. This course covers managing of data using Transact-SQL, querying data using advanced components of Transact-SQL, and database programming using Transact-SQL.

What Will I Learn?

  • Understand the underlying architecture and basic concepts of SQL Server 2016.
  • Familiarize with Transact-SQL and discern its differences and similarities with other query languages.
  • Write queries for multiple tables
  • Sort, filter and modify data using Transact-SQL
  • Understand different data types used in SQL Server
  • Use built-in functions, table expressions, set operators and subqueries
  • Group and aggregate data
  • Implement window ranking, offset and aggregate functions
  • Implement grouping sets and pivoting
  • Execute stored procedures, transactions and error handling
  • Programming with T-SQL
Free

Material Includes

  • Duration: Full-time- 15 Days
  • Duration: Part-time- 9 Months
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Requirements

  • Working knowledge of Relational databases and basic knowledge of Microsoft Window operating system.

Target Audience

  • This SQL Development training is meant for Database Developers, Database Administrators, and Business Intelligence personnel. SQL power users, business analysts report writers, and client application developers can also attend this course.