|
Free ebooks
 Free database ebooks SQL The Definitive Guide to MySQL (2nd Edition)-The Expert's Voice in Open Source
|
 Chapter 1: What Is MySQL? - This chapter begins with an overview of the most important concepts from the world of databases and then delves into the possibilities and limitations of MySQL. Chapter 2: The Test Environment - In this chapter we discuss first of all how to set up the test environment for MySQL on a local computer. Chapter 3: Introductory Example - The best way of becoming familiar with a new database or development system is to work through a full-fledged example. Thus in this chapter our goal is to create a web site for the purpose of conducting an opinion poll. Chapter 4: User Interfaces - This chapter introduces the most important user interfaces for MySQL. Chapter 5: Database Design - This chapter discusses the fundamentals of relational databases, collects the varieties of data and tables available under MySQL, offers concrete examples of MySQL database structures, shows how indexes enable more efficient table access. Chapter 6: An Introduction to SQL - This chapter provides an introduction to the database language Structured Query Language, or SQL for short. Chapter 7: SQL Recipes - This chapter contains a collection of small SQL examples that go somewhat beyond the elementary level of the other examples in this chapter. Chapter 8: InnoDB Tables and Transactions - This chapter offers a brief introduction to the world of InnoDB, and with its comparison of MyISAM and InnoDB tables offers a basis for choosing the optimal table type for a particular application. Chapter 9: Security - This chapter describes rather extensively the access system of MySQL, both its internal management and the tools that can assist you in changing access privileges. Chapter 10: Administration and Server Configuration - This chapter describes the administration and configuration of the MySQL server. Chapter 11: PHP — Fundamentals and Programming Techniques - This chapter provides general programming techniques. Chapter 12: PHP — Library Management - This chapter describes a relatively large PHP example program that allows for querying the mylibrary database and adding new titles to it. Chapter 13: PHP — Discussion Forum Chapter 14: Perl - This chapter gives a brief introduction to MySQL database access with Perl and shows, by means of a few examples, the large bandwidth of possible applications. Chapter 15: Java, JSP, JDBC - This chapter describes the development of MySQL applications with the programming language Java and with Java Server Pages (JSP). Chapter 16: C and C++ - This chapter gives a first introduction to programming MySQL applications with the programming languages C and C++. Chapter 17: Visual Basic, C#, ODBC - This chapter begins with some background information about ODBC and the setting up of data source names (DSNs), which simplify access to ODBC data sources. Chapter 18: SQL Reference - This chapter gives an overview of the SQL operators, functions, and commands available under MySQL. Chapter 19: MySQL Tools - This chapter is a reference for the options and functions of the most important MySQL tools. Chapter 20: API Reference - This chapter contains a reference to the APIs (application interfaces) that were introduced in this ebook for the programming languages PHP, Perl, Java, and C. Download free pdf ebooks for sql:The Definitive Guide to MySQL (2nd Edition)
|
