SQL has concise syntax, flexible usage method and powerful function. It has become the most popular database language (almost any important DBMS supports SQL) and an indispensable, basic skill for any programmers.
Sams Teach Yourself SQL in 10 Minutes is a classic bestseller about SQL beloved by readers around the world. Again, it is used as reference/teaching material in Massachusetts Institute of Technology, University of Illinois System and many other universities. Unlike other similar books, it skips the basic theory part of database technology, directly starts from practice. Instead, it focuses on the most commonly used and essential SQL knowledge in actual work environment, by means of a large number of concise instances.
Except serving as teaching material, the unique arranging mode also makes Sams Teach Yourself SQL in 10 Minutes become a convenient, fast reference manual with extremely strong practicability, which is suitable for beginners to learn SQL and for the majority of software developers or managers to reference.
// Table Of Contents //
- 1: Understanding SQL
- 2: Retrieving Data
- 3: Sorting Retrieved Data
- 4: Filtering Data
- 5: Advanced Data Filtering
- 6: Using Wildcard Filtering
- 7: Creating Calculated Fields
- 8: Using Data Manipulation Functions
- 9: Summarizing Data
- 10: Grouping Data
- 11: Working with Subqueries
- 12: Joining Tables
- 13: Creating Advanced Joins
- 14: Combining Queries
- 15: Inserting Data
- 16: Updating and Deleting Data
- 17: Creating and Manipulating Tables
- 18: Using Views
- 19: Working with Stored Procedures
- 20: Managing Transaction Processing
- 21: Using Cursors
- 22: Understanding Advanced SQL Features
- Appendix A: Sample Table Scripts
- Appendix B: Working in Popular Applications
- Appendix C: SQL Statement Syntax
- Appendix D: Using SQL Datatypes
- Appendix E: SQL Reserved Words
// Book Example Codes //
Database tables or creation scripts download:
// Download URLs //
// Related Posts //
As a popular reading material about computer science, Code: The Hidden Language of Computer Hardware and Software is much more vivid, interesting and easy to understand, absorb than any other similar ...
For people who like outdoor activities, if you don't know more knots skills than the man in the street, then you will get enough painful lessons in the future outdoor ...
Harry Potter Series has a total of 7 volumes which have swept around the world that has been translated into nearly 70 different languages, with accumulative total sales of more than ...
There are a lot of books on the MySQL database learning, but the related reference-qualitative ones are rare. And if you are or were finding a worth reading book on ...
Here, AppNee collected the series of books of 3ds Max Bible 2011, 2012, 2013 and 2014 4 editions written by Kelly L. Murdock and published by Wiley Publishing. All of which are ...
1945 II (AKA: 1945 二代, Battle Garegga Plus in China) is a Hacked/Plus/Turbo/Enhanced edition of the official Battle Garegga, made by fan player from China, with many exciting new features.
Serato DJ is a brand new entry-level DJ software released after the famous professional DJ solutions Serato Scratch Live and Serato ITCH). Officials said Serato DJ can change the way ...
Two of the most influential books in the past decade are The Tipping Point: How Little Things Can Make a Big Difference and Blink: The Power of Thinking Without Thinking. Now it's ...
Perfect Balance is series of extremely challenging and difficult physics and gravity based small balance game, with ingenious design. Your goal is to, in specific environments, through placing bricks in various ...
Castlevania: Lords of Shadow (キャッスルヴァニア ロード オブ シャドウ) is developed by MercurySteam from Spain, supervised by こじま ひでお (Hideo Kojima) and released by KONAMI for PlayStation 3, Xbox 360 in 2010, ...
Code: The Hidden Language of Computer Hardware and
Knots: The Complete Visual Guide HD PDF download
Harry Potter Series 1-7 Boxed Set Hardcover Ultimate
MySQL Pocket Reference, 2nd Edition HD PDF download
Autodesk 3ds Max 2011, 2012, 2013, 2014 Bible
[MAME] 1945 II – Hacked and enhanced edition
Serato DJ – Entry level professional DJ mixing
Outliers: The Story of Success HD PDF download
Perfect Balance – Challenges to masters of balance
Castlevania: Lords of Shadow – Ultimate Edition for
- Copy text content from AppNee: You are welcomed to do this, but do remember one thing: leave us a backlink. Otherwise, finally you will destroy our pay and effort, and get yourself blacklisted/banned by the entire SAYS group.
- Download link: Any download link does not work, email us to fix it for you.
- Software version: Want to get newer version of some software, email us.
- Virus scan: Always remember to do this by yourself using VirusTotal or VirSCAN (more trustworthy). Sometimes, we may forget it or get infected with virus.
- Email reply: As long as we could take time out from daily work & study, we would manage to answer every email worth to reply as soon as possible.
- Software recommendation: For excellent software you're finding but we did not share (make sure you searched through AppNee first), please let us know (via the Feedback). Then we will do our best to find all possible resources for you. But, there is no guarantee.
- Warnning: Before asking any questions, you'd better make sure you have read the post through, and do not use a fake email. Besides, never put too much hope on AppNee, or you will be very disappointed.