SQL Server

Versicle Institute of Technology
In Kolkata

You can also call the Study Centre
85840... More
Want to speak to an Advisor about this course?

Important information

Typology Course
Level Beginner
Start Kolkata
Class hours 2 hours of class
Duration 16 Weeks
Start Flexible
  • Course
  • Beginner
  • Kolkata
  • 2 hours of class
  • Duration:
    16 Weeks
  • Start:

The term DBMS refers to a software program that enables the creation and management of databases. Most of today's database systems are Relational Database Management System (RDBMS) as they have the ability to store related data across multiple tables. Microsoft SQL Server is a popular relational database management system. It has robust feature set at a lower price point than its competitors like Access. While Access suites to home and small office use, SQL Server suits to enterprise applications such as corporate CRMs and websites etc.

It is a computer application that is used to create desktop, enterprise and web based database applications. Till now, we have at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads at different levels and with various goals.

It gives us productive functionality and optimal performance with its powerful tools to solve our toughest IT challenges. It deals with complex environment with planned and developed applications for minimum of fuss.

Primary query languages of Microsoft SQL Server's are T-SQL and ANSI SQL. For creating a database driven website, then it is better off using a more robust system 'MS SQL Server'.

It uses comprehensive management capabilities for schemas, objects, security and changes. It diagnoses and resolves SQL Server performance issues before they impact end users and service levels.

Important information

Where and when

Starts Location
96L, S.P. Mukherjee Road, 2nd Floor, Hazra More, Kolkata, 700026, West Bengal, India
See map
Starts Flexible
96L, S.P. Mukherjee Road, 2nd Floor, Hazra More, Kolkata, 700026, West Bengal, India
See map

What you'll learn on the course

Data Organization
Data Integrity
Database Queries
Creating & Managing Database Tables
Database Maintenance

Teachers and trainers (1)

Versicle Institute TechnoloGY
Versicle Institute TechnoloGY

Course programme

Course Outline
  1. Introduction.
  2. Data Organization.
  3. Data Integrity.
  4. Database Designing Using E R Diagram.
  5. Identifying Keys in Tables.
  6. Normalization.
  7. Database Queries.
  8. Creating & Managing Database Tables.
  9. Database Maintenance.
  10. Indexing.
  11. Joining.
  12. Sub Queries.
  14. Stored Procedures.
  15. Triggers.
  16. Transactions.
  17. Exporting/Importing Data..

Achievements for this centre

Students that were interested in this course also looked at...
See all