SQL server

இப்பயிற்சியின் மூலம் Database-ல் எப்படி ஒரு தகவலை சேமிப்பது, அழிப்பது மற்றும் எப்படி Database-ஐ மாற்றம் செய்வது உள்ளிட்டவற்றை செயல்முறை விளக்கத்துடன் விளக்குகிறோம்.

History of SQL server 2005
What is SQL server?
Why We Learn SQL Server 2005

Checklist for Installation – System Requirements
Step by Step Installation Process
Testing and troubleshooting
Opening the application for the first time

What is Database?
What is Normalization?
Second Normal Form and Third Normal Form
What is Boyce-Codd Normal Form (BCNF)?
Creating Database Using SQL Server Management Studio
Creating a Database in Query Editor

Types of SQL Statements
Data Types in SQL Server 2005
Creating Tables
Inserting Values into a Table
How to view the Table Data
Changing the structure of the table
How to change the existing data in a table
The DELETE and DROP Command

SELECT statement with Different Clauses
ORDER BY and TOP Clause
Displaying Data from a table
Filtering Rows from a Table
Operators in WHERE Clause

Aggregate Functions
Scalar Functions
Numeric Functions
Date\Time Functions
Set Operators

Creating and Using Views

An Overview of Transact-SQL
Control Statements
Looping Statements
Operators in T- SQL

Understanding Cursors
Opening and Fetching a Cursor

Creating and Using Stored Procedure
System and Extended Stored Procedure
Overview of Triggers
Instead of Trigger

Transaction Process
Controlling Transactions
Security in SQL Server 2005
Working with REVOKE

Error Handling in Transact-SQL
Using the @@ERROR Function
Handling Errors with TRY-CATCH

Introduction to Locking in SQL Server
Shared and update Locks
Exclusive Locks
Dealing with Deadlocks

Understanding Logins
Creating, Editing, and Deleting Logins
Understanding Users and Schemas
Using Schemas
Adding Users
Creating a New Role

Introduction to Full text search
Introduction to APPPLY clause in SQL Server 2005
Recursive Queries using Common Table Expressions (CTE) in SQL Server
Creating Pivot Queries
Ranking Functions I
Ranking Functions II

About Jalamma Education

Jalamma Education Centre is a premier IT Education Institute with 14 Years of Experience in providing customized and individual training for candidates in computer software technologies

Learn more

Contact Us

  • Office : 8003 Zurich, Switzerland.

    Tel   : +41 44 586 24 11
    Mob : +41 76 544 09 63
    Mob : +41 77 954 56 86
    Mob : 076 717 62 13
    Tel   : 044 272 27 372
    Mob : 086 106 07 516
    Email-Id : info@jalamma.com

© jalamma.com
Scroll to Top