Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

SQL: The Language of Data

Current Status

Not Enrolled

Price

$37.00

Get Started

Course Content

01 Intro
01 - 01 Installing MySQL
01 - 02 Creating Your First Database and Table
01 - 03 Entering In Sample Data and Importing Data
01 - 04 Filtering Results - WHERE, DISTINCT and LIMIT Commands
01 - 06 Wildcards for Dynamic Filtering
01 - 07 Sorting Results By One or More Columns
01 - 08 Calculated Fields, Concatenation, Aliases, Built-In Functions
01 - 09 Additional Important Built-In Functions
02 Advanced Table Manipulation
02 - 01 Importing Multiple Tables At Once
02 - 02 Aggregate Functions and Grouping
02 - 04 Combining Data From Multiple Tables Using JOINS And UNION
02 - 05 Subqueries
02 - 06 What Is CRUD
02 - 07 Edit Records With UPDATE Statement
02 - 08 Using Indexes To Speed Up Searches
02 - 09 Using Multiple Columns For An Index (Compound, Composite Keys)
02 - 10 Table Relationships, Foreign Keys And The EER Diagram
02 - 11 Custom Rules with Check Constraints
02 - 12 Custom Field Defaults, Create and Update Record TIMESTAMPS
03 Additional Tips and Tricks
03 - 01 CASE WHEN Statements (Like IF THEN)

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram