Infospace Academy INFOSPACE EDUCATIONAL ACADEMY
(Registered Under SR Act XXI of 1860 Government of India, S.No. 371/ 2010)
 
 
 
SQL - Training Methodology
SQL (Structured Query Language) is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra. Its scope includes data query and update, schema creation and modification, and data access control. SQL was one of the first languages for Edgar F. Codd's relational model in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks" and became the most widely used language for relational databases.
   
Duration 1 month
   
Real time training 3 Days
   
Lab facility Unlimited
   
Placement Assistance HR assistance till you get a job
 
Assignments and Projects submission
 
Special Workshop for you on
 
♣ Seminars-You can attend seminars even afterfinishing your course
♣ Resume Preparation
♣ Interview Preparation
♣ Mock Interview
 
 
Course content  
 
Introducing Major features
Limits
Editions
Installing SQL Server
 
Basics of Database Design Normalization
Tools for Normalization in SQL Server
   
Building a Database Introducing SQL Server Management Studio
Databases
Tables
Indexes
Relations
Using T-SQL to build and alter objects
   
T-SQL Basics What is SQL?
Identifiers
Data types
Operators
Wild cards
Variables
Functions
   
SELECT Queries The SELECT clause
The FROM clause
The WHERE clause
Using Joins
ORDER BY
GROUP BY and HAVING
TOP N and TOP N%
OVER
Full-text search
   
Action Queries DELETE
TRUNCATE TABLE
UPDATE
INSERT
SELECT INTO
Locking and Show Plan What is Locking?
Monitoring and tuning Locking
Deadlocks
Application Locks
Tuning Queries with Show Plan
   
Views, Stored Procedures, and Functions Partitioning and Joining Tables with Views
Updateable views
Indexed Views
Information Schema Views
Catalog Views
Stored Procedures
Functions
   
Views, Stored Procedures, and Functions Transactions
Distributed Transactions
Rowset Functions
Ranking Functions
Cursors
Structured Error Handling
   
XML and SQL Server Using FOR XML
Using XQuery
   
Triggers INSERT triggers
DELETE triggers
UPDATE triggers
INSTEAD OF triggers
   
Triggers Understanding .NET and the CLR
Using CLR objects in SQL Server
Using the Sql namespace
   
Reporting Services The Reporting Services Architecture
Building Reports
Managing Reporting Services
   
Security and SQL Server Security modes and authentication
Fixed server roles
Database user accounts
Permissions
Database roles
Ownership chains
Conclusion  
Top      
News
 
 
  +91 44 - 6453 0991/92
                +91 9994795979
Live Chat
 
Final Year Projects 
 
Refer A Friend
 
Online Registration
 
 
Copyright 2007 © Infospace Academy.All Rights Reserved