My Pro Paradise

Operators In SQL Operators: SQL generally contains some reserved words that are used to perform operations such as Arithmetical, Comparison and Logical Operations etc. These reserved words are known as Operators. Generally, there are three types of operators in SQL: i.       SQL Arithmetic Operators ii.       SQL Comparison Operators iii.      SQL Logical Operators SQL Arithmetic Operators Let assume variable A holds 20 and variable B holds 60 then: Operators                              Description     Example   + Add   A+B= will give 80   - Subtract   A-B= will give -40   * Multiply   A*B= will give 1200 ...

  Types of SQL Commands SQL: SQL commands are used for communicating with the database. There are a total of 5 types of SQL commands 1. DDL (Data Definition Language) 2. DML (Data Manipulating Language) 3. DCL (Data Control Language) 4. TCL (Transaction Control Language) 5. DQL (Data Query Language) 1. DDL (Data Definition Language): Data Definition Language helps us to define database structure. ·       Create: Create statement is used to define a database. ·       Drop: Drop statement is used to remove the table and database from RDBMS. ·       Alter: Alter statement is used to add, delete or modify columns in an existing table. ·       Truncate: Truncate command is used to delete all the records from the table and free the space containing the table. 2. DML (Data Manipulating Language): Data Manipulating Language allows us to modify the database i...

  Data Types In SQL W hat is Data Type? A data type as the name suggests it is the type or category to which the data belongs to. A data type specifies a particular type of data, such as integer, floating-point, Boolean, etc. In SQL, the data type defines the type of data to be stored in each column of a table. SQL data types can be broadly divided into three categories 1.       Numeric Data Types 2.       String Data Types 3.       Data & Time Data Types Numeric Data Types String Data Types Data&Time DataTypes BIT CHAR(SIZE) DATE TINYINT VARCHAR(SIZE) TIME SMALLINT TEXT(SIZE) DATETIME MEDIUMINT TINYTEXT(SIZE) TIMESTAMP INT MEDIUMTEXT(SIZE) YEAR BIGINT LONGTEXT   ...

What is SQL? 1.     SQL was developed by Donald D. C  and Raymond F. Boyce at IBM. 2.     SQL stands for Structured Query Languages. 3.     Structured Query Languages is a standard Database Language. 4.     It is used to create, read, update and delete relational databases and tables. 5.     It is a case insensitive language. 6.    All the RDBMS like MySQL, Informix, Oracle, MS Access, and SQL Server use SQL as their standard database language. There are a lot of SQL companies out in the world that builds relational database systems to take care of storing and managing your data. Here are some of the established SQL companies and their products   1.     Oracle 2.     Microsoft SQL Server 3.     MySQL 4.     PostgreSQL 5.     IBM DB2 Click for downloading MySQL :) Click here   ...