Peer respond with at least 200 words in apa format thanks.
What does SQL stands for? Why is SQL such a powerful language?
SQL or Structured Query Language is the language used for relational database manipulation. It is a very powerful tool because it is good for creating and managing large databases, which most tech corporations utilize. SQL uses English statements, making it easy to use. SQL also is able to run on many different platforms such as servers, computers, or tablets (Why SQL…, 2011).
Why is a Join in SQL so powerful? What does it do and how does it work.
The SQL JOIN command is very powerful because it allows the user to link multiple tables together. This allows the user to see things like customer information for customers who made a specific order. The JOIN command will show the order information plus the customer information. In order for tables to be joined they must have at least one row that contains identical data (Pratt, 2012). An example would be:
SELECT CustomerName, CustomerInfo, OrderNum, OrderInfo
FROM Customer, Orders
WHERE Customer.OrderNum=Orders.OrderNum
Each table contains the OrderNum and thus can be linked (Pratt, 2012).
Why is by Query-By-Example so popular? How does it work? Give an example you have experienced. Why is it the better choice for the application?