Lucy Scott

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.

Relational Database and Transact-SQL

In 2012, Lucy Scott gave birth to her first baby. Despite her extensive pre-baby research, nothing prepared her for the momentous task of caring for this new little person. Featuring dozens of funny moments like baby's first lunch out to a forensic view of the living room, this charming doodle collection includes 120 two-color illustrations and is the perfect gift for Mother's Day, baby showers, or year-round fun. Also included are a few doodling prompts in the back of the book so moms can doodle their own first-year memories.

An Illustrated Journey Through One Mommy's First Year

Doodle Diary of a New Mom

When Lucy Scott gave birth to her adorable daughter Lois, nothing prepared her for the momentous task of caring for this new little person. Compelled to preserve the memories of her first year, Lucy started drawing, and so emerged Doodle Diary of a New Mum. From baby's first trip to the health visitor to her shrine to wet wipes, this funny collection of Lucy's doodles depicts dozens of dramatic, terrifying, and unforgettable new-mum moments. Sadly, and much to Lucy's dismay, she still cannot find any chapters in any parenting book on surviving the first trip to a pub with a baby.

An Illustrated Journey Through One Mummy's First Year

Doodle Diary of a New Mum

As an imaginative little girl goes through her day, she builds a city of blocks, cooks dinner for ten, and goes on amazing adventures with her stuffed animals.

Busy Busy!

Paper Hearts

Tina Smith

London is one of the most exciting cities in the world-dynamic, noisy, colourful - and non-stop. It can also be exhausting, crowded and intense. So for those of us who like to stop, breathe and enjoy a slower pace of life, Lost in London is for you. If you prefer to spend your weekends walking on London’s commons, or hunting down fireside pubs for a pint rather than frequenting cocktail bars or clubs, then read on. Lost In London first began life as a magazine. From this, its founders Lucy and Tina, have lovingly created a beautiful book that unearths a hidden treasure - the secret side of London. This urban nature guide shows us how to slow down and reconnect with the greener side of the capital. Sections include a guide to exploring the city’s reservoirs, cemeteries, and meadows, an alternative look at the Thames and London’s lakes, canals and wetlands, and an entire section dedicated to foraging, beekeeping and henkeeping.The book is full of delicious recipes for you to make using your foraged food, such as damson gin, pontack, pork, apple and black pudding pasties and blackberry vinegar. There’s gardening advice with suggestions on how to make the most of your allotment, rooftop or window box, practical ideas for outdoorsy day trips, and a brilliant guide to the animals, insects and birds that share our city. Packed with stunning illustrations, gorgeous photography and handy maps, this is an indispensable, inspirational guide to living simply in the city. Lucy Scott and Tina Smith launched Lost in London magazine three years ago over a shared passion for the natural world and reflecting its place in urban life. It was intended to be a oneoff experimental portfolio project, but it quickly established as one of the most foremost independent magazine titles around.

Lucy Scott

Books

Your next favorite book is out there