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 SQL Server data types Understanding column properties Creating tables, altering tables and adding constraints, relationships. Creating database diagrams
In Memory OLTP Data and delta file In Memory OLTP scenarios Delayed Durability Buffer Pool extension
Introduction to Recovery model Different type of backups Restore methods Piecemeal restore Restore scenarios Restoring System databases
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 authentication vs. Windows authentication SQL Server server-wide logins and database specific users Creating user-defined server roles Configuring contained databases.
Using SQL Server Books Online Using SQL Server Management Studio (SSMS) Using SQL Server Command Line interface Using SQL Server Configuration Manager
Understanding database indexes Checking index fragmentation and maintaining them Database statistics Understanding SQL Server Profiler Creating Traces Running server-side traces DMVs and DMFs
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.
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
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.