SQL Server Online Training

//

In short, Structural Query Language is called as SQL. It is the base to enter into Analytics, Datawarehouse and various jobs. Since past few years, data is increasing rapidly from multiple sources due to various reasons. Whenever data increases, SQL requirement also increases. It is a common Database language to interact with any Databases like MySQL, Postgres, SQL Server, Oracle, DB2, etc. SQL is required in most of the project related to Banking, Healthcare, Telecom, Finance, etc. This Course is designed from basic to advanced level topics based on IT industry requirement. From this course, you will learn all the topics required for real-time project work. This course will help you to build your career as the role of Development, Database/ETL Testing, Support, DBA, etc.


Course Objectives

What are the Course Objectives?
  • Understanding high-level Architecture of Database.
  • Work independently in Development, Support and Testing Project.
  • In-depth knowledge of various advanced concepts.prepare the Complex queries.
  • Upgrade database related technologies like DBA, Datawarehouse, Bigdata, ETL, etc.
Who should go for this Course?
  • Any IT experienced Professional.
  • Any B.E/ B.Tech/ BSC/ M.C.A/ M.Sc Computers/ M.Tech/ BCA/ BCom College Students in any stream.
  • Fresh Graduates
Pre-requisites:
The course can learn by any IT professional having basic knowledge of :
  • Computer System
  • DBMS Concepts

Course Curriculum

BASIC CONCEPTS

  • Database Concepts
  • RDBMS Concepts
  • Data Models
  • Constraints
  • Normalization- 1NF,2NF,3NF,BCNF etc
  • ER Diagrams

SQL SERVER CONCEPTS

  • Introduction to Sql Server 2008 R2
  • Sql Server 2008 Features
  • Server Types
  • Editions
  • Components
  • Management Studio
  • T-SQL Features
  • New Operators
  • DML Statements

T-SQL

  • DDL
  • Data Types
  • System Defined Data Types
  • User defined Data
  • Create/modify/delete tables
  • Operators
  • DML
  • DCL
  • Using Select Statement

MAINTAINING DATABASE INTEGRITY

  • Constraints
  • Rules
  • Entity Integrity
  • Domain Integrity
  • Referential Integrity

SUBQUERIES

  • Built-in function
  • Nested Sub Queries
  • Correlated Sub Queries
  • Derived tables
  • Recursive queries
  • Common Table Expression

JOINS

  • Cross Join, Inner Join, Self Join, Outer Join
INDEXES
  • Types of Indexes
  • • Creating indexes
  • Modifying indexes
  • Dropping indexes

VIEWS

  • About View
  • Creating Views
  • Altering Views
  • Materialized Views
  • Distributed View

STORED PROCEDURES

  • Advantages
  • System Stored Procedures
  • Extended Stored Procedures
  • Parameter Handling

USER DEFINED FUNCTIONS

  • Returning Scalar Value
  • Returning Table of Data
  • Deterministic Functions
  • Non Deterministic Functions

TRIGGERS

  • Constraints Vs Triggers
  • After Triggers
  • Instead of Trigger
  • DDL Triggers
  • Altering and Dropping Triggers

CURSORS

  • Select Vs Cursors
  • Types of Cursors
  • Creating Cursors
  • Open/Fetch/Close Cursors
  • Using Cursors in Stored Procedures and Triggers

MICROSOFT .NET FRAME WORK INTEGRATION

  • CLR Integration
  • UDA
  • UDF
  • Stored Procedures
  • Triggers

TRANSACTIONS AND LOCKS

  • ACID Properties
  • Implicit Transactions
  • Explicit Transactions
  • Transaction Process
  • Concurrency Problems
  • Lock Types
  • Distributed Transactions
  • Dead Locks

DATA TRANSFORMATION SERVICES

  • BCP
  • DTS

ADMINISTRATIVE TASKS

  • Creating Database
  • Copy, Maintaining Database
  • Security Concepts
  • Schemas, Permissions
  • Backup and Restore Database
  • Sql Server Agent
  • Sql Server Profiler
  • Database Engine Tuning Adviser

SQL SERVER MANAGEMENT OBJECTS

  • Programming with SMO
  • Connecting to Sql Server
  • Scripting

XML IN SQL SERVER

  • XML in Sql Server

WORKING WITH IMAGES

  • Working with Images

INTRODUCTION TO MS- BI

  • SSRS
  • Standard, Ad- hoc Embedded Reports
  • SSIS
  • SSAS

SQL SERVER 2012 FEATURES

  • Sequence
  • OFFSET and FETCH
  • WITH RESULT SETS in stored procedure THROW in triggers