Posts

Structured Query Language

                  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 | IF Statements | Switch Statement | Examples

Image
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)       {     ...