Kerem Koseoglu

Rheinwerk Publishing, Inc

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.

The Practical Guide

Michael Kofler

Bernd Öggl

Learn Git from scratch to advanced topics, including GitHub integration, branching, error troubleshooting, and using platforms like GitLab for version control in development environments. Key Features Covers Git installation, basic commands, and essential workflows for beginners Detailed exploration of advanced Git features like rebasing, hooks, and submodules Practical troubleshooting guide to address common Git errors and conflicts Book DescriptionThis practical guide is designed to take you from Git beginner to advanced user. Starting with installation and configuration, it covers the essential Git commands you'll need to create and manage repositories, track changes, and work with branches and commits. These fundamental concepts set the stage for more complex workflows and efficient version control management. The book then explores advanced features, such as using platforms like GitHub and GitLab for remote repositories. You'll learn how to collaborate with others through pull requests, set up continuous integration pipelines, and implement automation using hooks. The guide also includes advanced techniques like rebasing and working with submodules, helping you streamline your workflow and manage larger projects effectively. The final sections focus on troubleshooting common Git errors, from merge conflicts to authentication issues. Practical solutions and best practices ensure you can resolve problems quickly and efficiently. The book wraps up with a comprehensive Git command reference, making it a go-to resource for both new users and experienced developers. Whether you're working solo or in teams, this book will help you master version control with confidence.What you will learn Master the fundamentals of Git for version control and workflows Set up and configure Git on various operating systems Work with repositories on GitHub and GitLab platforms Manage branches and handle merge conflicts effectively Implement advanced Git features like hooks and submodules Troubleshoot common Git errors and find solutions Who this book is for This book is ideal for developers, DevOps engineers, and technical teams seeking to improve their Git skills. Beginners can start from scratch with Git’s fundamentals, while experienced users can dive deeper into advanced workflows. A basic understanding of programming concepts is recommended but not mandatory. For those looking to enhance team collaboration and automate workflows, this guide is perfect. It’s also suitable for individuals aiming to master version control in a professional environment or contribute to open-source projects using GitHub, GitLab, and other platforms.

Project Management for Developers and DevOps Teams

Master Swift programming from setup to advanced app development. Learn syntax, functions, control flow, error handling, and concurrency to build real-world iOS applications with Swift. Key Features Step-by-step guidance on setting up and using the Swift development environment. Practical examples of programming concepts, including functions, optionals, and closures. Advanced techniques for concurrency, error handling, and working with Swift modules. Book DescriptionThis comprehensive guide to Swift programming covers everything from setting up the development environment to advanced concepts. You will start with the fundamentals like Swift syntax, variables, constants, and functions, followed by deeper topics such as optionals, enumerations, and error handling. The book dives into advanced topics like working with structs, classes, and protocols, providing real-world examples of how to apply these concepts in app development. It also teaches how to master control flow, loops, and conditional statements to write clean, efficient code. You'll learn how to work with Swift's concurrency model, including async functions, tasks, and async streams for parallel execution. Additionally, the book covers Swift's powerful module system, explaining how to structure code with frameworks and packages for better organization and scalability. By the end, you'll have the skills to develop apps using Swift, handle complex programming challenges, and use advanced features like closures, generic functions, and extensions. Whether you're new to programming or experienced with other languages, this book provides everything you need to master Swift and become proficient in iOS app development.What you will learn Set up the Swift development environment for iOS development Understand Swift syntax and data types, including variables and constants Master control flow, loops, and conditional statements in Swift Learn to write and call functions, including closures and nested functions Work with optionals and handle errors effectively Develop advanced concepts like structs, classes, and protocols Who this book is for This book is ideal for aspiring iOS developers, programming enthusiasts, and anyone looking to learn Swift from the ground up. It is suitable for beginners who are new to programming, as well as developers with experience in other languages like Python or Java. A basic understanding of programming concepts will help, but no prior Swift knowledge is required. The book is designed to guide readers through every concept with hands-on examples and practical advice.

Swift Essentials: From Core Concepts to Building Real-World iOS Apps

Swift

Frank Neugebauer

Klaus Gebeshuber

Peter Kloep

André Zingsheim

Thomas Hackner

Markus Widl

Roland Aigner

Stefan Kania

Tobias Scheible

Matthias Wübbeling

Explore hacking methodologies, tools, and defensive measures with this practical guide that covers topics like penetration testing, IT forensics, and security risks. Key Features Extensive hands-on use of Kali Linux and security tools Practical focus on IT forensics, penetration testing, and exploit detection Step-by-step setup of secure environments using Metasploitable Book DescriptionThis book provides a comprehensive guide to cybersecurity, covering hacking techniques, tools, and defenses. It begins by introducing key concepts, distinguishing penetration testing from hacking, and explaining hacking tools and procedures. Early chapters focus on security fundamentals, such as attack vectors, intrusion detection, and forensic methods to secure IT systems. As the book progresses, readers explore topics like exploits, authentication, and the challenges of IPv6 security. It also examines the legal aspects of hacking, detailing laws on unauthorized access and negligent IT security. Readers are guided through installing and using Kali Linux for penetration testing, with practical examples of network scanning and exploiting vulnerabilities. Later sections cover a range of essential hacking tools, including Metasploit, OpenVAS, and Wireshark, with step-by-step instructions. The book also explores offline hacking methods, such as bypassing protections and resetting passwords, along with IT forensics techniques for analyzing digital traces and live data. Practical application is emphasized throughout, equipping readers with the skills needed to address real-world cybersecurity threats.What you will learn Master penetration testing Understand security vulnerabilities Apply forensics techniques Use Kali Linux for ethical hacking Identify zero-day exploits Secure IT systems Who this book is for This book is ideal for cybersecurity professionals, ethical hackers, IT administrators, and penetration testers. A basic understanding of network protocols, operating systems, and security principles is recommended for readers to benefit from this guide fully.

The Comprehensive Guide to Penetration Testing and Cybersecurity

Hacking and Security

Rheinwerk Publishing, Inc

Books

Your next favorite book is out there