Course , Free Course ,

SQL

SQL is a Structured Query Language. Using SQL, you can access and perform various operations on the database. It is the most used database query language.

View Course details

What will you learn?

In this course, you will learn followings:

SQL overview
Syntax
Data types
Operators
Create, alter, drop tables
Order By and Group By clauses
Constraints
Joins
Views
Subqueries
Index

Pre-requisite for the Course

None

Description

A warm welcome to this SQL course!

SQL is a mostly used database query language used to access data from the relational database. It can only work with data which is relational means stored in form of tables.

This is a perfect course to start with the SQL.

There are 3 projects as well as part of this project. So, learn the SQL and practice in the lab.

Who this course is for?

Back-end developer
Full-stack developer
Data engineer, Data scientist and Data analyst

Course Content

Expand All

SQL Introduction 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

SQL - Databases, DBMS, RDBMS Concepts

SQL - Data Types

Types of Keys in SQL

SQL - Operators

SQL Commands 13 Topics

Expand

Lesson Content

0% Complete 0/13 Steps

SQL - Create, Drop and Alter Database

SQL - Create, Select and Insert Records in a Table

SQL - Alter and Delete Records in a Table

SQL - Drop Table

SQL - Where Clause

SQL - AND & OR Clauses

SQL - Update Query

SQL - Delete Query

SQL - Like Clause

SQL - Top Clause

SQL - Order By & Group By

SQL - Distinct Keyword

SQL - Sorting Results

SQL References 19 Topics

Expand

Lesson Content

0% Complete 0/19 Steps

SQL - Working with Database

SQL - Constraints

SQL - Using Joins

SQL - Types of Joins Inner, Left and Right Join

SQL - Unions Clause

SQL - NULL Values

SQL - Alias Syntax

SQL - Alter Command

SQL - Truncate Table

SQL - Using Views

SQL - Transactions

SQL - Date Functions

SQL - Temporary Tables

SQL - Clone Tables

SQL - Sub Queries

SQL - Using Sequences

SQL - Handling Duplicates

SQL - Injection

SQL Indexes 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

SQL Index, Indexes in SQL and Database Index

SQL Stored Procedure 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

SQL Stored Procedure

SQL Hands On Project-1 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Database Project for MS SQL Server

Library Database Management System 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Library Database management system using SQL

SQL Hands On Project-2 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

SQL Server Project

Overview of SQL connectivity with Java 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Connect SQL with Java

+8 enrolled

Not Enrolled

Login to Enroll

Free

Course Includes

9 Lessons
44 Topics
Course Certificate