Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In passband transmission, the amplitude, phase or frequency of the carrier signal is regulated to transmit the bits. The incoming data stream is modulated onto a carrier and then transmitted over a band-pass channel. The types of passband transmission are illustrated as − Amplitude Shift Keying (ASK) In ASK, the amplitude of the signal is varied to represent the signal levels, while frequency and phase remains constant. In order to represent 0 and 1, two different amplitudes are used. Frequency Shift Keying (FSK) In FSK, the frequency of the signal is modulated to represent the signal levels, while ... Read More
We can convert a string to date with the help of STR_TO_DATE() function. Let us see an example. Creating a table. mysql> create table StringToDateDemo -> ( -> YourDate varchar(100) -> ); Query OK, 0 rows affected (0.49 sec) Inserting records into the table. mysql> insert into StringToDateDemo values('10/27/2018'); Query OK, 1 row affected (0.11 sec) The following is the syntax to convert string to date using the STR_TO_DATE() function. SELECT STR_TO_DATE(yourColumnName, '%m/%d/%Y') from yourTableName; Let us now implement it. ... Read More
Before getting into listview example, we should know about listview, Listview is a collection of items pulled from arraylist, list or any databases. Most uses of listview is a collection of items in vertical format, we can scroll up/down and click on any item.What is custom listview?Custom listview works based on customAdapter. In this custom adapter we can pass custom object. We are passing subject data to listview as shown below −Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add ... Read More
To list all columns in a table, we can use the SHOW command. Let us first create a table. mysql> create table ColumnsList -> ( -> id int, -> Firstname varchar(200), -> LastName varchar(100), -> Age int, -> Address varchar(300), -> CollegeName varchar(100) -> ); Query OK, 0 rows affected (1.33 sec) Syntax to list all column names. show columns from yourTableName; The following is the output. mysql> show columns from ... Read More
Before getting into listview example, we should know about listview, Listview is a collection of items pulled from arraylist, list or any databases. Most uses of listview is a collection of items in vertical format, we can scroll up/down and click on any item.What is custom listview?Custom listview works based on customAdapter. In this custom adapter we can pass custom object. We are passing subject data to listview as shown below.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the ... Read More
The electromagnetic spectrum is the entire range of electromagnetic radiation according to the wavelength or frequencies. It has a range of frequencies from 1Hz to Hz. The waves in order of increasing frequencies are radio waves, microwaves, infrared rays, visible light, UV rays, X-rays and gamma rays.Among these range, the frequencies between Hz to Hz are used for communication. The following diagram shows the electromagnetic spectrum. The first figure gives the full range of frequency spectrum while the second figure elaborates that part of the spectrum which can be used for data communication − The ... Read More
We can store data in MySQL as JSON with the help of JSON data type. The following is an example. Let us now create a table. mysql> CREATE table JsonAsMySQLDemo -> ( -> id int, -> name varchar(100), -> PageDemo JSON, -> eventInfo JSON -> ); Query OK, 0 rows affected (0.67 sec) Storing records into JSON data type. mysql> INSERT into JsonAsMySQLDemo values -> ( -> 1, ... Read More
Before getting into listview example, we should know about listview, Listview is a collection of items pulled from arraylist, list or any databases. Most uses of listview is a collection of items in vertical format, we can scroll up/down and click on any item.This example demonstrate about How to make a ListView in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. In the above activity_main.xml, we have declared a ... Read More
In the electromagnetic spectrum, all omnidirectional waves in the frequencies 3KHz to 1GHz are called radio waves. They are widely used for communications since they are easy to generate, can travel long distances and can penetrate buildings. Radio waves have omnidirectional antennas, i.e. antennas that can send signals in all directions. The properties of radios waves vary according to their frequencies. However, radio waves at all frequencies are prone to interference from electrical equipments like motors etc. Low and Medium Frequency Radio Waves Low and medium frequency radio waves can pass through obstacles and have ground propagation. However, the ... Read More
The EXISTS tells if the query returned results or not while IN can be used for comparing one value with other. IN uses literal values. Note − IN is preferred in a subquery whenever a subquery result is very small. If the subquery result is very large then EXISTS is used. Since IN is a preferred choice for subquery results that are smaller, we are considering an example of IN. To create a table. mysql> create table InSubQueryDemo -> ( -> PNumber int, -> PName varchar(100) -> ... Read More