Getting Started with Firebird: Learning by Doing

Whether you want to develop your own database application or administer an enterprise wide database management system, or even learning about relational database management systems for the first… Lue lisää Whether you want to develop your own database application or administer an enterprise wide database management system, or even learning about relational database management systems for the first time. Getting Started with Firebird is written in a friendly format. We hope you will be inspired by this book. In this book, you will find out how to tackle database implementation using Firebird, with confidence. Getting started with Firebird's simple, step-by-step format makes it a "must-have" book for aspiring database developers as well as database administrators. Learn how to master key database techniques, from simple topics to more advanced topics, following clear instructions with images. For example, find out how to write from simple to advance SQL scripts, user-friendly GUI tool (DBeaver), Firebird's isql command-line tool, database programming, maintenance, security and access control, debugging techniques, including comment documentation and much more. Discover the strength Firebird SQL language. This book is packed with inspirational and practical hands-on projects that are easy-to-follow. Each chapter will take you from start to finish with clear step-by-step instructions, along with examples for you to try out. Each chapter ends with suggestions to try out, allowing you to test yourself on what you have learnt. This book is very much a hands-on book and you are required to "roll your sleeves" up and get stuck-in Perfect for enthusiasts who want to develop their database skills and ideal for the beginner, intermediate and advanced developers wishing to migrate to Firebird quickly. This book covers such things as basic 'create' and 'alter' tables, ACID, setup and Use sphinx to perform full-text search filter. Learn about Domains, Virtual Columns, Views and Cursors, Stored procedures and triggers. Learn about how to manage transactional processing, and much more. ..