Best IT training centre in Kalyan | Diti Institute in kalyan

Database Training

Training Databases are storage systems comprised of information regarding training, certifications, and licensures for companies as a way to stay up-to-date on training information.

Call Trainer
+91 8976758080

Database Training

Introducing SQL Server

What's is SQL Server?

SQL Server Editions

Installing SQL Server

Basics of Database Design

Introducing SQL Server Management Studio

Creating a Database

Adding Tables

Building Relations

Primary key and Foreign key

Creating Indexes

Concept of Normalization

Concept of Denormalization

T-SQL Basics

What is T-SQL?

Syntax Conventions

Introducing AdventureWorks

Executing SQL Statements

Identifiers

Creating Data Types

Operators

Variables

Functions

SQL Queries

SQL Syntax

SELECT Clause

FROM Clause

SQL Aliases

Select Distinct

WHERE Clause

ORDER BY Clause

SQL Like and Text Search

SQL In and NOT In

SQL Between

SQL AND, OR , NOT

Using GROUP BY and HAVING

Using TOP N

UNION Queries

Action Queries

SELECT INTO queries

DELETE queries

TRUNCATE TABLE queries

INSERT queries

UPDATE queries

JOINS

Inner Join

Right Join

Left Join

Full Join

Functions

What is Functions

Type of Functions

Syntax of Functions

How to create Functions

Execute Functions

Rowset Functions

Rank function

Dense_rank

Triggers

Creating Triggers

Altering Triggers

Using the Inserted and Deleted Tables

Checking Updated Columns

XML and SQL Server

What is XML

Convert normal table data into XML data

XML Columns and Indexes

Querying and Modifying XML Data

Using OPENXML

Advanced SQL

Stored Procedures

Views

Transactions

Profiler

Sub Query

Cursors

Error handling

Indexes

Execution Plans

DataBase Backup

How to take DB backup

How to restore BD

How to import data from Excel

SMO and RMO Programming

Retrieving Server Information

Working With Database Objects

Generating Scripts

Viewing and Modifying Server Configuration

MYSQL DATA DEFINITION using SQL

Manage Databases

MySQL Table Types

MySQL Data Types

MySQL CREATE TABLE

MySQL Primary Key

MySQL Foreign Key

MySQL Sequence

MySQL INT Data Type

MySQL DECIMAL Data Type

MySQL DATE Data Type

MySQL TIME Data Type

MySQL DATETIME Data Type

MySQL ALTER TABLE

MySQL RENAME TABLE

MySQL ADD COLUMN

MySQL DROP TABLE

MySQL Temporary Table

Basic Data Manipulation using SQL

SQL Syntax

What is DDL, DML and DCL?

SQL Select

SQL Distinct

SQL Where

SQL And & Or

SQL Order By

SQL Insert Into

SQL Update

SQL Delete

SQL Injection

SQL Select Top

SQL Like

SQL Wildcards

SQL In

SQL Between

SQL Aliases

SQL Joins

SQL Inner Join

SQL Left Join

SQL Right Join

SQL Full Join

SQL Union

SQL Select Into

SQL Insert Into Select

SQL Create DB

SQL Create Table

SQL Constraints

SQL Not Null

SQL Unique

SQL Primary Key

SQL Foreign Key

SQL Check

SQL Default

SQL Create Index

SQL Drop

SQL Alter

SQL Auto Increment

SQL Views

SQL Dates

SQL Null Values

SQL Null Functions

SQL Data Types

SQL DB Data Types

SQL Functions

SQL Avg()

SQL Count()

SQL First()

SQL Last()

SQL Max()

SQL Min()

SQL Sum()

SQL Group By

SQL Having

SQL Ucase()

SQL Lcase()

SQL Mid()

SQL Len()

SQL Round()

SQL Now()

SQL Format()

MYSQL STORED PROCEDURES

MySQL Stored Procedures Introduction

MySQL Stored Procedures Getting Started

MySQL Stored Procedure Variables

MySQL Stored Procedure Parameters

MySQL Stored Procedures – Return Multiple Values

MySQL IF Statement

MySQL CASE Statement

IF vs. CASE

MySQL Loop Statements

MySQL Cursor

MySQL Stored Procedures Listing

MySQL Error Handling

MySQL Stored Procedures – Raising Error Conditions

MySQL Stored Function

Introduction to SQL Trigger

MySQL Triggers Implementation

Create Trigger in MySQL

Managing Triggers in MySQL

Create Multiple Triggers For The Same Trigger Event And Action Time

Working with MySQL Scheduled Event

Modifying MySQL Events

MYSQL VIEWS

Introduction to Database View

Views in MySQL

MySQL CREATE VIEW

MySQL Views & WITH CHECK OPTION

Creating MySQL Updatable Views

LOCAL & CASCADED in WITH CHECK OPTION

Managing Views in MySQL

SQL Server Syllabus

Introducing SQL Server

My Sql

Let's Start The Training Today!