Course Detail

SQL SERVER Course

SQL SERVER Course - Hi-Tech Academy


Course Detail


Course Description

SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.


Expected Skills

* Learn Database models
* Overview of SQL Server Management Studio and Transact-SQL language
* Master writing simple and complex queries that retrieve data from the database
* Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
* Insert, update, and delete data
* Retrieve data from tables
* Joins
* Sub-queries
* Working with Data Types
* Procedure and Functions
* Understand the different Views
* Working with Triggers
* Design a database
* Maintain databases, tables, and sequences with SQL statements
* Create and manage views
* Ensure the integrity of multiple, related database updates by using transactions
* Retrieve data using cursors
* Manage binary data using BLOBs

Institute Overview

Ranchi, Jharkhand, India

Hi - Tech is a leading name in the computer training industry. We are known for churning out globally competent professionals who are miles ahead of others in skill set, knowledge and ability to deliver. We have a wide bouquet of IT courses that are... Read More

Related Courses

Google Map