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

Switch Statement In Java

Switch Statement: The switch statement is just like if-else-if ladder statement. It executes one statement from multiple conditions. It works with a byte, short, int, long, and String. In other words, we can say the Switch case statement is a substitute for a long if statement that compares to several integral values. Syntax of Switch statement in java Enhance Switch or Switch With Arrow: The new syntax uses the -> operator instead of the colon we're used to with switch statements. Also, there's no break keyword. Another addition is the fact that we can now have comma-delimited criteria. Syntax of Enhance Switch in java

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

Variables and Data types in Java

MY PROGRAMMING PARADISE Variables: Variables are used to store data in a computer’s memory. In other words, we can say, variables are just like a container that holds the value while the java program executed. There are three types of variables in java: 1- Local 2- Instance 3- Static Rules for declaring identifier (Variable name) 1- All identifiers must begin with a letter, currency character, or underscore. 2- Blank spaces are not allowed. 3- An identifier name is case-sensitive. 4- A keyword cannot be used as an identifier. Declaring variables: byte age = 28; short salary =32500; float price = 25.50f; char name = ‘v’; boolean flag=true; Data types: There are two types of data types in java. 1- Primitive Data type 2- Non- primitive Data types Primitive Data type: There are mainly eight types of primitive data types: Types Size Range Default Value byte 1 Byte [-128, 127] 0 short 2 Byte [-32,768 , 32...

My Pro Paradise

Search This Blog