𝔖 Scriptorium
✦   LIBER   ✦

πŸ“

Discovering SQL : a hands-on guide for beginners

✍ Scribed by Kriegel, Alex


Publisher
Wiley Pub
Year
2011
Tongue
English
Leaves
499
Series
Wrox beginning guides
Edition
1
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL. * Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code * Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered * Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software * Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners

✦ Table of Contents


Content: Drowning in data, dying of thirst for knowledge --
Breaking and entering : structured information --
A think you can relate to--designing a relational database --
Overcoming the limitations of SQL --
Grouping and aggregation --
When one is not enough : a query within a query --
You broke it
you fix it : combining data sets --
What else is there, and why? --
Optimizing performance --
Multiuser environment --
Working with unstructured and semistructured data --
Not by SQL alone --
Installing the library database --
Installing RDBMSs software --
Accessing RDBMSs --
Accessing RDBMSs with the SQuirreL Universal SQL Client.


πŸ“œ SIMILAR VOLUMES


Discovering SQL: A Hands-On Guide for Be
✍ Alex Kriegel πŸ“‚ Library πŸ“… 2011 πŸ› Wrox 🌐 English

Teaching the SQL skills that businesses demand when hiring programmersIf you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear

Discovering SQL: A Hands-On Guide for Be
✍ Alex Kriegel πŸ“‚ Library πŸ“… 2011 πŸ› Wrox 🌐 English

Discover best practices for turning data into information you can use Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access, SQL Server, Oracle, and

Getting started with SQL: a hands-on app
✍ Nield, Thomas πŸ“‚ Library πŸ“… 2016 πŸ› O'Reilly 🌐 English

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL

Getting Started with SQL: A Hands-On App
✍ Thomas Nield πŸ“‚ Library πŸ“… 2016 πŸ› O'Reilly Media 🌐 English

<div><p>Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals

Getting Started with SQL: A Hands-On App
✍ Thomas Nield πŸ“‚ Library πŸ“… 2016 πŸ› O'Reilly Media 🌐 English

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL