Talking Data: unravel the SQL and Database mysteries
Database Design, Diving into SQL and Advanced SQL Usage.
This e-Book will teach you how to use SQL and Databases to create amazing new applications and interactive features for your website.
Rudy Limeback and Robert Stuttaford show you how to unravel
the mysteries of a well designed database and effective SQL queries.
The book is divided into three major Parts, Database Design, Diving into SQL and Advanced SQL Usage. This e-Book contains everything you need to setup your database and get started with SQL. After you’ve learned the basics the authors show you how to optimise your database and your SQL queries. Then it’s time to move on to advanced SQL and to learn the final tips and tricks to optimize your database enabled website or application.
Overview
What this book does, and who it's for.
This book is for anyone with an interest in developing their SQL and Database skills. Both writers use very clear examples to teach you how to create and optimise your SQL queries and your database.
Screenshots
Content
Introduction
- About Rudy Limeback and Robert Stuttaford
- Talking Data: unravel the SQL and Database mysteries
Database Design
- Getting Started
- Normalisation
- Simple Queries
- Database Performance Tuning And Optimasation
- SQL Server Stored Procedures: The Whys And The Hows
Ding Into SQL
- Cross Joins
- Loop The Output
- Aggregates And Grouping
- How About A Date?
- Many-To-Many Relationships
- UNION
- Duplicates
- CASE Expressions
Advanced SQL Usage
- Paging in SQL
- SQL Performance Tips
- The Usage of NULL
- Working With Strings
Reviews
Be the first to write a review
You must me logged in to write a review.