Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MySQL for Beginners
429 students

MySQL for Beginners

MySQL and SQL databases. Learn how to install - Never used MySQL before? Start here!
Created bySurjeet Singh
Last updated 9/2012
English

Course content

1 section • 11 lectures • 29m total length

  • What is a database?1:29
    A database is a structured collection of data. Here are some typical examples of databases: An online store database  that stores products, customer details and orders A database for a web forum  that stores members, forums, topics and posts A database for a blog system , such as WordPress, that sto…
  • Why use a database?1:56
    If you haven't used a database for your website before, you may have stored data in text files such as comma-separated value (CSV) files. Here's an example of a CSV file: username,password,emailAddress,firstName,lastName "johnsmith","brickwall53","john@example.com","John","Smith" "maryjones","garden…
  • Why use MySQL?2:05
    You now know why databases are useful, and how they can help you build complex websites and web apps. But why use MySQL in particular? There are many great DBMSs out there, including  MySQL ,  PostgreSQL ,  SQLite ,  Oracle , and  SQL Server , and all of them can be used for most web development pur…
  • Installing MySQL4:06
    As I mentioned above, most web hosting accounts come with MySQL pre-installed. However, if you're developing websites using MySQL, you also want to have the MySQL server running on your own computer, so that you can create and test your databases and code without needing to upload files to your live…
  • Issuing commands to MySQL4:06
    Assuming you've now installed and started your MySQL server using one of the above techniques, how do you interact with the server? When you installed the MySQL server, you also installed  mysql , the MySQL Monitor. This is a command-line client program that you can use to connect to the server and…
  • Creating a database0:38
    Let's create a simple database for an imaginary book store. At your  mysql>  prompt, type the following and press Enter: create database bookstore; If all goes well, you'll see something like this: Query OK, 1 row affected (0.05 sec) MySQL has now created your database. You can check this by typing …
  • Some SQL basics0:39
    All of the commands you've issued so far —  select now() ,  show databases , and create database bookstore  — are SQL statements. SQL, or Structured Query Language, is the language you use to communicate with most DBMSs, including MySQL. Using SQL, you can create and delete databases and tables; ins…
  • Creating a simple table8:14
    As with all relational databases, MySQL organizes its data in tables. A table holds one or more records of related data, in a similar way to an associative array in JavaScript or PHP. A table consists of: One or more fields.  Each field holds a specific type of information. For example, in a  books…
  • Adding records1:44
    You've now created a database called  bookstore , and added a  books  table to it. Let's try adding a record to the  books  table. To add a record to a table, you use the SQL  INSERT  statement, passing in the record's field names and values. Type the following line in the MySQL Monitor to insert a…
  • Retrieving records3:04
    Now that we've added some records to the table, how can we retrieve them? This is where SQL queries come in. The SQL  SELECT  statement lets you retrieve one or more records from a table — or even multiple tables at once — based on criteria that you supply. The basic syntax is: SELECT fieldNames FRO…
  • Summary1:45
    MySQL in particular. You've covered the following topics: The concept of a database , which lets you easily store large amounts of structured data for your websites and web apps. Why databases are a good idea  compared to, say, flat text files of data. Some reasons to choose MySQL  for your DBMS. Ho…

Description

A database is an essential part of most websites and blogs, but setting up and using a database can be a daunting task for the beginner web developer.

In this tutorial you'll learn — in simple terms — how to install, set up, and use a MySQL database on your computer. This will give you a good grounding in MySQL that you'll find useful when you start developing database-driven websites using PHP, Ruby, or your language of choice.

You'll explore the following areas in this tutorial:

  • The concept of a database, and why databases are useful
  • The advantages of using MySQL to manage your databases
  • How to install MySQL on your computer
  • Using the MySQL Monitor program to send commands to your MySQL server
  • How to create a database and table
  • SQL (Structured Query Language), and what it's used for
  • Adding records to a table, and retrieving records from a table

Ready to start exploring MySQL? Let's go!

Report abuse