WAMP + MySql = Awesome
4.3 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,683 students enrolled

WAMP + MySql = Awesome

I teach you how to install WAMP and MySQL and I show you how to use these 2 tools together to create a Really cool DB.
4.3 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,683 students enrolled
Created by Rico Rodriguez
Last updated 11/2015
English [Auto]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 7 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Design a Complex Database For Any Line Of Business Application
  • Be Able To Write Complex SQL Statements
  • Be able to manipulate a massive amount of data in milliseconds.
  • Understand what a Relational Database Is
  • Understand Primary and Foreign Keys
Course content
Expand all 46 lectures 02:52:12
+ Let's Discuss The Project We Will Do Throughout this class
18 lectures 44:46

Welcome to WAMP + MYSQL = AWESOME online tutorial.
This class will help you set up WAMP and learn on a local instance of MySQL that will keep you learning in a local environment.

It’s a smart world out there so gear up and let’s learn together!

Preview 00:44

Hey Guys!

WAMP + MYSQL = AWSOME is your one-stop e-learning support for SQL [Structured Query Language] basics for both developer and non-developer enthusiast like you.

The tutorial will narrow down the list of essential details about the SQL commands such as SELECT, UPDATE, DELETE, INSERT INTO, CREATE DATABASE to name a few.

It will provide you with a step by step learning modules from installing WAMP [Windows] and MAMP [Macintosh] down to SQL syntax, statements and functions. This tutorial will help you in creating effective databases suited to your lifestyle and business management demands with ease.

So stay tuned in.

Preview 00:41

Want a high-definition tutorial for effective learning environment? Check this out!

Preview 00:11

This chapter will introduce Databases by description, management, creation and its purpose in maintaining and accessing information.

Preview 01:35

As you hit the play button, this video will summarize the overview of the course outline provided by WAMP + MYSQL = AWESOME tutorial.

Courses that are arranged and designed just for YOU.

Preview 00:47

A quick talk about common database applications that you yourself can experience on a daily basis.
This video will serve as your head start in selecting significant elements to manage and organize your databases.

Preview 02:48

In this video, we will describe our project. It is where you can find instructions for setting up a new database in order for you to host the Music Festival.

This teaching technique will challenge e-learner’s potential to provide a report of descriptive information on a database for a project to come up with a simple database concept.

The first case study is up!

Let's go on.

Preview 01:46

This chapter will help the students differentiate relevant from irrelevant keys of information needed for the case study provided by the previous video [lecture 7].

Preview 01:42

We will learn the basics first and understand different tools in database creation before designing a table. This is a summary of discussions about the following:

  • VIEW
  • Sub levels of FIELD

In addition, it covers the anatomy of tables such as identity columns, foreign key columns and data columns.

Shortly after this video, we will learn how to design a table.

Tools In Our Database Toolbox

In order to enumerate the different data needed in the case study [Lecture 7], we need to identify the required information of the band and vendors from the Music Festival to create a database table.

*Database keys hold vital parts in relational databases and for table structure.

This will help you narrow down important keys such as identifying name, home state, number of band members, genre, contact details, lot sizes, incomes and who to contact and Etc. These are only a few of some requirements for the database development.

The keys will be assigned and categorized under different data types VARCHAR, STRING, DECIMAL and INTEGERS.

Next stop is for FOREIGN KEYS.

Initial Discussion About Tables

In designing databases, you need foreign keys to make the links on table possible. We often call this cross referencing. Its a relationships between PARENT and CHILD tables and its ability to CREATE and ALTER tables to spread out the data.

Foreign Keys

This chapter will assist you in downloading WAMP SERVER.

WAMP stands for [Windows, Apache, MySQL, Php] it is a Windows Server that functions as a platform in web development environment to easily manage your databases.

Just click the video and see steps as quick as 1-2-3 and you’ll be there in no time.

Download WAMP

This simple video tour will help you familiarize with PHPMyAdmin environment. PhpMyAdmin is a free software tool written in PHP. Frequently, manages Databases, SQL panes to run queries, status, export and imports and etc.

PHP is originally spelled out as Personal Home Page. Known for its versatility and usefulness in web development.

Stay tuned and see you in the next tutorial.

Simple Tour Of PHP My Admin

In line with the previous video tour in PHPMyAdmin environment, we will now proceed to our Mysql WAMP server and get started.

We will teach you how to generate your first database and be able to select effective collation [utf8_general_ci] to meet the case study requirements.

Your first table will hold all eight fields of data that was identified in the case study [Music Festival]. Make a quick visit to Lecture 7 and Lecture 10.These data are assigned to different placeholders to set the data’s NAME, TYPE, VALUES, INDEX and Etc for your database structure.

Creating Our Database and First Table

In this part of our PhpMyAdmin tutorial, we will briefly discuss the functionality of each tool. The left panel of PhpMyAdmin environment is actually a preview list of databases. Opting for one database link will help you manage your data. After selecting a database, the STRUCTURE window pops out and display tables. This action allows to create more tables and set the number of columns. Technically, it is presented in a form of a placeholder that requires field’s name, data type, attributes, collations, indexes and etc.

In SQL window, SQL scripting statements and queries were written. SEARCH window is provided for you to search any databases to generate search query for your chosen table. Building QUERY and INSERTING clause is needed for data records on your table, IMPORT and EXPORT of data, OPERATIONS window helps you in renaming a table, copying a table even changing table values.

Walk Through of PHP My Admin From a Database Standpoint

Under this section of WAMP + SQL = AWESOME PhpMyAdmin tutorial, we will discuss easy to follow instructions in creating vendor, customer and band tables in our database [BILLFEST].

This chapter assumes that you will be retrieving all the data from the case study and transfer it to phpMyAdmin by filling up the placeholders at the same time setting your database structure [NAME, TYPE, COLLATION and etc].

At the end of this video we will have our database and tables about our actual festival.

Getting more exciting, right?

Creating Our Vendor and Customer Tables

This chapter flashes lists of Music Legends in text file.
It contains the following:
1. Artist’s names [ FIRST NAME and LAST NAME ]
2. Locations
3. Number of Band Members
Download the file or simply highlight the text, then copy the selected text from this screen and paste it to a notepad, so grab your copy now!

Don't miss our next tutorial!

Band List

In the following part of our PhpMyAdmin tutorial we will start to fill up our database table with our festival data. This music festival scenario will help us identify the things we need the most, the things we miss and demands that we need to meet.

Technically, we will learn to insert data to our database [BILLFEST] by using the text data from LECTURE 17.transferring data may take time but in the process we are mastering the table fields [tbband].

So hit the play button and ROCK ON!

Filing Out Our Data
+ Basic SQL Lets Discuss The Select Statment
14 lectures 01:23:13

The previous lesson taught us to fill up the band data into our table for bands [tbband] under database [BILLFEST]. Now, we are about to add the vendor lists data that includes ART, FOOD and JEWELRY. But first things first we need to grab this text data by downloading it or simply copy it from this screen and paste it to any text editor.

This is now under SECTION 2 Of our tutorial and will cover Basic SQL [discussion on SELECT statement]

Vendor List

Same goes to this chapter, see LECTURE 18 about filling up data on tables but this time select the table for vendor [tbvendor] under BILLFEST.

The data includes the following:

  • Vendor name
  • Lot sizes
  • Type [ART, FOOD and JEWELRY]
  • Contact Number
  • Contact Name
  • Contact email

This may take up some time but learning is a process.
Got some error though, can you see your self out? Don’t forget to SAVE and go back to STRUCTURE to check out some errors. [NULL allow on total sales, since we miss it at first]

If done hit “GO” button and you are DONE!

Fill Out Our Vendors

Under this section of the PhpMyAdmin Tutorial we will demonstrate INSERT INTO to the table for customers [tbcustomers].

Here you can find instructions as you go to SQL window in PhpMyAdmin. There are six important buttons [SELECT*, SELECT, INSERT, UPDATE, DELETE and CLEAR] that is needed for basic SQL scripting. It will run SQL queries for database BILLFEST.

SNEAK-PEAK : The advantages of using scripting in inserting bunchful data without encoding it manually.Curious?

See Lecture 22.

Insert 1 Record By Script

A sneak peak was introduced prior to this video about inserting massive data for customer’s table in BILLFEST database. Moreover, the use of online free name generator as an example to demonstrate how effective SQL scripting is.

WAMP + SQL = AWESOME tutorial will assist you the step by step processes to manage enormous data, the creation of macro technique in the scripting to eliminate manual activities for data encoding.

To create a macro technique:

  1. Place the cursor at the beginning of the first row.
  2. Hit START RECORDING button
  3. Select the value for lastname in the first row.
  4. Remove the lastname and the comma
  5. Press END key to move to the end of the line if you are dealing with hundreds of data else make sure to go to the end of the line.
  6. Add comma
  7. To paste the lastname after the firstname.
  8. Make sure to return to the start of the line or press HOME key
  9. Move to the next line then hit STOP RECORDING.
  10. Press PLAY button then use your arrow keys to apply the MACRO that you just recorded.

Its like an action recorded and apply scripting automatically.

Everything is AWESOME.

Massive Customer Import

See Lecture 22 for your 10 step guide in creating macro in SQL scripting.

Another massive data to import, so open up your notepad and copy these files as we proceed to the next video tutorial in working with examples on “SELECT" statement.

Massive Import Script

This lesson will focus on SQL “SELECT” statement. SELECT statement is used to retrieve data from a database table in the form of result table. By using our project, we will be able to understand SELECT statement in action.

The tutorial will help you identify the difference between SELECT* and SELECT. The purpose of “*” is to indicate that you want to display all the fields while SELECT statement will select columns whose values you want to call.

The structure of this statement requires parameters or arguments. The command statement, the kind of data we are selecting, where to retrieve the data and conditions that it requires for the record to be sort out.

See you after you are done with these exercises!!!

Working Examples Of A Select Statement

Welcome back!
Considering that you are done with the previous exercises [Lecture 24], we wil now proceed to this video.
In this chapter of our tutorial, we’ll do few exercises to check out how far are we now in terms of learning this topic.

We provided you with to do list.
1. Write the SELECT statement that will find all the FOOD VENDORS
2. Write the SELECT statement that will find all the ROCK BANDS with nore that 4 members
3. Write the SELECT statement that retrieves only the EMAIL ADDRESS of each bands.
4. Write the SELECT statement that but alias EMAIL ADDRESS as EMAIL

Now do this challenge as your homework.

Answers to Our Excercises

This SQL tutorial explains how to use ORDER BY clause in band table for our festival. The statement ORDER BY clause is to sort our data from the database table either through in descending or ascending manner. You should consider that columns that are specified in the ORDER BY clause is of the columns selected in the SELECT column list.

In additional, aliases defined in the SELECT Statement can be used in an ORDER BY Clause. [Lecture 26, 4th task from the exercise]. Aliases gives temporary name to a database table or column table.

Let’s run down into details about the clause, considering by default ORDER BY Clause sort data in ascending order. In order to sort the data in descending order you must declare it obviously in writing DESC attribute to your data.

That sounds really interesting, right?

Now, hit the play button.

Order By Clause

This video will now focus on WHERE clause in SQL using our project’s lot sizes under vendor table. WHERE clause condition filters the results then apply SELECT, INSERT, UPDATE, or DELETE statement and return all data from the table.

See our next video.

Where Clause In Detail

In this tutorial, we will introduce SQL LIKE condition and how to use it in our case study[table for customers].
This statement is used in the WHERE clause of a SELECT, INSERT, UPDATE, or DELETE statement to search for a specified requirements or matching pattern. It will return all corresponding data based on the conditon that you set. The parameter of expression requires column or field; its pattern is matching to either % or _.


% [PERCENT SIGN WILD CARD] It allows you to match any string of any length even zero length and use it mutiple times in the same string.

_ [UNDERSCORE WILD CARD] It allows you to match on a single character

The Like Statement

This link is for you to follow instructions on how to perform the phpMyAdmin installation for your hosting account by bringing MySQL to the web.

It is an intuitive free software tool provided by phpMyAdmin constructed in PHP for web interfaces, support, data processes, administrations, creative and versatile.


The file is less than 10MB, 9.9MB to be exact and it will only take you less than 5 minutes to download it.

Gear up!


This WAMP + SQL = AWESOME video tutorial will discuss a series of processes about the scenario of exporting and importing data.

You can select export or import method base, saving procedures, format-specific options, create object options in order for you to download or upload data.

Hit replay button if you want to review again.

How To Export and Import Data

In this part of our lesson we will be able to identify the purpose of redesigning the database by learning how to manage small details on our project.

First, it is to fix mistakes from the initial database design at the same time it allows the database to adapt changes in system requirements. We need to understand the current structure of our database so that we can test it or update it for changes. Significantly, we can create backup for our data. We can also read a database diagram and deisgn a schema that produces data model. [reversed engineering]

SQL statements are helpful in database redesign because they are correlated subqueries with exists/ not exists expressions specialized form of correlated subqueries. Commands can alter table and drop column if necessary.

Hope this additional information is helpful to you.
See yeah!

Database Redesign
Remember our Lecture 11? You can visit that video for a recap.
We already created the following tables in our BILLFEST database.
  1. tbband
  2. tbcustomer
  3. tbgenre
  4. tbvendor
This video will now create another foreign key by adding another table and name it as tbvendortype.
it will include the three types art/photography, food distributor and jewelry.

Watch out for the new technique!

SECTION 2 of our tutorial ENDS here.

Excited for the next section.

Lets Do another Foreign Key
+ Creating Random Data
6 lectures 24:39

This chapter is the start of SECTION 3: Creating Random Data for our project.

Keep in mind that we will be using FOREIGN KEY [tbbandID] in order for us to link the table[tbband]. In line with this, review Lecture 11 if you miss something. We will be doing some example like adding new table for the band members and it is for you to construct it further.

Adding A Band Member Table

You guys go ahead and add the 3 remaining bands on your own. We provided you with this list for the exercise so that it will help you go through the experience the process in adding data to the different placeholders.

SQL Excercise : Add The Remaining 3 Band Members

This video assumes that you are done adding the remaining band data and assign each data to its allocated band ID. Go and hit the play button so that we can compare our answers.

Answer to Excercise

IN Statement is one of the coolest SQL statement in terms of saving time, it also allows you to specify for multiple values in a WHERE clause. The video will enumerate the structure of IN statement that will call data records from case study’s bandID.

This practice in SQL scripting will help you manage your data in no time.
The In Statement

This tutorial will discuss about MySQL had a RAND function [RAND ()] that can invoke to produce random numbers of floating-point value between the range of 0 to 1. This is to fill in numerical values to our case study at the same time update our records.

Keep watching!

Using The Rand Function To Make Random Data

This lesson will focus on the importance of handling our data for easy management. We need to know our data, analyze our data and make decisions for our data. By doing so, it will make us a better company.

This is the end of SECTION 3 tutorial.

Create Random Demographic Data
+ Sub-queries
1 lecture 07:27

SECTION 4 of our tutorial will focus on a SUB - QUERY.

As defined in MySQL, sub-query is a query within a query that can exist in WHERE clause, SELECT clause and FROM clause. This 7-minute long video will introduce the sub-query and how to use it. It will help us get data more quickly and use foreign keys without using the joint. To optimize our SQL statement tutorial, we will try subqueries in updating our data and fixing columns [how did you find us] field.

What is a Sub-query and how to use it
+ Analytics
6 lectures 08:02

Start of Section 5: Analytics

In this chapter, we need to figure out how to solve and update our project. In which case, the genre ID doesn't match the genre holder. So you are expected to at least figure it out on your own.

Then after this the video we will reveal the answer.

Try not to sneak.

SQL Exercise: Update Genre Based on GenreID and Use A Sub-query To Do It

How was it?[Lecture 40]

This is the answer of the previous challenge. You can try this one and discover it yourself.

Solution To The Sub-Query Excercise

The tutorial prepared a thorough explanation about the solution of the last do it yourself exercise. This video will expound the details of tbGenre.ID and GenreID as sub queries.

Explaination of the Excercise

In this tutorial, you will learn how to use the MySQL aggregate functions. The importance of learning these functions will help you perform some calculations on data values in order to retrieve data because not all data you need is in the table. We will discuss the basic analytics on your data, such as COUNT, MAX, MIN, SUM and AVG.

See our next video.

Basic Analytics Using Aggregate Functions

We provided you with a text file to start with MySQL Analytics on tickets bought from the customer’s table.

Go grab it now and lets have some fun today.

Answer To the Analytics Excercise

This two and a half minute video will explain our next activity using MySQL Analytics by getting the average ticket/s bought by every table for customers[tbcustomer].

We will be using aggregate functions such as to COUNT and to SUM analytics for us to know how much do we make on tickets. Getting the MAX and MIN functions that returns the set of values of tickets everybody bought for the said music event.

What a great day to see the festival’s summary report/s!

Any project in mind right now? In the meantime, lets proceed to our next tutorial.

Explanation of the Analytics Excercise
+ Analytics With A Group By
1 lecture 04:03

To supplement MySQL Analytics, GROUP BY will bring you to another level of SQL scripting. MySQL extend to use this fancy function because there are non-aggregated columns and they are good in retrieving group information. The GROUP BY clause is most likely to be found in SELECT statement. It is used to scan all the database tables and create temporary tables where this transitory table will discover other groups that are arranged sequentially for the application of aggregation.

Excited for the next Lecture?

Our First Group BY
  • You don't need to know anything before taking this course
  • Do you want to SKY ROCKET your Income?
  • Do you want to master the skill of SQL.
  • Do you have an Interview coming up where you know SQL would look amazing on your resume?

Low pay SQL developers make $60,000 per year. In this course you will learn the skills necessary to rock out SQL Statements, Views, Stored Procedures and more.

In this course you will Design a database from scratch so that you understand the thought process that goes into such a design. We will then bring in the basic skills of SQL and give you example upon example of how to use this skill while building on those basic skills adding in more technique and more difficulty until they become more advanced. You will learn skills that even you average DBA doesn't do properly.

  • SQL Statements
  • Views
  • Stored Procedures
  • Triggers
  • User Defined Functions
  • and a lot more!

When you are done with this course, you will be able to walk into a interview with a calm confidence and show them that you know what you are doing and apply these skills to build the database back end for an application that will stand the test of time.

If you want a better career take this course you will not be disappointed.

Enroll with confidence! Your enrollment is backed by Udemy's 30-day, no-questions-asked, money-back guarantee!

Who this course is for:
  • If you have ever wanted to understand databases you should take this course
  • If you want to know how to speed up Queries you should take this course.
  • If You have never Seen a Database You Should Take this course