Free SQL Tutorials

SELECT QUERY IN SQL

A database is a systematic collection of data.  Database systems are used  to store, access, delete data. furthermore, it also systematically organize data in a database.This article briefly discuss about the use and importance of SELECT Query in SQL. Consider a cafeteria, which provides snacks and other eatable item to its customers. Traditionally, the snacks, …

SELECT QUERY IN SQL Read More »

SQL DDL,DML,DCL,TCL COMMANDS – Free SQL Tutorial

SQL is a database language that has commands to create, manipulate etc the database. All the commands can be broadly classified into following categories: DDL Commands DML Commands DCL Commands TCL Commands DDL(Data Definition Language) Commands: Data Definition Language commands in SQL are used to define the database schema. These commands deal with description of …

SQL DDL,DML,DCL,TCL COMMANDS – Free SQL Tutorial Read More »

SQL Aggregate Functions – Free Tutorial and Online Training

SQL Aggregate functions are described in this article. SQL functions are like average , sum , count , first last etc. SQL Aggregate functions Consider the following Student table with ID, Marks, Age,Name as columns. +—-+——-+—–+———–+ | Table Name – Student | +—-+——-+—–+———–+ | ID | MARKS | AGE | NAME | +—-+——-+—–+———–+ | 1 …

SQL Aggregate Functions – Free Tutorial and Online Training Read More »

SQL Date Functions – Free Tutorial and Online Training

In SQL, there are a lot of library functions used while working with Date in Databases. The given below are the list of SQL date functions along with examples. SQL Date Functions     NOW(): NOW() function returns the current date and time of the system. Example: Query:  Select NOW ();  Result:  2018-14-21   15:08:05       CURDATE(): CURDATE() functions …

SQL Date Functions – Free Tutorial and Online Training Read More »