MySQL for Non-Programmers

MySQL for Non-Programmers

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 02m | 149 MB

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.

Table of Contents

1 Learn to program with MySQL

Introduction to Databases
2 What’s a database
3 Why use MySQL
4 Types and uses of different databases
5 Command line vs. IDE
6 Install MySQL

Get Started The Basics
7 Create a database
8 MySQL data types
9 Create a table
10 Keys and constraints
11 Create a script to build the database

Advanced Concepts
12 Queries
13 Expressions
14 Clauses
15 Functions and operators

Query Data
16 Joins
17 Query, sort, filter, and modify data
18 Stored procedures
19 Create indexes

20 Next steps