Code With Vikas

 In this post I'm going to discuss how you can start working with relational databases in your own system practically. Database Management System is really a very important subject in terms of GATE,University exams, placement, jobs,etc. So, It is better to have practical knowledge of databases with SQL. SQL stands for Structure Query Language , I have already discussed about SQL in one of my post. So, MySQL is a DBMS, to work with database and we are going to discuss about it. Installing MySQL 1. Go to  Download MySQL Installer  . This link is for window users, other users can download it's latest release from www.dev.mysql.com. 2.   Double click on downloaded setup, it will start installer . It will take only 3 minutes to download MySQL.Please make sure that you must have a good internet connection. 3. Select a setup type as seen in  image. You can choose as per your need but I would suggest that you should select Full because it contains all products needed fo...

                  Structured Query Language   SQL (Structured Query Language ) is a query language that is basically used to make a connection with the database and work with the database. According to ANSI(American National Standards Insititute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database or retrieve data from a database. Some common relational database management systems that use SQL are Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. SQL is not case sensitive. Table Basics A relat...

Control Statements  These are those statement which controls the flow of program control. They transfer the control of program to another part of program conditionally or unconditionally. There are several control statements in the C Programming which are being discussed below - If Statement  If statement evaluates the condition inside the parentheses. if the condition is true then statement inside the if body are executed and if the condition is evaluated to false then statements inside the body of if are skipped. Syntax :  if(condition)                 {                     Statements;                  } Flow Chart :  If-If Statement  This is used to check multiple conditions for a particular problem. Syntax :       if(condition)       {     ...