Skip to Content

Certificate in RDBMS with T-SQL ​

This course introduces you to basic concepts and architecture of database management systems. The course

further explains the need and the types of data models used by industry. Further, it illustrates the basic

concepts of relational models. Concepts like relation, relational operator, and normalization are also

discussed.

Table of Contents

  • Appreciate SQL Server as a database server
  • Identify the SQL Server tools
  • Retrieve data
  • Use functions to customize the result set
  • Summarize and group data
  • Query data by using joins
  • Query data by using subqueries
  • Manage result sets
  • Manage databases
  • Manage tables
  • Manipulate data by using DML statements
  • Manipulate XML data
  • Create and manage indexes
  • Create and manage views
  • Implement a full-text search
  • Implement batches
  • Implement stored procedures
  • Implement functions
  • Implement triggers
  • Implement transactions
  • Monitor performance
  • Optimize performance

Start with the customer – find out what they want and give it to them.

WE WOULD LIKE TO HEAR FROM YOU 

Learn about our financing options for this programme.

Contact us