SQL: Structured Query Language
1 - Introduction
• What Is Database?
• What is Database Management System (DBMS)?
2 - Datatypes and Constraints
• What are Datatypes ?
• Types and Examples .
• How to use .
• What are Constraints?
• Types and Examples.
• How to use.
3 - Statements in SQL
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Transaction Control Language (TCL)
• Data Control Language (DCL)
• Data Query Language (DQL)
4- Software installation
• Installing and set up of software
5- Data Query Language (DQL)
• Select
• From
• Where
• Group By
• Having
• Order By
6 -Operators
• Types and Examples
7- Functions in SQL
• Single Row Functions
• Multi Row Functions
• Arithmetic Functions
• Date & Time Functions
• String Functions
• String Functions
8-Sub Query
• Introduction to Sub Query
• Working of Sub Query
• Query Writing and Execution
• Types of Sub Query
1. Single Row Sub Query
2. Multi Row Sub Query
• Nested Sub Query.
09- Pseudo Columns
• Introduction on Pseudo Columns
• ROWID
• ROWNUM
• Working and Usage.
10- JOINS
• What Is Join?
• Types of Joins.
• Cartesian Join
• Inner Join
• Outer Join
• Self-Join
• Queries and Examples.
11- Co- Related Sub Query
• Working and Examples
12- Data Definition Language (DDL)
• Create
• Rename
• Alter
• Truncate
• Drop
13- Data Manipulation Language (DML)
• Insert
• Update
• Delete
14- Transaction Control Language (TCL)
• Commit
• Save point
• Rollback
15- Data Control Language (DCL)
• Grant
• Revoke
16- MISCELLANEOUS
• Introduction to ERD
• Examples
• Views ( simple & Complex )
• CASE Statements
16- PL SQL
• Introduction to Procedures
• Introduction to Triggers
• Indexing
SQL Process
What is a DBMS?
A database management system (DBMS) is a software used to store and manage data. It guarantees the quality, durability, and confidentiality of information. The most popular type of DBMS are Relational Database Management Systems, or RDBMSs. Here, the database consists of a structured set of tables and each row of a table is a record.
What is SQL?
Structured Query Language (SQL) is the standard language for data manipulation in a DBMS. In in simple words its used to talk to the data in a DBMS. Following are types of SQL Statements
Data Definition Language (DDL) allows you to create objects like Schemas, Tables in the database
Data Control Language (DCL) allows you to manipulate and manage access rights on database objects
Data Manipulation Language (DML) is used for searching, inserting, updating, and deleting data, which will be partially covered in this programming tutorial.
What is Query?
A Query is a set of instruction given to the database management system. It tells any database what information you would like to get from the database. For example, to fetch the student name from the database table STUDENT, you can write the SQL Query like this:
SELECT Student_name from STUDENT;
SQL Process
When you want to execute an SQL command for any DBMS system, you need to find the best method to carry out your request, and SQL engine determines how to interpret that specific task.
Important components included in this SQL process are:
SQL Query Engine
Optimization Engines
Query Dispatcher
Classic Query Engine
A classic query engine allows you to manage all the non-SQL queries.
What will you learn in this course?
This course is designed for anyone planning to work with databases, especially in the roles of system administrators and application developers. The tutorials help beginners learn the basic SQL commands, including SELECT, INSERT INTO, UPDATE, DELETE FROM, and more. Each SQL command comes with clear and concise examples.
In addition to the list of SQL commands, the tutorial presents flashcards with SQL functions, such as AVG(), COUNT(), and MAX(). Along with these, quizzes help validate your basic knowledge of the language.
The tutorial can help you handle various aspects of the SQL programming language.