Venkat-sql-azure training

 SQL SERVER PERFORMANCE TUNING AND TROUBLESHOOTING TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused :  SQL  Server Performance Tuning and TroubleShooting Number of Students : 250 Date of the Programme : 24-08-2017 Location of the Programme : Sri Kanyaka Parameswari Arts and Science College For Women Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Overview of SQL Server Performance Tuning-how to improve indexes-how to create highly selective indexes-What is query Optimizer and how to make use of it-what is response time and total time- : Use Parameterized Queries-Limit Using OUTER JOIN-Query only when you must- Real World Knowledge How SQL Server Works In...

DEVELOPING SQL DATA BASES TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : Developing   SQL Data Bases Number of Students : 100 Date of the Programme : 25-01-2018 Location of the Programme : Paavai Engineering College. Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Databases and its Applications.    Overview of SQL Database -Benefits of Adapting  SQL-Role Features of SQL  : How to Develop a SQL Data Base - Basic Concepts In Developing a SQL Database - How to Design and Implement Data Objects - How to Manage Data Base Concurrency    Pro's and Con's of Adapting SQL  - How to Organize Data  Objects - Way To Implement Data Int...

SQL SERVER DESIGN AND IMPLEMENT VIEWS TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Server Design And Implement Views Number of Students : 120 Date of the Programme : 21-02-2018 Location of the Programme : Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers . 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its Design. Overview of SQL Server Design and Implement Views-Database Design- Design Optimization-Maintenance-Data base Maintenance : Designing Data Bases-Transact SQL-Data Tier Applications-Deploying Data tier Applications-Managing Data Tier Applications-Samples: What is Normalization-Data Integrity: Estimating the Size of the Database: Views-  SQL Server View...

OPTIMIZE DATA BASE OBJECTS AND SQL INFRASTRUCTURE TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused :  Optimize Data base Objects and SQL Infrastructure Number of Students : 110 Date of the Programme : 20-02-2018 Location of the Programme :Chennai KaaShiv Infotech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Server Execution Plans.  Overview  of Optimize Statics and Indexes- create statistics-Modifying the existing statics-update the query optimization statics-update query optimization statics : how to perform index defragmentation-Data and Index Organization- review current index usage and identify missing indexes- identify and consolidate overlapping indexes ...

 SQL SERVICE FEATURES TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused :  SQL  Server Features Number of Students : 800 Date of the Programme : 21-01-2018 Location of the Programme : Chinmaya heritage,Chetpet,Chennai Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Overview of SQL Server Features: Supported Migration Objects in SQL: Stored Procedures and Functions of SQL Server: Information about SQL Server Identify Columns: Role of SQL Server:  SQL Server migration  Core Features: How parses and transform T-SQL Stored Procedures: ...