Home
About Us
Tutorials
Solutions

DATABASE Object Definitions

Development Tutorials for Beginners to Advanced developers
Tutorials
SQL
DATABASE Object Definitions

DATABASE Object Definitions

SQL CREATE DATABASE
SQL DROP DATABASE
SQL BACKUP DATABASE
SQL CREATE TABLE
SQL DROP TABLE
SQL ALTER TABLE
SQL CREATE / ALTER / DROP COLUMN
SQL Data Types
SQL Constraints
SQL PRIMARY KEY
SQL FOREIGN KEY
SQL CREATE INDEX
SQL Views

1. Introduction

Get Started
Setting Up the Development Environment
Write Your First SQL Statement

2. DATABASE Object Definitions

SQL CREATE DATABASE
SQL DROP DATABASE
SQL BACKUP DATABASE
SQL CREATE TABLE
SQL DROP TABLE
SQL ALTER TABLE
SQL CREATE / ALTER / DROP COLUMN
SQL Data Types
SQL Constraints
SQL PRIMARY KEY
SQL FOREIGN KEY
SQL CREATE INDEX
SQL Views

3. SELECT Queries

SQL - SELECT Query
SQL - WHERE Clause
SQL - AND and OR Clauses
SQL - TOP Clause
SQL - ORDER BY Clause
SQL - Group By Clause
SQL - Distinct Clause
SQL - INNER JOIN

4. INSERT / UPDATE / DELETE Queries

SQL - INSERT Statement
SQL - UPDATE Statement
SQL - DELETE Statement

About

Sobiens Information Technology Ltd helps businesses accelerate innovations and overcome business challenges with the aim of improving business performance. Our specialized people and tested approach enable us to work with clients understand their goals and have a clear vision of how to seamlessly integrate an accelerated solution to help meet those goals.

Subscribe Email

Follow Us On

Facebook
Youtube

Contacts

Kemp House
152-160 City Road
London
EC1V 2NX
Phone: +44 203 239 9259
Email: info@sobiens.com