Introduction to SQL | Installation of MySQL

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

Comments

Methods of String in java

String in Java String: A Java string is a sequence of characters that exist as an object of the class java. lang. Here is the list of important methods available in the java string class: Ø startsWith ( ): It checks if the string starts with the given prefix. If yes then return true else false. Ø endsWith () : It checks if the string ends with the given suffix. If yes then return true else false. Ø substring(int begin index) : It return s the substring of the string. The substring start s with the character at the specified index. Ø substring(Int begin index , int end index) : Returns the substring. The substring starts with the character at begin index and ends with the character at end index. Ø toLowerCase() : It converts all the character s of the string into lower case(Small Letters). Ø toUpperCase() : It converts all the character s of the string into upper case(Capital Let...

Data Types In SQL

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 ...

Conditional Statements In Java

Conditionals Statement A conditional statement is a set of rules performed if a certain condition is met. A conditional statement begins with the keyword if followed by parentheses. The result of the evaluation is true or false. · ‘ if ‘ statement · ‘ if-else ‘ statement · Nested ‘ if ‘ statement · ‘ if-else - if ‘ statement IF statement: ‘IF’ statement is the most basic and simple statement among all the statements. For example- if a value is less than 0, return “Negative value”. Let’s see an example- IF-ELSE statement: The if-else is statement is an extended version of If. Let’s see an example- Nested IF-ELSE statement : In Java, when there is an if statement inside another if statement then it is known as nested if-else. Let’s see an example- IF-ELSE-IF: ‘ if-else-if ’ statement is used when we need to check mul...

My Pro Paradise

Search This Blog