SQL Tutorial | learning SQL. | SQL Command

SQL Commands: SQL commands are instructions used to communicate with the database to perform specific task that work with data. SQL commands can be used not only for searching the database but also to perform various other functions like, for example, you can create tables, add data to tables, or modify data, drop the table, set permissions for users. SQL commands are grouped into four major categories depending on their functionality:    1.Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE. CommandDescription CREATECreates a new table, a view of a table, or other object in database ALTERModifies an existing database object,...

Read more »

Posted in: learning SQL.,SQL Command,SQL Tutorial

SQL Tutorial | Learning SQL |SQL Overview

                     SQL - Overview: What is SQL?  Ans: SQL is structured Query Language which is a computer language for storing, manipulating and retrieving data stored in relational database. SQL is the standard language for Relation Database System. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Informix, postgres and SQL Server uses SQL as standard database language. Also they are using different dialects, Such as:     1.MS SQL Server using T-SQL,    2. Oracle using PL/SQL,     3.MS Access version of SQL is called JET SQL (native format )etc  Ans2:     1.SQL stands for Structured...

Read more »

Posted in: learning SQL.,SQL Tutorial,SQL-Overview