Posts

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

6 Advantages of Columnar Databases over Traditional RDBMS

Image
In traditional RDBMS, when a data source is accessed by multi users at single time, then database will go into deadlock state. One of the advantages of a columnar model is that if two or more users want to use a different subset of columns, they do not have to lock out each other.         (Superior benefits for NoSQL Jobs) This design is made easier because of a disk storage method known as RAID (redundant array of independent disks, originally redundant array of inexpensive disks), which combines multiple disk drives into a logical unit. Data is stored in several patterns called levels that have different amounts of redundancy. The idea of the redundancy is that when one drive fails, the other drives can take over. When a replacement disk drive in put in the array, the data is replicated from the other disks in the array and the system is restored. The following are the various levels of RAID: RAID 0 (block-level striping without parity or mirroring) has no (or zero) re

Top features of Apache Avro in Hadoop eco-System

Image
Avro defines a data format designed to support data-intensive applications, and provides support for this format in a variety of programming languages. The Hadoop ecosystem includes a new  binary data serialization system  — Avro.  Avro provides: ·       Rich data structures. ·          A compact, fast, binary data format. ·          A container file, to store persistent data. ·          Remote procedure call (RPC). ·         Simple integration with dynamic languages. Code generation is not required to read or write data files nor to use or implement RPC protocols. Code generation as an optional optimization, only worth implementing for statically typed languages. Its functionality is similar to the other marshaling systems such as Thrift, Protocol Buffers, and so on. The main differentiators of Avro include the following: [Hadoop Interview Questions] Dynamic typing —  The Avro implementation always keeps data and its corresponding schema together. As a resu

RDBMS Vs Key-value Four Top Differences

Image
This post tells you differences between rdbms and distributed key-value storage. Rdbms is quite  different from key-value storage. RDBMS (Relational Database) You have already used a  r elational  d atabase  m anagement  s ystem — a storage product that's commonly referred to as  RDBMS .  It is basically a structured data. RDBMS systems are fantastically useful to handle moderate data. The BIG challenge is in scaling beyond a single server.  You can't maintain redundant data in rdbms. All the data available on single server. The entire database runs on single server. So when server is down then database may not be available to normal business operations. Outages and server downs are common in this rdbms model of database. Key-Value Database Key-value storage systems often make use of redundancy within hardware resources to prevent outages. This concept is important when you're running thousands of servers because they're bound to suffer hardware bre

Amazon web services -Object Storage

Image
Object Storage: Object storage provides the ability to store, well, objects — which are essentially collections of digital bits. Those bits may represent a digital photo, an MRI scan, a structured document such as an XML file — or the video of your cousin's embarrassing attempt to ride a skateboard down the steps at the public library (the one you premiered at his wedding). Object storage offers the reliable (and highly scalable) storage of collections of bits, but imposes no structure on the bits. The structure is chosen by the user, who needs to know, for example, whether an object is a photo (which can be edited), or an MRI scan (which requires a special application for viewing it). The user has to know both the format as well as the manipulation methods of the object. The object storage service simply provides reliable storage of the bits. Difference between Object storage and File storage Object storage differs from file storage, which you may be more familiar with from usi

SOAP Vs REST top differences you need to know

What is SOAP? SOAP is based on a document encoding standard known as Extensible Markup Language (XML, for short), and the SOAP service is defined in such a way that users can then leverage XML no matter what the underlying communication network is. For this system to work, though, the data transferred by SOAP (commonly referred to as the payload) also needs to be in XML format. Notice a pattern here? The push to be comprehensive and flexible (or, to be all things to all people) plus the XML payload requirement meant that SOAP ended up being quite complex, making it a lot of work to use properly. As you might guess, many IT people found SOAP daunting and, consequently, resisted using it. About a decade ago, a doctoral student defined another web services approach as part of his thesis: REST Representational State Transfer, which is far less comprehensive than SOAP, aspires to solve fewer problems. It doesn't address some aspects of SOAP that seemed important but tha

SQL Vs NOSQL real differences to read today

Image
SQL and NoSQL both or two different languages that will be used on different databases. In resolving bigdata analytics NoSQL is most popular. Where as SQL is popular in relational databases. SQL Vs NOSQL Top Differences SQL SQL is structured query language  It was first commercial language used in RDBMS  SQL language is divided into multiple sub elements NoSQL Data is not in one machine or even one network.  Data can be any type public data and private data  Huge volume of data so you cannot put it in one place.  It is uncoordinated in time as well as space.  It is not always nice, structured data that SQL was meant to handle. Also Read RDBMS Vs NoSQL Databases top differences

What is CompTIA Cloud+ Certification

Image
#What is CompTIA Cloud+ Certification: The CompTIA Cloud+ certification is an internationally recognized validation of the knowledge required of IT practitioners working in cloud computing environments. This exam will certify that the successful candidate has the knowledge and skills required to understand standard cloud terminology and methodologies to implement, maintain, and deliver cloud technologies and infrastructures (e.g., server, network, storage, and visualization technologies); and to understand aspects of IT security and use of industry best practices related to cloud implementations and the application of virtualization. Related: Cloud Computing+Jobs Cloud+ certified professionals ensure that proper security measures are maintained for cloud systems, storage, and platforms to mitigate risks and threats while ensuring usability. The exam is geared toward IT professionals with 24 to 36 months of experience in IT networking, network storage, or data center adminis