SQL Tutorial | Learn SQL Database by Geekster

SQL Tutorial

Master the language of databases with our SQL tutorials. Learn how to retrieve, organise, update, and manage data like a pro. Unlock valuable insights and power your applications.

Tutorial

Start your coding journey with our step-by-step tutorials, designed for absolute beginners.
Articles

Enhance your SQL knowledge with in-depth articles and practical examples.

Introduction to SQL

Introduction to SQL, SQL (Structured Query Language) serves as an effective language for communicating with databases. Users employ it to...

SQL Syntax

When you want to do some operations on the data in the database, you must write the query in the...

SQL Data Types

A column’s data type is essentially the type of data format that will be used to store the data in...

SQL Operators

Database administrators and users utilize SQL queries to manipulate and access the data of database tables and views. They employ...

SQL Create Database

In SQL, the 'Create Database' statement is the first step for storing the structured data in the database. The database developers...

SQL DROP Database

In SQL, sometimes there is a need to delete or drop the database on which you are working. Deleting a database means...

SQL SELECT Database

In SQL, we always need to Select our Database before starting to work with the database. Once we create a database...

SQL CREATE TABLE

SQL CREATE TABLE statement is used to create a table in a database. In RDBMS, database tables store data in the...

SQL DROP TABLE

SQL is a programming language used to manipulate data that are stored in the database. It is flexible and user-friendly....

SQL DELETE Table

SQL DELETE, a fundamental operation, removes data from a database. It's integral to database management, selectively deleting records based on...

SQL RENAME TABLE

Let's under SQL RENAME TABLE with an example. Suppose we have two tables in our database named table1 and table2. Although we have...

SQL TRUNCATE TABLE

SQL Truncate Table is one of the Data Definition Language (DDL) commands. It deletes all the records in a database...

SQL COPY TABLE

Let's discuss why we use SQL COPY TABLE, There may be a situation when you need an exact copy of...

SQL TEMP TABLE

SQL TEMP TABLE provides a standardized way to interact with databases and perform tasks such as querying data, inserting, updating,...

SQL SELECT Statement

We can fetch either the entire table or according to some specified rules. The data returned is stored in a...

SQL SELECT DISTINCT

SELECT DISTINCT in SQL eliminates all duplicate records from the result returned by the SQL query. The DISTINCT keyword is used in combination...

SQL SELECT COUNT

SQL SELECT COUNT is an aggregate function used to get the count of the provided expression. It returns the count...

SQL SELECT FIRST

we are going to study the SELECT FIRST commands in SQL, as we all know that there is already a...

SQL SELECT LAST

In SQL, the concept of "SQL SELECT LAST" typically refers to retrieving the most recent or last records from a...

SQL SELECT RANDOM

Introducing randomness with SQL SELECT RANDOM statement, queries can be beneficial for various purposes such as selecting random samples for...

SQL SELECT IN

In relational databases, SQL (Structured Query Language) serves as the universal language for managing and manipulating data. With 'SQL SELECT...

SQL SELECT DATE

The SELECT statement is a powerful tool used to retrieve data from a database. Additionally, when working with date and...

SQL SELECT SUM

In SQL (Structured Query Language), the SELECT statement is a fundamental command used to retrieve data from a database. The...

SQL SELECT NULL

The SQL SELECT statement is a fundamental query used to retrieve data from a database. However, what happens when you...

SQL OR CLAUSE

As you know, while managing and storing a large amount of data in a database, SQL is frequently used. SQL clauses are...

GROUP BY & HAVING Clause in SQL

In SQL, the GROUP BY clause categorizes rows with similar values into groups.The HAVING clause filters groups based on conditions...

SQL WHERE CLAUSE

Imagine a giant warehouse full of boxes. You only want the boxes with red shoes. The WHERE clause in SQL...

SQL AND CLAUSE

In SQL (Structured Query Language), the "AND" clause is a logical operator used to combine multiple conditions in a query's...

SQL WITH CLAUSE

SQL SORTING ON MULTIPLE COLUMNS

In the world of databases, organizing and retrieving data efficiently is paramount. Sorting data is a fundamental operation in SQL...

SQL ORDER BY LIMIT

In SQL, the ORDER BY clause is used to sort the result set returned by a query based on one...

SQL ORDER BY RANDOM

In database management, SQL (Structured Query Language) stands as a cornerstone for querying and manipulating data. The ORDER BY clause...

SQL ORDER BY CLAUSE WITH ASCENDING ORDER

In SQL, the ORDER BY clause is a fundamental component used to arrange the results of a query in a...

SQL INSERT STATEMENT

The SQL INSERT statement is a fundamental command used to add new records or rows into a database table. It...

JOINS IN SQL

In the realm of Sql join introduction of relational databases, SQL JOIN is a crucial operation that enables the merging...

INNER JOIN IN SQL

The SQL INNER JOIN is used to retrieve records from two or more tables where there is a match based...

Left Join In SQL

The SQL LEFT JOIN is used to retrieve all records from the left table (the first table specified in the...

RIGHT JOIN IN SQL

The SQL RIGHT JOIN is a type of join operation used to retrieve all records from the right table (the...

FULL JOIN IN SQL

The SQL FULL JOIN is a type of join operation that combines the results of both LEFT JOIN and RIGHT...

Where condition in SQL

In SQL, the WHERE clause is important for filtering rows in a query based on specific criteria. This means that...

SQL WITH CLAUSE

Explore Geekster’s Upskilling Course

Full Stack Web Development

Become a full stack web developer with placement guarantee in this beginner friendly course!

Data Science & Artificial Intelligence

Learn data analysis, machine learning, and data visualisation skills through hands-on projects.

With you, every step
of the way

ABOUT GEEKSTER

Courses

FELLOWSHIP

Explore