"I would rather entertain and hope that people learned something than educate people and hope they were entertained."
-Walt Disney

Training >> Courses Offered >> SQLServer 2012

Download printable copy Download printable copy

About SQLServer 2012 Course

Image

SQL Server 2012 course offers a powerful way of managing the database information.The SQL Server online training provides a way to create databases, generating transaction over different sql servers.SQL server videos will provide a complete detailed explanation about how to deal with SQL Server management studio.

SQLServer 2012 Course Objectives

  1. Understand the architecture of SQL Server
  2. Understand how SQL Server handles memory and threading
  3. Read query plans
  4. Assign indexes
  5. Use the new T-SQL operators
  6. Use the XML data type
  7. Use Reporting Services
  8. Take advantage of CLR integration to write great performing applications

Prerequisites

No Details

SQLServer 2012 Course Duration

20 Hours
  • Collapse Basic Database Concepts
      1. Concepts of Data, Metadata, Files
      2. Concepts of DBMS
      3. Database Models
      4. File Management Systems
      5. Relational Database Systems
      6. Procedural & Non procedural approaches
      7. Database Design
      8. E.F.Codd's Rules
  • Collapse Normalization
      1. First Normal Form
      2. Second Normal Form
      3. Third Normal Form
  • Collapse Introduction to SQL Server
      1. Features of SQL Server
      2. Different Editions of SQL Server
      3. Components of SQL Server
      4. Services of SQL Server
      5. Comparison of SQL Server with Oracle
  • Collapse Database Design
      1. Logical & Physical database design
      2. Relational database design
      3. Creating databases
  • Collapse Management Studio
      1. Basics of SQL
      2. Data types, expressions, operators
      3. Working with Queries & Clauses
      4. Creating Databases
      5. Creating Tables, Stored Procedures
      6. Working with Indexes & Views

Trainer Profiles

A well known trainer at Deccansoft for more than 3 years, she is a specialist in SQL Server 2008 and has taught well over 300 students. Her uniqueness lies in conducting her classes with ease and clarity, making her students understand even the most complex queries with no difficulty at all. Her class sessions are also now available as videos, targeting students who want to learn the course at their own pace and convenience. more

facultyImg
Vandana Soni

Enquire with us

Email Id:
Contact No:
Course:
Subject:
Details:
CaptchaImage refresh