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.
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.