MySQL for Non-Programmers

MySQL for Non-Programmers

1h 2mBeginner2022-06-07

Authors

Martine Moses

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

Introduction

  • Learn to program with MySQL

Introduction to Databases

  • What s a database
  • Why use MySQL
  • Types and uses of different databases
  • Command line vs. IDE
  • Install MySQL

Get Started - The Basics

  • Create a database
  • MySQL data types
  • Create a table
  • Keys and constraints
  • Create a script to build the database

Advanced Concepts

  • Queries
  • Expressions
  • Clauses
  • Functions and operators

Query Data

  • Joins
  • Query, sort, filter, and modify data
  • Stored procedures
  • Create indexes

Conclusion

  • Next steps
40,000 Toman