Posts

Showing posts with the label cloud computing vs virtual machines

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
Post a Comment
Read more

Cloud Computing Vs Virtualization Real Differences

-
Image
Servicing of computing resources you can say as Cloud computing. They charge for some amount each service used by an user. On the other hand, making multiple machines virtually by using same hardware is called virtualization. Sell all the real differences. Public Vs Private Vs Hybrid Cloud Public Cloud:  Available to the public is called the PUBLIC cloud.  Private Cloud : Available to the particular Business/Company is called PRIVATE Cloud.  Hybrid Cloud: Combination of Public and Private Clouds. Cloud Services Related: How Industries will Change due to Cloud Computin g Cloud Services Cloud services (remote data and computation) are exposed as simple and user-friendly web services. For example, Microsoft's ADO.NET (originally called Astoria) provides the tools to expose any data object from a collection, stored in a database or other form, as a URI to an encoded form using a standard such as JSON or ATOM representation Google's AppEngine provides a way
Post a Comment
Read more