SQL


1400+

SQL Professionals Trained

6+

New Batches Every Month

10+

Industry Experience

10+

Corporates Worked with


Menu would be displayed here either through coding or pin

SQL Overview

UpScale's SQL Training enables you to master the complete SQL

Modes of Training

Curriculum

Introduction to database

Introduction to DBMS

Purpose of database systems

Components of database systems

Applications of database

RDBMS

Data independence

Database Schema

DML, DDL, DCL

Instances

Data Modelling

ER Models

Relations Models

Relational Database Design

Data Integrity Rule

Functional Dependency

Normalization

Normalization needs and its forms

Relations Algebra

DDL and DML Statements

Datatypes of the Columns

Create Statement

Insert Statement

Alter Statement

Drop Statement

Update Statement

Delete Statement

Truncate Statement

Working with Queries

Understanding Select Statemen

Using of keywords like Top, Distinct, Null

Using String and Arithmetic Expression

Exploring Where Clause with Operations

Using Advance Operations

Sorting data by Order By clause and Group by

Sub Queries

Aggregate Functions

Using Function in Queries

Using Predefined Functions

Count, Sum, Min, Max, Avg

Having Clause

Using Group by

Joins and Set Operations

Joins and Set Operations

Types of Joins

Co-Related Sub Queries

Set operations using Union, Intersect and Except

Working with Constraints and Data Integrity

Entity Integrity

Domain Integrity

Referential Integrity

Unique

Not Null

Primary key

Foreign key

Default Check

Views

Introduction to Views

Advantages of Views

Creating Views

Altering Views

Dropping Views

Advance option while Creating Views

DCL

Creating Users and Roles

Granting and Revoking Roles

Granting and Revoking Privileges

Management using Management Studio

T-Sql and Stored Procedures

What is T-SQL

Scripts and Batches

Using Statements

Error Handling

Introduction to Stored Procedure

Advantage of Stored Procedure

Creating, Modifying and dropping Stored Procedure

User defined functions

Triggers and Cursors

Introduction to Triggers

Creating, Altering and Dropping Trigger

Using Rollback Tran

Creating Cursor

Cursor vs Select

Type of Cursor

Advantages of Cursor

Want a Free Course

Share your details and we'd get back to you soon!
Send me details
Terms and Conditions apply
close-link

Call for Free Courses