MySQL for Non-Programmers
1h 2mBeginner2022-06-07
Authors

Martine Moses
Back-End and Integration Developer
Course details
These days, in nearly every field, data is king. More and more businesses are asking non-technical employees to generate data reports, and having a command of the tools used to accomplish these reporting tasks may either lead to new job opportunities or keep you from advancing in your career. In this course, Martine Moses teaches mySQL database basics, easing you into a familiarity with this popular relational database. She covers how it differentiates from other DBs, best use cases, and how to perform basic functions within mySQL. Whether you’re a non-programmer looking to expand your skill set, or looking to move into the tech realm, this course gives you a groundwork to learn more about mySQL and using databases in general.
Skills covered
MySQLDatabase DevelopmentDatabase ManagementPersonaOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Learn to program with MySQL
1. Introduction to Databases
- 02 - What s a database
- 03 - Why use MySQL
- 04 - Types and uses of different databases
- 05 - Command line vs. IDE
- 06 - Install MySQL
2. Get Started - The Basics
- 07 - Create a database
- 08 - MySQL data types
- 09 - Create a table
- 10 - Keys and constraints
- 11 - Create a script to build the database
3. Advanced Concepts
- 12 - Queries
- 13 - Expressions
- 14 - Clauses
- 15 - Functions and operators
4. Query Data
- 16 - Joins
- 17 - Query, sort, filter, and modify data
- 18 - Stored procedures
- 19 - Create indexes
Conclusion
- 20 - Next steps
Related courses
Related learn paths
- Advance your Skills as a PHP Developer: Working with Data
- Get Started with PHP
- Master Advanced Excel Data & Analytics Skills
- SQL for Data Professionals in Finance
- Introduction to Fundamental Skills for Data Work: Data Storage
- Become a Back-End Web Developer
- Explore Web Development with Node.js
- Take Better Photos with Your Phone