Delphi is the hottest selling programming language on the market. This guide presents Delphi database programming techniques in a logical and easy-to-follow sequence that helps readers really understand the principles involved in developing programs. Workshops, Q&A's, and do's and don'ts reinforce the information found in each chapter.
Sams Teach Yourself SQL in 21 Days, Fourth Editionprovides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.
Marketshare for DB2 has been growing steadily over the past 5 years and with the recent release of DB2 Universal Database V8, the product has never had more momentum. Not only is the product used in every company on the Fortune 500, but it is becoming very popular in the small to medium sized businesses as well. Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform. (DB2 also runs on z/OS, OS/400, AIX, Linux, HP-UX, and Sun Solaris.) Readers are guided through performing all the commonly used tasks to run DB2, including installing DB2, setting up DB2, creating databases and tables, populating the database with data, accessing the data, ensuring the database is tuned for performance. This book differs from the competition in that it provides examples and scenarios making it very easy for the reader to learn complicated tasks. It gives them everything they need for the commonly used tasks in a simple to understand manner. Quizzes and exercises strengthen the knowledge gained and ensure concepts are learned rather than memorized.
By the middle of the first chapter, readers can create their first program! This title gives an overview of the basics of the C++ programming language and moves readers directly into creating applications.
Write successful, professional-quality programs using Visual Basic; add music, voice, and graphics to your applications; find out how to write your own dynamic link library (DLL); learn to use sprite controls and DirectDraw to affect animation; and create your own ActiveX controls.
A professional software developer and consultant introduces Pascal to the beginning programmer. The book features day-by-day lessons and clear syntax examples of everyday programming. Includes week-at-a-glance and week-in-review sections. All code listings include output and analysis. The book shows users how to implement the latest Pascal enhancements.
Learn to rapidly build and deploy cross-platform applications from a single codebase with practical, real-world solutions using the mature Delphi 10.4 programming environment Key FeaturesImplement Delphi's modern features to build professional-grade Windows, web, mobile, and IoT applications and powerful serversBecome a Delphi code and project guru by learning best practices and techniques for cross-platform developmentDeploy your complete end-to-end application suite anywhereBook Description Delphi is a strongly typed, event-driven programming language with a rich ecosystem of frameworks and support tools. It comes with an extensive set of web and database libraries for rapid application development on desktop, mobile, and internet-enabled devices. This book will help you keep up with the latest IDE features and provide a sound foundation of project management and recent language enhancements to take your productivity to the next level. You'll discover how simple it is to support popular mobile device features such as sensors, cameras, and GPS. The book will help you feel comfortable working with FireMonkey and styles and incorporating 3D user interfaces in new ways. As you advance, you'll be able to build cross-platform solutions that not only look native but also take advantage of a wide array of device capabilities. You'll also learn how to use embedded databases, such as SQLite and InterBase ToGo, synchronizing them with your own custom backend servers or modules using the powerful RAD Server engine. The book concludes by sharing tips for testing and deploying your end-to-end application suite for a smooth user experience. By the end of this book, you'll be able to deliver modern enterprise applications using Delphi confidently. What you will learnDiscover the latest enhancements in the Delphi IDEOvercome the barriers that hold you back from embracing cross-platform developmentBecome fluent with FireMonkey controls, styles, LiveBindings, and 3D objectsBuild Delphi packages to extend RAD Server or modularize your applicationsUse FireDAC to get quick and direct access to any dataLeverage IoT technologies such as Bluetooth and Beacons and learn how to put your app on a Raspberry PiEnable remote apps with backend servers on Windows and Linux through REST APIsDevelop modules for IIS and Apache web serversWho this book is for This book is for Delphi developers interested in expanding their skillset beyond Windows programming by creating professional-grade applications on multiple platforms, including Windows, Mac, iOS, Android, and back-office servers. You'll also find this book useful if you're a developer looking to upgrade your knowledge of Delphi to keep up with the latest changes and enhancements in this powerful toolset. Some Delphi programming experience is necessary to make the most out of this book.
For programmers, Web developers and power users who want to take their knowledge of Visual J++ to the next level. This book covers the creation of Web applets and fully functional applications that interface with a database. The CD includes scripting and author source code.
In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up. Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL. Step-by-step instructions carefully walk you through the most common SQL tasks. Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge. Notes and Tips point out shortcuts and solutions. New terms are clearly defined and explained. Learn how to... Use SQL-2003, the latest standard for the Structured Query Language Design and deploy efficient, secure databases Build advanced queries for information retrieval Sort, group, and summarize information for best presentation Tune databases and queries for maximum performance Understand database administration and security techniques For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University–Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems. Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles. Category: Database Covers: ANSI SQL User Level: Beginning–Intermediate Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections as they become available.
