Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles on Trending Technologies
Technical articles with clear explanations and examples
Cable, ADSL, and Fiber
Definitions Cable − Cable network is a system of providing varied services like television programming, FM programming, Internet and telephone services over existing cable TV network. ADSL − Asymmetric Digital Subscriber Line (ADSL) is a type of broadband communications technology to transmit digital data at a high bandwidth on existing phone lines to homes and businesses. Fiber − Fiber or Fiber to the home (FTTH) is a technology to deploy optical fibers in the local loop of the telephone networks to the users home for providing high-speed data connectivity. Comparisons Wires Cable − They use the copper coaxial ...
Read MoreDigital Advanced Mobile Phone System
Digital Advanced Mobile Phone System (D-AMPS)is a digital version of Advanced Mobile Phone Systems (AMPS), the original analog standard for cellular phones. D-AMPS uses a combination of time division multiple access (TDMA) and frequency division multiple access (FDMA). It adds TDMA to get three channels per AMPS channel, thus tripling the number of calls on a channel. Features They are standardised by IS-54 and IS-136. As in AMPS, D-AMPS also uses frequencies from 800 to 900MHz for transmission. Half of the spectrum is used for sending signals and the other half is used for receiving signals. The frequency ...
Read MoreLocal Access and Transport Areas
In U.S. telecommunications,Local access and transport area (LATA) refers to a geographical area in the U.S. which is allocated to telephone companies. The telephone companies, legally termed as local exchange carriers (LECs) provide telecommunication services, within the allotted areas. A LATA may be within the same U.S. state or may span across more than one state, as laid down in Telecommunications Act of 1996. Two types of connections are possible. IntraLATA − It is a connection between two LECs within the LATA. InterLATA − It is a connection providing long-distance service between LECs in different LATAs.
Read MoreGlobal System for Mobile Communications
Global System for Mobile communication (GSM) is the most widely used digital mobile telephony system. GSM technology was first launched in Finland in 1991. It was developed by European Telecommunications Standards Institute (ETSI) to describe the protocols for 2G mobile communications.Presently, GSM comprises of approximately 90% of mobile connections worldwide. Features Original 2G standard was a digital, circuit-switched, full duplex network. GSM is part of the evolution of wireless mobile telecommunications including High-Speed Circuit-Switched Data (HSCSD), General Packet Radio Services (GPRS), Enhanced Data GSM Environment (EDGE), and Universal Mobile Telecommunications Service (UMTS). GSM operates at either 900 MHz ...
Read MoreNetwork Physical Layer
The network physical layer is the lowest network layer in the Open System Interconnections (OSI) model. The primary concern of this layer is transmission of individual bits from one node to another over a physical medium. In TCP/IP model, the physical layer and the data link layer are combined as the host - to - network layer. Physical Layer in the OSI Model The Open System Interconnections (OSI) model is a layered networking framework that conceptualizes how communications should be done between heterogeneous systems. The physical layer is its lowest layer. The following diagram depicts the position of the physical ...
Read MoreGet table names using SELECT statement in MySQL?
To get table names using SELECT statement, use “information_schema.tables”. Let us see an example, wherein we have a database that contains 3 tables. The syntax to get all table names with the help of SELECT statement. SELECT Table_name as TablesName from information_schema.tables where table_schema = 'yourDatabaseName'; Using database “test”, and applying the above syntax to get the table names using SELECT mysql> use test; Database changed mysql> SELECT Table_name as TablesName from information_schema.tables where table_schema = 'test'; Output with the name of the three tables. +--------------------+ | TablesName ...
Read MoreHow to prepend a string to a column value in MySQL?
To prepend a string to a column value in MySQL, we can use the function CONCAT. The CONCAT function can be used with UPDATE statement. Creating a table. mysql> create table PrependStringOnCOlumnName -> ( -> Id int, -> Name varchar(200) -> ); Query OK, 0 rows affected (1.35 sec) Inserting some records. mysql> insert into PrependStringOnCOlumnName values(1, 'John'); Query OK, 1 row affected (0.12 sec) mysql> insert into PrependStringOnCOlumnName values(2, 'Carol'); Query OK, 1 row affected (0.18 sec) mysql> insert into PrependStringOnCOlumnName values(3, 'Johnson'); Query OK, 1 row affected (0.45 sec) ...
Read MoreHow should I enable LOAD DATA LOCAL INFILE in my.cnf in MySQL?
We can enable it with the help of the SET command with GLOBAL. The first time, local infile will be off. The following is the syntax. mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile'; Here is the output. +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | OFF | +---------------+-------+ 1 row in set (0.01 sec) We can enable the local infile with the help of ON or boolean value true or numeric value 1. The following is the syntax to enable the local infile. mysql> SET GLOBAL local_infile = 'ON'; Query OK, 0 ...
Read MoreHow to take backup of a single table in a MySQL database?
The backup of a table can be made with the help of backup table as well as mysqldump utility. The backup table concept was used in MySQL version 5.0 and its earlier version. Here, I am performing backup with the help of mysqldump. Firstly, we will open cmd with the help of shortcut key. The mysqldump will run at the cmd. Therefore, firstly open cmd with the help of shortcut key − windowskey+R; Here is the snapshot − Now, cmd will open − In this, the MySQL bin folder is present at the following location − ...
Read MorePassing an array to a query using WHERE clause in MySQL?
We can pass an array with the help of where IN clause. Let us first create a new table for our example. mysql> create table PassingAnArrayDemo -> ( -> id int, -> Firstname varchar(100) -> ); Query OK, 0 rows affected (1.60 sec) Let us now insert records. mysql> insert into PassingAnArrayDemo values(1, 'John'), (2, 'Carol'), (3, 'Smith'), (4, 'Bob'), (5, 'Johnson'), (6, 'David'), (7, 'Sam'), (8, 'Jessica'); Query OK, 8 rows affected (0.32 sec) Records: 8 Duplicates: 0 Warnings: 0 To display all records. mysql> select *from PassingAnArrayDemo; The ...
Read More