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
Introduction
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
Conclusion
20 Next steps
Resolve the captcha to access the links!