MySQL 5 Development (Part 1) Tutorials
Introduction / What This Course Will Cover
Subtitles of the Movie (MySQL 5 Development (Part 1) / Introduction / What This Course Will Cover)
In this lesson we will map out what we will cover in Part 1 of the MySQL 5 Development course. The purpose of the MySQL 5 Development course is to give you a good start doing database development work with the current version of MySQL Server and provide a solid foundation for good MySQL Development practices. The job of the database developer is to create database tables and to write code for manipulating the content of those tables. When we determined that we had to split this course into two parts, I decided that Part 1 would focus on Setup, Background, and basic nondestructive Querying commands and Part 2 would address those commands where the data is changed, as well as more complex queries that could involve multiple tables. We will also introduce Server-Side Programming Constructs like Stored Procedures. So our Course Objectives are these, when this course is finished you should understand the Basic Installation and Configuration of the MySQL Server for your preferred operating system. You should have a basic understanding of the purpose of the Server and a Client program and how they interact. You should understand the Basic Syntax and the important Options of the Commands that we cover in Part 1. You should be able to solve simple Querying problems using a Single Table, as well as understanding how to perform Aggregation Queries. And you should understand how to look up help in the online manual and from the interactive MySQL Client program, as well as how to Query the Server about information about the database installation, what we call Metadata. This will all set the stage for the more interesting and challenging subjects to be covered in Part 2 of the MySQL 5 Development course. So here are the specific topics that we will address in Part 1. As part of the introduction, which we're in right now, we will start with a brief history of MySQL, that will help explain why MySQL performs some operations in certain ways as well as provide some other background information. We then get down to business and review some basic principles of database work. If you have significant experience with databases, much of this section will be old news but if you are new to working with databases, these lessons lay the groundwork for everything that is to follow. The terminology and definitions introduced here help us to better communicate about the subject. We will also include a couple of brief chapters on installation and configuration of MySQL which will reveal a few of those little-known and often overlooked secrets that you want to know about. You will only need view the installation lesson for the operating system you are using to take this course, but you might find the others informative as well. We follow this with a brief primer on using the Command Line Client programs that come with the MySQL server. Again, there is some variation from platform to platform mainly due to differences in the Shell programs that run the MySQL Client programs. Once we're all set up and briefed on basic operations, we will begin using MySQL to perform basic calculations with the Select Command. We use this basic knowledge to explore how we can interact with the variables and perform many more complex calculations which we will need to understand once we begin Querying Data in Database Tables. Then we really get down to using the Select Command to retrieve information from database tables. This is the operation that most people would use most often, it is a simple process on its surface, but there are many options within this process that I will help you master. In order to be able to build new information content we need to understand how to Create and Modify Databases and Tables. We'll then get a little more technical and discuss the details of the basic data types MySQL offers and why understanding these details is important in our work. And no discussion about MySQL Tables would be complete without also detailing the various storage engines that we can choose from for managing those tables. This is one of the more unique and misunderstood aspects of MySQL so pay close attention to these lessons. We may occasionally need to copy data from our database for use by another program, so we will cover some basic techniques for exporting data. Then we briefly look at prepared statements, this is a very powerful and important feature of MySQL but one that doesn't take too long to master. There will be occasions where we need to examine various aspects of our database installation or what we call Metadata. We have two basic ways of accessing Metadata in MySQL, so a short set of lessons on this will prove to be beneficial. And then we wrap up Part 1 and prepare for the more complex and potentially dangerous content of Part 2. Anytime we can change the content of the database, danger lurks. So that fact ultimately guided my choice of where to split Parts 1 and 2 of this course. In the next lesson we will look briefly at the system requirements that must be met to play along with us as we explore how to use MySQL 5.5.
Tutorial Information
| Course: | MySQL 5 Development (Part 1) |
| Author: | David Swain |
| SKU: | 34225 |
| ISBN: | 1-936334-93-3 |
| Release Date: | 2011-05-27 |
| Duration: | 11 hrs / 129 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
