Installing MySQL and Creating Databases | MySQL for Beginners

Summary

In this MySQL tutorial series introduction, the host outlines the structure of the upcoming beginner, intermediate, and advanced lessons. The first lesson focuses on setting up MySQL, including installation and creating a database. The host also directs viewers to full courses on analystbuilder.com for in-depth learning and practice. The tutorial demonstrates downloading MySQL, installing it, and configuring it as a Windows service. The host guides viewers through creating a database using SQL script files, showcasing the basics of MySQL Workbench and setting the stage for future lessons on querying data.

Takeaways

• 😀 The video is the first in a MySQL tutorial series, aimed at beginners.
• 🎓 The MySQL tutorial series is divided into three parts: beginner, intermediate, and advanced.
• 💻 The tutorial covers installation of MySQL and setting up a database for learning purposes.
• 🔗 Links to full MySQL courses are provided in the video description, including a crash course and courses for different skill levels.
• 🌐 The MySQL installer can be downloaded from dev.mysql.com/downloads.
• 🖥️ The tutorial demonstrates installing MySQL on a Windows machine, with instructions for other operating systems available.
• 🛠️ The installation process includes selecting setup type, checking requirements, and configuring the MySQL server.
• 🔐 A password is set for MySQL authentication, and the server is configured to start automatically at system startup.
• 🗂️ The tutorial includes creating a database and tables using SQL script files, which can be downloaded from GitHub.
• 🔍 The MySQL Workbench interface is introduced, showing how to execute SQL queries and view database contents.

Q & A

What is the purpose of the MySQL tutorial series mentioned in the script?

The purpose of the MySQL tutorial series is to teach the basics of MySQL, broken up into beginner, intermediate, and advanced levels, with the first lesson focusing on setting up MySQL and creating a database.

Where can the full MySQL courses created by the speaker be found?

The full MySQL courses created by the speaker can be found on analystbuilder.com.

What are the different types of MySQL downloads available as per the script?

The different types of MySQL downloads available are 'MySQL Installer Community' and 'MySQL Installer Web Community'.

What is the difference between 'MySQL Installer Community' and 'MySQL Installer Web Community'?

The 'MySQL Installer Community' is a larger download that includes the installer, while 'MySQL Installer Web Community' is a smaller download that retrieves the installer from the web.

Why might the speaker suggest using 'Developer Default' during the MySQL setup?

The speaker suggests using 'Developer Default' during the MySQL setup to install the necessary components without needing to configure advanced settings, which are typically unnecessary for beginners.

What is the requirement that the speaker encountered during the MySQL installation process?

The requirement encountered during the MySQL installation process was the Microsoft Visual C++ redistributable package, which needed to be downloaded and installed.

What authentication method does the speaker choose for the MySQL server configuration?

The speaker chooses the 'Password' authentication method for the MySQL server configuration, opting not to use the 'Legacy' authentication method.

Why does the speaker decide to start the MySQL server at system startup?

The speaker decides to start the MySQL server at system startup for convenience, ensuring that the server is automatically available without manual intervention.

What is the significance of the 'Parks and Rec create DB' file mentioned in the script?

The 'Parks and Rec create DB' file is significant as it contains the SQL script to create the database and tables that will be used throughout the MySQL tutorial series.

How does the speaker demonstrate the execution of SQL queries in MySQL Workbench?

The speaker demonstrates the execution of SQL queries by using the lightning bolt button in the MySQL Workbench query editor, which runs the highlighted code or all code in the editor window if nothing is highlighted.

What is the final step the speaker takes to ensure readiness for the next lesson?

The final step the speaker takes is to remove the SQL additions feature in MySQL Workbench to prepare for the next lesson, which will focus on learning the basics of SQL.

Outlines

00:00

💻 Introduction to MySQL Tutorial Series

The video script introduces a MySQL tutorial series divided into beginner, intermediate, and advanced levels. The first lesson in the beginner series focuses on setting up MySQL by installing it and creating a database for learning purposes. The instructor mentions three comprehensive MySQL courses available on analystbuilder.com, tailored for different skill levels and interview preparation. The courses include practice questions and guided projects. The video then proceeds with a step-by-step guide to download MySQL from dev.mysql.com, selecting the appropriate installer for the user's operating system, and navigating through the installation process. The instructor chooses the 'Developer Default' setup type and encounters a minor issue with the installation path but continues with the installation. The video concludes with the MySQL installer's requirements check, emphasizing the need for the Microsoft Visual C++ redistributable package, which the instructor had to install personally.

05:00

🛠 Configuring MySQL Server and Workbench

The script continues with the MySQL installation process, focusing on configuring the MySQL server. The instructor skips the configuration for the router and samples/examples, as they are not essential for the tutorial's purpose. The server configuration involves selecting an authentication method, where the instructor opts for a password-based approach over the Legacy method. Despite a minor glitch with the password field remembering a previous password, the configuration proceeds with setting the MySQL server to run as a Windows service and starting at system startup. The video then demonstrates the completion of the server configuration and briefly touches on configuring additional components like samples and examples, which involve adding sample databases. The installation is finalized, and the instructor shows how to start MySQL Workbench and access the local instance. The video ends with a demonstration of creating a new query tab and opening a SQL script file to create a database, which is part of the tutorial's GitHub repository.

10:02

📊 Exploring MySQL Workbench and Database Creation

The final paragraph of the script describes the process of using MySQL Workbench to create and explore a database. The instructor navigates to the 'local instance' in Workbench and opens a SQL script file named 'parks and rec create DB' from a预先 created folder. This script is used to create the database and populate it with tables and data, which will be used throughout the tutorial series. The video demonstrates executing the script to create the database and tables, and then refreshing the schemas to view the newly created 'Parks and Recreation' database. The instructor also shows how to open a table to view its data, explaining the structure of the 'employee demographics' table with columns like employee ID, first name, last name, age, gender, and birth date. The video concludes with a brief overview of executing queries in the query editor, highlighting the difference between running all queries in the editor and running only the highlighted query. The instructor expresses excitement for the upcoming lessons, which will delve into the basics of SQL queries.

Keywords

💡MySQL

MySQL is an open-source relational database management system (RDBMS) based on SQL (Structured Query Language). It is widely used for managing data in web applications and is known for its speed, reliability, and ease of use. In the video, MySQL is the central theme as the tutorial series aims to teach viewers how to install, set up, and use MySQL for database management. The script mentions installing MySQL and creating a database, which are foundational steps for beginners learning MySQL.

💡Tutorial Series

A tutorial series refers to a collection of instructional videos or lessons designed to teach a specific skill or subject. In the context of the video, the tutorial series is broken into beginner, intermediate, and advanced levels, each targeting different skill levels of MySQL users. The video script outlines the structure of the series and what viewers can expect to learn in each part.

💡Beginner Series

The beginner series is the initial part of the tutorial series designed for individuals who are new to MySQL. It covers the fundamentals of setting up and using MySQL databases. The video script specifically mentions that the first lesson is part of the beginner series, where the focus is on installation and basic setup, such as creating a database.

💡Database

A database is an organized collection of data, typically stored and accessed electronically using a computer system. In the video, the script discusses creating a database in MySQL, which is a fundamental step in learning how to manage data using this RDBMS. The database created will be used throughout the series for practical examples and exercises.

💡Installation

Installation refers to the process of setting up and preparing software for use on a computer. In the video script, the installation of MySQL is a key step that the tutorial guides viewers through. The script details the steps to download MySQL from the official website and the process of running the installer on a Windows machine.

💡MySQL Workbench

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. It provides data modeling, SQL development, and comprehensive administration tools. In the video, MySQL Workbench is mentioned as the tool that will be used to manage and interact with the MySQL database after installation.

💡SQL (Structured Query Language)

SQL is a standard language for managing and manipulating relational databases. It is used for creating, updating, and querying databases. The video script implies that SQL will be the primary language used throughout the tutorial series to interact with MySQL databases.

💡Authentication Method

An authentication method is a process or mechanism by which a user's identity is verified by a system. In the video script, the tutorial covers the selection of an authentication method during the MySQL installation process, which is crucial for securing access to the database server.

💡Configuration

Configuration in the context of software installation refers to the customization of settings to suit specific requirements or preferences. The video script describes configuring the MySQL server, which includes setting up the server type, networking, and authentication settings to prepare it for use.

💡Sample Database

A sample database is a pre-populated database provided for demonstration, testing, or learning purposes. The video script mentions the option to install sample databases during the MySQL setup, which can be useful for beginners to explore and understand database structures and operations without starting from scratch.

💡Query Editor

A query editor is a tool that allows users to write, edit, and execute SQL queries. In the video, the MySQL Workbench's query editor is introduced as the interface where viewers will write SQL code to create and manipulate databases and tables. The script demonstrates how to use the query editor to run SQL scripts that create databases and insert data.

Highlights

Introduction to a MySQL tutorial series divided into beginner, intermediate, and advanced levels.

Installation of MySQL and creation of a database for learning purposes.

Availability of three full MySQL courses on analystbuilder.com for different skill levels.

Downloading MySQL from dev.mysql.com/downloads.

Selection of the MySQL installer based on operating system preference.

Explanation of the difference between MySQL Installer Community and MySQL Installer Web Community.

Installation process walkthrough, including setup type selection.

Dealing with installation path conflicts and requirements checks.

Installation of Microsoft Visual C++ redistributable package as a requirement for MySQL.

Configuration of the MySQL server with authentication method selection.

Setting up MySQL server as a Windows service with automatic startup.

Completion of MySQL installation and launching MySQL Workbench.

Introduction to MySQL Workbench interface and local instance connection.

Creating a new database using a SQL script file.

Explanation of the SQL script file content and its purpose in creating tables and inserting data.

Execution of SQL script to create a database and populate tables.

Demonstration of refreshing schemas to view the newly created database.

Preview of the 'employee demographics' table data within MySQL Workbench.

Explanation of executing SQL queries and viewing query results in MySQL Workbench.

Anticipation for the next lesson focusing on the basics of SQL queries.

Transcripts

what's going on everybody today we are

going to be starting our MySQL tutorial

[Music]

series now the entire MySQL series will

be broken up into three smaller series

we'll have our beginner our intermediate

and are Advanced this lesson is the very

first lesson in the beginner Series

where we're going to walk through all of

the beginner or the basics of MySQL

today we're going to be setting

everything up so we'll be installing

MySQL and then creating our database

that we'll use to actually learn my SQL

now before we get started I wanted to

let you know that I created three full

MySQL courses over on analyst

builder.com I built a crash course for

MySQL for people who are going to be

interviewing or taking technical

interviews I also created a full MySQL

course that's going to cover everything

from the basics all the way to the

intermediate level and then lastly I

created an advanced course that's going

to teach you a lot of the more advanced

things that an analyst would typically

use those courses are going to go really

in depth and they're going to have a lot

of practice questions along the way and

we'll also have full guided projects in

there as well I'll have links in the

description to to all of those courses

if you want to check those out now

without further Ado let's jump on my

screen and install my SQL and create our

database all right so let's get started

by downloading MySQL we're going to come

right over here to dev. myql.com

/downloads slster and I will have that

link in the description so you don't

have to write all that out but you

should be seeing this page right here

now we have to select an operating

system I'm using a Windows machine and

if you aren't if you're using Linux or

Mac or something else it should populate

at 4 you but if it doesn't just select

this drop down and select your operating

system next we have two different

downloads we can install the MySQL

installer Community or MySQL installer

web Community this one is very small but

then you actually do have to download

the installer it just gets it from the

web this one I'm going to download the

actual installer it's larger but this is

the one I'm going to do so I'm going to

go ahead and select download it's going

to ask me if I want to log in or create

an account and I don't I'm going to say

no thanks just start my download

I'm going to save this in this desktop

folder doesn't really matter where you

save it we're going to save that and

it's going to download it should be done

in just a few seconds I'm going to go

ahead and click on it and it's going to

open it up when it's finished and we

should get the interface or the UI for

the actual installation for MySQL so

here is the MySQL installer and first

thing we need to do is choose a setup

type now we're going to keep the

developer default unless you really know

what you're doing and you can select the

server only the client only full which

is literally everything my SQL has to

offer or custom so we're going to keep

this developer default just installing

the things that we kind of need so let's

go ahead and select next and for

whatever reason on my computer it's

saying this path already exists you

probably won't get that but I'm just

going to go ahead and select next and

then I'll select yes it keeps doing that

I can't explain why but it keeps doing

that for me even though I've deleted it

from my computer completely U but it

just remembers it somewhere in its

memory now the next thing we need is to

check requirements now I just have this

one it says I need to download this uh

Visual Studio I'm not going to do that

but on your screen you may have multiple

multiple requirements typically you're

looking at something like this Microsoft

Visual C++ redistributable package what

you need to do is download this all you

have to do is Click download once you

download and install that on your

computer and then we go back all of

those should be gone that's the one that

I see the most when I'm actually working

with these requirements I had to install

it myself when I got this new laptop so

go ahead and install that if you need to

but if yours looks like mine we don't

need this visual studio for what we're

going to do so we're going to go ahead

and select next it is giving us a prompt

that we haven't satisfied all the

requirements but that's okay we're going

to go ahead and select yes as well now

we're ready to install all of these

things these are all things that myl

wants you to install the most important

are the server and the workbench but it

does not hurt to have all these other

things as well some of these connectors

are also important so we're going to go

ahead and

execute this will take just a few

minutes I'll skip ahead uh when they're

all done but this should take just a few

minutes and then we'll continue on

installing my SQL so everything just

completed and now we're going to select

next and now we need to actually

configure our product now really the

only one that we actually need to

configure is the server the router says

we need to configure it and the samples

and examples say we need to configure it

as well but really it's just the server

let's go ahead and select next

now we're not going to change anything

for this type and networking unless you

know what you're doing with the port the

X protocol Port uh we're not going to

change any of this we'll go ahead and

select next next thing we need to do is

Select an authentication method I'm

going to be using a password I'm not

going to be using the Legacy

authentication method so I'm just going

to go ahead and create a password now

for you and I keep getting this error

and I can't explain why right here for

you you should be creating a password at

the bottom it's remembering my password

somehow and I I really can't explain it

but I'm going to create my password or

check my password uh this is one that I

already created uh before I deleted it

off my computer but it's still there um

so it's saying my password is still good

but if you need to you should be

entering a password and then confirming

your password and saving it and then you

should also be checking it as well and

then we're going to configure this as a

MySQL server as a Windows service I'm

going to keep that checked uh and we're

going to start the MySQL server at

system startup I like that automatically

being there I don't want to mess with

that so I'm going to keep it as it has

it we're going to go ahead and select

next and the last thing we do is just

need to execute this and then everything

we put in there is going to actually go

so let's run this and execute it and

that's just finished so let's go ahead

and select finish now it says

configuration complete for the server

but we also need to configure these

other two let's take a look at these

really quickly we're not going to do

anything on this it even says we really

don't need to do this we just need to

click finish and configuration not

needed next we'll do samples and

examples and we can input our password

and all this is really going to do is

put in some sample databases for us in

our database which if you want you

definitely can do that uh I just

connected that worked I'm going to hit

next and execute and it's basically just

going to put in a database or two some

sample ones for you to look at and the

configuration is complete you don't have

to do that one but we'll see that in

just a second we're going to select next

and now the installation is completely

done and we can start my SQL workbench

after setup and start my SQL shell after

setup now I'm not going to do the shell

so I'm going to actually uncheck that

and we're going to select

finish now my SQL just popped up for us

and this is exactly what you should be

seeing now there's a lot of things in my

SQL to learn and know how to do we're

not going to be taking a look at all of

that stuff today but in future lessons

we'll walk through a lot of these

different things that kind of correlate

with different lessons or things that

we're working on in my SQL the first

thing that we're going to click on is

right over here this is our local

instance this is local to just our

machine it's not a connection to you

know some other database on the cloud or

anything like that it's just our local

instance we're going to go ahead and

click on this so this is what you should

be seeing right here this is where we're

going to actually write all of our SQL

code and I'll show you all this in just

a second but this is where we can

actually create our database and our

database is going to go right over here

on this left hand side this silicon one

is actually a sample database it has a

bunch of tables and Views St procedures

functions has all these things in in

here if you want to go ahead and mess

around with that what we're about to do

is create our own database that we're

going to be using throughout this entire

series both the beginner intermediate

and advanced we'll use a lot of this and

sometimes we'll import some other ones

for different use cases but this will

serve for most of what we're trying to

do throughout this entire series now

what I'm going to do is I'm going to go

ahead and I'm going to say open a SQL

script file in a new query Tab and right

here it opened up to a folder that I

already created this MySQL beginner

series folder within it we have this

right here the parks and rec create DB

now in order to get this you just have

to go to the GitHub and download this

file that's all you have to do we're

then going to open this file so let's

click on it we're going to say open and

what you're now seeing is basically the

query editor this is where you can write

your code now we're not importing a

database we're actually creating it by

running code now because this is the

first lesson in the beginner series I'm

going to assume that you don't know a

ton about my SQL really all this is

doing is creating the database name and

then we're inserting a few tables into

that database and then we're inserting

data into those tables so this is all of

our data that will go into these tables

that we create we only have one two

three different tables that we're going

to be using so all you have to do to run

this is click this lightning button

right up here we're going to go ahead

and execute this if we come down to the

bottom and we pull this up this is our

output this says six rows affected and

we have a bunch of other things like

create table create table insert insert

create table insert into these things

are all working perfectly so now if we

go ahead and click refresh in our

schemas with this refresh button right

here this Parks and Recreation table is

populated if we go under the tables we

see all of these things so now that

we've actually created our database and

our tables that's really all we were

trying to do in this lesson but I just

want to open up a table really quickly

show you what it looks like show you how

we can run code and then in the next

lesson we'll start actually learning how

to query this data so let's go up to

employee demographics we're going to

rightclick and select rows limit 1000

this is going to open up a new window

right up here and it's going to say

select everything from this database dot

this table employee demographics and it

ends with a semicolon now right down

here we have this output window this is

the actual data that sits in our table

we have columns right here so employee

ID first name last name age gender and

birth date and then here are all of our

employees on each row so these are all

separate rows we have Leslie nope Tom

haford and it goes on and on so this is

all of our data the most important

things to know when we're actually

working with this and I'm going to zoom

in is if we hover over this query right

here and we run it we can select this

execute which is this lightning bolt

with this I we're going to execute this

and it's going to run this because we're

highlighted over it now if we have two

queries let's say this one right here

but let's change it to employee uncore

salary so we'll do underscore salary

let's say we want to query this table so

now if we highlight over this and we go

up and select the lightning bolt with

the I now we're looking at a different

table but if we select even if we're

hovering over this if we select this

button we're going to execute everything

in this editor window so let's run this

and now you can see at the bottom we

have two outputs the employee

demographics and the employee salary so

this button is going to run everything

in this editor window whereas if we

select this lightning bolt with the ey

we're doing everything that's just under

where we have the cursor where we have

it highlighted the very last thing that

I want to mention is that right over

here you may have this up and you

probably don't want that we're not going

to do any SQL additions in the series

you can get rid of that by clicking this

button right here so starting in the

next lesson we'll have everything ready

to go and we will start learning the

basics of my sequel I hope you're able

to follow along get everything set up

how we have it on the screen I am super

excited about this series I just I love

SQL so I'm really really really excited

to get started on this with you guys I

will see you guys in the next

[Music]

lesson

[Music]