SQL: The Practical Guide

Rheinwerk Publishing, Inc · Kerem Koseoglu

tra 2026. · Packt Publishing Ltd

E-knjiga

493

str.

Alati

O ovoj e-knjizi

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...

Saznajte više

O autoru

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.

Ocijenite ovu e-knjigu

Recite nam što mislite.

Informacije o čitanju

Pametni telefoni i tableti

Instalirajte aplikaciju Google Play knjige za Android i iPad/iPhone. Automatski se sinkronizira s vašim računom i omogućuje vam da čitate online ili offline gdje god bili.

Prijenosna i stolna računala

Audioknjige kupljene na Google Playu možete slušati pomoću web-preglednika na računalu.

Elektronički čitači i ostali uređaji

Za čitanje na uređajima s elektroničkom tintom, kao što su Kobo e-čitači, trebate preuzeti datoteku i prenijeti je na svoj uređaj. Slijedite detaljne upute u centru za pomoć za prijenos datoteka na podržane e-čitače.

Označite kao neprikladno