977-1-4240005

MSSQL Training

MS SQL is relational database management system (RDBMS) used for storing and retrieving data. It was initially released by Microsoft Corporation in association with Sybase in 1989 and later Microsoft retained the all the rights while Sybase parted company. Since then Microsoft has released various versions in 2000, 2005, 2008, 2012 and 2014 adding more features and editions. MS SQL uses .NET or ASP languages which makes easy connection with database system.

Data management becomes tedious job if we are to manually do the data managing jobs. This has created the need for a system that provides interaction with database and users in more friendly and interactive methods. MS SQL handles basic database functions such as text data; it also can store other types of data such as graphics, audio file and other more complex formats. The ability it grants to users to quickly store and retrieve data/information and multiple users can access data at a single time has made it very popular database management system for windows servers.

This course has been designed to provide fundamental knowledge along with real time development scenarios to enable IT professionals and developers to be able to implement and manage knowledge gained during the training. This course will disseminate insights about the terminology, concepts, and skills necessary to understand database components, security requirements, graphical tools and scripts allowing students to develop skills and tools to implement their knowledge in real time application development. As well, Implementing and managing solutions, integrating SQL Server with other applications will also be highly emphasized during the training.

The training course gradually starts from Database fundamentals and then move onto associate level which will discuss at length about SQL Server, Querying MS SQL, Administrating SQL Server and Implementing Data storage with MS SQL. After the students have gained enough exposure and developed skills, the course will move onto the Expert Level where the students will be acquainted data platform. In this section, students will gain thorough knowledge about techniques, models and strategies to develop MS SQL Server with databases and designing solutions for MS SQL. Finally, the course will move onto next section where students will learn to implement data models and reports with MS SQL Server and designing Business intelligence solutions.

MS SQL Training is intended for candidates who want to learn both database development and database administrator track. MS SQL training will provide in depth knowledge about the Data Manipulation Language, Data Definition Language, designing Database using E-R diagrams, Keys, Relationships, Joins, Cursors and triggers.

At IT Training Nepal we have a pool of highly experienced and dedicated team of professionals working in Database field offering you the service as instructors. With the help of reference materials, collaborative and dynamic learning environment and professional guidelines you can surely achieve your goal to become qualified database developer/ administrator.
 

Objectives

The main objective of this course is to develop qualified professionals who will be able to administer and develop complex SQL Server.

The course objectives of this training course are:

  • To learn to develop and manage MS SQL Server databases
  • To learn to access, store, retrieve and manipulate data and queries with SQL
  • To use graphical and command tools with MS SQL
  • To develop strategies and use tools to perform monitoring and performance tuning.
  • To understand and Integrate SQL Server with .NET, MS Office and XML
  • Identify, evaluate and implement solutions and database security.

Who can join MSSQL Training?

A person who wants to work in the field of database as a database administrator or as a database developer can join this training. Since, no programming knowledge is required it is easy for people from other background to start a career in IT. If you want to go to US and start a career in database then this training is appropriate for you. It is equally important for web application developers working on asp.net technology and desktop application developers working on C#.

Prerequisites: No prior technical knowledge is required hence anyone who wants to start a career in database can join this training.

Syllabus

Module 1: MSSQL Course Syllabus

  • Introduction to MSSQL SERVER
  • Knowledge of Client Server Architecture in MSSQL SERVER
  • Introduction to SQL Server Configuration Tools
  • Difference between different version of SQL Server editions and compare its features
  • Introduction to SQL Server Management Studio and organize the workspace
  • Registering different types of servers
  • Exploring object explorer
  • Understanding database properties using management studio
  • Understanding columns properties using management studio
  • exploring security and management properties in object explorer
  • Using the query analyzer using query editor
  • Introduction to Structured Query Language
  • Difference between Data Definition Language and Data Manipulation Language
  • Understanding data types and select the correct data types to store data in a table
  • create table using CREATE TABLE SQL
  • Importance of constraints and using it
  • Identify unique records using PRIMARY KEY and UNIQUE constraints
  • Using database diagrammer tool
  • Understanding the importance of Normalization
  • Enforcing relationships using FOREIGN KEY
  • Fetch Data using Structured Query Language
  • Filter data using the where clause in SQL
  • Working with data and time
  • Working with strings and substrings
  • Converting data from one data type to another data type
  • Sorting the extracted data
  • Use of predicates in the SQL
  • Importance of Joins
  • Using inner joins in SQL
  • Using left outer joins in SQL
  • Multiplying data using cross joins
  • Understanding Complex Joins
  • Make use of Unions to stack data
  • Introduction to Sub Queries
  • Make use of sub queries in the form of expression
  • Adding sub queries as derived tables
  • Working with correlated sub queries
  • Use aggregate functions in SQL
  • Knowing how to group data set
  • Nesting aggregations by using group by clause
  • Filtering, grouping and adding grand totals and make use of having clause
  • Generating cross tab (pivot ) table
  • Knowing how to calculate cumulative sum
  • Using full text search
  • Searching for specific words
  • Using fuzzy search technique to search phrases
  • Introduction to Views
  • Create view
  • Preventing disappearing rows using views
  • Protecting schema changes using schema binding
  • Nesting of Views
  • Introduction to Distributed queries
  • Link to external data sources
  • Execute distributed queries
  • Using pass through queries
  • Insert, update, delete data
  • Using the output clause
  • Introduction to T-SQL
  • Make use of variables
  • control the procedural flow
  • examine SQL Server with Code
  • make use of temp tables
  • Understanding how to develop dynamic SQL
  • Introduction to Stored Procedure
  • Knowing how to compile stored procedure and execute it
  • Knowing how to capture RETURN values from stored procedures
  • Declaring variables and parameters
  • Creating and utilizing local variables in stored procedure
  • Passing input and output parameters in stored procedure
  • Interrogating global variables
  • Working with a cursor
  • Handling errors
  • Controlling transactions
  • Develop stored procedures that can fetch data from multiple servers
  • Execute dynamic queries by using OPENROWSET and OPENQUERY
  • Introduction to Trigger
  • Using instead of trigger
  • Knowing how to disable trigger
  • Using the update function
  • Selecting transaction data
  • Nesting of Trigger and using recursive trigger
  • Using trigger to validate complex business rules
  • Auditing data changes
  • Introduction to user defined functions
  • Creating scalar functions
  • Make use of inline table valued function
  • Using multi-statement table-valued user defined functions
  • Using apply command
  • Introduction to Indexing
  • Creating index
  • Examining query execution
  • Understanding transaction faults
  • stepping through a transaction
  • understanding lock and working with locks
  • viewing deadlocks
  • Implement conditions by using IF-ELSE statement
  • Make use of WHILE and GOTO loops
  • Identifying start and end of code blocks with BEGIN and END
  • Make use of PRINT for debugging
  • Returning data using RETURN
  • Debugging T-SQL in Management Studio
  • Knowing how to handle errors
  • communicate problems with client using RAISERROR
  • intercept errors using TRY and CATCH
  • Dealing with open transactions when an exception occurs
  • Introduction to optimization theory

After the completion of MSSQL training one can start working as a database developer or a database administrator. It is required in almost all software companies. MSSQL is in high demand in US at companies which works with huge volumes of data.

Testimonial

IT Training Nepal

Pradip Hamal

I was working as System Admin and planning enter into programming section as well. I joined SQL server training course here and now I can work as Database Administrator and programmer.  

 

15 Feb, 2014
5 / 5  stars

IT Training Nepal

Pooja Mukhiya

I wanted to learn about database system with RDBMS. I joined IT Training Nepal after consultations with my colleagues. I am really happy that I took the training; the training has instilled on me great deal of knowledge and confidence to work as Database Developer. Thanks a lot.

15 Feb, 2014
5 / 5  stars

Special Offer

  • Free Ms Access Training