Buy New
-
To see product details, add this item to your cart.
Ships from: Amazon.com Sold by: Amazon.com
Used - Good
-
To see product details, add this item to your cart.
FREE Returns
Return this item for free
We offer easy, convenient returns with at least one free return option: no shipping charges. All returns must comply with our returns policy.
Learn more about free returns. How to return the item? - Go to your orders and start the return
- Select your preferred free shipping option
- Drop off and leave!
Ships from: Amazon Sold by: Starry Light Books
Return this item for free
We offer easy, convenient returns with at least one free return option: no shipping charges. All returns must comply with our returns policy.
Learn more about free returns.- Go to your orders and start the return
- Select your preferred free shipping option
- Drop off and leave!
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the author
OK
SQL: The Practical Guide to Master Relational Databases, SQL Syntax, and Sublanguages for Effective Database Management (Rheinwerk Computing)
Purchase options and add-ons
Whether you’re managing large datasets or writing your first query, expand your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then, dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-word applications!
- Master SQL programming for database management and manipulation
- Learn to use the five SQL sublanguages: DDL, DML, TCL, DQL, and DCL
- Define schemas and tables; modify and query data; and configure database authorizations
Relational Database Elements
Understand the fundamentals of relational databases and schemas. Learn the elements of a database structure, from tables to views to keys. Then, review more advanced concepts like normalization, stored procedures, triggers, and authorization.
Setting Up Your Environment
Follow click-by-click instructions to install and set up a local PostgreSQL database and a pgAdmin or Visual Studio Code IDE. See a SQL demo in action in your environment and experiment with code samples.
SQL Sublanguages
Use the sublanguages of SQL for your daily tasks. Start by creating and altering database objects. Insert, update, and delete data in tables and then modify multiple tables together. Query data from single or combined tables and limit data access using authorizations.
- ISBN-101493226797
- ISBN-13978-1493226795
- EditionNew
- PublisherRheinwerk Computing
- Publication dateFebruary 26, 2025
- LanguageEnglish
- Dimensions7 x 1 x 10 inches
- Print length415 pages
Frequently bought together

Customers who viewed this item also viewed
- SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Programming - QuickStart Guides)PaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Monday, Sep 21
- Python 3: The Comprehensive Guide to Hands-On Python Programming (Rheinwerk Computing)PaperbackFREE Shipping by AmazonGet it as soon as Sunday, Sep 20
- Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with DataPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQLPaperbackGet it as soon as Friday, Sep 25
- SQL for Data Analytics: Analyze data effectively, uncover insights and master advanced SQL for real-world applicationsJun ShanPaperbackFREE Shipping by AmazonGet it as soon as Monday, Sep 21
- Real-World SQL for Analysts: 90 Practice Problems to Get You Job-ReadyPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Monday, Sep 21
Customers also bought or read
- Python 3: The Comprehensive Guide to Hands-On Python Programming (Rheinwerk Computing)
Paperback$53.79$53.79FREE delivery Sun, Sep 20 - JavaScript: The Comprehensive Guide to Learning Professional JavaScript Programming (Rheinwerk Computing)
Paperback$47.65$47.65FREE delivery Mon, Sep 21 - Scripting: Automation with Bash, PowerShell, and Python—Automate Everyday IT Tasks from Backups to Web Scraping in Just a Few Lines of Code (Rheinwerk Computing)
Paperback$33.14$33.14Delivery Sun, Sep 20 - Full Stack Web Development: A Comprehensive, Hands-On Guide to Building Modern Websites and Applications (IBPA Gold Award Winner) (Rheinwerk Computing)
Paperback$44.80$44.80FREE delivery Sun, Sep 20 - PHP and MySQL: The Comprehensive Guide to Server-Side Web Development with PHP 8 – Build Dynamic Websites with Database Integration, Security, and More (Rheinwerk Computing)
Paperback$59.95$59.95FREE delivery Mon, Sep 21 - Hacking and Security: The Comprehensive Guide to Ethical Hacking, Penetration Testing, and Cybersecurity (Rheinwerk Computing)
Paperback$48.20$48.20FREE delivery Sun, Sep 20 - Excel: The Comprehensive Guide for Beginners and Power Users to Master Formulas, Charts, Pivot Tables, and More with Step-by-Step Examples (Rheinwerk Computing)
Paperback$46.39$46.39FREE delivery Sun, Sep 20 - HTML & CSS: The Comprehensive Guide to Excelling in HTML5 and CSS3 for Responsive Web Design, Dynamic Content, and Modern Layouts (Rheinwerk Computing)
Paperback$51.36$51.36FREE delivery Sun, Sep 20 - Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data#1 Best SellerComputer Programming Structured Design
Paperback$19.99$19.99Delivery Sun, Sep 20 - SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
Paperback$46.15$46.15FREE delivery Sep 25 - 30 - Java: The Comprehensive Guide to Java Programming for Professionals (Rheinwerk Computing)
Paperback$54.67$54.67FREE delivery Sun, Sep 20 - Node.js: The Comprehensive Guide to Server-Side JavaScript Programming (Rheinwerk Computing)
Paperback$43.80$43.80FREE delivery Sun, Sep 20 - SQL for Data Analytics: Analyze data effectively, uncover insights and master advanced SQL for real-world applications
Paperback$37.99$37.99FREE delivery Mon, Sep 21 - Generative AI with Python: The Developer’s Guide to Pretrained LLMs, Vector Databases, Retrieval Augmented Generation, and Agentic Systems (Rheinwerk Computing)
Paperback$47.73$47.73FREE delivery Sun, Sep 20 - Real-World SQL for Analysts: 90 Practice Problems to Get You Job-Ready
Paperback$18.49$18.49Delivery Mon, Sep 21 - Python and SQL Bible: From Beginner to World Expert: Unleash the full potential of data analysis and manipulation by mastering Python and SQL
Paperback$34.36$34.36Delivery Mon, Sep 21 - Rust: The Practical Programming Guide to Fast, Safe, and Concurrent Systems Development
Paperback$59.95$59.95FREE delivery Sun, Sep 20 - Programming Neural Networks with Python: Your Practical Guide to Building Smart AI Systems with Machine Learning and Deep Learning (Rheinwerk Computing)
Paperback$59.95$59.95FREE delivery Sun, Sep 20 - Simple SQL: Beginner’s Guide To Master SQL And Boost Career (Zero To Hero)
Paperback$25.99$25.99Delivery Mon, Sep 21 - Getting Started with Python: Step-by-Step Guide for Beginners to Learn Core Concepts and Build Real-World Python Applications
Paperback$39.95$39.95FREE delivery Sun, Sep 20 - Developing AI Applications: Beginner-Friendly Guide to Building AI Solutions from Scratch with No-Code Tools (Rheinwerk Computing)
Paperback$44.95$44.95FREE delivery Mon, Sep 21 - Learn Microsoft Power BI: A comprehensive, beginner-friendly guide to real-world business intelligence
Paperback$44.99$44.99FREE delivery Mon, Sep 21 - Python for Engineering and Scientific Computing: Practical Applications with NumPy, SciPy, Matplotlib, and More (Rheinwerk Computing)
Paperback$41.31$41.31FREE delivery Mon, Sep 21 - React: The Comprehensive Guide to Mastering React.js with Hands-on Examples, Expert Tips, and Everything You Need to Build Dynamic, Scalable User Interfaces (Rheinwerk Computing)
Paperback$50.50$50.50FREE delivery Sun, Sep 20 - SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Paperback$36.49$36.49FREE delivery Mon, Sep 21
From the brand
-
Programming Books:
-
Rheinwerk Computing is a leading publisher of professional books specializing in topics that empower you to excel in the digital world.
Our books are designed to offer practical, hands-on knowledge and are written by industry experts who bring real-world insights to each publication.
Whether you're a beginner looking to build foundational skills or an experienced professional seeking to stay updated, Rheinwerk Computing has something for you!
From the Publisher
The skills you need to work with relational databases!
Your hands-on guide to programming databases with SQL!
Structured Query Language (SQL) is the lingua franca of relational databases. It’s used to manage and modify databases and allows you to create, read, update, and delete datastored in those databases. SQL isn’t just for developers—anyone working with data and databases can benefit from learning it.
For those new to database programming, the book walks you through the basics of relationship databases. You’ll understand the foundations of database structures and common terminology before you begin working. You’ll follow steps to set up a playground PostgreSQL database where you can experiment with writing SQL code, trying out SQL features, and working with the code examples from the book. By the end of the book, you’ll be able to confidently apply SQL to your business applications.
More experienced readers can jump to the chapters on SQL sublanguages, where you’ll find detailed examples taken from real-world applications that show you how SQL works in practice. First, you’ll create database objects like schemas and tables with data definition language (DDL). Next, you’ll add data into tables and learn how to modify data when needed using data manipulation language (DML).
With transaction control language (TCL), you’ll modify multiple tables together. Then, you’ll jump into querying with data query language (DQL), where you’ll review data filters, string/math operations, date/time-based calculations, and advanced ranking functionalities. Finally, you’ll master data control language (DCL) to organize data access and authorizations and keep sensitive data private.
- Databases and schemas
- Tables, views, and keys
- PostgreSQL
- Data definition language (DDL)
- Data manipulation language (DML)
- Transaction control language (TCL)
- Data query language (DQL)
- Data control language (DCL)
Inside the book:
This book is suitable for anyone interested in SQL at any level. Whether you’re a student just beginning to learn SQL or a data analyst who works with databases every day, you’ll find the real-world knowledge you need to boost your skills in this guide. Professional programmers, testers, data analysts, administrators, and business users who need to query databases can all benefit from this book’s practical examples and expert tips.
- Easy-to-read, expert knowledge on SQL and its sublanguages
- Practical examples that draw from real-world applications
- Detailed, numbered code listings
- Diagrams, charts, tables, note boxes, and background information
- Code examples available for download
- A comprehensive index
Meet the author:
Dr. Kerem Koseoglu is a seasoned software engineer, author, and educator with extensive experience in global software development projects. In addition to his expertise in ABAP, he is also proficient in database-driven development using Python and Swift. He is the author of Design Patterns in ABAP Objects (SAP PRESS), as well as several best-selling technical books in Turkey. He has a Ph.D. in organizational behavior.
JavaScript: The Comprehensive Guide
|
HTML & CSS: The Comprehensive Guide
|
Full Stack Web Development: The Comprehensive Guide
|
PHP and MySQL: The Comprehensive Guide
|
Python 3: The Comprehensive Guide to Hands-On Python Programming (Second Edit...
|
|
|---|---|---|---|---|---|
| Customer Reviews |
4.7 out of 5 stars 135
|
4.5 out of 5 stars 88
|
4.6 out of 5 stars 74
|
4.5 out of 5 stars 13
|
— |
| What is it? (What does it teach) | A comprehensive guide to JavaScript! | The comprehensive guide to HTML and CSS! | The comprehensive guide to full stack web development. | Your comprehensive guide to PHP 8! | The ultimate Python 3 guide for all levels! |
| What you'll learn? | Master core concepts, build dynamic web applications, and explore server-side and mobile development. | Learn how to build and style web pages using HTML and CSS, create responsive layouts, work with multimedia, and gain a foundational understanding of JavaScript. | Learn to design websites with CSS, structure with HTML, add interactivity with JavaScript, and master web protocols, APIs, PHP, testing, deployment, security, and optimization. | Learn PHP 8 from the basics to advanced techniques, including object-oriented programming, MySQL integration, debugging, security, and automated testing, while building dynamic, secure websites. | Learn to write effective Python code. Cover core concepts like functions, modularization, and object orientation, and explore data types. Dive into advanced topics, including Django and GUIs. |
| Who is this book for? | Web developers using JavaScript for frontend and backend programming. | Web developers using HTML and CSS for frontend programming. | Developers | Developers | Python programmers |
| Key Features? | Step-by-step instructions and downloadable source code available. | Step-by-step instructions and code samples are available for download. | Hands-on learning with downloadable code samples. | Downloadable code and example projects. | Step-by-step instructions and downloadable code are available. |
| Level of difficulty? | Provide readers with entry level concepts to advanced topics. | The book starts with the basics of HTML and CSS and gradually progresses to more advanced topics. It also includes an introduction to JavaScript. | Starts with the basics and digs deeper for advanced professionals. | This book provides the essential knowledge for beginners while offering deeper insights for experienced developers to build dynamic, secure websites. | Beginners to professional programmers. |
Editorial Reviews
About the Author
Dr. Kerem Koseoglu is a seasoned software engineer, author, and educator with extensive experience in global software development projects. In addition to his expertise in ABAP, he is also proficient in database-driven development using Python and Swift. He is the author of Design Patterns in ABAP Objects (SAP PRESS), as well as several best-selling technical books in Turkey. He has a Ph.D. in organizational behavior.
Product details
- Publisher : Rheinwerk Computing
- Publication date : February 26, 2025
- Edition : New
- Language : English
- Print length : 415 pages
- ISBN-10 : 1493226797
- ISBN-13 : 978-1493226795
- Item Weight : 1.9 pounds
- Dimensions : 7 x 1 x 10 inches
- Best Sellers Rank: #955,219 in Books (See Top 100 in Books)
- #148 in SQL
- #536 in Database Storage & Design
- #1,669 in Computer Programming Languages
- Customer Reviews:
About the author

Dr. Kerem Koseoglu (1978) was born in Istanbul, Turkey. His favorite hobbies; programming, writing and music, turned into professional occupations over the years. In addition to his career in writing, he is a freelance software architect and an active bass player. You can visit his personal website at www.keremkoseoglu.com .


















