SQL: The Practical Guide

Rheinwerk Publishing, Inc · Kerem Koseoglu

abr 2026 · Packt Publishing Ltd

Libro electrónico

493

Páginas

Herramientas

Acerca de este libro electrónico

Unlock the power of SQL to manipulate and query relational databases. Learn database creation, optimization techniques, security practices, and more through hands-on examples.Key Features

Step-by-step instructions for mastering SQL.
Practical examples covering real-world SQL applications.
Emphasis on data security, transaction control, and optimization.

Book DescriptionThis book starts with an introduction to the fundamentals of SQL and relational databases, including key concepts like tables, schemas, and data types. It provides a solid foundation for beginners, guiding readers through the setup process, including local database installation and SQL IDE configuration. As the book progresses, it dives into SQL operations, such as creating and manipulating databases, tables, and views using Data Definition Language (DDL). Readers will explore Data Manipulation Language (DML) to insert, update, and delete data, as well as learn about stored procedures, triggers, and automation techniques. The final sections focus on advanced topics like transaction control, data querying, and data control. Readers will gain in-depth knowledge of SQL queries, including complex operations such as joins, subqueries, and window functions. The book concludes with database security, user access control, and best practices for maintaining data integrity. By the end, readers will be equipped to apply SQL in real-world applications, ensuring efficient, secure, and optimized database management.What you will learn

Understand the fundamentals of relational databases and SQL.
Master database creation, modification, and deletion.
Learn how to perform data manipulation with SQL queries.
Explore advanced SQL topics like window functions and subqueries.
Learn about database security and transaction control.
Implement data integrity through normalization and keys.

Who this book is for

This book is ideal for anyone interested in learning SQL, whether you're a beginner or an intermediate user. Readers should have a basic understanding of databases and data management before starting. The book assumes no prior experience with SQL, but familiarity with concepts like data types and basic programming will be beneficial. It is designed for aspiring database administrators, developers, or anyone looking to enhance their data management skills.

Unlock the power of SQL to manipulate and query relational databases. Learn database creation, optimization techniques, security practices, and more through hands-on examples.Key Features Step-by-step instructions for mastering SQL. Practical examples covering real-world SQL applications. Emphasi...

Descubrir más

Acerca del autor

The Rheinwerk Computing series offers new and established professional comprehensive guidance to enrich the readers' skillsets and enhance their career prospects. Their publications are written by leading experts in the fields of programming, administration, security, analytics, and more. Each book is detailed and hands-on to help readers develop essential, practical skills that they can apply to their daily work.

Dr. Kerem Koseoglu is a seasoned software engineer, author, and educator with extensive experience in global projects and commercial applications. With over twenty years of experience in SAP ABAP, he's also proficient in database-driven development using Python and Swift. He is the author of Design Patterns in ABAP Objects (SAP PRESS, 2017) and several bestselling technical books in Turkey. He holds a PhD in organizational behavior and is renowned for his work in time management. He conducts a variety of technical and soft-skill trainings. He speaks Turkish, English, and German fluently. When he's not coding or teaching, you're likely to find him onstage, playing his bass guitar. You can visit his website at www.keremkoseoglu.com or contact him at kerem@keremkoseoglu.com.

Califica este libro electrónico

Cuéntanos lo que piensas.

Información de lectura

Smartphones y tablets

Instala la app de Google Play Libros para Android y iPad/iPhone. Como se sincroniza de manera automática con tu cuenta, te permite leer en línea o sin conexión en cualquier lugar.

Laptops y computadoras

Para escuchar audiolibros adquiridos en Google Play, usa el navegador web de tu computadora.

Lectores electrónicos y otros dispositivos

Para leer en dispositivos de tinta electrónica, como los lectores de libros electrónicos Kobo, deberás descargar un archivo y transferirlo a tu dispositivo. Sigue las instrucciones detalladas que aparecen en el Centro de ayuda para transferir los archivos a lectores de libros electrónicos compatibles.

Marcar como inapropiada