Publishers of technology books, eBooks, and videos for creative people
Relies on a format designed to make learning as easy as possible—even for students with little or no database programming experience.
Helps students quickly understand the key concepts that underlie all databases and queries.
Covers everything students need to quickly become productive and effective with SQL.
Shows students how to begin using advanced SQL features that can significantly improve the reliability and performance of their database applications and queries.
Will be valuable to students regardless of the database platform they are currently utilizing, proprietary or “open”—and will remain useful if they change platforms in the future.
Will remain valuable to students long after they've mastered the fundamentals of SQL.
Database management. It may sound daunting, but it doesn't have to be, even if you've never programmed before. SQL: Visual QuickStart Guide isn't an exhaustive guide to SQL written for aspiring programming experts. It's simply an invaluable resource for those who want a fast, easy way to harness information living in complex databases.
Because author Chris Fehily assumes no prior programming experience on your part (just a familiarity with your OS's file system), he spends the first few chapters laying out the basics, including clear explanations of the relational database model and SQL syntax. Then he jumps into step-by-step tasks designed to get you comfortable using SQL right away. You'll learn how to use SQL's most popular statements and commands to maintain, retrieve, and analyze database information, and to create and edit database objects. Each visually oriented task features the actual code and plenty of screenshots to keep you on track. Fehily takes a software-independent approach to teaching SQL, but includes tips for specific database software. You may not be a programming expert, but with SQL: VQS, who will be able to tell?
Click below for the files related to this title:
1. DBMS Specifics.
2. The Relational Model.
3. SQL Basics.
4. Retrieving Data From a Table.
5. Operators and Functions.
6. Summarizing and Grouping Data.
7. Retrieving Data From Multiple Tables.
9. Inserting, Updating, and Deleting Rows.
10. Creating, Altering, and Dropping Tables.
Corrections and Updates