Category: SQL

SQL

Advantages of MongoDB

Advantages of MongoDB Having seen the good features of MongoDB, now every developer should be able to understand why it is better to use NoSQL based database for big data transactions and for implementing a scalable model. Now, its time to leave behind the schema definitions of RDBMS and get an advantage of using schema-less […]

SQL

Transmission Mediums in Computer Networks

Transmission Mediums in Computer Networks Data is represented by computers and other telecommunication devices using signals. Signals are transmitted in the form of electromagnetic energy from one device to another. Electromagnetic signals travel through vacuum, air or other transmission mediums to move from one point to another(from sender to receiver). Electromagnetic energy (includes electrical and […]

SQL

SQL VIEW

SQL VIEW A VIEW in SQL is a logical subset of data from one or more tables. View is used to restrict data access. Syntax for creating a View, CREATE or REPLACE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition As you may have understood by seeing the above SQL query, a view is […]

SQL

What is an SQL Sequence?

What is an SQL Sequence? Sequence is a feature supported by some database systems to produce unique values on demand. Some DBMS like MySQLsupports AUTO_INCREMENT in place of Sequence. AUTO_INCREMENT is applied on columns, it automatically increments the column value by 1 each time a new record is inserted into the table. Sequence is also some what similar to AUTO_INCREMENT but it has some […]

SQL

SET Operations in SQL

SET Operations in SQL SQL supports few Set operations which can be performed on the table data. These are used to get meaningful results from data stored in the table, under different special conditions. In this tutorial, we will cover 4 different types of SET operations, along with example: UNION UNION ALL INTERSECT MINUS UNION […]

Back To Top