Best sql Server Training institute in chennai adyar

01/05/2014 Professional & Short Term Course

Price: Check with seller

Description

Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. These platforms are picked after a thorough research and analysis based upon the existing and prospective IT industry in mind.


 


Topic 1: SQL Server Basics



  • Client-Server database architecture and SQL Server architecture

  • Installing MS SQL Server (2008, 2012 or earlier)

  • Tables, relational databases, SQL and database objects

  • Design and develop MS SQL Server databases and tables

  • Referencing objects in SQL Server databases

  • Obtaining information from database tables

  • SQL Server security


Topic 2: Understanding Tables and Databases



  • Creating databases manually

  • Creating databases with database wizard

  • Defining a maintenance plan wizard

  • Databases using Transact-SQL

  • Database manipulation: characteristics and deletions

  • Working with tables


Topic 3: Indexes and Views



  • The basics of index structures

  • Creating and working with indexes

  • Indexes and table architecture

  • Creating views (including using view manager)

  • Working with views

  • Indexed views


Topic 4: Database Diagrams, the Query Analyzer and SQL Basics



  • Working with diagrams

  • Diagramming for pubs database

  • Server connectivity and Screen management

  • Working with queries

  • SQL essentials (select, create table, insert, delete, update)


Topic 5: Stored Procedures, Triggers and Replication



  • Components of stored procedures

  • Creating and working with stored procedures/system stored procedures

  • Components of triggers

  • Creating and working with triggers

  • Replication model and types of replication

  • Merge replication


Topic 6: Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager



  • Creating, importing and exporting DTS

  • Creating, scheduling backups and restores

  • Authentication types, users, roles, security plans

  • Configuring DSN, loading analysis manager and working with cubes

  • Work on a final project



Thanks and Regards


 


Rajesh


84/8, Venkatarathinam Main Street,
Venkatarathinam Nagar, Adyar, 
Chennai - 600 020


Contact: 9840774522/ 8056102535



 

More Details

Total Views:26
Reference Id:#371257
Phone Number:9840774522
Current Rating: /5 0 Vote

Comments

Copyright © 2021 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com