Download
App
Brochure download
Fill in your details
  • +91-80-42188793
  • enquiry@itasinc.in

Mega Package : Essential Skills for Data Science, Data Analytics, Business Analytics, MIS Reporting --> 26 Courses, 350+ Videos, 150+ Hours Video Contents, Downloadable Practice Files, 300+ Downloadable E-Books, 150 MS Excel Editable, Reusable templates, 300+ Excel, CSV Data Sets, 100000+ Infographics, Graphics & Images Library, 1000+ Sample Editable Resumes, 70000+ Designer Fonts, Instagram, YouTube Thumbnails & Stories

>

Microsoft SQL Server 2017

Fees : Rs 15,000 Only

Duration : 24 Hours

Enroll Now

This course is designed to help you understand Basic and Advanced concepts of SQL and SQL Server concepts. The course is designed for beginners and professionals.

Microsoft SQL Server is a relational database management system developed by Microsoft. It is also called as MS SQL Server. Its primary function is to storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

Prerequisites:

There are no Prerequisites for this tutorial. Candidate should have basic windows, keyboard and mouse skills

Course Objectives:

After the course, you will be able to:

  • Build and maintain database using SQL Commands
  • Using DML statements like Insert, Update and Delete
  • Write and Call Stored Procedures in database
  • Using Functions stored in database.
  • Write and manage Database Triggers, Cursors and Index
  • Use Server Concepts

Course Contents

  • What is SQL?
  • SQL Process
  • SQL Commands

  • Data, Database, Field, Record
  • What is RDBMS?
  • SQL Constraints
  • Data Integrity
  • Advantages of DBMS
  • Limitations of File Management System
  • Understanding Client and Server

  • Analyzing the Requirement
  • Identify Entities and their Relationships
  • E-R Diagram Symbols
  • Drawing E-R Diagram
  • E-R Diagram uses
  • Conversion of E-R Diagrams into Tables

  • Database Normalization
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)

  • MySQL
  • MS SQL Server
  • Oracle
  • MS Access

  • Various Syntax in SQL

  • Character and String Data Types
  • Numeric Data Types
  • Date and Time Data Types
  • Unicode Character String Data Types
  • Binary Data Types
  • Miscellaneous Data Types

  • What is an Operator in SQL?
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators

  • Boolean Expressions
  • Numeric Expressions
  • Date Expressions

  • NOT NULL Constraint
  • DEFAULT Constraint
  • UNIQUE Constraint
  • Primary Key
  • Foreign Key
  • CHECK Constraint
  • INDEX Constraint
  • Dropping Constraints
  • Integrity Constraints

  • CREATE Database
  • DROP or DELETE Database
  • SELECT Database, USE Statement
  • CREATE Table
  • Creating a Table from an Existing Table
  • DROP or DELETE Table
  • INSERT Query
  • SELECT Query
  • WHERE Clause
  • AND & OR Conjunctive Operators
  • The AND Operator
  • The OR Operator
  • UPDATE Query
  • DELETE Query
  • LIKE Clause
  • TOP, LIMIT or ROWNUM Clause
  • ORDER BY Clause
  • Group By
  • Distinct Keyword
  • SORTING Results
  • Handling Duplicates

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • SELF JOIN
  • CARTESIAN or CROSS JOIN

  • The UNION ALL Clause
  • INTERSECT Clause
  • EXCEPT Clause
  • NULL Values
  • Alias Syntax

  • The CREATE INDEX Command
  • The DROP INDEX Command
  • INDEX Constraint
  • ALTER TABLE Command
  • TRUNCATE TABLE Command

  • What are Views?
  • Advantages of Views
  • Creating, Altering, Dropping Views
  • Advance Options while Creating a View
  • SQL Server Catalogue Views
  • The WITH CHECK OPTION
  • Having Clause

  • Properties of Transactions
  • Transactional Control Commands
  • Wildcard Operators
  • Date Functions
  • Temporary Tables
  • What are Temporary Tables?
  • Dropping Temporary Tables
  • Clone Tables

  • Subqueries with the SELECT Statement
  • Subqueries with the INSERT Statement
  • Subqueries with the UPDATE Statement
  • Subqueries with the DELETE Statement

  • What are Stored Procedures?
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping
  • Input, Output and Optional Parameters
  • System Defined Stored Procedures and Functions
  • User Defined Functions

  • What are Triggers?
  • Constraints vs Triggers
  • Creating, Altering, Dropping Triggers
  • After and Instead of triggers
  • Using Rollback Transaction

  • Creating Cursors
  • Cursors vs. Select
  • Types of Cursors
  • Locks on Cursors
  • Advantages of Cursors

  • Using AUTO_INCREMENT Column
  • Obtain AUTO_INCREMENT Values
  • Renumbering an Existing Sequence
  • Starting a Sequence at a Particular Value

  • Generating SQL Script
  • Executing SQL Script
  • Generating Change Script
  • Taking database Backup
  • Restoring database using Backup
  • Attaching and Detaching of Database

iTAS (iTech Analytic Solutions) is a complete Analytics Solution provider with. unparalleled value-optimizing Information Insight to client organizations through the use of cutting-edge, customized reporting systems, analytical models, and database applications

iTAS (iTech Analytic Solutions) provides data driven business decisions with quantitative modeling expertise & deep understanding of business needs and state-of-the-art technologies to solve complex problems.

Useful Links

Support

Contact Us

  • +91-80-42188793
  • Branch 1:No. 9, 1st Floor, 8th Main, 9th Cross, SBM Colony, Brindavan Nagar,Mathikere, Bengaluru, Karnataka, India - 560054
  • Branch 2:#403, 11th Cross,19th Main, 1st Block, Rajajinagar, Bengaluru - 560 010

Enquiry

  • M: +91 9066068793, 9066078793, 9902058793
  • E: enquiry@itasinc.in

Placements

  • M: +91 7619483672
  • E: jobs@itasinc.in

Copyright ©2018 iTAS. All Rights Reserved