Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

SQL SERVER DEVELOPMENT Course Details
 

Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Oct 16th @2:00PM

Faculty: Mr. Ahmed Shareef (18+ Yrs of Exp,.. & Real Time Expert)

Duration : 40 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91- 9246212143, 80 96 96 96 96


Syllabus:

SQL SERVER 2016

Basics

  • Database
  • DBMS
  • RDBMS
  • Oracle and SQL Server

SQL Server Environment

  • Introduction to SQL Server
  • Types of Servers
  • DB Life Cycle
  • Editions, Features, Hierarchy of SQL Server
  • SQL Server Management Studio Enhancements
  • SQL Server Business Intelligence Development Studio (BIDS) / SSDT

SQL Server Database

  • Types of database
  • Working with user defined databases

SQL Language

  • DDL
  • DML (INSERT, UPDATE, DELETE, MERGE)
  • TCL
  • DDL
  • DCL

Joins and Sub Queries

  • SQL Operators
  • Simple Queries
  • Built in Functions
  • Joins
  • Sub-Queries
  • Advanced Queries

Data Integrity

  • Domain Integrity
  • Entity Integrity
  • Referential Integrity
  • Normalization & Denormalization

Views

  • Create View
  • Advantage of Views
  • Updatable Views
  • Non Updatable Views
  • Indexed View

Synonyms, Sequences

Introduction to T-SQL

  • Anonymous Block
  • Stored Block

Introduction to Anonymous block

  • Basic Programming
  • Exception Handling
  • Cursors

Stored block Stored Procedures

  • System Stored Procedure
  • User Defined Stored Procedures
  • Advantages of Procedures
  • Passing In/Out Parameters
  • Altering Procedure
  • Extended Stored Procedures

User Defined Functions

  • Scalar UDF
  • Inline UDF
  • Multi Statement Table UDF
  • Table Variables, Temporary Tables

Triggers

  • DML Triggers (After | Instead of )
  • DDL Triggers
  • Magic Tables
  • Advantages of Triggers

Transactions and Locks

  • Implicit Transactions
  • Explicit Transactions
  • TCL Commands
  • Lock Types
  • Isolation Levels
  • Dead Locks
  • MS-DTC

Indexes

  • Clustered Index
  • Non Clustered Index
  • Creating Index
  • Advantages of Indexes

XML Integration

  • FOR XML
  • OPEN XML
  • XML Data Type

Security

  • Windows Authentication
  • SQL Server Authentication
  • Creating, Dropping Login
  • Database Permissions
  • Introduction to Roles, Schema

Database Maintenance

  • Backup Database
  • Restore Database
  • Deployment of Database
  • Generating T-SQL Scripts and Batches
  • System Databases and System Tables

SQL Server Agent

  • Jobs
  • Schedules

Data Transformation Services

  • BCP