This guide combines the proven tutorial approach to teaching SQL with a collection of major SQL statements with example code for five major database systems: SQL Server, Oracle, DB2, MySQL and Access.
"synopsis" may belong to another edition of this title.
The Programmer's Guide to SQL provides an in-depth yet concise tutorial on the use of Structured Query Language (SQL). Once you've mastered the fundamentals, the book serves as a handy desktop reference on SQL usage, covering all of the major SQL statements that you'll need when programming databases. It also comes complete with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access. In each case, the book demonstrates how the SQL standard is implemented (and and often extended) by each database system vendor. Specific topics include: Querying, modifying, and summarizing data using SQL functions Using complex nested queries and joins Programming database stored procedures, triggers, and views Creating tables, indexes, and other database objects Writing transaction-safe SQL Implementing basic database security The book also includes two complete case studies that show how to create and query the underlying database for a fully featured website, as well as how to implement role-based security in your applications.This book is ideal for any programmer, analyst, or database administrator in search of a SQL reference that also demonstrates how to use SQL to solve real business problems.
Cristian Darie is a software engineer with experience in a wide range of modern technologies. He is the author of numerous books, including his popular ASP.NET C# e-commerce tutorial, his Ajax and PHP tutorial, and his search engine optimization tutorial for PHP developers. Cristian studied distributed application architectures for his Ph.D, and is getting involved with various commercial and research projects. When not planning to buy Google, he enjoys his bit of social life. If you want to say "Hi," you can reach Cristian through his personal website, www.CristianDarie.ro.
"About this title" may belong to another edition of this title.
Shipping:
£ 2.82
Within U.S.A.
Seller: HPB-Red, Dallas, TX, U.S.A.
paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!. Seller Inventory # S_399293962
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.05. Seller Inventory # G1590592182I4N00
Quantity: 1 available
Seller: Better World Books Ltd, Dunfermline, United Kingdom
Condition: Good. Ships from the UK. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Seller Inventory # 1495137-20
Quantity: 1 available
Seller: Lakeside Books, Benton Harbor, MI, U.S.A.
Condition: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books!. Seller Inventory # OTF-Y-9781590592182
Quantity: Over 20 available
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Condition: New. Seller Inventory # 1760018-n
Quantity: 5 available
Seller: booksXpress, Bayonne, NJ, U.S.A.
Soft Cover. Condition: new. Seller Inventory # 9781590592182
Quantity: 10 available
Seller: Lucky's Textbooks, Dallas, TX, U.S.A.
Condition: New. Seller Inventory # ABLIING23Mar2811580081942
Quantity: Over 20 available
Seller: California Books, Miami, FL, U.S.A.
Condition: New. Seller Inventory # I-9781590592182
Quantity: Over 20 available
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Condition: As New. Unread book in perfect condition. Seller Inventory # 1760018
Quantity: 5 available
Seller: Basi6 International, Irving, TX, U.S.A.
Condition: Brand New. New. US edition. Expediting shipping for all USA and Europe orders excluding PO Box. Excellent Customer Service. Seller Inventory # ABEJUNE24-195295
Quantity: 1 available