Applying SQL Generation and Other Concepts to the Real World

The generation of SQL commands using SQL is one of the first steps in applying ingenuity to solve real-world problems encountered on the job. Depending on your specific job, you might encounter situations in which you have to create a lot of SQL code. If the process of creating the code is more tedious than logical, you might ask yourself if there is an easier way to create the code. If the information needed to create the code is already stored in the database, why re-create it manually?

Thinking problems out fully before attempting a solution is always the best policy when coding SQL, or writing any computer program for that matter. You can ask yourself the following questions when ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.