This book introduces you to the field of relational database development and usage. There are many good books in this field. This book is different. It covers the basics so that beginners can read cover to cover. It is not a book for all levels of readers. For example, this book uses Microsoft SQL Server and Transact-SQL (or T-SQL). It will not mention the different dialect of Oracle or MySQL. If you are interested in Oracle or MySQL, you should use a different book. If you learned SQL Server from this book at your institution and you need to use other DBMS in your future job, the knowledge is only one Google away. This is not a reference book. For example, there are multiple ways to use aliases in T-SQL, but we only use one way. We believe that it is pretty easy to know different ways of using aliases once you finish this book. Why introduce all the different ways of using aliases for the first timer?This book is also unique with over 100 SQL examples and exercises. Most of these examples and exercises are paired. Readers learn one SQL example and can find a corresponding SQL exercise. We believe you have to write the codes in order to show you understood this book. You won't complete this book in 24 hours or 7 days.Even though the book is simple, by the end of the book, readers will be able to apply the knowledge learned to real world projects. We include one project with the detailed process of developing the database and the SQL examples of using the database. This book also includes three case studies readers can practice. This book uses a custom database which is simple with very limited data. The advantage of this approach is that you can manually find the solution before you write the SQL statement (Appendix 2 provides all data of the database). For example, if the question asks for the highest priced deliveries product, you can manually go to Appendix 2 of the book and find the product before you write the SQL statement.Please use Amazon's preview to take a look of the book before purchasing.

The third edition includes 343 review questions. We are grateful to Dr. Youlong Zhuang for reviewing this edition.

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Seller's business information

Reduxbooks.com
3423 Lousma Drive SE, Grand Rapids, MI, 49548, U.S.A.

Sale & Shipping Terms

Terms of Sale

Redux Books guarantees 100% customer satisfaction. If, for any reason, you are not satisfied with your
order, we will issue a total refund for the cost of the book(s) (shipping will not be refunded, unless the
return is the result of an error on our part)upon receipt of the book(s) being returned. All books are
available on a first ordered/first served basis. If you have any questions regarding specific books that
were not covered in the descriptions or citations on abebooks.com, please place a ...

More Information

Shipping Terms

Orders usually ship within 1 business day. Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.