For SQL Server Training and Consultancy , Please visit :  https://sqlserverprofessional.wordpress.com/

SQL Server Professional offers  Consultancy and   Hands-On  Master Training in the areas of SQL Server Development and Administration . Team has Practical Production experience of more than 20 Years in SQL Server tools and  members are certified in SQL Server Development and Administration.

Email : sqlservertraining@outlook.com

Mob: +91-9036916045 ( CEO : M A Srinivas, Bangalore, India)

Corporate houses/COMPANIES can directly deal with us to have Quality Training and Save Training and  Consultancy Costs bypassing  middle agents

About 10 to 20 % of  Revenue GENERATED is donated to charitable institution as corporate social responsibility

NOMINAL TRAINING FEES FOR FRESHERS , JOB SEEKING YOUTHS

Services in Consultancy : Auditing of Servers, Best Practices Implementation, Optimize Installation and Configuration of H/W, O/S, Database Engine, Code Reviews, Performance Optimization, Trouble Shooting, Error Fixing, Debugging, Documentation , Feature Implementation,  Tips and Tricks  etc.

Services in Training :  SQL Server Training in Development and Administration (DBA).
All Trainings are hands-on , practical business oriented use cases at different  levels for beginners (100), Experience up to 5 years ( 200), More than 5 years (300)
Administration :

•  H/W , O/S, Engine Configuration
• Auditing of existing Server,
• User Authorization and Authentication (Login, Database user, Role) , Access ( Grant, Revoke, Deny),
• Optimum Placing of files (mdf,ldf), tempdb placement, Use of appropriate RAID, database file size optimization ( initial size, incremental size),
• Policy based management, auditing
• Index de-fragmentation ( reorganize,  rebuild)
• Backup and Restore, Report tools
• Central management Server, Registered Servers
• High Availability
• Clustering, Always-on,  Replication, Mirroring, ,Log Shipping.
• Performance ( Profiler, Extended Events, Performance Monitor)

Development :

• Normalization, Entities, Attributes, Data Modeling ( Logical and Physical),
• Table Creation, Constraints( Check, Unique, Default, Foreign Key) , Appropriate data types,
• Indexes (Clustered, Non Clustered, Filtered, Include, Columnar)
• T-SQL Development :  Select, Joins (Inner, Outer, Full, Cross) , GROUP BY,ORDER BY,UNION,INTERSECT,EXCEPT,CROSS APPLY,OUTER APPLY
• Predicates ( Sargable & NON Sargable), Conditional (IF .. ELSE, CASE), Looping ( While)
• Locks ( Blocking and Deadlocks), Transaction Isolation levels ,
• RANKING Functions , CDC, Change Tracking, Auditing, XML, Execution plan analysis
• Tracing and Extended Events
• Optimized Code Development delivering right code first time and all the time ,
• Memory OLTP, Columnar Index, Temporal Tables, Row level  Security, Encrypt Database, Query Cost, Query Statistics, Stretch Database
• DOs and DONT’s, Tips and Tricks SSMS configuration and optimization

Faculty Certifications

Microsoft Certified – Querying Microsoft SQL Server 2012  : 70-461

Microsoft Certified – Administering Microsoft SQL Server 2012 : 70-462

Contact: 
Email : sqlservertraining@outlook.com
Mob: +91-9036916045 ( CEO : M A Srinivas, Bangalore, India)

•  Experience in SQL Server in production environment as developer, DBA, Database   Architect , Trainer from 1996
• SQL Server  Consultant, Corporate Trainer in SQL Server Administration and Development.
•  Managed  More than 80 servers and DB Sizes of 2 TB and above
•  Conducted  more than 4 lakh Code Reviews, Re-Written Stored Procedures , Rearranged indexes with performance improvement of more than 90%
• Conducted  Server Auditing, Configuration, Optimization, Troubleshooting, Feature Implementation, Disaster Recovery,  Backup and Restore ,High Availability
• Conducted Corporate training in SQL Server ( All Versions) in Development and Administration (DBA)
• Corporate Trainings conducted in

SQL Server  2016  / 2014 / 2012 / 2008 R2 / 2008 / 2005

• Administration (DBA)
• Development
• Performance Tuning and Troubleshooting
• High Availability( Clustering, Always ON , Mirroring, Replication, Log Shipping)
• Conducted more than 250 Trainings both internal and external

 Consultancy

• Setting up Infrastructure, Configuration
• Disaster Recovery, Performance Optimization, Trouble Shooting
• Auditing, High Availability, Security, Maintenance ,Monitoring
• Development
• Documentation

  Main Clients : 
IBM, HCL, Envestnet, Oracle, XLhealth, Variant, Pelsoftlabs, Digital Harbor , First American ,NIIT, ARM, EXCELITY,RBS, Dubai and U S Clients etc.