MySQL is the world's most popular relational database solution used in businesses and independent projects, with thousands of new developers and users coming on board every day. Because it continues to evolve and integrate into the biggest technologies on the web, there has never been a better time to learn, and this hands-on MySQL 5 tutorial course makes it easy. With a step-by-step approach tailored for beginners, course author Jason Gilmore introduces the fundamental concepts underlying relational databases and helps you learn how to build your own functional database and manage it using standard techniques and tools. You'll get 91 lessons taking you from MySQL installation and configuration through learning and using different data types, retrieving and filtering data, working with functions, performing backup and security tasks and more. No prior experience is needed. Matching work files are included so that you can follow the course point by point through the development process.
What You Will Learn
- The basic building blocks of relational databases and how they apply, including strings, numerical data types, primary and foreign keys, functions and queries.
- How to install and set up a usable MySQL server on Windows.
- How to access, modify and manage your data within a MySQL database.
- How to use relational databases to solve problems in business and software or web development.
Who Should Take This Course
- Anyone who wants to learn to create functional, flexible databases for archival, organization or software development purposes.
- Users moving from software-centered solutions such as Microsoft Access or FileMaker looking for a greater degree of control.
- Anyone who wants to increase their employment or promotion prospects by learning a current, relevant technology standard.
What People Are Saying
"I thought MySQL was over my head...the books I'd bought didn't help but these videos have already made a huge difference in what I can do."
- Darrel Nixa
"Jason is awesome as a teacher, and I can't say enough how helpful having the files were in following along."
- Rachel Black
"The section on optimization is where it really came together for me...there's some serious power here if you've got a lot of data to work with."
- Tom Leippi