SQL Server

Versicle Institute of Technology
In Kolkata

Rs10001-20000
You can also call the Study Centre
85840... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Beginner
  • Kolkata
  • 2 hours of class
  • Duration:
    16 Weeks
  • When:
    Flexible
Description

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
Venues

Where and when

Starts Location Timetable
Flexible
Kolkata
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
FACULTY

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.
  13. Views.
  14. Stored Procedures.
  15. Triggers.
  16. Transactions.
  17. Exporting/Importing Data..

Compare this course with other similar courses
See all