Number Of Pages: 432
Publication Date: August 14, 2006
Publisher: For Dummies
Format: Pdf
Size: 7.20 MB
Book Description:
Start building and using relational databases with SQL's newest features
The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more!
Discover how to
* Use SQL in a client/server system
* Build a multitable relational database
* Construct nested and recursive queries
* Set up database security
* Use SQL within applications
* Map SQL to XML
SQL For Dummies
On
12:06 PM
0
comments
SQL Cookbook
On
11:57 AM
0
comments
Number Of Pages: 640
Publication Date: December 16, 2005
Publisher: O'Reilly Media
Format: chm
Size: 674 KB
Book Description:
In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:
Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out
Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function
Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set
How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques
The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string
Sams Teach Yourself SQL in 24 Hours
On
11:53 AM
0
comments
Number Of Pages: 504
Publication Date: June 9, 2008
Publisher: Sams
Format: Pdf
Size: 2.17 MB
Book Description:
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.
The Definitive Guide to MySQL 5
On
11:16 AM
0
comments
Number Of Pages: 784
Publication Date: September 23, 2005
Publisher: Apress
Format: Pdf
Size: 10.58 MB
Book Description:
The Definitive Guide to MySQL 5, Third Edition, is the newest revision of Michael Kofler’s popular book. This is the first book to offer in-depth instruction about the new features of the world’s most popular open source database server. Updated to reflect changes in MySQL version 5, this book will expose you to MySQL’s impressive array of new features: views, stored procedures, triggers, and spatial data types. Whether you’re a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.
Sams Teach Yourself MySQL in 10 Minutes
On
11:13 AM
0
comments
Number Of Pages: 288
Publication Date: May 19, 2006
Publisher: Sams
Format: chm
Size: 970 KB
Book Description:
Sams Teach Yourself MySQL in 10 Minutes provides a no-fluff, just-the-answers guide to building and managing MySQL databases. It is carefully organized and thoughtfully written to provide just the information that you need in order to gain a rapid working knowledge of MySQL. Get up to speed quickly with Sams Teach Yourself MySQL in 10 Minutes.
MySQL Tutorial
On
11:08 AM
0
comments
Number Of Pages: 288
Publication Date: December 4, 2003
Publisher: MySQL Press
Format: chm
Size: 639 KB
Book Description:
A concise introduction to the fundamentals of working with MySQL.
MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.
Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.
MySQL Pocket Reference
On
11:03 AM
0
comments
Number Of Pages: 96
Publication Date: Feburary 19, 2003
Publisher: O'Reilly Media
Format: chm
Size: 146 KB
Book Description:
Easy to take and use anywhere, the MySQL Pocket Reference provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world.
MySQL 5.0 Certification Study Guide
On
8:08 AM
0
comments
Number Of Pages: 643
Publication Date: September 3, 2005
Publisher: MySQL Press
Format: chm
Size: 1.60 MB
Book Description:
This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months.
The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.
Number Of Pages: 888
Publication Date: May 7, 2006
Publisher: MySQL Press
Format: chm
Size: 1.70 MB
Book Description:
Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, the MySQL Administrator's Guide and Language Reference is the official guide to installing MySQL, to setting up and administering MySQL databases, and to storing and retrieving data in these databases. This new edition combines into one book the MySQL Language Reference (on CD) with the practical information of the MySQL Administrator's Guide book.
Mastering MySQL 4
On
7:58 AM
0
comments
Number Of Pages: 772
Publication Date: January 21, 2003
Publisher: Sybex
Format: chm
Size: 1.86 MB
Book Description:
MySQL is the leading open-source database platform, and its popularity has grown with the widespread adoption of PHP for interactive web applications. With version 4, MySQL has added many new features and shown itself to be ready for widespread use. Mastering MySQL is a comprehensive guide to this new version, for both developers and administrators who want to get the most out of MySQL. It provides thorough coverage of SQL, both for the beginner and advanced user, as well as database design and normalization--topics often ignored in much database development. Readers will learn how to configure and optimize MySQL for high-volume usage and get the most out of the various transactional and non-transactional table types. Readers also get full coverage of common database tasks, including backup, maintenance, and replication. There is also a chapter on database security issues, a section on programming with MySQL, and references for most popular programming languages, including PHP, Perl, Java, Python and C/C++. Author Ian Gilfillan is lead developer for South Africa's premier news portal, has developed and taught web and database programming courses, and has written technical articles on MySQL.
Number Of Pages: 504
Publication Date: March 13, 2006
Publisher: Apress
Format: pdf
Size: 6.34 MB
Book Description:
JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the authors other book, JDBC Recipes: A Problem-Solution Approach, leaves off.
This new edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developers application development.
MySQL Crash Course
On
10:01 PM
0
comments
Number Of Pages: 336
Publication Date: December 22, 2005
Publisher: Sams
Format: chm
Size: 525 KB
Book Description:
MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:
Retrieve and sort data
Filter data using comparisons, regular expressions, full text search, and much more
Join relational data
Create and alter tables
Insert, update, and delete data
Leverage the power of stored procedures and triggers
Use views and Cursors
Manage transactional processing
Create user accounts and manage security via access control
MYSQL in a Nutshell
On
9:40 PM
0
comments
Number Of Pages: 576
Publication Date: April 15, 2008
Publisher: O'Reilly Media
Format: chm
Size: 525 KB
Book Description:
When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book.
The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.
MySQL Cookbook
On
9:26 PM
0
comments
Number Of Pages: 976
Publication Date: January 27, 2007
Publisher: O'Reilly Media
Format: chm
Size: 1.42 MB
Book Description:
Good programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel. If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process.
Subscribe to:
Posts (Atom)