Posts

Showing posts with the label Amazon Web services

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

3 Top AWS benefits to the Organization

In this post, I have explained benefits for an organization while using AWS. You can choose the AWS as a career option since a lot of openings are there in the market. To be specific, Cloud storage is an online storage facility which is given to users so that they can use external servers to store or host their data.    Most of the business organizations need large storage capacities. Moreover, businesses need storage capacities to be clubbed with mobility. Due to this, Cloud computing has become very popular in the last few years. Amazon Web Services or AWS makes sure that anything digital is securely stored and available anywhere. Due to the same reason, Amazon Cloud computing is the most widely used and popular Cloud service on the Internet.  In this post, we will tell you about some general benefits of using Amazon Web services. We will tell you how Amazon Cloud computing helps your organization. Benefits of using Amazon Web Services Amazon Web services provide a

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