497 reviews

SQL

By Intern Vision

Learning

Overview
Curriculum

About the Course

Structured Query Language and is the standard programming language for defining, managing, and manipulating relational databases.

Introduction
Select and Where
SQL Sub Languages - Order by
- Part 1 - SQL Sub Languages - Order By Clauses
  01:05:10
- Part 2 - SQL Sub Languages - Order By Clauses
  01:00:18
Select Into
- Part 1 - Any - All - Select Into - Insert Into - Case
  01:02:19
- Part 2 - Any - All - Select Into - Insert Into - Case
  01:02:34
Delete Top
- Part 1 - Delete - Top - Aggregate Functions - Wild Cards
  53:33
- Part 2 - Delete - Top - Aggregate Functions - Wild Cards
  01;02:24
Insert Update
In Between
- Part 1 - In - Between - Table Alias
  45:02
- Part 2- In - Between - Table Alias
  45:48
SQL Comments
- Part 1 - SQL Comments - SQL Operators
  34:34
- Part 2- SQL Comments - SQL Operators
  51:23
Joins
- Part 1 - Joins
  01:04:02
- Part 2- Joins
  01:03:10
Union All
- Part 1 - Union All - Union - Group By - Having - Exists - Not Exists
  01:02:03
- Part 2 - Union All - Union - Group By - Having - Exists - Not Exists
  01:08:17
Null Functions
- Part 1 - Null Functions - Transact SQL
  01:02:04
- Part 2 - Null Functions - Transact SQL
  01:08:16
Examples if
- Part 1 - Examples - If - Conditional Statements
  01:02:27
- Part 2- Examples - If - Conditional Statement
  01:08:05
GoTo Statement
- Part 1 - Goto Statement - Looping Construct
  01:06:06
- Part 2- Goto Statement - Looping Construct
  01:02:02
Sub Programs
- Part 1 - Sub Programs - Stored Procedures
  01:07:59
- Part 2- Sub Programs - Stored Procedures
  56:16
Stored Procedure
- Part 1 - Stored Procedure Examples
  01:01:16
- Part 2- Stored Procedure Examples
  01:08:03
Stored Procedure Modification
- Part 1 - Modifying and Dropping a Stored Procedure
  58:48
- Part 2- Modifying and Dropping a Stored Procedure
  01:01:43
Dynamic Queries
- Part 1 - Dynamic Queries - Procedure Returning Values - Functions
  51:22
- Part 2- Dynamic Queries - Procedure Returning Values - Functions
  01:16:36
Break Continue
- Part 1 - Break - Continue - Exception Handling
  56:58
- Part 2- Break - Continue - Exception Handling
  01:06:52
SP Exception Handling
- Part 1 - Structured Exception Handling
  48:48
- Part 2- Structured Exception Handling
  01:01:48
Try Catch Blocks
- Part 1 - Multiple and Nested Try Catch Blocks
  52:57
- Part 2- Multiple and Nested Try Catch Blocks
  01:05:04
Table Valued Functions
- Part 1 - Using Anonymous Block - Table Valued Functions
  01:05:10
- Part 2- Using Anonymous Block - Table Valued Functions
  01:01:08
Backup DB
- Part 1 - Backup DB - Differential Example - DDL Statements
  46:28
- Part 2- Backup DB - Differential Example - DDL Statements
  01:03:38
UserDefined DB
- Part 1 - User Defined DB - Creating DB with GUI - Query - Commands
  48:30
- Part 2- User Defined DB - Creating DB with GUI - Query - Commands
  01:11:56
Database Constraints
- Part 1 - Database Constraints and Domain Integrity Constraints
  35:29
- Part 2- Database Constraints and Domain Integrity Constraints
  41:09

₹3000 ₹4500

Enroll Today for ₹1000

Remaining Amount: ₹2000

This course includes:

Instructor: Intern Vision

Duration: 10hrs

Topics: 25

Course validity: 6 months

Language: English

Certificates: Yes

Click outside to hide the comparison bar

Compare

Top