Training in SQL Server

I-PAD Technologies Promises the future of education in Information Technology by dedicating it self towards sharpening your technical and soft skills to improve your chances in this competitive world. Silent Features are...

Ø I-PAD Technologies assures robust, practical and industry-worth guidance and training to the student.

Ø I-PAD Technologies offers the student community a complete exposure to all application/firmware development activities carried at our offshore research center

Ø Faculties with rich teaching experience and considerable practical experience will be involved in the training program.

Ø The required infrastructure for conducting the program will be available in totally.

Ø It is assured that the program will be conducted, strictly based on agreed curriculum and time schedules with the at most professionalism.

Ø Heavy emphasis will be laid on practical issues to make the students worthy of the industry at the conclusion of the training program.

Ø Communication skills and Confidence building will be an integral part of the program.


OUR EXPERTISE

We are proud to be the pioneers in "Hardware and Networking". Just when everyone was bent upon Software, we foresaw the tremendous potential in Hardware and Networking, and successfully emerged as one of the best IT Company for Hardware and Networking Solutions and the best institute for Hardware and Networking Training. Today the two sides of its business are equally balanced. The expertise of its training is coupled with a strong commitment to provide the best Hardware and Networking solutions. This has put I-PAD Technologies in the unique position of deriving synergies between Network Solutions and IT Training. At I-PAD Technologies, we have versatile, highly qualified and certified Hardware and Networking Engineers with varied academic backgrounds and is headed by Mr.Srinivasa Rao.K. The teaching staff are in the field with the complete understanding of the IT industry, its prospects and are provident enough to see to it that you are equipped with the latest knowledge in the ever changing world of IT industry. After extensive learning, we subject our students to some Real Time situations (which is often created by our staff) and student left alone, to handle the situation, to overcome the problem, with his own solutions. In this way, he is getting experienced, even before the completion of course and is very much ready to seek the job with tremendous confidence.

In keeping view of the student's requirements, the I-PAD Technologies are providing 24-hour lab facility. The lab is also open on all Sundays / Holidays Our labs are enormous and equipped with the latest systems available in the industry today. We also have product maintenance engineers who see to it that our systems are fully functional at all times. We have a good library, shelving books with latest versions and editions covering various topics on Real Time situations and Trouble shooting, etc.


Introduction to SQL Server 2000

· Overview of Database Concepts

· Databases

o File Server and Client - Server Databases

o Relational Databases

o OLTP and OLAP Databases

o Transaction Logs

· Tables

o Records, Fields and Values

o Rows and Columns

o Null Values

o Field Properties

o Keys and Relationships

o Indexes and Constraints

o Rules and Defaults

· Views

o SQL

o Locking

o DDL and DML

o Query Plan

· Stored Procedures

o Triggers

o Transactions

o System Stored Procedures

· Ownership and Security

· Jobs, Alerts and Operators

· Replication

· Application Programming Interfaces

· Overview of SQL Server

· Programs installed with SQL Server

o Books Online

o Client Network Utility

o Server Network Utility

o Service Manager

o Profiler

o Query Analyzer

o OSQL

o Bulk Copy Program (BCP)

o Enterprise Manager

· Parts of a Database

o Tables

o Views

o Stored Procedures

o Diagrams

o Database User Accounts

o Database Roles

o User - Defined Data types

o User - Defined Functions

o Rules and Constraints

o Defaults

o Full - Text Catalogs

· SQL Server Storage Concepts

o Pages

o Extents

· Database Design and Normalization

· What is Normalization?

o Key Concepts of Normalization

· First Normal Form

o Defining First Normal Form

o Identifying a Primary Key

· Second Normal Form

o Foreign Keys and Relations

· Third Normal Form

· Boyce - Codd Normal Form

· Advanced Normalization

o Forth Normal Form

o Fifth Normal Form

· Denormalization

o Making the Trade - offs

· Tools for Normalization in SQL Server

o Identity Columns

o Constraints

o Rules

o Declarative Referential Integrity (DRI)

o Triggers

o Database Diagrams

· Transact - SQL Overview and Basics

· What is Transact - SQL?

o ANSI SQL

o SQL Dialects

o SQL Configuration Options

· T - SQL Syntax and Conventions

o Reading Syntax Diagrams

o Valid Identifiers

o Referring to Objects

o Reserved Words

· Datatypes

o Integers

o Text

o Decimal

o Money

o Floating Point

o Date

o Binary Data

o Miscellaneous

o Synonyms for Datatypes

· Operators

o Available Operators

o Operator Precedence and Grouping

· Wild Cards

· Variables

o System Global Variables

o Local Variables

· Functions

o Generating GUIs

· Executing T - SQL

o Using Query Analyzer

o Using SQL Server Enterprise Manager

o Using OSQL

· Select Queries

· Using Basic SELECT Queries

o Limiting Records with the WHERE Clause

· Using Joins

o INNER JOINS

o OUTER JOINS

o JOINing Multiple Tables

· Turning Result Sets into Reports

o Using ORDER BY

o Using GROU BY and HAVING

o Using ROLLUP

o Using CUBE and GROUPING

o Using COMPUTE and COMPUTE BY

o Using TOP N

· Full - Text Searching

o Installing and Configuring Full - Text Search

o Performing Full - Text Search

o Administrating Full - Text Search

· Linked Server queries

· Action Queries

· What are Action Queries?

· Delete Queries

o Syntax of DELETE

o Limitations of DELETE

o Examples of DELETE

o Syntax of TRUNCATE TABLE

o Limitations of TRUNCATE TABLE

o Example of TRUNCATE TABLE

· Update Queries

o Syntax of UPDATE

o Limitations of UPDATE

o Examples of UPDATE

o The WRITETEXT Statement

o The UDATETEXT Statement

· Insert Queries

o Syntax of INSERT

o Limitations of INSERT

o Examples of INSERT

o Syntax of SELECT INTO

o Limitations of SELECT INTO

o Examples of SELECT INTO

· Advanced Transact - SQL Transactions

o What are Transactions?

o The ACID Properties

o Using Transactions

o Distributed Transactions

o Transaction Tips

· Rowset Functions

o CONTAINSTABLE

o FREETEXTTABLE

o OPENQUERY

o OPENROWSET

o OPENDATASOURCE

· Cursors

o What are Cursors?

o DECLARE CURSOR

o OEN and @@CURSOR_ROWS

o FETCH and @@FETCH_STATUS

o CLOSE0

o DEALLOCATE

o A Cursor Example

· Tables

· Planning Tables

· Creating Tables

· Restricting the Data

o Enforcing Domain Integrity

o Enforcing Entity Integrity

o Enforcing Referential Integrity

o Using Database Diagrams

· Indexing

· Index Architecture

o Understanding Heaps

o Understanding Clustered Index

o Understanding Nonclustered Indexes

· Creating Indexes

o Creating Indexes with Enterprise Manager

o Creating Indexes with the Index Tuning Wizard

· Views

· Using views to Partition Tables

o Creating a View with the Create View Wizard

o Modifying a View in the View Designer

o Using Aliases in a View

o Organizing the Result Set

· Using Views to Join Tables

o JOINing Two Tables in a View

o JOINing Multile Tables in a View

· Modifying Data through a View

· Working with Indexed Views

o Considerations

o Creating Indexed Views

o Enhancing Indexed Views with Inline User - Defined Functions

· Stored Procedures

o Understanding Stored Procedures

o Using System and Extended Stored Procedures

· Using Triggers

· Understanding Triggers

o Working with INSERT Triggers

o Working with DELETE Triggers

o Working with UDATE Triggers

o Working with INSTEAD OF Triggers

· Advanced Considerations

o Combining Trigger Types

o Reporting Errors with RAISERROR()

o Recursive Triggers