Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Use coupon code “MARCH20” for a 20% discount on all items! Valid until 31-03-2025

Site Logo
Site Logo

Royal Mail  express delivery to UK destinations

Regular sales and promotions

Stock updates every 20 minutes!

SQL in 24 Hours, Sams Teach Yourself

8 in stock

Firm sale: non returnable item
SKU 9780137543120 Categories ,
Select Guide Rating

The straightforward, step-by-step approach shows students how to work with database structures, objects, queries, tables, and more. In just hours, they will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server e...

£29.99

Buy new:

Delivery: UK delivery Only. Usually dispatched in 1-2 working days.

Shipping costs: All shipping costs calculated in the cart or during the checkout process.

Standard service (normally 2-3 working days): 48hr Tracked service.

Premium service (next working day): 24hr Tracked service – signature service included.

Royal mail: 24 & 48hr Tracked: Trackable items weighing up to 20kg are tracked to door and are inclusive of text and email with ‘Leave in Safe Place’ options, but are non-signature services. Examples of service expected: Standard 48hr service – if ordered before 3pm on Thursday then expected delivery would be on Saturday. If Premium 24hr service used, then expected delivery would be Friday.

Signature Service: This service is only available for tracked items.

Leave in Safe Place: This option is available at no additional charge for tracked services.

Description

Product ID:9780137543120
Product Form:Paperback / softback
Country of Manufacture:US
Series:Sams Teach Yourself
Title:SQL in 24 Hours, Sams Teach Yourself
Authors:Author: Ryan Stephens
Page Count:624
Subjects:Programming and scripting languages: general, Programming & scripting languages: general, Databases, Databases
Description:Select Guide Rating

The straightforward, step-by-step approach shows students how to work with database structures, objects, queries, tables, and more. In just hours, they will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server extensions. Every lesson builds on what students have already learned, giving them a rock-solid foundation for real-world success.

Step-by-step instructions carefully walk students through the most common SQL tasks.

  • Practical, hands-on examples show students how to apply what they learn.
  • Quizzes and exercises help them test their knowledge and stretch their skills.
  • Notes and tips point out shortcuts and solutions.

Learn how to…

  • Define efficient database structures and objects
  • “Normalize” raw databases into logically organized tables
  • Edit relational data and tables with DML
  • Manage transactions
  • Write effective, well-performing queries
  • Categorize, summarize, sort, group, and restructure data
  • Work with dates and times
  • Join tables in queries, use subqueries, and combine multiple queries
  • Master powerful query optimization techniques
  • Administer databases and manage users
  • Secure databases and protect data
  • Use views, synonyms, and the system catalog
  • Extend SQL to the enterprise and Internet
  • Master important Oracle and Microsoft extensions to ANSI SQL

In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security.


This Seventh Edition is thoroughly revised and reorganized for faster learning and a deeper understanding of modern SQL development. Based on standardized SQL throughout, it teaches using new sample code based on the free, easy-to-use Oracle Database Express (XE). You''ll find more hands-on examples than ever, culminating in an all-new Bonus Exercises Workshop with even more real-world practice.


This guide''s straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, from transactions and joins to complex data retrieval using views and subqueries.


Step-by-step instructions carefully walk you through the most common SQL tasks.
Practical, hands-on examples show you how to apply what you learn.
Quizzes and exercises help you test your knowledge and stretch your skills.
Notes and tips point out shortcuts and solutions.


Learn how to...

* Master core relational database concepts, SQL concepts, and language components
* Clearly understand your data
* Set up databases and plan efficient database designs
* Define entities and relationships, establish data structures, and create database objects
* "Normalize" raw databases into logically organized tables
* Edit relational data and tables and manage transactions
* Write effective, well-performing queries
* Categorize, summarize, sort, group, and restructure data
* Work with dates and times
* Join tables in queries, use subqueries, and combine multiple queries
* Optimize performance with indexes and other techniques
* Administer databases and manage users
* Secure databases and data


Imprint Name:Addison Wesley
Publisher Name:Pearson Education (US)
Country of Publication:GB
Publishing Date:2022-02-26