25 Jun SQL Tutorial

SQL is a Standard Query language used to manage, access, and manipulate data in an RDBMS. It is used to insert, update, and delete records from a database. Also, set permissions on tables and views with SQL.

Get Certified 4,549 students  | Audio: English

The SQL tutorial is prepared for students, engineers, and professionals. Beginning with the introduction and installation, you will learn how to create a database and tables, and how to insert records and select them. We have also included operators, clauses, and subquery lessons. With that, step-by-step text and video lessons are provided.

SQL Index

The following lessons are covered in the SQL Tutorial,

• SQL Introduction
• SQL vs NoSQL

 SQL – Install & Setup

• Install SQL on Windows
• [Solved] A required file could not be downloaded error while….

SQL – Create & Insert

• Create a Database
• Create a Table
• Insert Records

 SQL – Select Records

• SELECT statement
• SELECT DISTINCT statement
• WHERE Clause

 SQL – Order Records

• ORDER BY Clause

 SQL – Operators

• AND Operator
• OR Operator
• NOT Operator
• IN Operator
• BETWEEN Operator
• LIKE Operator

 SQL – Built-in Functions

• SQL MAX() Function
• SQL MIN() Function
• SQL SUM() Function
• SQL AVG() Function
• SQL COUNT() Function

 SQL – Constraints

• SQL Primary Key Constraint
• SQL Foreign Key Constraint
• SQL Unique Constraint
• SQL Check Constraint
• SQL NOT NULL Constraint

 SQL – Alter & Update

• SQL ALTER TABLE Statement
• SQL UPDATE Statement
• SQL Aliases

 SQL – Advanced

• SQL Stored Procedures
• SQL Indexes
• SQL SELECT INTO Statement
• SQL SELECT TOP Clause
• Backup a Database
• SQL Views
• Drop a Table

 SQL – Resources

• SQL Examples
• SQL Interview QA