image

About the MS SQL Server

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. This tutorial explains some basic and advanced concepts of SQL Server such as how to create and restore data, create login and backup, assign permissions, etc. Each topic is explained using examples for easy understanding.

Course Syllabus

Querying Microsoft SQL Server 2014(70-461) - 40 Hours
  • Foundation of Querying
  • Getting Started with Select Statement
  • Filtering & Sorting Data
  • Combining Sets
  • Grouping & Windowing
  • Querying Full - Text Data
  • Querying & Managing XML Data
  • Creating Tables & Enforcing Data Integrity
  • Inserting, Updating & Deleting Data
  • Other Data Modification Aspects
  • Implementing Transactions Error Handling & Dynamic SQL
  • Designing & Implementing T-SQL Routines
  • Using Tools to Analyze Query Perfomance
Soft Skill Training - 8 Hours
  • Basics of Communication
  • Importance of Effective Communication
  • Prepare & Deliver an Effective Presentation
  • Interview Question
  • How to prepare for an Interview
  • Resume Writting Tips
  • Identify Common Questions Asked in an Interview
Project Internship - 14 Hours