Posts

Showing posts with the label articles

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 to Modernize Software Applications with AI (3 of 3)

Artificial intelligence is now changing the world. It is also called synonym for automation. The new concept is we can implement AI in the software development life cycle. How we can develop software applications with improved quality? Software Engineering is concerned with the planning, design, development, maintenance, and documentation of software systems. It is well known that developing high-quality software for real-world applications is complex.  Such complexity manifests itself in the fact that software has a large number of parts that have many interactions and the involvement of many stakeholders with different and sometimes conflicting objectives.  Furthermore, Software Engineering is knowledge-intensive and often deals with imprecise, incomplete and ambiguous requirements on which analysis, design, and implementations are based on. Artificial intelligence (AI) techniques such as knowledge-based systems, neural networks, fuzzy logic, and data mining have be

How to Modernize Software Applications with AI (2 of 3)

Image
Creating like human intelligence in devices, the software also called artificial intelligenc e. Ambient intelligence because of its interactivity with the user is an attractive medium to advertisers. Some examples: Human Intelligence Adswitch This could be a large step forward for the advertising industry as not all adverts are able to reach their potential customers and now advertisers can target the correct market as the advert will adapt to the changing environment . Ambient Intelligence The application of Ambient Intelligence in the Home Automation field is likely to continue as it can be simply allowed to disappear into the environment without homeowners having to notice it carrying out the complex instructions that would make lives easier.   It is also likely that newer methods of interacting with the interfaces will be a hot area for some time to come as speech and touch have specific limitations. It can be argued that one of the main reasons that ambient inte

Story IoT devices human intelligence basic concepts(1 of 3)

Image
The definition of Artificial intelligence is the continuous technological advances have gradually surrounded people with a wide range of electronic devices and information technology. The short name for Artificial intelligence is 'ai'. In this regard, it is necessary to develop intuitive interfaces and systems with some degree of intelligence, with the ability to recognize and respond to the needs of individuals in a discrete and often invisible way, considering people in the center of the development to create technologically complex and intelligent environments. Artificial Intelligence Vs Ambient Intelligence Artificial Intelligence Ambient Intelligence 1. Artificial Intelligence Artificial intelligence in basic words machines can take decision intelligently They understand natural language - How humans communicate each other Robots - you can treat them as Artificial intelligent machines. Machine Language Algorithms help machines act as intelligent machin