Introduction to SQL Server 2014

Introduction to SQL Server 2014
  • Querying Microsoft SQL Server 2014
  • Administering Microsoft SQL Server 2012 Databases
  • Implementing a Data Warehouse with Microsoft SQL Server 2014
  • Apply built-in scalar functions.
  • Apply ranking functions.
  • Combine datasets.
  • Create and alter DML triggers.
  • Create and alter indexes.
  • Create and alter stored procedures.
  • Create and alter tables.
  • Create and alter user-defined functions (UDFs).
  • Create and alter views.
  • Create and modify constraints.
  • Design T-SQL stored procedures.
  • Design views.
  • Implement aggregate queries.
  • Implement data types.
  • Implement error handling.
  • Implement subqueries.
  • Implement the sequence generator
  • Manage transactions.
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Modify data by using MERGE statements.
  • Optimize queries.
  • Query and Manage XML data.
  • Query data by using SELECT statements.
  • Return data by using the OUTPUT clause.
Interested to enroll to this course? Yes No