Call us on +91-9994528354
enquiry@thinkup.in
INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS AND DATABASES
- What is a database and a 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
SQL SERVER 2012 INSTALLATION
- Editions of SQL Server 2012
- Hardware and Software pre-requisities for a successful SQL Server installation.
- Understanding SQL Server components.
- Perform a successful SQL Server 2012 installation
- Slipstreaming SQL Server installation with service packs.
- Understanding SQL Server version identifiers, installed directories and conventions.
SQL SERVER 2012 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
SQL SERVER 2012 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 DATABASE OBJECTS
- Understanding Schemas
- Understanding SQL Server data types
- Understanding column properties
- Creating tables, altering tables and adding constraints, relationships.
- Understanding the filetable
- Creating database diagrams
SQL SERVER BACKUP AND RECOVERY – PART 1
- Introduction to Backup and Recovery strategy for databases.
- Full Database backups using SIMPLE Recovery Model
- Full Database and Transactional log backups with FULL Recovery Model
- Backup history and maintenance
- Designing Maintenance plans for Backup Tasks
- SQL Server Agent for scheduling backups
- Database Mail for email notifications to DBAs
SQL SERVER BACKUP AND RECOVERY – PART 2
- Introduction to Database Restore and Recovery
- Full database restore
- Full database restore and recovery of transactional logs
- Restoring system databases
SQL SERVER DATA EXPORT AND IMPORT (DATA MOVEMENT)
- Partial Data export and import using the command line tools – BCP command
- Partial Data export and import using GUI tools – Export and Import Wizard
- Move or copy a full database
SQL SERVER SECURITY
- SQL Server authentication vs. Windows authentication
- Auditing database logins using SQL Server Error Logging
- SQL Server server-wide logins and database specific users
- Creating user-defined server roles
- Configuring contained databases
PERFORMANCE TUNING – PART 1
- Understanding database indexes
- Checking index fragmentation and maintaining them
- Database statistics
- Understanding SQL Server Profiler
- Creating Traces
- Running server-side traces
PERFORMANCE TUNING – PART 1
- Understanding the Extended Events architecture
- Creating and configuring an Extended Events session
- Using an extended events session to monitor system performance
Students Works
-
Name: Krithika
Course: Exchange 2010
Comments: Excellent Training, Very well Knowledges trainer are here, Good place to learn
-
Name: Hilda Thabitha
Course: Java
Comments: Good Infrastructure, Explains the concept clearly, Doubts are cleared immediately, practical session are interesting and eagar to learn more
-
Name: Stanley Ruban
Course: IBM TSM
Comments: I have no negative feedback about the institute, the follow up done through phone call for classes is nice, A very good trainer with good experience.
-
Name: Ashok Kumar
Course: SAS
Comments: Overall it was good to study here, Trainer are very good and friendly
-
Name: Vikram
Course: Oracle DBA
Comments: Provides real time training working in company, Calm Environment, Administration was good, trainer has great knowledge in DBA, Great sense of humor , passionate down to earth, Very helpful
