MS SQL Course

MS SQL

​Course Overview

Database designers have incredible scope of business activities which create colossal information. Microsoft has intentionally conveyed this partner level SQL Server Training to make the individual skilled in creating Microsoft SQL Server database. This course giving information of utilizing highlights of SQL Server item and the related tools to build up a database.

MS SQL Server is a relational database the (RDBMS) system created by Microsoft. Developed for storing and recovering information as required by different applications. It very well may be run either on a similar PC or on another over a system. This course clarifies some essential ideas of SQL Server like how to store and manipulate data, make login and permissions, authorizations, and so forth.

This SQL Server course gives you all the Transact-SQL training they have to make database objects like Tables, Views, Stored methods and Functions and triggers in SQL Server. And implementing Queries and Sub-questions, working with Joins and more.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data. 

Anyone who already have knowledge on SQL, Relational Databases and SQLite. Students Individuals moving into a database stream as administrator.

Further, you will learn SQL to effectively use a server-side scripting language, like PHP or ASP which is essential to building a website that differentiates data from the database. For learning Microsoft SQL no programming languages required.

You get hired if you complete the course by the companies Amazon, American express, Philips, LinkedIn, Toyota, flipkart and many more

The main topics covered in this course are: Introduction to Microsoft SQL Server, Installing and Configuring SQL, SQL Server Development Tables, Data Types, Views, Constraints, Stored Procedures, SQL Top and Clause, Overview and Intro on SQL Server DBA, Microsoft Business Intelligence (MSBI) & Architecture, SQL Server Reporting Services (SSRS) and more.

MS SQL Course Syllabus

Introduction to Microsoft SQL Server

  • Overview of SQL Server Management Studio and Transact-SQL language
  • History of SQL Server versions, and Editions available
  • SQL Server Versions and Editions, service, and component
  • An Overview of DBMS Technology
  • Distinction between client server and file server databases
  • SQL Table basics, data types and functions.
  • Installation of SQL server – editions, authentication modes, and services
  • Roles and responsibilities of DBA
  • Tools used in server side client in SQL

Installing and Configuring SQL

  • Pre installation steps, Installations 2012/2014/2016
  • Viewing installation process with LOG files.
  • Adding or removing components, installing service packs
  • Configuring various Services, Startup Parameters
  • Configuring default backup folder and configuring services

SQL Server Development – Tables, Data Types, Views, Constraints

  • Overview of System Databases, File groups and Files
  • Database Architecture.-Data Files, Log Files, Extents, Page architecture
  • Database Configuration Options, Creating a Database, Database Snapshots
  • System Tables and System Views, System Data Types
  • Creating a Table, Table Variables vs. Temporary Tables
  • Special Data Types, User-Defined Data Types, Table Types
  • Primary Key, Foreign Key and Unique Constraint
  • Partitioning Setup, Operations on a Partitioned Table
  • Purpose Of Views, Simple and Complex Views
  • Clustered Index, Non Clustered Index, Creating , Altering and Dropping Indexes
  • Encryption and Schema Binding Options in creating views

Stored Procedures, SQL Top and Clause

  • Stored Procedure Interfaces, Creating and Executing Stored Procedures
  • Advantages of Stored Sub Programs compared to Independent SQL Statements
  • Types of User Defined Functions Scalar Functions, and Table Valued Functions
  • Permissions on User Defined Functions
  • Purpose of Triggers, Creating, Altering and Dropping Triggers
  • Differences between Stored Procedures and User Defined Functions and Triggers
  • Overview, Types of Joins, Explanation of Joins
  • Conditional Statements- If else, and Goto
  • Loops- WHILE, For, FOR Each, Break, Continue
  • SQL Query Types- SELECT, INSERT, UPDATE, DELETE, UNION
  • SQL CLAUSES-DISTINCE, FROM, WHERE, ORDER BY, GROUP BY, HAVING

Overview and Intro on SQL Server DBA

  • Blocking & Deadlocks, Backup Strategies Restore Techniques
  • Replication Entities, Replication Architecture, Replication Agents.
  • Types of Replications, Configuring Replication, Snapshot Replication
  • Handling the Exception using TRY…CATCH
  • SQL server Indentation & Guidelines for writing Code
  • SQL Developer Summary using Live Project

Microsoft Business Intelligence (MSBI) & Architecture

  • Introduction to Business Intelligence- SSIS, SSRS, SSAS
  • BI Solutions Planning Solutions Designing Data Warehouses
  • Introducing SQL Server Reporting Services, Managing Reporting Services
  • Testing, Tuning BI Solutions, Performance Measurements,
  • Creating a Metadata Database

SSIS (SQL Server Integration Services) Overview

  • SSIS History, SSIS Architecture, Creating a Simple Package
  • SSIS Tools- Import and Export Wizard, SQL Server Data Tools
  • SQL Server Management Studio, Command-Line Utilities
  • SSIS Tasks- Looping and Sequence Tasks, Data Preparation Tasks, Workflow Tasks
  • Administration Tasks, Execute Package Task
  • Sequence Containers, For Loop Container, Groups
  • Data Flow, and Sources & Destinations
  • SSIS transaction, error handling, Event Handling
  • Using Variables, Parameters and Expressions
  • Deployment Models, Package Configuration, Security

SQL Server Reporting Services (SSRS)

  • Creating Tabular and List Reports, Grouping and Sorting, and Calculation and Formatting
  • Report Types, Creating Matrix Reports, and Charts
  • Learn how to enable and control report caching
  • Managing Reporting Services and configure for deployment
  • Creating a Report Template, and Saving the Report Template
  • Designing the Header and Adding a Header and Footer
  • Setting Report Properties, and Renaming Report Items

SQL Analysis Service (SSAS)

  • Overview to SSAS,OLTP and OLAP
  • Configuring Dimensions with SSAS, Build, Deploy, and Process, and Browsing the Dimension
  • Creating and Configuring SSAS Cubes, Making a Test Copy of a Cube
  • Schema’s and Dimensions, Measures and Aggregates
  • Creating Cube and Browsing Cube, Working with Data Source
  • SSAR reporting, Types of Reports, Creating Groups, and Exporting Reports