SQL SELECT Query SQL SELECT Query is used to getting or retrieve data from a table in the database. It is most commonly and highly used SQL statement in DBMS. A query may give result from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must specify the column(s) name
Continue reading »What is SQL? | List of SQL Commands | SQL Queries
What is SQL? SQL (Structured Query Language) is used to perform operations on the records stored in database like creating and modifying tables, updating records, deleting records, views, functions etc. Structured Query Language is just a query language, it is not a database or tables. To perform SQL queries, first you need to install any database for example Oracle, MySQL, MongoDB, PostGre
Continue reading »Types of Databases | Different Kinds of Database Management Systems
Types of Databases There are different types of databases which are categorized on the basis of their functionalities. These are as follows : Relational Databases : Relational Databases is the most common of all the different types of databases. In this, the data in a relational databases is stored in various tables. Each table has a key field which is
Continue reading »What is Database Design? | How Can I Design Database?
Database Design Database design is the process of generating a detailed data model of database. This data model contains all the needed logical and physical design and physical storage parameters needed to generate a design in a data definition language (DDL), which can then be used to create a database. A fully attributed data model contains detailed attributes for each entity.
Continue reading »C Strings | String Functions in C Language
C Strings C strings is nothing but an array of characters (OR char data types). that is terminated by \0 (null character). String in/output:
1 2 |
printf("%s",S); scanf("%s",S); |
string.h : Collection of functions for string manipulation. There are two ways to declare string in c language. By string literal By character array Let’s see the example of declaring string by literal.
1 |
char ch[]="TechMiror"; |
In
Continue reading »C Functions | Functions in C | Learn C Language
C Functions C Functions is a block of code that takes information in (symbolic names called parameters), do some computation or operations, and (usually) returns a new piece of information based on the input parameter information. A function is a group of statements that perform together on a specific task. Every C program has at least one function, which is main() (Entry
Continue reading »C Arrays: How to Declare, Initialize and Access Elements ?
C Arrays C arrays is a collection of data items, with all of the same type and accessed using a common name. A one-dimensional(1-D) array is like a list; A two dimensional(2-D) array is like a table. In C language there is no limits on the number of dimensions in an array, though specific implementations may. Some texts refer to
Continue reading »What is a Database? | Introduction to Database
What is Database? Before we learn about database , let’s understand – What is Data? In simple words data can be facts related to any object. For example your name, age, height, weight, color etc are some data related to you. A picture, image, file etc can also be considered data. Database is a systematic collection of data. Databases support manipulation
Continue reading »Branching and Looping Statements in C | Decision Making | Control Statements
Branching and Looping in C Language We can control the flow of a program using branching and looping statements in any language. Branching statements give us code which is optionally executable, depending on the outcome of certain tests or you can say certain cases which we can define. Looping statements are used to repetition of a section of code a
Continue reading »Data Types in C Language | What is Data Types?
C Data Types Data types specify how we enter data into our c programs and what type of data we can enter in it. C language has some predefined set of data types to handle various kinds of data that we use in our c program. C data types have different storage capacities and meaning. Different type of data types in
Continue reading »