"""Mastering Relational Databases"

"From Fundamentals to Advanced Concepts"""

Patrick Mukosha

$66.95 $57.11

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Patrick Mukosha
03 October 2023

Database design & theory; Data warehousing; Information visualisation; Information architecture

Series: The Goodman

"""Mastering Relational Databases: From Fundamentals to Advanced Concepts"" is an indispensable guide for anyone seeking to become an expert in the world of relational databases. This comprehensive book takes readers on a journey from the very basics of relational databases to advanced topics, equipping them with the knowledge and skills needed to effectively design, manage, and optimize database systems.

Key Features:

Fundamental Concepts: The book begins with a solid foundation, covering the fundamental concepts of relational databases. Readers will gain a clear understanding of what databases are, how they work, and why they are crucial in the world of data management.

Data Modelling:

It delves deep into data modelling techniques, teaching readers how to design efficient and normalized database schemas. Concepts like entities, attributes, relationships, and normalization are explained in a practical and accessible manner.

SQL Mastery:

The book provides a comprehensive guide to Structured Query Language (SQL), covering everything from basic queries to advanced topics like stored procedures, triggers, and optimization techniques. Readers will learn to harness the full power of SQL to manipulate and retrieve data effectively.

Indexing and Performance Optimisation:

Performance is a critical aspect of database management. The book explores advanced techniques for indexing, query optimization, and database tuning, ensuring that readers can maximize the efficiency of their database systems.

Concurrency Control and Transactions: Understanding how databases handle multiple users and ensure data consistency is essential. This book explains concurrency control mechanisms and the principles of transaction management in depth.

Security and Data Integrity: Security is paramount in modern databases. The book covers authentication, authorization, encryption, and data integrity mechanisms, enabling readers to protect their data from unauthorized access and breaches.

Advanced Topics:

For those looking to push the boundaries, the book explores advanced topics such as distributed databases, replication, and high availability solutions, ensuring readers are well-prepared to tackle complex real-world scenarios.

Practical Example: Throughout the book, practical examples and real-world case studies illustrate key concepts, making it easy for readers to apply what they've learned in their own database projects.

Best Practices:

The book emphasizes best practices in database design, administration, and maintenance, instilling a professional approach to managing data.

""Mastering Relational Databases: From Fundamentals to Advanced Concepts"" is not just a book; it's a comprehensive resource that empowers readers to become proficient in all aspects of relational databases. Whether you are a beginner looking to grasp the basics or an experienced database professional seeking to refine your skills, this book will be your go-to reference on the journey to mastering relational databases."

By: Patrick Mukosha
Imprint: Patrick Mukosha
Volume: 1
Dimensions: Height: 216mm, Width: 140mm, Spine: 13mm
Weight: 299g
ISBN: 9798223718666
Series: The Goodman
Pages: 234
Publication Date: 03 October 2023
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

Patrick Mukosha is a Management Consultant originally from Kitwe, Copperbelt Province of Zambia. He has a Doctorate in Management (Strategic Management) and Masters (Strategic Planning) from Atlantic International University, USA. He also holds a bachelor's in Information Technology from University of East Anglia, Norwich, UK, and a Diploma in Business Management from Canterbury College of Technology, Canterbury, UK. Member of the Institute for Leadership Development, York University, USA (2001-08), He was elected Vice President-Midlands of Computer Society of Zambia (2004), Executive Director for VISION-2011 - a consortium of NGOs (2009 - 2011, Founder of Strategic Management Community of Zambia (2017), Vice Chairperson Mungule Ward Development Committee (2021-2026). He has worked for more than 15 years for International IT and Telecommunication companies in senior management portfolios. After finishing his PhD in 2017, he embarked on career as a Management Consultant. He has worked on several Strategic Planning projects and conducts coaching and mentorship in Entrepreneurship, Business Management, Strategic Management and ICT. He's an aggressive serial entrepreneur and founder of PatWest Technologies.