SQL Server Programming
Computer
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
Module 1: SQL Server Overview
Module 2: Overview of Programming SQL Server
Module 3: Creating and Managing Databases
Module 4: Creating Data Types and Tables
Module 5: Implementing Data Integrity
Module 6: Planning Indexes
Module 7: Creating and Maintaining Indexes
Module 8: Implementing Views
Module 9: Implementing Stored Procedures
Module 10: Implementing Triggers
Module 11: Optimizing Query Performance
Module 12: Managing Transactions and Locks
|
|
||||||||||||
SQL Server Programming
Module 1: SQL Server Overview
Topics:
What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Module 2: Overview of Programming SQL Server
Topics:
Designing Enterprise Application Architecture
SQL Server Programming Tools
The Transact-SQL Programming Language
Elements of Transact-SQL
Additional Language Elements
Ways to Execute Transact-SQL Statement
Module 3: Creating and Managing Databases
Topics:
Creating Databases
Creating Filegroups
Managing Databases
Introduction to Data Structures
Module 4: Creating Data Types and Tables
Topics:
Creating Data Types
Creating Tables
Generating Column Values
Generating Scripts
Module 5: Implementing Data Integrity
Topics:
Types of Data Integrity
Enforcing Data Integrity
Defining Constraints
Types of Constraints
Disabling Constraints
Using Defaults and Rules
Deciding Which Enforcement Method to Use
Module 6: Planning Indexes
Topics:
Introduction to Indexes
Index Architecture
How SQL Server Retrieves Stored Data
How SQL Server Maintains Index and Heap Structures
Deciding Which Columns to Index
Module 7: Creating and Maintaining Indexes
Topics:
Creating Indexes
Creating Index Options
Maintaining Indexes
Introduction to Statistics
Querying the sysindexes Table
Setting Up Indexes Using the Index Tuning Wizard
Performance Considerations
Module 8: Implementing Views
Topics:
Introduction to Views
Advantages of Views
Defining Views
Modifying Data Through Views
Optimizing Performance by Using Views
Performance Considerations
Module 9: Implementing Stored Procedures
Topics:
Introduction to Stored Procedures
Creating, Executing, Modifying, and Dropping Stored Procedures
Using Parameters in Stored Procedures
Executing Extended Stored Procedures
Handling Error Messages
Performance Considerations
Module 10: Implementing Triggers
Topics:
Introduction to Triggers
Defining Triggers
How Triggers Work
Examples of Triggers
Performance Considerations
Module 11: Optimizing Query Performance
Topics:
Introduction to the Query Optimizer
Obtaining Execution Plan Information
Using an Index to Cover a Query
Indexing Strategies
Overriding the Query Optimizer
Module 12: Managing Transactions and Locks
Topics:
Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
