SQL Server Training Module

SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Duration

25 Days

SQL Server
    What is SQL
    Why SQL?
    SQL Commands
  • DDL - Data Definition Language
  • DML - Data Manipulation Language
  • DCL - Data Control Language
  • DQL - Data Query Language
  • SQL RDBMS Concepts
  • What is field?
  • What is record, or row?
  • What is column?
  • What is NULL value?
  • SQL Syntax
  • SQL SELECT Statement
  • SQL DISTINCT Clause
  • SQL WHERE Clause
  • SQL AND/OR Clause
  • SQL IN Clause
  • SQL BETWEEN Clause
  • SQL Like Clause
  • SQL ORDER BY Clause
  • SQL GROUP BY Clause
  • SQL COUNT Clause
  • SQL HAVING Clause
  • SQL CREATE TABLE Statement
  • SQL DROP TABLE Statement
  • SQL CREATE INDEX Statement
  • SQL DROP INDEX Statement
  • SQL DESC Statement
  • SQL TRUNCATE TABLE Statement
  • SQL ALTER TABLE Statement
  • SQL ALTER TABLE Statement (Rename)
  • SQL INSERT INTO Statement
  • SQL UPDATE Statement
  • SQL DELETE Statement
  • SQL CREATE DATABASE Statement
  • SQL DROP DATABASE Statement
  • SQL USE Statement
  • SQL COMMIT Statement
  • SQL ROLLBACK Statement
  • SQL Data Types
  • Exact Numeric Data Types
  • Approximate Numeric Data Types
  • Date and Time Data Types
  • Character Strings Data Types
  • Unicode Character Strings Data Types
  • Binary Data Types
  • Misc Data Types
  • SQL Operators
  • What is an Operator in SQL?
  • SQL Arithmetic Operators
  • SQL Comparison Operators
  • SQL Logical Operators
  • SQL Expressions
  • SQL - Boolean Expressions
  • SQL - Numeric Expression
  • SQL - Date Expressions
  • SQL Joins
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • SELF JOIN
  • CARTESIAN JOIN
  • SQL Unions Clause
    SQL NULL Values
    SQL Alias Syntax
    SQL Indexes
  • The CREATE INDEX Command
  • Single-Column Indexes
  • Unique Indexes
  • Composite Indexes
  • Implicit Indexes
  • The DROP INDEX Command
  • SQL TRUNCATE TABLE
    SQL - Using Views
  • Creating Views
  • The WITH CHECK OPTION
  • Updating a View
  • Inserting Rows into a View
  • Deleting Rows into a View
  • Dropping Views
  • SQL HAVING CLAUSE
    SQL Transactions
    Transaction Control
  • The COMMIT Command
  • The ROLLBACK Command
  • The SAVEPOINT Command
  • The RELEASE SAVEPOINT Command
  • The SET TRANSACTION Command
  • SQL Wildcard Operators
    SQL Date Functions
    SQL Temporary Tables
    SQL Sub Queries
  • Subqueries with the SELECT Statement
  • Subqueries with the INSERT Statement
  • Subqueries with the UPDATE Statement
  • SQL – Handling Duplicates
    SQL – Injection
    SQL – Useful Functions
    SQL – Stored Procedures
    SQL – Triggers
    SQL – Cursor
    SQL – Exception Handling

You have gone through all the training and reading material, since you decided to choose your career. This might have given you initial understanding about the procedures and techniques and you are even able to pass your certification as well ...

Best - SAP training center in London.