SQL Language and Relational Database Systems: What You Need to Know

What is SQL and Why is it Important?

SQL language and relational database systems based on it are one of the most important foundation technologies in the computer industry. Over the last two decades, SQL has grown from its first commercial use into a computer product and services market segment worth tens of billions of dollars per year, and SQL stands today as the standard computer database language. Literally hundreds of database products now support SQL, running on computer systems from mainframes to personal computers and even handheld devices. An official international SQL standard has been adopted and expanded twice. Virtually every major enterprise software product relies on SQL for its data management, and SQL is at the core of the database products from Microsoft, Oracle, and IBM, the three largest software companies in the world.

SQL is also at the heart of open-source database products that are helping to fuel the popularity of Linux and the open-source movement. From its obscure beginnings as an IBM research project, SQL has leaped to prominence as both an important computer technology and a powerful market force.What, exactly, is SQL? Why is it important? What can it do, and how does it work? If SQL is really a standard, why are there so many different versions and dialects? How do popular SQL products like SQL Server, Oracle, Informix, Sybase, and DB2 compare?

How does SQL relate to Microsoft standards, such as ODBC and COM? How does JDBC link SQL to the world of Java and object technology? What role does it play in the emerging “web services” architecture, and the competing web services architectures from the Microsoft and Java-based camps? Does SQL really scale from mainframes to handheld devices? Has it really delivered the performance needed for high-volume transaction processing? How will SQL impact the way you use computers, and how can you get the most out of this important data management tool?

1. Determine how many books are in the Cooking category. Answer:

2. Display the number of books with a retail price of more than $30.00. Answer:

3. Display the most recent publication date of all books sold by the BookStore. Answer:

4. Determine the total profit generated by sales to customer 1017.

Note: Quantity should be reflected in the total profit calculation List the retail price of the least expensive book in the Computer category Determine the average profit generated by orders in the ORDERS table. Note: The total profit by order must be calculated before finding the average profit. Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn’t recently placed an order with BookStore Books.Determine the average retail price of books by publisher name and category. Include only the categories Children and Computer and the groups with an average retail price greater than $50. Answer: 9. List the customers living in Georgia or Florida who have recently placed an order totaling more than $80. Answer: 10. What’s the retail price of the most expensive book written by Lisa White?