Introduction to database management systems and databases

What is a database and database management system (DBMS) . Introduction to Microsoft SQL Server and its overall SQL Server Data Platform . History and Current trends of DBMS and Database Administration . Tasks of a Database Administrator.

Understanding Schemas

Understanding SQL Server data types Understanding column properties Creating tables, altering tables and adding constraints, relationships. Creating database diagrams

SQL Server 2014 Feature (Advance Topics)

In Memory OLTP Data and delta file In Memory OLTP scenarios Delayed Durability Buffer Pool extension

Backup and Restore

Introduction to Recovery model Different type of backups Restore methods Piecemeal restore Restore scenarios Restoring System databases

SQL Server 2014 Installation

Editions of SQL Server 2014 Hardware and Software pre-requisities for a successful SQL Server installation. Understanding SQL Server components. Perform a successful SQL Server 2014 installation Slipstreaming SQL Server installation with service packs. Understanding SQL Server version identifiers, installed directories and conventions.

SQL Server security

SQL Server authentication vs. Windows authentication SQL Server server-wide logins and database specific users Creating user-defined server roles Configuring contained databases.

SQL Server 2014 Administration and Development Tools

Using SQL Server Books Online Using SQL Server Management Studio (SSMS) Using SQL Server Command Line interface Using SQL Server Configuration Manager

Performance Tuning

Understanding database indexes Checking index fragmentation and maintaining them Database statistics Understanding SQL Server Profiler Creating Traces Running server-side traces DMVs and DMFs

SQL Server Architecture

Understanding SQL Server system databases. Understanding the SQL Server database structure. SQL Server files and filegroups. SQL Server Transactional logs, Recovery Models. What is the difference between SQL Server instance and database. Client-Server Communication. Attaching and detaching SQL Server databases.

SQL Server High Availability (Advance Topics)

Database Mirroring Log Shipping Replication Always On Failover cluster instance improvements Creating Always On availability groups Administering Always On Availability groups Reading secondary database copies

T-SQL and Transaction concept

Categories of T-SQL command.Concept of Transaction .Transaction faults .Isolation Levels

Qualification: 10+2/B.A/B.Com/B.Tech/B.Sc.(IT)/BCA/M.Sc(IT)/MCA/M.Tech pursuing or completed in any discipline.

Course duration will be approx for 3 months. Weekdays and Weekends batches are available. In weekdays 3 classes of 2 hours and in weekends 2 classes of 2.5 Hours.

  • Weekdays Batches : Monday - Friday - 9:00 AM -2:00 PM & 2:00 PM -6 :00 PM
  • Trainers having good practical exposure are only eligible for taking the classes of students.They share theirs own experience and guide the students accordingly according to the industry needs of professionals.We are guiding the students at each and every moment of time where they stuck.Our honest approach towards the student to trained them and try to get them establish in IT industry ASAP.

    Students Testimonial

    It is a good for new comer or experienced .Job is waiting because u get to learn which support you in industries.Join asap to make your future in IT industries !

    It Career Makers is best coaching to learn the software and improve your skill ability .
    - Brajendra Kumar

    They have excellent faculty. There is a wide range of courses that they offer, also the method of teaching is excellent unlike rest of the IT institutes today. They start from the basics and also clear each and every doubt one has practically.
    -Vasu Vimal

    I have good experience with ITCM. Good for Software Testing Learning.
    -Yash Tehlan

    It's good enough for understanding environment of IT industries .I got job with the help of ITCM Only.
    -Kshitij Arora

    Supportive and cooperative faculties.Full of zest and enthusiasm.Focused study delivery.Highly motivated morale.
    -Mudit Rastogi