What is SQL Server LEFT JOIN?

In SQL, a LEFT JOIN is a type of outer join that returns all rows from the left table (also called the “first” or “left” table), and any matching rows from the right table (also called the “second” or “right” table). If there is no match, NULL values are returned for right table’s columns. Here […]

Oracle What and How

What are views in Oracle? A View in Oracle is the representation of a SQL statement that is stored in memory. It can easily be re-used. The following is an example query: SELECT customerid, customername FROM customers WHERE countryid=’US’; To create a view use the CREATE VIEW command as seen in the following example: CREATE […]

SQL Joins: Left Join vs Inner Join

What is SQL JOIN? SQL is a Structured Query Language. Join is SQL instruction to combine different sets of data (i.e. two tables) together. So let’s say there are two tables of data, one of them has information about people firts_name, last_name, id, and the second table has information of people exact location and you […]

Oracle SQL: UNION vs UNION ALL

UNION and UNION all are both set operators. This means that they operate on sets of data that both combine two sets of data into singe result set. Difference between UNION and UNION ALL The difference of UNION and UNION ALL is how they treat the duplicates. UNION removes duplicate results from final result UNION […]

Container Orchestration with Kubernetes

It is 2020, and containers and mainly container orchestration industry is hot right now. The usage statistics of container orchestration is increasing and it is forecasted to be increased yearly (report). Kubernetes Kubernetes is a container orchestration solution for deploying, scaling and managing containers across multiple physical or virtual machines. It was open-sourced by Google […]

What is Container Orchestration?

Companies that have more than 1K containers and 300 services do need container orchestration. So what is container orchestration? Orchestration is a set of operations that are used for selection, deployment, monitor and control the configurations of resources by cloud providers or application owners to guarantee a quality service. Container orchestration enables cloud and application […]

Data and Data Resources

What is a data resource? The difference between data and a data resource is that the data exists solely on the internet and a data resource is collected with similar data and stored to a certain scale. For example, a data resource could be all telephone number of people living in a certain area, whereas […]

Data Orchestration Tools

When is the data orchestration process is required? Companies that need data orchestration are those that need to compute easily in the public cloud. In the past, many companies used on-premise computing but by the time they started to migrate from on-premise to cloud. What is cloud migration? Moving the data, application or any business […]

Data Orchestration Industry

The data industry is rising and the main reason is that many companies are built around data. Lot’s of data-driven applications are built yearly that solve different issues. Having accurate data helps to improve products, keep customers happy and therefore focus organization goals more strategically. The more data-driven applications the more need for data orchestration […]