SQL VIEWS + Complex Queries, Cross Joins, Unions, and more!  |¦| SQL Tutorial

SQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL Tutorial

I have dissected many hard drives, and let me tell you – databases can be a sticky and complicated mess! The number of tables… the unusual column names… the linking…

Read more »
Introduction to MySQL Enterprise Edition

Introduction to MySQL Enterprise Edition

Read more »
Relational Databases – How to Choose  |¦|  SQL Tutorial  |¦|  SQL for Beginners

Relational Databases – How to Choose |¦| SQL Tutorial |¦| SQL for Beginners

When choosing a database, you may experience analysis paralysis. I understand. The number of choices can feel overwhelming, and more options are being engineered every year. Today, we survey the…

Read more »
SQL Index |¦| Indexes in SQL |¦| Database Index

SQL Index |¦| Indexes in SQL |¦| Database Index

Today we are going to run SQL queries against a table containing ten THOUSAND records. {{ Maniacal laughter }} {{ Phone call }} What is it, I’m in the middle…

Read more »
MySQL Enterprise Edition [Newer Version Available]

MySQL Enterprise Edition [Newer Version Available]

Read more »
MySQL – Renomear tabelas com RENAME TABLE – 19

MySQL – Renomear tabelas com RENAME TABLE – 19

Read more »
Compiling the Dodeca Servlet (Installing Dodeca, Part 4/5)

Compiling the Dodeca Servlet (Installing Dodeca, Part 4/5)

Next, we’ll be compiling the Dodeca servlet. From the Start Menu, navigate to Applied OLAP>Utilities, and then select ClickOncePrep Utility. For this tutorial, we’ll only be updating some of the…

Read more »
Should I Learn Oracle or MySQL?

Should I Learn Oracle or MySQL?

Should I learn Oracle or MySQL? MySQL is a popular open source database, but Oracle seems like the default database I see in use. Oracle is more expensive to implement…

Read more »
Backing up MySQL Cloud Service Instances

Backing up MySQL Cloud Service Instances

[background music] In this video we’ll backup and restore databases on MySQL Cloud Service. MySQL Cloud Service uses MySQL Enterprise Backup to backup to cloud storage which in turn uses…

Read more »
Patching MySQL Cloud Service

Patching MySQL Cloud Service

In this video I’ll demonstrate how to patch a MySQL Cloud Service instance. Under Administration, it indicates that one patch is available. I’ll select Administration to apply the patch. The…

Read more »