Advanced SQL concepts include joins, grouping, aggregate functions, and Common Table Expressions (CTEs). ER diagrams can be generated using tools like MySQL Workbench and SQL Server Management Studio.

03-14-2013 TECH How To Use MySQL With Meteor I’ve been using Meteor for the last few months and for the most part I really like it.

If you never set, forgot, or change your MySQL password, you're in luck. This article walks you through these steps, so you'll never be at a loss for that database root user password.

Because MySQL is such a popular database, I thought it would be a great data source to use as an illustration. This will also refresh your memory on how to set MySQL up for remote connections.

How to Call a Stored Procedure From PHP in MySQL. Stored procedures provide PHP programmers with pre-programmed database applications that retrieve and edit MySQL records. Stored procedures let ...