Statements Of SQL

Now that we know what a Database is, and what does it contain, lets not waste time and jump into the main topics that you should be aware of when the word SQL comes to your mind.

From here onwards I will refer to the below table, as an example and refer to SQL Statements.

Database Structure

So My sample Database has got Two Tables, named C_Korner and Sales, Sales is as of now empty, as of now we are more interested to play around with the C_Korner Table, where it has got:

1. Four Columns (A_ID, U_Name, U_Password, U_Status), and
2. Four Rows, means Four Records.

An Important Thing about SQL is that it is not case-sensitive like other Languages. The Language Structure is very friendly.

Now, There are many types of Database, which we will gradually come to know with our posts, here just to give you some examples will be, MySQL, MsSQL, PostgreSQL, etc etc.

We are now not focusing on the Database Server Types. To Be very very generic, we are just trying to be friendly with SQL.

With most other Languages, semi-colon is a necessity, and to terminate a statement like in Java or Php.

But with SQL, it depends on Database Server, some Database systems requires semi-colon at the end and some does not. Well semi-colons are sometimes used in some complex statements where we would combine several statements, and thus semi-colon will make the SQL server know, that the statements are separated and the SQL Engine would not be confused.

So Isn't it Interesting? Well Guess You are confident to dive into the world of SQL. Thats all for this post friends, and Don't Forget to check my next post.

Thank You!