In this book we will introduce you to MySQL as well as some great tools you can download for free that will allow you to develop databases and entire web sites on your computer. We will introduce you to MySQL and through simple language give you the foundation you need to advance to more complicated projects.
If you have ever used or try to use books explaining MySQL before and are just confused as hell don’t worry this book is totally different. I explain everything that you need to know and give you pictures, descriptions and even sample code you can use to get started.
We will even create a simple web form that will employee or user information. You can then take this and expand on it to create your very own databases.
So if you are tired of being confused and just reading books that give you garbage information you need to read this book. It won’t get you building the next Facebook but it will give you the understanding and tools to start building something that one day may turn into the next big thing.
Here Is A Preview Of What Inside The Book:
- Define efficient database structures and objects
- “Normalize” raw databases into logically organized tables
- Edit relational data and tables with DML
- Manage transactions
- Write effective, well-performing queries
- Categorize, summarize, sort, group, and restructure data
- Work with dates and times
- Join tables in queries, use subqueries, and combine multiple queries
- Master powerful query optimization techniques
- Administer databases and manage users
- Secure databases and protect data
- Use views, synonyms, and the system catalog
- Extend SQL to the enterprise and Internet
- Master important Oracle and Microsoft extensions to ANSI SQL
