Course Duration
Live Projects
Training Format
SQL Professionals Trained
New Batches Every Month
Industry Experience
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
SELF PACED LEARNING
- High Quality videos built by industry experts with theory and demonstration of features and tasks of the Selenium with Java
- Learn at your Convenience.
- You get pre-defined recordings
- Delivered through LMS.
- Fixed Course Content.
- Certification Guidance Provided.
SELF PACED LEARNING
- High Quality videos built by industry experts with theory and demonstration of features and tasks of the Selenium with Java
- Learn at your Convenience.
- You get pre-defined recordings
- Delivered through LMS.
- Fixed Course Content.
- Certification Guidance Provided.
Curriculum
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
Data Integrity Rule
Functional Dependency
Normalization
Normalization needs and its forms
Relations Algebra
Datatypes of the Columns
Create Statement
Insert Statement
Alter Statement
Drop Statement
Update Statement
Delete Statement
Truncate Statement
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
Using Function in Queries
Using Predefined Functions
Count, Sum, Min, Max, Avg
Having Clause
Using Group by
Joins and Set Operations
Types of Joins
Co-Related Sub Queries
Set operations using Union, Intersect and Except
Entity Integrity
Domain Integrity
Referential Integrity
Unique
Not Null
Primary key
Foreign key
Default Check
Introduction to Views
Advantages of Views
Creating Views
Altering Views
Dropping Views
Advance option while Creating Views
Creating Users and Roles
Granting and Revoking Roles
Granting and Revoking Privileges
Management using Management Studio
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
Introduction to Triggers
Creating, Altering and Dropping Trigger
Using Rollback Tran
Creating Cursor
Cursor vs Select
Type of Cursor
Advantages of Cursor