Course Details

course-thumb

SQL for DBMS

Overview
Carriculum
Instructor

SQL Tutorial

The SQL SELECT Statement

SQL WHERE Clause

SQL AND OR NOT Logical Operators

Use of SQL ORDER BY keyword for sorting by ascending and descending order

Insert Data Into Database Using SQL

Working With NULL Value in SQL

Updating Database Data Using SQL UPDATE statement

Delete Data From Database Using SQL Query

Use of SQL Limit

SQL MIN() and MAX() Aggregate Functions

SQL COUNT(), AVG() and SUM() Aggregate Functions

Use of SQL LIKE Operator

Use of SQL IN Operator

The SQL BETWEEN Operator in Where Condition

Use Aliases on SQL Query

SQL Join Query

Use of SQL INNER JOIN

Use of SQL LEFT JOIN

Use of SQL RIGHT JOIN

Use of SQL FULL OUTER JOIN

Use of SQL Self JOIN

SQL UNION Operator to Concatenate Query Result

More SQL

SQL GROUP BY Statement

Using SQL HAVING Clause with WHERE Condition

The SQL EXISTS Operator with WHERE condition

SQL INSERT INTO SELECT Statement

Select Conditionally using CASE Statement

Instructor
Al-Mamun Sarkar
Lectures
27
Course level
Beginner
Last Update:
Apr 13 , 2020
Language
English

Share On: