dbForge Studio for MySQL
This course covers a wide range of topics across the design, development, management, and administration of MySQL and MariaDB databases. Here you will find the easiest and fastest ways to accomplish nearly any database-related task using dbForge Studio for MySQL, an all-in-one IDE for MySQL and MariaDB.
- 6 Modules
- 38 Lessons
- 3h 4min
-
IntroductionWhat Is MySQL: A Guide for Beginners11:14
-
Get Started With MySQL Easily Using dbForge Studio4:56
-
Getting Started With dbForge StudioOverview of the Core Features of dbForge Studio for MySQL4:01
-
Database Development Tools in dbForge Studio for MySQL7:06
-
Installing MySQL on Windows3:59
-
Installing dbForge Studio for MySQL on Ubuntu Using Wine4:45
-
Installing dbForge Studio for MySQL on Linux Using CrossOver5:25
-
Installing dbForge Studio for MySQL on macOS Using CrossOver5:48
-
The Start Page of dbForge Studio for MySQL2:40
-
Connecting to a MySQL Database4:36
-
Connecting to a MySQL Database Instance on Amazon RDS1:52
-
Setting Connection Categories in dbForge Studio1:37
-
How-to Tutorials: Database Design & DevelopmentHow to Create a MySQL Database0:58
-
How to Create a MySQL Table1:40
-
MySQL Primary Key: What It Is and How to Use It9:20
-
A Comprehensive Guide to MySQL Foreign Keys12:49
-
Many-to-Many Relationships in MySQL: A Comprehensive Tutorial2:13
-
A Beginner's Guide to MySQL JOINs2:31
-
How to Work With the MySQL Slow Query Log7:57
-
How to Debug MySQL Stored Procedures2:26
-
How to Create Queries Visually Using Query Builder2:27
-
How to Import & Export MySQL Data6:56
-
How to Generate Test Data and Populate Your Databases With It3:40
-
How to Reverse-Engineer MySQL Database Objects7:05
-
How to Create MySQL Databases With Database Projects4:31
-
How to Version-Control MySQL Databases2:32
-
How-to Tutorials: Database ManagementHow to Backup and Restore a MySQL Database7:10
-
How to Synchronize Data Between Two MySQL Databases2:58
-
How to Compare and Synchronize MySQL Schemas3:01
-
How to Migrate MySQL Databases6:30
-
How-to Tutorials: Database AdministrationHow to Create a New User in MySQL4:00
-
How to Manage User Privileges in MySQL10:15
-
How to Check Running Queries and Processes in MySQL5:58
-
How to Perform MySQL Table Maintenance8:16
-
How to Copy MySQL Database Schemas3:39
-
How-to Tutorials: Data Analysis & ReportingHow to Create a MySQL Data Report3:45
-
How to Create a Pivot Table in MySQL2:07
-
How to Generate Documentation for a MySQL Database1:06
What Is MySQL: A Guide for Beginners
Here is your most comprehensive introduction to MySQL—a guide that will help you explore the history and basics of MySQL as well as the wide range of features and capabilities that established it as one of the most renowned and popular database management systems.
Get Started With MySQL Easily Using dbForge Studio
If you want to get effectively started with MySQL and MariaDB databases, you will need a suitable tool that will help you access and manage them in the easiest way. Here we suggest dbForge Studio for MySQL, an all-in-one IDE with a rich set of features and a clean interface, perfect for beginners and seasoned users alike.
Overview of the Core Features of dbForge Studio for MySQL
Learn all about the core features offered by dbForge Studio, from context-aware code completion, debugging, and source control to database design, backups, table maintenance, and user management.
Database Development Tools in dbForge Studio for MySQL
Get acquainted with the full set of database development tools available in dbForge Studio for MySQL: Code Editor, CRUD Generator, Query Profiler, MySQL Debugger, and more!
Installing MySQL on Windows
Watch a step-by-step guide to downloading and installing MySQL on your Windows machine.
Installing dbForge Studio for MySQL on Ubuntu Using Wine
Learn how to download and install dbForge Studio for MySQL on Ubuntu using Wine.
Installing dbForge Studio for MySQL on Linux Using CrossOver
Check an alternate way of installing and running dbForge Studio for MySQL on Linux via CrossOver, a compatibility solution by CodeWeavers.
Installing dbForge Studio for MySQL on macOS Using CrossOver
Learn how to install and run dbForge Studio for MySQL on your Mac via CrossOver, a compatibility solution by CodeWeavers.
The Start Page of dbForge Studio for MySQL
Get acquainted with the Start Page, the first thing you see upon launching dbForge Studio. It comprises several tabs that provide quick access to the key features of the Studio.
Connecting to a MySQL Database
See how to establish a connection to a MySQL database in dbForge Studio.
Connecting to a MySQL Database Instance on Amazon RDS
Learn how to create a MySQL database instance on Amazon RDS and connect to it in dbForge Studio for MySQL.
Setting Connection Categories in dbForge Studio
Facilitate your further work with multiple connections in dbForge Studio for MySQL by creating, setting up, and managing connection categories.
How to Create a MySQL Database
See how easy it is to create a new MySQL database in dbForge Studio with just a few clicks.
How to Create a MySQL Table
Creating tables in dbForge Studio for MySQL is just as easy and doesn't require any coding. Check the video to see how it's done.
MySQL Primary Key: What It Is and How to Use It
The guide covers the concept of a primary key, demonstrates how to establish primary keys for both new and existing tables, and provides guidance on managing primary keys using dbForge Studio.
A Comprehensive Guide to MySQL Foreign Keys
The guide covers the concept of a primary key, demonstrates how to establish primary keys for both new and existing tables, and provides guidance on managing primary keys using dbForge Studio.
Many-to-Many Relationships in MySQL: A Comprehensive Tutorial
Learn how to create many-to-many relationships between MySQL tables in dbForge Studio.
A Beginner's Guide to MySQL JOINs
Learn all about the most popular types of JOINs in MySQL: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and CROSS JOIN. See how to handle MySQL JOINs most effectively using dbForge Studio for MySQL.
How to Work With the MySQL Slow Query Log
Find out how to troubleshoot query performance issues in dbForge Studio for MySQL.
How to Debug MySQL Stored Procedures
Get acquainted with the easiest way of debugging stored procedures using the Studio's integrated MySQL Debugger.
How to Create Queries Visually Using Query Builder
Coding is not the only way to construct MySQL queries. See how it's done using the Studio's visual Query Builder. With its help, you can draw queries of any complexity on diagrams without writing a single line of code.
How to Import & Export MySQL Data
Learn how to import and export MySQL data in dbForge Studio with up to 14 most popular formats and a slew of versatile settings at hand.
How to Generate Test Data and Populate Your Databases With It
Learn how to use the Studio's built-in Data Generator for populating MySQL database tables with thousands of rows of meaningful, column-intelligent test data.
How to Reverse-Engineer MySQL Database Objects
Study the process of reverse-engineering database objects in dbForge Studio for MySQL.
How to Create MySQL Databases With Database Projects
Take a look at database design made simple with the Database Projects and Schema Compare features that come with dbForge Studio for MySQL.
How to Version-Control MySQL Databases
Learn how to version-control database schemas and static table data, commit and revert changes, view and resolve conflicts, and track all changes using the Studio's integrated Source Control.
How to Backup and Restore a MySQL Database
Have a look at the straightforward process of backing up and restoring MySQL databases without coding in dbForge Studio for MySQL.
How to Synchronize Data Between Two MySQL Databases
See how easy it is to compare and synchronize the data of two databases in dbForge Studio.
How to Compare and Synchronize MySQL Schemas
Similarly, learn how to compare database schemas and synchronize them with minimum effort.
How to Migrate MySQL Databases
Discover the simplest way of migrating databases between different environments across MySQL, MariaDB, Amazon Aurora, and Amazon RDS.
How to Create a New User in MySQL
Take a look at the step-by-step process of creating a new user and granting permissions in dbForge Studio for MySQL.
How to Manage User Privileges in MySQL
See how dbForge Studio can help you review the existing MySQL user accounts, as well as assign and review their privileges.
How to Check Running Queries and Processes in MySQL
Learn how to use the MySQL Session Manager of dbForge Studio to identify running processes and queries, view current users logged in to a MySQL instance, and terminate their sessions.
How to Perform MySQL Table Maintenance
You can perform essential MySQL table maintenance tasks using dbForge Studio for MySQL. Learn how to analyze tables, check them for errors, optimize your data, and repair corrupted tables in no time.
How to Copy MySQL Database Schemas
See how easy it is to copy database schemas and table data using the Studio's Backup and Restore functionality.
How to Create a MySQL Data Report
Learn how to create compelling data reports in the most effortless way using dbForge Studio for MySQL.
How to Create a Pivot Table in MySQL
Get acquainted with the process of creating, customizing, and designing pivot tables in dbForge Studio.