SQL Select Query and Use of Select Command | Learn DBMS | Tech-Mirror

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 …

Read More

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 …

Read More

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 …

Read More

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. …

Read More

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:

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.

In …

Read More

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 …

Read More

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 …

Read More

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 …

Read More

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 …

Read More

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 …

Read More