|
Free ebooks
 Free database ebooks SQL MySQL Tutorial:A concise introduction to the fundomentals of working with MySQL
|
 Part I, "MySQL Basics," will teach you how to install and configure MySQL on your system and will give you a tour of your installation.Chapter 1. Installing MySQL - In this chapter, we will see how to install MySQL and set it up for normal use. Chapter 2. Quick Tour - This chapter introduces the structure and tools associated with MySQL. Part II, "Designing and Creating Databases with MySQL," will take you through the process of database design and creation. Readers who have done database design before can skim through this part of the book, but if databases are new to you, we suggest that you read it in detail. Chapter 3. Database Design Crash Course - In this chapter we will review the basic principles of database design and normalization. Chapter 4. Creating Databases, Tables, and Indexes - In this chapter you'll learn how to create all the basic MySQL structures: databases, tables, and indexes. Part III, "Using MySQL," takes you through how to query MySQL on a day-to-day basis. Chapter 5. Inserting, Deleting, and Updating Data - In this chapter, we will look at how to insert and change data in your MySQL database with the INSERT, DELETE, and UPDATE statements. Chapter 6. Querying MySQL - In this chapter, we will cover the SQL SELECT statement in some detail. Chapter 7. Advanced Queries - In this chapter, we'll discuss more advanced queries. Principally, we will look at how we can run queries across multiple tables. Chapter 8. Using MySQL Built-In Functions with SELECT - In this chapter, we will make some use of the SELECT statement without any tables. Part IV, "MySQL Table Types and Transactions," explains how to use the different storage engine types in MySQL, with a special focus on the InnoDB engine and how it can be used for transactions. Chapter 9. Understanding MySQL's Table Types - In this chapter, we'll review the different table types available to the MySQL database designer. Chapter 10. Using Transactions with InnoDB Tables - In this chapter, we will cover transactions in MySQL. Part V, "Administering MySQL," explains the basic tasks needed to perform DBA duties with MySQL, including user management, configuration, database maintenance, backup and recovery, database security, and replication. Chapter 11. Managing User Privileges - In this chapter, we'll discuss user account creation, the different privileges available, and how these privileges are represented within MySQL tables. Chapter 12. Configuring MySQL - In this chapter, we'll follow up on the brief introduction to configuration you received in Chapter 1, "Installing MySQL." Chapter 13. Administering Your Database - Although this chapter is structured in a task-oriented fashion, we will make use of one important script, mysqladmin, for several of these tasks. Chapter 14. Backup and Disaster Recovery - In this chapter we will look at how to back up or make copies of your databases, how to move them to another machine, and how to recover when things go wrong. Chapter 15. Securing Your MySQL Installation - In this chapter we'll discuss general security issues you should consider when running MySQL. Part VI, "Optimizing MySQL," will help you to get the most out of your MySQL database by optimizing your server setup, database, and queries for your specific situation. Chapter 17. Optimizing Your MySQL Server Configuration - In this chapter, we'll look at some options for speeding up your MySQL server. Chapter 18. Optimizing Your Database - In this chapter, we'll look at how you can optimize your database tables. Download free ebooks for SQL:MySQL Tutorial:A concise introduction to the fundomentals of working with MySQL
|
