SQL DBA TRAINING

 

Prince Infotech is a leading provider of SQL Server DBA Training in Guduvancheri. Excellent syllabus with Placements and Microsoft certifications.

Prince Infotech provides Real-time and Practical Training exclusively on SQL Server technologies. Prince Infotech has been providing the best possible SQL DBA Course on both Classroom Training and Corporate Training. Our SQL DBA training courses include SQL Server Development, SQL Server Database Administration (SQL DBA), Microsoft Business Intelligence (MSBI) and Windows & SQL Azure. At SQL DBA Training Institute, we provide Complete PRACTICAL & REALTIME Trainings with Certification Guidance, Case Studies and Projects exclusively on Microsoft SQL Server 2008, 2008 R2 and SQL Server 2012.

 

SQL DBA Training in Guduvancheri

Real-time Practical SQL DBA Training designed to work with all major SQL Database Administration activities including DB Design, Normalization Rules, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24×7 Lab, Certification and Job Support with one Realtime Project included in the course. Versions: SQL Server 2012 & SQL Server 2014 

 

SQL DBA Training Content & Course Syllabus

SQL DBA course content is exclusively designed with Basics through Advanced Concepts. This SQL course is specifically designed as per the Microsoft Official Curriculum (MOC) to provide COMPLETE PRACTICAL Training on SQL Server 2008, R2 and 2012 Production Database Administration (SQL DBA).

 

T-SQL [BASIC SQL SERVER]

  • SQL Server Design Architecture
  • Database Design Techniques
  • Table Design Principles
  • Data Integrity & Consistency
  • Aliasing & Naming Conventions
  • Schema Creation & Namespace
  • Views and Data Security
  • JOINS and Sub Queries
  • Indexes and Performance
  • Index Selectivity & Options
  • Stored Procedures & Tuning
  • Functions and Limitations
  • DML and DDL Trigger Types
  • System Objects & Metadata
  • Cursors Usage and Issues
  • Synonyms and Limitations
  • Transaction ACID Properties
  • Transaction Locks and Memory
  • Query Hints & Tuning Options
  • New Functions in DENALI
  • IIF and RESULT SETS in DENALI

 

BASIC ADMINISTRATION

  • Transaction Isolation Levels
  • Blocking Issues & Deadlocks
  • Partitioning Strategy & Tuning
  • DB Snapshots and Usage
  • Backup Strategies & Tuning
  • Restore and Recovery Options
  • Replication Techniques
  • Peer – Peer Replication
  • Replication Issues & Alerts
  • Log Shipping and Issues
  • Database Mirroring and Issues
  • Security Management & Issues
  • SQL Server Performance Tuning
  • Troubleshooting Issues
  • Resource Governor (I/O Issues)
  • Error Handling Measures
  • Import – Export Techniques
  • Tempdb Issues and Sizing
  • Database Cloning and Issues
  • Insdirect checkpoints
  • Optimizing SSIS Packages
  • Contained Databases in DENALI
  • Security Audits in DENALI

 

ADVANCED ADMINISTRATION

  • Certificates and Signatures
  • Cryptography & Security Keys
  • Service Broker Implementation
  • Query Troubleshooting & Tuning
  • SQL Server Profiler & Filters
  • DB Engine Tuning Advisor
  • Data Movement Procedures
  • SMO Connection & BCP Tool
  • Maintenance Plans & SSIS
  • SQL CMD & Remote Access
  • Database Mail and Alerts
  • SQL Server Clustering Issues
  • Server and DB Upgrades
  • Server Migrations & Testing
  • Policy Based Management
  • MSDTC and Server Linking
  • Client Level Statistics & Tuning
  • CPU, IO and Memory Issues
  • Always-On Availability Groups
  • Contained Databases in DENALI
  • Optimizing SSIS Packages

About Python

Python is most popular and versatile programming language. Python programming language has advanced data structures and effective object-oriented programming concept that allows the developers to write concepts in fewer links than other programming languages. The simple syntax and dynamic typing feature make python as ideal programming language for scripting and rapid application development in many platforms. This programming language is used in leading companies like Google, Yahoo, CERN and even in NASA. If you are new or just need brush-up with python programming language, you can consider taking python training in Guduvancheri at Prince Infotech.

Python programming language supports multiple programming models such as imperative and functional programming, object oriented or procedural styles. This programming language also features automatic memory management, dynamic type system and also features inclusive libraries. Being an open source platform, python programming language is used everywhere. It increases the career prospects of python developers.

Chapter 1: An Introduction to Python

  1. Introduction
  2. A Brief History of Python
  3. Python Versions
  4. Installing Python
  5. Environment Variables
  6. Executing Python from the Command Line
  7. IDLE
  8. Editing Python Files
  9. Python Documentation
  10. Getting Help
  11. Dynamic Types
  12. Python Reserved Words
  13. Naming Conventions

Chapter 2: Basic Python Syntax

  1. Basic Syntax
  2. Comments
  3. String Values
  4. String Methods
  5. The format Method
  6. String Operators
  7. Numeric Data Types
  8. Conversion Functions
  9. Simple Output
  10. Simple Input
  11. The % Method
  12. The print Function

Chapter 3: Language Components

  1. Indenting Requirements
  2. The if Statement
  3. Relational and Logical Operators
  4. Bit Wise Operators
  5. The while Loop
  6. break and continue
  7. The for Loop

Chapter 4: Collections

  1. Introduction
  2. Lists
  3. Tuples
  4. Sets
  5. Dictionaries
  6. Sorting Dictionaries
  7. Copying Collections
  8. Summary

Chapter 5: Functions

  1. Introduction
  2. Defining Your Own Functions
  3. Parameters
  4. Function Documentation
  5. Keyword and Optional Parameters
  6. Passing Collections to a Function
  7. Variable Number of Arguments
  8. Scope
  9. Functions – “First Class Citizens”
  10. Passing Functions to a Function
  11. map
  12. filter
  13. Mapping Functions in a Dictionary
  14. Lambda
  15. Inner Functions
  16. Closures

Chapter 6: Modules

  1. Modules
  2. Standard Modules – sys
  3. Standard Modules – math
  4. Standard Modules – time
  5. The dir Function

Chapter 7: Exceptions

  1. Errors
  2. Runtime Errors
  3. The Exception Model
  4. Exception Hierarchy
  5. Handling Multiple Exceptions
  6. raise
  7. assert

Chapter 8: Input and Output

  1. Introduction
  2. Data Streams
  3. Creating Your Own Data Streams
  4. Access Modes
  5. Writing Data to a File
  6. Reading Data From a File
  7. Additional File Methods
  8. Using Pipes as Data Streams
  9. Handling IO Exceptions
  10. Working with Directories
  11. Metadata
  12. The pickle Module

Chapter 9: Classes in Python

  1. Classes in Python
  2. Principles of Object Orientation
  3. Creating Classes
  4. Instance Methods
  5. File Organization
  6. Special Methods
  7. Class Variables
  8. Inheritance
  9. Polymorphism
  10. Type Identification
  11. Custom Exception Classes

Chapter 10: Regular Expressions

  1. Introduction
  2. Simple Character Matches
  3. Special Characters
  4. Character Classes
  5. Quantifiers
  6. The Dot Character
  7. Greedy Matches
  8. Grouping
  9. Matching at Beginning or End
  10. Match Objects
  11. Substituting
  12. Splitting a String
  13. Compiling Regular Expressions
  14. Flags

 

we'll one over 5 Years of experience you always the best guidance

GET STARTED