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
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …
video
Bootstrap 5 Course: Build Responsive Websites Like a Pro
There is no doubt that the future belongs to web developers who know how to build …
video
Learning Autodesk AutoCAD 2017
In this Learning AutoCAD 2017 training course, expert author Brian Benton will teach you everything you …
book
CHFI Computer Hacking Forensic Investigator Certification All-in-One Exam Guide
An all-new exam guide for version 8 of the Computer Hacking Forensic Investigator (CHFI) exam from …