SQL CREATE Table
SQL CREATE Table command is used to create a table in SQL. In order to create a table using SQL, you need a table name, column name and it’s datatypes. SQL CREATE Table Syntax Let’s check the basic syntax of … Read more »
SQL
SQL Select Database
In a real-world scenario, you will have multiple databases in your SQL Schema. In order to perform any kind of operations on the database, you need to select the database first. The SQL USE statement is used to select any … Read more »
SQL RENAME database
SQL RENAME DATABASE statement is used to rename a database. Sometime we need to rename database if in later stage stage we find that database name should be more relevant or if we want to create a temporary database. Now … Read more »
SQL DROP database
SQL DROP statement is used to drop or delete database objects from the schema. For example: If you want to drop a table you can user drop table statement. SQL DROP database statement is used to drop or delete databases … Read more »
SQL Create Database
In order to store and manipulate data in a database, you need to first create a database. This database subsequently holds tables and data. We are assuming that you already have MySQL or SQL server with you to use. If … Read more »
SQL Functions
SQL provides many built-in functions to perform calculations on data. Operations such as mathematical calculations, string manipulation like concatenation, substring are performed using these SQL Functions. SQL Functions broadly can be divided into the following two categories. Aggregate Functions Scalar … Read more »
SQL Keywords
SQL Keywords are the reserved words that are used to perform various operations in the database. These Keywords are case insensitive. For example, SELECT and select has the same meaning in SQL. List of SQL Keywords The available SQL Keywords … Read more »
SQL Expressions
SQL Expressions are combination of one or more values, operators and SQL functions that evaluate to a value. These SQL EXPRESSIONs are similar to a formula and they are written in query language. You can also use them to query … Read more »
SQL Operators
SQL Operators are the reserve keywords, characters or symbols which are mainly used along with the WHERE clause to perform operations such as comparisons and arithmetic operations. These reserve keywords, characters or symbols are known as operators. These operators are … Read more »
SQL Data Types
SQL Data Types denotes the type of data that can be stored in a table column. Each column in a table is associated with a data type. For example, for storing integer types data in a column, you need to … Read more »