Skip to content

Home
Certificate Courses
Special Packages
Login
Earn With Us
Contact
0

SQL – Basic to Intermediate

Current Status

Not Enrolled

Price

₹2500

Get Started

Take this Course

Course Content

Expand All

Demo SQL Basic 3 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/3 Steps

Introduction To Course

Creating, Altering, Deleting Table

Select Query, Select With Where Claus

Basic SQL Material

Overview 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Introduction To Course

Understanding Database 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Database and Relational Database

Understanding Interface

Beginning With SQL 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Types of SQL Commands - DDL,DML,DQL,DCL,TCL

Creating, Altering, Deleting Database

Expand

Lesson Content

0% Complete 0/2 Steps

Create Table by Importing Data

Creating, Altering, Deleting Table

Constraints 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Procedural, Declarative Integrity Constraints

Using Not Null, Unique, Default and Check, Index Constraints

Primary Key And Referential Integrity or Foreign Key Constraints

Data Types In SQL 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Data Types In SQL

Using Data Types In SQL

Data Manipulation Language 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Computed Columns

Data Query Language 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Select Query, Select With Where Claus

OPERATORS, BETWEEN, AND, IN, LIKE, IS NULL

Order By Clause, Distinct Keyword

Built In Functions 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Aggregate & Scalar Functions

Super Aggregate Functions

Over (Partition By …) Clause

Ranking Functions

Set Operators 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Union, Intersect, Except

Expand

Lesson Content

0% Complete 0/3 Steps

Inner Join - Equi, Natural, Theta

Self Join & Cross Join

Outer Join - Left, Right, Full

Sub Queries 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

What Are Sub Queries

Single Row & Multi-Row Sub-Query

Any or Some, ALL

Co-Related Sub-Queries

Exists and Non-Exists

Indexes 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Clustered Index, Non-Clustered Index

Create, Alter and Drop Indexes

Expand

Lesson Content

0% Complete 0/4 Steps

What Are Views And Its Purpose

Creating, Altering and Dropping Views

Simple and Complex Views

Encryption and Schema Binding Options in creating views

Security 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Login Creation- SQL Server Login, Windows Authentication Login

User Creation-Granting and Revoking permissions & Roles

Important Tip 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Find Duplicates

Assessment 1 Topic | 1 Quiz

Expand

Lesson Content

0% Complete 0/1 Steps

Login

Accessing this course requires a login, please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.

Copyright © 2023 TestFormula

A Certificate Courses Portal of Edu4Sure

error: Content is protected !!

WhatsApp us