Tutorial

SQL Syntax

SQL Syntax

SQL keywords are not case-sensitive which means SELECT is the same as select. Database and Table names may be case-sensitive, that depends on the operating system. This means database and table names are case-sensitive on Linux/Unix operating systems and case-insensitive on Windows operating systems. Comments in SQL Comments are ingored by database engine. We write …

SQL Syntax Read More »

SQL Overview

SQL Overview

SQL (Structured Query Language) is a standard query language for storing, managing and retrieving data in relational database management system. What is Relational Database Management System A relational Database Management System (RDBMS) is a database management system that is based on the relational model and used to interact with a relational database. RDBMS is based …

SQL Overview Read More »

sql introduction

SQL Introduction

SQL (Structured Query Language) is a standard query language for storing, managing and retrieving data in relational database management system. SQL is not a database system, it is a query language. It is pronounced as S-Q-L or sometimes as See-Quell. Applications of SQL SQL allows users to access and manipulate databases. SQL allows users to …

SQL Introduction Read More »

Literals in C

Literals in C

Constant values used within a program are known as Literals. These constant values occupy memory but do not have any reference like variables. There are four types of literals in C Integer literal Float literal String literal Character literal Integer literal Integer literals are used to represent and store the integer values. Integer literal is followed …

Literals in C Read More »

Operators in C

Operators in C

An operator is a symbol that helps us to perform specific mathematical and logical computation operation on a value or a variable. There are following types of operators to perform different types of operations in C language. Arithmetic Operators Relational Operators Logical Operators Bitwise Operators Assignment Operators Other Operators Arithmetic Operator An arithmetic operator performs …

Operators in C Read More »

Identifiers in C

Identifiers in C

Identifier refers to name given to different entities such as constants, variables, structures, functions, etc. Example int age; double mobile_number; Here age and mobile_number are identifier. int and double are data type. Rules for naming Identifier We cannot use keywords as identifier. The first letter of an identifier should be either a letter or an …

Identifiers in C Read More »

Storage Classes in C

Storage Classes in C

Storage class determines the scope, visibility, memory location, default value and lifetime of a variable or function. A storage class in C is used to describe the following things. Variable’s scope. Location where the variable will be stored. Initialized value of a variable. Lifetime of a variable. Who can access a variable? There are four …

Storage Classes in C Read More »

Keywords in C

Keywords in C

Keywords are predefined, reserved words used in programming that have special meanings to the compiler. It helps us to use the functionality of C language. We cannot use it as a variable name, constant name, etc. There are 32 reserved keywords in the C language. ** All keywords must be written in lowercase. Table of 32 …

Keywords in C Read More »

Constants in C

Constants in C

A constant is a variable whose value cannot be changed after its definition. Constants in C are the fixed values and its value remains unchanged during the entire execution of the program. Generally, we use const keyword to create a constant. There are two Ways in C to define constants Using const keyword. Using #define preprocessor. Constants are also …

Constants in C Read More »

Variables in C

Variables in C

Variable is a storage place to hold data which has some memory allocated to it. It is used to store data.  it can be reused many times. We can change value of a variable during execution of a program. Different types of variables require different amounts of memory. C is a strongly typed language. This …

Variables in C Read More »