Video description
This course teaches you how to create a stand-alone MySQL database and how to add, change, delete, and query data within that database. You'll develop a basic understanding of relational databases and gain hands-on experience with the typical software tools application developers, business analysts, and database report writers use to create and work with MySQL databases.
When you complete this course, not only will you know how to use MySQL, you'll also have a good understanding of the world's dominant relational database management systems developed by Oracle, Sybase, Microsoft, and IBM.
- Become familiar with relational databases and the distinctions between SQL and MySQL
- Gain hands-on experience creating and querying MySQL databases
- Discover how to use functions, create indexes, and summarize data
- Understand how to do complex SQL queries and optimize a database's performance
- Explore comparison and logical operators, pattern matching, joins, and subqueries
- Know how to modify database data using SQL, and how to create and use views
- Learn the processes and software used in the world's leading RDMS systems
Publisher resources
Table of contents
- Introduction
- Creating A Database
- Querying Data From A Database
- Using Functions And Summarizing Data
-
Advanced Database Queries
- Many To Many Relationships
- Join Multiple Tables With The Using Clause
- Join Multiple Tables With The On Clause
- Eliminating Duplicate Rows From The Results
- Using The Like Operator For Pattern Matching
- Using The In Operator
- How Subqueries Work
- Subqueries With The In Operator
- Creating And Using Views
- Combining SQL Results
- Conclusion
Product information
- Title: Introduction to MySQL
- Author(s):
- Release date: March 2017
- Publisher(s): Infinite Skills
- ISBN: 9781491982327
You might also like
video
AWS Certified Cloud Practitioner Complete Video Course
7 Hours of Video Instruction Seven hours of video instruction covering the fundamentals of cloud computing; …
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
video
Linux Fundamentals
10+ Hours of Video Instruction Linux Fundamentals LiveLessons has more than 10 hours of comprehensive video …
video
MySQL 5
In this computer based training course, expert author Jason Gilmore introduces you to MySQL, a popular …