SQL SERVER

Description

SQL SERVER is Microsoft relational database management system is a software product which primarily stores and retrieves data requested by other applications. … SQL is a special-purpose programming language designed to handle data in a relational database management system.

Key Features

This impeccable Microsoft SQL Server Training Course is exclusively designed for aspiring Data Analysts, Business Analysts, Data Scientists, MSBI / Power BI Engineers and SQL Database Developers. This course is applicable for both starters as well as for experienced professionals. This course includes SQL Basics, T-SQL Queries, Query Writing and Query Understanding required for Data Analysts and Business Analysts.

  • 24 Hrs. Instructor Led Training
  • Certification & Job Assistance
  • Customized Schedule
  • Pay in 2 Installments
  • Good Theory Material
  • We Provide Class Videos
  • Real -Time Project

Course Curriculum

Chapter 1: SQL SERVER INTRODUCTION
  • Data, Databases and RDBMS Software
  • Database Types: OLTP, DWH, OLAP
  • Microsoft SQL Server Advantages, Use
  • Versions and Editions of SQL Server
  • SQL: Purpose, Real-time Usage Options
  • SQL Versus Microsoft T-SQL [MSSQL]
  • Microsoft SQL Server – Career Options
  • SQL Server Components and Usage
  • Database Engine Component and OLTP
  • BI Components, Data Science Components
  • ETL, MSBI and Power BI Components
  • Course Plan, Concepts, Resume, Project
  • 24 x 7 Online Lab for Remote DB Access

Software Installation Pre-Requisites

Chapter 2: SQL SERVER INSTALLATIONS
  • System Configuration Checker Tool
  • Versions and Editions of SQL Server
  • SQL Server and SSMS Installation Plan
  • SQL Server Pre-requisites: S/W, H/W
  • SQL Server 2016 / 2017 Installation
  • SQL Server 2019 Installation
  • Instance Name and Server Features
  • Instances: Types and Properties
  • Default Instance, Named Instances
  • Port Numbers, Instance Differences
  • Service and Service Account Use
  • Authentication Modes and Logins
  • Windows Logins and SQL Logins
  • File Stream and Collation Properties

DB Engine and Replication Components

Chapter 3: SSMS Tool, SQL BASICS - 1
  • SQL Server Management Studio
  • Local and Remote Connections
  • System Databases: Master and Model
  • MSDB, TempDB, Resource Databases
  • Creating Databases: Files [MDF, LDF]
  • Creating Tables in User Interface
  • Data Insertion & Storage. Limitations
  • SQL: Purpose and Real-time Usage
  • SQL Versus T-SQL: Basic Differences
  • DDL, DML, SELECT, DCL and TCL
  • Creating Tables using SQL Scripts
  • Data Storage, Inserts – Basic Level
  • Table Data Verifications with Select

SELECT Statement for Table Retrieval

Chapter 4: SQL BASICS - 2
  • Creating Databases & Tables in SSMS
  • Single Row Inserts, Multi Row Inserts
  • Rules for Data Insertion Statements
  • SELECT Statement @ Data Retrieval
  • SELECT with WHERE Conditions
  • Batch Concept and Go Statement
  • AND & OR Operators Usage
  • IN Operator and NOT IN Operator
  • Between, Not Between Operators
  • LIKE and NOT LIKE Operators
  • UPDATE Statement & Conditions
  • DELETE & TRUNCATE Statements
  • Logged and Non-Logged Operations
  • ADD, ALTER and DROP Columns

ALTER & DROP Table Statements

Chapter 5: JOINS, T-SQL Queries : Level 1
  • JOINS – Table Comparisons Queries
  • INNER JOINS For Matching Data
  • OUTER JOINS For (non) Match Data
  • Left Outer Joins with Example Queries
  • Right Outer Joins with Example Queries
  • FULL Outer Joins – Realtime Scenarios
  • Join Queries with “ON” Conditions
  • Join Unrelated Tables in SQL Server
  • NULL, IS NULL Operators in Joins
  • CROSS JOIN and CROSS APPLY
  • CROSS JOIN Versus CROSS APPLY
  • One-way & Two Way Data Comparisons
  • Important Join Queries in T-SQL

Join Options: Merge, Loop, Hash

Chapter 6: Group By, T-SQL Queries Level 2
  • GROUP BY Queries and Aggregations
  • Group by Queries with Having Clause
  • Group by Queries with Where Clause
  • Using WHERE and HAVING in T-SQL
  • Rollup: Usage and T-SQL Queries
  • Cube: Usage and T-SQL Queries
  • UNION and UNION ALL Operators
  • Comparing Where, Having Conditions
  • GetDate, Year, Month, Day Functions
  • Rollup with Having & Grouping
  • Date and Time Functions in T-SQL
  • Convert Functions with DateTime
  • DateTime Styles, DateAdd, DateDiff
  • String Functions: Trim, SubString

StringSplit, Concat, Len, Left, Right

Chapter 7: JOINS, T-SQL QUERIES Level 3
  • Self-Referencing Keys, Candidate Key
  • Adding PK to Existing Tables
  • Adding FK to Existing Tables
  • Self Joins and Table Aliases
  • Join Queries with Group By, Aggr
  • Views For T-SQL Query Store
  • Fetch, Offset, Next Rows, Order By
  • Joins with Group By, Sub Queries
  • Formatting with IIF and CASE
  • Formatting with Cast, Convert
  • Using Joins with Nested Sub Queries
  • Sub Queries and Alternatives to Joins
  • Excel Pivot Tables and Reports
  • Pie Charts & Data Refresh Options
Chapter 8: View, SPs, Function Basics
  • Views: Types, Usage in Real-time
  • System Predefined Views and Audits
  • Listing Databases, Tables, Schemas
  • Function Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • UDF: Creation, Executions with Select
  • Variables & Parameters in SQL Server
  • Implementing Dynamic Joins in T-SQL

Our Trainers.

Our Trainers fully trained on how to handle students by provide complete freedom to get out the students innovative and probelem solving skills to understand the subject and learn based on real-time examples. Our trainers help the candidates in completing their projects. And even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.

 

  • Every Trainer experience between 5 to 15 Yearsof Experience.
  • Trained more than 500+students every year.
  • Strong Theoretical & Practical Knowledge.
  • Certified Professionals with High Quality in training delivery.
  • Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  • Most of our trainer working in multnational companies.

Testmonials

Very Good Hands-on SQL SERVER Learning Experience. It helps full with recorded sessions and detailed SQL SERVER. The trainer covered each and every topic with Real-time Quires.

 

Anitha Roy

Software Employee

I have taken SQL SERVER online training from SHIVA TECHNO, although it is online but the team helped me a lot. Server access, materials, update about the classes everything is done perfectly by the them. I got every thing that is required to become an expert in SQL SERVER.

Pallavi

Student, Student

FAQ’s

Who should learn SQL Server?
  • SQL developers 
  • Data Analysts, Business Analysts, Data Scientists
  • Database Server professionals
  • ETL Developers
  • MSBI / Power BI Engineers
  • People aspiring to start their careers as SQL Server DBA
Do I get any discount on the course?

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

Do SHIVA TECHNO accepts the course fees in installments?

Yes, we accept payments in two installments.

We're Here To Help you!

Office

106/2A/2RT, 2nd Floor – 201 A, Above Sindhu Cargo Carriers,         S.R. Nagar, Hyderabad – 38, India.

Hours

M-F: 8am – 10pm S-S: Closed

Contact Us

Call Us:  +91 9849683033

Mail Us: info@shivatechno.com