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

How Communication Services happen in CLOUD

(Cloud computing Jobs)
(Cloud computing Jobs)
For service developers, making services available in the cloud depends on the type of service and the device(s) being used to access it. The process may be as simple as a user clicking on the required web page, or could involve an application using an API accessing the services in the cloud.

Telcos are starting to use clouds to release their own services and those developed by others, but using Telco infrastructure and data. The expectation is that the Telco’s communications infrastructure provides a revenue generating opportunity.

Using the Communications Services When in the cloud, communications services can extend their capabilities, or stand alone as service offerings, or provide new interactivity capabilities to current services.

Cloud-based communications services enable businesses to embed communications capabilities into business applications,such as Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) systems. For “on the move” business people, these can be accessed through a smartphone, supporting increased productivity while away from the office.

These services are over and above the support of service deployments of VoIP systems, collaboration systems, and conferencing systems for both voice and video. They can be accessed from any location and linked into current services to extend their capabilities, as well as stand alone as service offerings.

In terms of social networking, using cloud-based communications provides click-to-call capabilities from social networking sites,access to Instant Messaging systems and video communications, broadening the interlinking.

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