Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Protocols: Top 6 Key Parts

In telecommunications, a protocol is a system of rules that allow two or more entities of a communications system to transmit information. The medium can be any kind of entity.

 iot protocols
 What is PROTOCOL
  1. Important aspects of networks that are neither devices nor media are rules or protocols. These rules are the standards and protocols that specify how the messages are sent, how they are directed through the network, and how they are interpreted at the destination devices. 
  2. For example, in the case of Jabber instant messaging, the XMPP, TCP, and IP protocols are all important sets of rules that enable our communication to occur.
  3. These are the rules or standard that defines the syntax, semantics, and synchronization of communication and possible error recovery methods. Protocols may be implemented by hardware, software, or a combination of both.

Communicating systems

They use well-defined formats (protocol) for exchanging messages. 
  • Each message has an exact meaning intended to elicit a response from a range of possible responses pre-determined for that particular situation. 
  • The specified behavior is typically independent of how it is to be implemented. Communications protocols have to be agreed upon by the parties involved. 
  • To reach an agreement, a protocol may be developed into a technical standard. A programming language describes the same for computations, so there is a close analogy between protocols and programming languages: protocols are to communications as programming languages are to computations.

Most commonly used devices in a networking

  1. Switch - the most common device for interconnecting local area networks 
  2. Firewall - provides security to networks 
  3. Router - helps direct messages as they travel across a network 
  4. Wireless Router - a specific type of router often found in home networks 
  5. Cloud - used to summarise a group of network devices, the details of which may be unimportant to the discussion at hand 
  6. Serial Link - one form of WAN interconnection, represented by the lightning bolt-shaped line 

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers