Sams Teach Yourself SQL in 10 Minutes Fourth Edition New full-color code examples help you see how SQL statements are structured Whether you're an application developer database administrator web application designer mobile app developer or Microsoft Office users a good working knowledge of SQL is an important part of interacting with databases. & Sams Teach Yourself SQL in 10 Minutes offers the straightforward practical answers you need to help you do your job. Expert trainer & popular author Ben Forta teaches you just the parts of SQL you need to know-starting with simple data retrieval & quickly going on to more complex topics including the use of joins subqueries stored procedures cursors triggers & table constraints. You'll learn methodically systematically & simply-in 22 short quick lessons that will each take only 10 minutes or less to complete. With the Fourth Edition of this worldwide bestseller the book has been thoroughly updated expanded & enhanced. Lessons now cover the latest versions of IBM DB2 Microsoft Access Microsoft SQL Server My SQL Oracle Postgre SQL SQLite Maria DB & Apache Open Office Base. & new full-color SQL code listings help the beginner clearly see the elements & structure of the language. 10 minutes is all you need to learn how to...* Use the major SQL statements * Construct complex SQL statements using multiple clauses & operators * Retrieve sort & format database contents * Pinpoint the data you need using a variety of filtering techniques * Use aggregate functions to summarize data * Join two or more related tables * Insert update & delete data * Create & alter database tables * Work with views stored procedures & more 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 & Deleting Data 17 Creating & 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 ...

Sams Teach Yourself Visual Basic (R) 2010 in 24 Hours James Foxall STARTER KIT DVD

Includes:: Visual Basic

...

Write Windows 8 Metro apps capable of running on one billion devices -- & do it with familiar HTML5 & Java Script technologies! Sams Teach Yourself Windows 8 Metro Apps with Java Script & HTML5 in 24 Hours is the quickest way for web & Windows developers to profit from the massive new Windows 8/ Metro opportunity. Microsoft MVP Chad Carter teaches every facet of HTML5/ Java Script Metro development simply & clearly through 24 concise hands-on lessons focused on knowledge you can apply immediately. Each lesson builds on whats come before helping you get practical results fast! Youll learn how HTML5 Java Script & CSS3 fit into Metro development...how to quickly master Metro design & start using Microsofts powerful Metro templates...what you need to know about Win RT & Win JS...how to build high-performance Metro apps...how to handle tablet & smartphone form factors touch & sensors...how to bind data to apps & store it locally or remotely...how to manage app lifecycle events...how to make the most of Metros innovative UI features...and much more. Carter walks you through constructing apps & games from start to finish & even shows how to get them certified for sale at the Windows Store. Step-by-step instructions walk readers through key tasks...Q-&-As Quizzes & Exercises test their knowledge... Did You Know?" tips offer insider advice..." Watch Out!" alerts help them avoid problems. By the time theyre finished readers will be comfortable with every phase of Windows 8 Metro development -- from planning apps through earning revenue!" ...

Meet Tilly Redbrow who doesn't just love horses
- she lives breathes & dreams them too! It's nearly Christmas & everyone's excited
...

Use this friendly full-color guide to make the most of the extraordinary Samsung Galaxy Note device! The Samsung Galaxy Note is the first mobile device that successfully bridges the gap between a modern smartphone & a tablet. Nicknamed phablet" it has an array of features that could intimidate you without the help of this plain-English guide! Dan Gookin shows you how to set up & configure the Galaxy Note & use the revolutionary "S" software that means that you can draw directly on the screen with the special stylus or "S Pen". You'll also learn to use both phone & tablet features get online & use the web text make calls shoot photos get GPS directions & all the rest easily! The Galaxy Note is a revolutionary concept that combines smartphone & tablet technology; this guide demystifies the complex technology so you can take advantage of every feature Shows how to set up & configure the device work with the interface & use the unique "S" software to write or draw directly on the touchscreen Covers all the phone features including voicemail & texting as well as basic tablet features such as web browsing e-mail & social media Explores how to use the camera make notes get directions play music synchronize & share content use apps & more Written by immensely popular author Dan Gookin known for both technical expertise & his friendly easily understood style Samsung Galaxy Note For Dummies is just what you need to help you get up & running with your fabulous new "phablet"." ...

Colorful guide to getting more out of your Galaxy S smartphone! Now that you've got your new Galaxy S smartphone you've got to figure out how to use it! If you're baffled by the technology & the documentation this book can help. Written in the fun but clear & thorough For Dummies style this book answers all your questions. You'll find out how to do all the fun stuff: texting social networking using the camera how to watch movies & more. & you'll also learn how to handle the housekeeping": synching your phone with your PC using business applications downloading apps accessing the calendar what all the widgets mean & much more. Helps you get up to speed on any Samsung Galaxy S smartphone including the Fascinate Epic Captivate Vibrant & other Galaxy S phones Clarifies the basics of how to use the phone how the technology works how to configure everything & how to make it totally yours Delivers a full slate of how-tos tricks features & techniques all in full color Covers setup & configuration texting e-mailing taking & sharing pictures playing games buying & installing apps personal & business apps & more

Includes:: tips on making the most of multimedia features--games music movies photos & more You'll get gobs more from your Galaxy S with the help of Samsung Galaxy S For Dummies. "

...

A full-color reference for getting the most out of your Samsung Galaxy Tab 10.1! A vast improvement over the original Galaxy Tab the 10.1 uses the latest version of the Android operating system & is a 4G LTE mobile device. These upgrades--along with many others including the better screen quality better web browsing with Flash & better multitasking capabilities--are all covered in this fun & friendly guide to the Samsung Galaxy Tab 10.1. Everything from how-to topics to the most useful features to helpful tricks & techniques this practical guide shows you how to get the most out of this cutting-edge device. Details how the Galaxy Tab 10.1 goes one step further than the iPad with phone communications plus video chat & conferencing Explains in detail how to find your way around the Galaxy Tab 10.1 Covers e-mailing web browsing using the digital library connecting with friends in the galaxy taking photos with the camera & enjoying music Highlights how to customize your Galaxy Tab 10.1 so that it's right for your needs Samsung Galaxy Tab 10.1 For Dummies is must-have reading for anyone who wants to go beyond the basics & explore another galaxy of tablet computing! ...

Poet essayist biographer lexicographer critic conversationalist & wit Dr Johnson is one of the great figures of English literature perhaps the most"ed English writer after Shakespeare. This new biography illuminates the unknown Johnson: the awkward youth the unsuccessful schoolmaster the eccentric marriage his early years in London in the 1740s scratching a living the epic struggle to produce the Dictionary. Using material unknown to previous biographers Peter Martin describes the psychological knife-edge on which Johnson felt he lived caused by his severe melancholia & his physical diseases. The Samuel Johnson that emerges from this enthralling biography is still the foremost figure of his age but a more rebellious unpredictable & sympathetic figure than the one that Boswell so memorably portrayed. ...

Samuel Pepys is the astonishing biography by bestselling author Claire Tomalin 2002 Whitbread Book of the Year. Immaculately well done. Tomalin has managed to unearth a wealth of material about the uncharted life of Samuel Pepys". (Craig Brown Mail on Sunday). " Sex drink plague fire music marital conflict the fall of kings corruption & courage in public life wars navies public execution incarceration in the Tower: Samuel Pepys' life is full of irresistible material & Claire Tomalin seizes it with both hands. Fast vivid accessible". (Hermione Lee Guardian). "A rich thoughtful & deeply satisfying account. It takes us behind & beyond the diary
- which means that on finishing it we can reread the diary with greater pleasure & understanding then ever before". (Noel Malcolm Evening Standard). " In Claire Tomalin Pepys has found the biographer he deserves. Her perceptive level-headed book finally restores to the life of the diarist its weight & dignity". (Lisa Jardine New Statesman). "A great achievement & a huge pleasure. A vivid chronicle of contemporary history seen through the all too human preoccupations of this ordinary & extraordinary man". (Diana Souhami Independent). From the acclaimed author of Charles Dickens: A Life & The Invisible Woman this celebrated biography casts new light on the remarkable diaries of Pepys & brings his story vividly to life once more. Claire Tomalin is the award-winning author of eight highly acclaimed biographies including: The Life & Death of Mary Wollstonecraft; Shelley & His World; Katherine Mansfield: A Secret Life; The Invisible Woman: The Story of Nelly Ternan & Charles Dickens; Mrs Jordan's Profession; Jane Austen: A Life; Samuel Pepys: The Unequalled Self; Thomas Hardy: The Time-Torn Man & most recently Charles Dickens: A Life. A former literary editor of the New Statesman & the Sunday Times she is married to the playwright & novelist Michael Frayn."
...

Pepys Diary is one of the most celebrated journals of all time. Such is the wit & style of Pepys writing that listeners to this selection from the early years of the diary will gain not only a unique view of seventeenth century London life but also a vivid picture of Pepys the man as he strives to establish himself in his career & in society. ...