This book is not just about SQL, but also about how SQL fits into the process of creating and maintaining databases and database applications. In this book, I cover how SQL fits into the larger world of application development and how it handles data coming in from other computers, which may be on the other side of the world, or even in interplanetary space.
I assume you may want to do a few things; for example, recreate some of the examples in the book. You may even want to enter some SQL code and execute it. To do that, you need at the very least an SQL editor, and more likely a database management system of some sort. Many choices are available, both proprietary and open-source. I mention several of these at various places throughout the book. I don’t recommend any one in particular. Any product that complies with the ANSI/ISO international SQL standard should be fine.
TABLE OF CONTENT:
Book 1 - SQL Concepts
Book 2 - Relational Database Development
Book 3 - SQL Queries
Book 4 - Data Security
Book 5 - SQL and Programming
Book 6 - SQL and XML
Book 7 - Database Tuning Overview
Book 8 - Appendixes
password:knowfree.net
This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers.
Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.
The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well.
Identity management specialist Marlin B. Pohlman brings over 14 years of personal and professional experience to this third edition, offering a definitive guide for corporate stewards who are struggling with the challenge of meeting regulatory compliance pressures while embarking on the path of process and system remediation. He examines multinational regulations, delves into the nature of governance, risk, and compliance (GRC), and outlines a common taxonomy for the GRC space. He also cites standards that are used, illustrating compliance frameworks such as BSI, ITIL, and COBIT. The resource also focuses on specific software components of the Oracle Identity Management solution and includes elements of the Oracle compliance architecture.
phpBB is a free, open source Internet community application, with outstanding discussion forums and membership management. Written in the PHP scripting language, and making use of the popular MySQL database, phpBB is a standard among web hosting companies throughout the world, and is one of the most widely-used bulletin board packages in the world. phpBB short-circuits the need for you to be a web development master in order to create and manage massive online communities. This book gives you the power to use phpBB to set up and run your own online discussion forums with ease, and develop your own Internet community. It takes you through the whole process of setting up your phpBB site, and helps you create, customize and manage your own online community with phpBB. Written by experienced phpBB administrators and enthusiasts, the emphasis is on simple, and practical guidance for you to get the most from phpBB.
Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner’s Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered.