RDBMS Essentials and T-SQL Programming

Overview

Information is a critical factor for any business to be successful. Information is extracted from data stored in databases. Today, relational databases are the most popular form of storing data. Besides storing data and extracting information, a database has to be managed effectively. Aspiring database developers should be able to efficiently implement and maintain databases. This knowledge will enable them to build robust database solutions.

Strong Foundation

Post Graduate Programme in Hardware and Networking in panvel and navi mumbaiIntensive Learning

NIIT Certification

NIIT Certification

Experienced Faculty 

About the course:

Information is a critical factor for any business to be successful. Information is extracted from data stored in databases. Today, relational databases are the most popular form of storing data. Besides storing data and extracting information, a database has to be managed effectively. Aspiring database developers should be able to efficiently implement and maintain databases. This knowledge will enable them to build robust database solutions. 
The RDBMS Essentials & T-SQL Programming course provides a learner the necessary skills to query and manage databases using SQL Server. The course starts with an introduction to the client-server architecture and an overview of SQL Server. In addition, it familiarises the students with Structured Query Language (SQL) and builds on the complexity of query handling in SQL Server with every progressing session.

Course Curriculum:

Identify the SQL Server tools

    1. Retrieve, summarise and group data
    2. Use functions to customise the result set
    3. Query data by using joins and sub-queries
    4. Manage databases, tables and result sets
    5. Manipulate data by using DML statements
    6. Create and manage indexes and views
    7. Manipulate XML data and implement a full-text search
    8. Implement batches, stored procedures, functions, triggers and transactions
    9. Monitor and optimise database performance

 

  • Able to interact in English in a classroom environment 
  • Comfortable working in the Windows environment 

Exit Profile:

After completing this course, students will: Manage and manipulate data using SQL Server

Copyright © 2019 NiitPanvel