In relational databases, SQL is a standard language for storing, modifying, and retrieving data.
You are aware of the fundamentals of the SQL query language, but you believe you are not utilizing SQL's expressive power to its maximum potential. Before sending data across the network to your applications, you'd like to understand more about using SQL within the database. You want to develop your SQL abilities further.
Let's face it: SELECT columns FROM table WHERE conditions are all that many database engineers ever learn about SQL, which is a deceptively simple language to master. But the language allows us a ton more versatility. Expert SQL developers from around the world discuss their preferred SQL features and practices in the SQL Notes for Professionals. Learning how to solve real-world problems will give you the skill and confidence to step up in your career.
The content of the SQL Notes for Professionals book was produced by the lovely people at Stack Overflow and was assembled from the documentation on that website. The Creative Commons BY-SA license is used for text content. See the list of authors who contributed to the various chapters at the conclusion of the book. Unless otherwise stated, images may be protected by the copyright of their respective owners.