• Timeline
  • Sponsors
  • FAQs
  • About us
  • Learning Materials
    • Android
    • C
    • C++
    • C#
    • Git
    • HTML/CSS/JavaScript
    • Java
    • MongoDB
    • PHP
    • Python
    • R
    • Ruby
    • SQL
    • Swift
    • VB.NET
  • Badges
  • Log in
Logo4

SQL

Setting up the environment

Oracle online terminal

For beginners

Overview

RDBMS Concepts

Databases

Syntax

Data Types

Operators

Expressions

Create database

Drop database

Select database

Create table

Drop table

Insert query

Select query

Where clause

AND & OR Clauses

Like Clause

Top Clause

Order by

Group by

Distinct Keyword

Sorting Results

For intermediates

Constraints

Joins

Union

NULL values

Alias syntax

Indexes

Having Clause

Transactions

Wildcards

Date Functions

Temporary Tables

Clone Tables

Sub-queries

Using sequences

Handling duplicates

SQL Injection

Useful resources

Books and resources

Contact: [email protected]