Posts

Showing posts with the label Cloud Storage

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

Cloud Storage as a Service Basics (2 of 3)

The really awesome point is cloud storage. Yes, you are storing data in cloud. But you need to understand here few good things about it.   What is cloud storage... Cloud storage involves exactly what the name suggests—storing your data with a cloud service provider rather than on a local system. As with other cloud services, you access the data stored on the cloud via an Internet link. Even though data is stored and accessed remotely, you can maintain data both locally and on the cloud as a measure of safety and redundancy.  Cloud storage has a number of advantages over traditional data storage : The benefits.. If you store your data on a cloud, you can get at it from any location that has Internet access.  This makes it especially appealing to road warriors.  Workers don’t need to use the same computer to access data nor do they have to carry around physical storage devices.  Also, if your organization has branch offices, they can all access the data from the cloud p

Cloud Storage as a Service Basics(1 of 3)

Image
Cloud storage is a model of networked enterprise storage where data is stored in virtualized pools of storage which are generally hosted by third parties. Hosting companies operate large data centers, and customers that require their data to be hosted buy or lease storage capacity from these hosting companies. The data center operators virtualize the resources according to customer requirements and expose them as storage pools, which the customers can use to store data. Physically, the resource may span multiple servers and multiple locations. The safety of the data depends upon the hosting companies and on the applications that leverage the cloud storage. Cloud storage is based on highly virtualized infrastructure and has the same characteristics as cloud computing in terms of agility, scalability, elasticity, and multi-tenancy. It is available both off-premises and on-premises.  While it is difficult to declare a canonical definition of cloud storage architecture, object sto

Cloud Storage the real Points You Need to Read Now

Image
There are hundreds of different cloud storage systems, and some are very specific in what they do. Some are niche-oriented and store just email or digital pictures, while others store any type of data. Some providers are small, while others are huge and fill an entire warehouse. In this post, you will know about: Storage in Cloud The inside details of Cloud New things in Cloud Storage Storage of CLOUD One of Google’s data centers in Oregon is the size of a football field and houses thousands of servers.  The inside details of  Cloud Storage At the most rudimentary level, a cloud storage system just needs one data server connected to the Internet.  A subscriber copies files to the server over the Internet, which then records the data.  When a client wants to retrieve the data, he or she accesses the data server with a web-based interface, and the server then either sends the files back to the client or allows the client to access and manipulate the data