SQL Learning Tutorials For Beginners

SQL Learning Tutorials For Beginners

In this SQL Learning Tutorials For Beginners, we will learn database concepts and how to create and work with various databases like MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems using the Structured Query language i.e. SQL. This SQL tutorial prepared for the beginners to help them understand the basic to advanced SQL concepts.

Bellow are the topics covered under this Tutorial.

Introduction To SQL

DBMS Concepts

RDBMS Concepts

Data Integrity

Database Normalization

DML and DDL in SQL

Data Definition Language (DDL)

Data Manipulation Language (DML)


SQL Queries

SQL Statements:

SQL Data Definition Language (DDL) Queries
Create Database
Drop Database
Create Table
Delete
Drop Table
Alter Table

SQL Data types

SQL Data Manipulation Language (DML) Queries
Select
Where
Conditional operators
Insert
Update
Delete
Truncate

Sub Queries
Alias
Like
Between
In
Union
Joins
Not null
Unique

SQL Keys
Primary key
Foreign key

SQL Functions
Avg
Count
First
Last
Max
Min
Sum
Groupby
Having
Ucase
Lcase
Mid
Len
Round
Date
Now
Format

Fresh2Learn Home

Introduction To SQL

SHARE