Venkat-sql-azure training

MONITORING SQL  DATABASE  PERFORMANCE TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : Monitoring  SQL  Data Base Performance Number of Students : 70 Date of the Programme : 28-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 Its features. Overview of SQL Database  Performance: Monitor databases using the Azure portal-CPU Percentage-DTU Percentage-Data IO Percentage-Database size Percentage: Monitor resource use-Impact of Data base performance-Transact SQL Stored Procedures-SQL Server system stored procedures: How to Monitoring the  resource utilization: Role of monit...

 DATA WAREHOUSING TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused :  Data Warehousing Number of Students : 80 Date of the Programme : 27-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 Its features. Overview of Data Warehousing: What is Data Warehousing-How Data warehouse helps to the business Stockholder-: Features of Data Warehousing: Terminology of Building Data Warehouse-Dimensions,Measures and Related Concepts- Additive measures- Semi-additive measures - Non-additive measures- Hierarchy- Data Mart  - Member : Terminology of Building Data WarehouseFacts -and Dimension Tab...

 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 ...