Learning SQL
Alan Beaulieu has over 25 years of experience designing, creating, and implementing specialized database applications. He is the author of the O'Reilly books Learning SQL and Mastering Oracle SQL, as well as an online SQL course for the University of California. He now owns his own consulting firm that specializes in database design and development in the financial services and telecommunications industries. Alan graduated from Cornell University's School of Engineering with a Bachelor of Science in Operations Research.
As data flows into your organization, you must put it to use as soon as possible—and SQL is the greatest tool for the job. Author Alan Beaulieu's latest edition of Learning SQL assists developers in learning SQL essentials for developing database applications, performing administrative tasks, and generating reports. New chapters cover SQL and big data, analytic functions, and working with extremely large databases.
Using numerous pictures and annotated examples, each chapter provides a self-contained education on a major SQL subject or method. Exercises allow you to put what you've learned into practice. SQL knowledge is required for data interaction. With Learning SQL, you'll quickly learn how to put this language's strength and versatility to use.
- Quickly learn SQL fundamentals and a few advanced features.
- SQL data statements are used to create, manipulate, and retrieve data.
- SQL schema statements are used to create database objects such as tables, indexes, and constraints.
- Discover how datasets interact with searches and the significance of subqueries.
- Use SQL's built-in functions to convert and manipulate data, and conditional logic in data statements.
Author: Alan Beaulieu
Link to buy: https://www.amazon.com/Learning-SQL-Generate-Manipulate-Retrieve/dp/1492057614/
Ratings: 4.6 out of 5 stars (from 324 reviews)
Best Sellers Rank: #38,720 in Books
#5 in MySQL Guides
#6 in Data Warehousing (Books)
#6 in SQL