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

IBM - Open Cloud Architecture

Cloud computing is changing the way we think about technology, and it’s no passing fad. Consumers are using the cloud to store music. Startups are turning to cloud to get up and running without huge investments. Big businesses and governments are relying on clouds to make more data more accessible. 

Cloud computing.

is changing how business and society run, and it's opening up huge avenues of innovation. We are looking at how developers are now combining systems of record with systems of engagement, and we see a new style of cloud-based application emerging.

These are systems of interaction. For these applications to be sustainable, cloud computing needs to be built on open source and standards.

Wide adoption of open source software and open standards should be everyone's goal. It means customers won’t have to fear vendor lock-in, and organizations can participate in a growing market that welcomes a wide variety of cloud technology and service providers.

We've learned through our experience that open source and standards allow developers to share information more quickly and easily, and at lower costs. This leads to greater innovation. We are at an inflection point. We're focusing the industry on important standards for interoperability, and their open source reference implementations will:
  • Ensure that end users have a strong voice in establishing and adopting cloud computing paradigms
  • Reduce barriers of entry into cloud computing, such as development skills and freedom of choice
  • Increase the long-term viability of today’s cloud investments
  • Prevent unnecessary architectural complexity and fragmentation.
  • Openstack is a software to control your cloud

Open-stack software 

It controls large pools of compute, storage, and networking resources throughout a datacenter, managed through a dashboard or via the OpenStack API. OpenStack works with popular enterprise and open source technologies making it ideal for heterogeneous infrastructure.

Hundreds of the world’s largest brands rely on OpenStack to run their businesses every day, reducing costs and helping them move faster. OpenStack has a strong ecosystem, and users seeking commercial support can choose from different OpenStack-powered products and services.

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