MySQL Database MasterClass: Go From Pupil To Master!

This is a MySQL MasterClass that gets you immediate hands on experience with a database. From design to Master Class!
4.4 (84 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
5,258 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 46
  • Length 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

  • 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!

What are the requirements?

  • You don't need to know anything before taking this course

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: What Is A Database
9 pages

These are the slides for section 1. It's great to download these early so you can use them to go along with the course

Article

Here you will find the entire schema to the MySQL db. Its good to download for a refresher or to give yourself a helping hand when you need it.

03:42

Let's talk about what a database is. We will go into some detail about what a database is and how to use one.

03:09

Tables are the building blocks of databases. This is where we store our data.

6 questions

section 1 quiz

Section 2: Designing Your First Database
16 pages

Here are all the slides for this section so you can follow along while we design and build our database.

04:30

In here i take you on a quick tour of php My admin so that you can understand the IDE.

16:50

In this chapter of our tutorial, we will figure out how to create a table for UDEMY’s customers. We will identify the necessary data associated with the table such as the identity of the column, email addresses, password, addresses and name.

This time, we will encode all the needed data for customer’s details to the table. We will show you the environment inside the MySQL Database.

So sit back and watch for more exciting tutorials.

17:07

In this MySQL video tutorial, we will create a new table for video. Then we will identify what makes up a class and check out any associated relationships to each elements. In addition, we will also have personType and be able to insert data base on personType.

See how far you go in this tutorial. Try out the quiz after this lecture.

6 questions

Section 2 quiz

Section 3: Keys Both Primary and Foreign
8 pages

Hey guys!

As you hit play button, we provided you with an automated play slides for your notes.

This is a brief introduction to primary and foreign keys. We identify the importance of each for our tables. We provided you with a sneak-peak of our goal in linking table people to table classes, video classes and how does it work.
Excited? See the next video.

16:38

To supplement further, we will identify foreign keys and primary keys and its purpose to our table.

As we discussed, foreign keys used to link two tables together. On the other hand, primary keys are ID’s field on a table that makes a table unique and must not contain any NULL values. In MySQL, it supports foreign keys that allows us to do cross-referencing across table and its constraints help keep in consistent spreading of data in our tables.

This video will show you how to create table for StudentClass, VideoClass table and insert all data need in phpMySQL that includes 3 fields [ID, personID and classID]. Then be able to use foreign keys on it and be able to use relations for each table.

6 questions

Section 3 quiz

Section 4: The Select Statment in MySQL
9 pages

Welcome to Section 4: The Select Statement.

Hit play button in an auto play of slides in our next lesson. This slide will show you the actual SQL, the Select Statement syntax and how does it works in our database.

08:33

The SELECT Statement, helps you retrieve your data records from one or more SQL tables. Select data from the database which includes the results stored in a table.

To use the SELECT Statement, we need to declare the command statement, then what do we want to select [* - Select all fields], also it could be a specific table, FROM and WHERE to retrieve the data. Technically, it filters data from our database.

SELECT * FROM table_name;
We provided you with samples in order for you to understand the processes in using a SELECT Statement and run it.


Go check it out!


00:47

Lets see where are we right now in this tutorial.

We will have an exercise that will further enrich our skills in writing a SELECT Statement.
Try it and you'll enjoy the challenge!
The next video will show you the answer, lets compare it you're done. See yah!
05:38

Hey! Check this out.

The previous video provided you with 4 writing activities using a SELECT statement. So let’s compare our work if we’re on the same page.
To write a SELECT Statement to the following:

  1. Finding all classes under Sally’s teaching
  2. Finding all classes under Steve’s teaching
  3. Retrieving email addresses for each person
  4. Writing same SELECT statement, but aliases, email address as the Username.
19:14

Guess what? This 19-minute video will perform a step by step process with different scenarios and show you with necessary points to consider while using a SELECT Statement.

There are many things we can do inside a SELECT Statement. We listed down all the possible things you can start with this statement. In line with this, we will show you the basics in retrieving data. What is nice about SELECT Statement it can perform mathematical operations seemingly, isn't it amazing?

So many things unlocked!

Article

Hi there!

We provided you with useful queries that you can try on from this section.

Try it and see the results.

9 questions

Section 4 quiz

Section 5: The Order By and A Deep Dive Into The Where Clause
6 pages

Press the play button for an auto play of slide shows for our next tutorial.

This slide covers a sneak-peak of our upcoming lessons.
ORDER BY and WHERE clauses of Section 5 of our tutorial.

05:02

This section of MySQL tutorial, we will discuss the concept of ORDER BY clause.

ORDER BY, retrieves data by ascending or descending manner. ORDER clause by default filters data in ascending means. If you want the other way around you need to declare the DESC [descending] after column names.

Better start managing your data!
21:20

We’re back and let us start with WHERE clauses. WHERE clause uses to filter data in a manner that it only retrieves those records that is specified in the statement. WHERE can be on any fields that we can call if needed.

This video will provide you useful examples that you can try. This 21-minute long advance tutorial, can show you possible scenarios and on how to deal with massive sets of data.

To use this clause statement, we need to understand its anatomy.
SELECT col_name, col_name
FROM
table_name
WHERE
col_name operator value;

FYI: Operators [Operator value] can be equal, not equal, greater than or lesser than, between and more to mention.

Hope you learn something today!
Hit replay button to experience awesomeness again!

09:45

Let’s proceed with the next clause the GROUP BY. It can be used in a SELECT statement to gather all data across multiple or group of records by one or more columns.

GROUP BY, takes analytics to another level of challenge for our database.

We will be using Student class as our example in this tutorial.

Ready? Hit play button.

Article

Lecture 21:

Hey guys! We provided you with different WHERE clause OPERATORS to try with. At the same time, you can also check the following OPERATORS listed below.

= Equal

<> Not equal. for some SQL it is !=

> Greater than

< Less than

>= Greater than or equal

<= Less than or equal

BETWEEN Between

LIKE Search for a pattern or filter keywords or values and etc.

IN To specify multiple possible values for a column

Try this, I know you can. See you on the next tutorial.

8 questions

Section 5 quiz

Section 6: Analytics With the Group By Feature
5 pages

Hit the play button for auto slides.

We will discuss the following for the next Section:

  • Analytics 101
  • SQL statements for GROUP BY and Analytics.

Are you excited to start? Play the button!

07:42

This is analytics 101 and we will start to analyze data.

Let’s start with aggregate functions such as AVG, MIN, MAX, COUNT and SUM that we can use in the data analytics. We provided you with samples at phpMyAdmin under the class table for further understanding. This is how we should alias AVERAGE data and check out SUM, COUNT, MIN and MAX ID from our query.


Article

Here it is!

Go on grab this example and try this out.
What a good challenge can wait to set up with you guys.

3 questions

Group by

Section 7: Sub Queries
5 pages

Welcome to Section 7 of our tutorial. This is a course slides for Sub-Queries.

To start with,

  • What is a sub- query?
  • Why use a sub- query?
10:33

We will learn about sub- query today because we have an independent data from another table.

A subquery may follow in the following:

- SELECT clause

- FROM clause

- WHERE clause

Now, let us use a sub-query, we need to understand the following guidelines to consider when using subqueries. Subqueries cannot manipulate their results internally, so ORDER BY clause cannot be added in to a subquery. At the same time, subquery can be treated as an inner query, another query called as outer query placed as part of another query.

Article

Sub-query is fun! Get a dose of it by testing these statements.

5 questions

Sub Queries.

Section 8: Joins In MySQL
4 pages

This is the start of Joins in MySQL.

Inner joins, its purpose is to select rows from both tables as long as it matches between columns in both tables.

SELECT col_name(s) //declare column name

FROM table_1 //locate the table

INNER JOIN table_2 //apply INNER join

ON table_1.col_name = table_2.col_name; //processing INNER oins for results.

08:20

Okay, now let us use class table to check out the inner joins. We provided you with a demonstration which you can see the processes wherein ths statement returns the data queries. Use the inner joins that this tutorial provided you.

Article

This tutorial provided you with lists of INNER joins that you can use in order to perform the exercise.

10:42

Left Outer Joins, technically returns all rows from the left that matches the rows from the other data table. If the data from the right side doesn’t match, it means it is NULL by value.

Let us go and fill up these placeholders for us to perform the left outer joins. The advantage of using LEFT outer joins, is that it ables to retrieve all data from the rows. It sbles to match the data from the left table, even if there are no matchces in the othe table.

Article

Hey guys! We provided you with these useful statements that you can try out on this activity!

4 questions

MySQL Joins

Section 9: Installing MySQL Locally
Article

Section 9 of our MySQL online tutorial is all about installing MySQL locally. Copy and Paste this link to your address bar and it will lead you to download site. Follow instructions carefully and you'll have you MySQL ready.

05:33

Hey guys! Here it is! We will teach you how to download and install the MySQL.

Go to this link: http://dev.mysql.com/downloads/ and follow the rest of the instructions. Don’t forget to Windows update for a hassle free installation.

As we start to log-in to phpMyAdmin, we will export it and be able to select our database. We will configure our database and execute the process.

Then we’re good to go.

01:58

As you guys can see the SQL is running, we will connect to our server. We will import some data so that we have something to work with.

As a practice, we will use Udemy as our sample database.

Section 10: Creating Our First Views And Stored Procedures
05:57

This is the start of Section 10 of our tutorial: Creating our first views and stored procedures.

Lecture 36 is all about creating our first view and at the same time, we provided you with samples for better understanding.

A view is defined as a statement in our queries. It can contain rows of a table and SELECT rows from a table. The purpose of using views is to modify and customize the view for each user has of the database.
Interested? Hit play button.

Article

See this text file as you practice in creating your first view. You should try this out. The view can provide us a backward compatible interface to match a table whose schema has changed. It allows us to summarize data from different tables that can generate reports from our queries. Best is, it allows the user to customize his/her table base on exactly on his/her condition and needs.

09:18

This video talks about stored procedures. What is nice about stored procedures is that it’s like snippets of prepared codes that you can recycle all over. It allows us to work faster than usual because it has list of statements that we can retrieve anytime.

As we go on, we provided you with samples that best explains stored procedures.
Enjoy!

Article

Take a look at these samples that provided just for you. You can start by trying this out. There are a lot of stored procedures available that you can practice with. It assists the user in completing a consistent implementation of logic across the application by improving database’s performance.


03:23

Discover another topic in this section. Some examples of USER DEFINED FUNCTIONS are the scalar and tabular functions which are an excellent tool for certain programming task.

Today, we will take you on a quick tour about Basic Scalar UDF.

In a Basic Scalar UDF, the UDF stands for User-Defined-Functions. This video will show you how to create scalar functions. It can help us solved confusions with an enhancement to the SQL database engine speed performance.

Section 10 quiz
1 question
Section 11: Inserts Updates and Deletes
06:57

This is the last section of our tutorial and it covers insert updates and learn deletes.

In this topic, we will learn about INSERT statements. What is good about it is that we can INSERT queries that we need during the development of our database.
Stay with us and you will learn how to INSERT statements by adding descriptions.

Challenge yourself now.

Article

Take a look at these code samples that you can try. Here, we can copy group or specific records from one table to another existing table. Further, it doesn’t need to be on the same table. This concept is helpful, especially if you want to do some sorting in managing your database.

05:13

Next is UPDATE Statements. It is used to update data queries in a table. This tutorial will help you modify a massive set of data using UPDATE Statement. But first things first, we need to use WHERE clause so that we will know which specific records that should be updated.

SYNTAX:

UPDATE table_name //Declare UPDATE statement with the table name that we want to update
SET col1=val1, col2=val2 and etc. //We will SET the data by declaring the columns with its equivalent value.
WHERE some_col = some_val; //declare WHERE clause to determine where you want to update in this case we have declared the column with its equivalent value.

Article

Check this out! Grab yourself a copy that you can use it in writing UPDATE statements. The UPDATE statement allows you to change your records in individual rows, set of rows or all of the rows. The SET clause identifies the columns to be updated. Finally, the WHERE clause determines what to modify.

Article

To try out the examples in this section, visit lecture 46 for it will further help you understand DELETE statement. These samples will help you manage your database by sorting out and omitting unnecessary data records from your table. Take an extra precaution, especially in deleting queries on your tables. Understand that the WHERE clause is very important to include in the DELETE statements else you’ll loose all your records.


07:21

Managing queries on our table is quite challenging, we need to be more cautious especially if we want to UPDATE or DELETE our data records. Take note that the WHERE clause is very important in dealing DELETE statement else we will loose all our records.

So you better think twice or 100 times to DELETE set of data records.
Hit play button so that you can experience it first hand on how we manage to DELETE queries without messing the database.

Section 11 quiz
9 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rico Rodriguez, SQL Architect, Senior Software Developer, Project Manager

I have spent my life teaching others how to be better developers and master the art that is Software Engineering.

I have designed many Enterprise level applications as well as IOS and Android Applications. The skills I teach in my courses is the same skills that I use every day to do everything from running my teams to consulting on Enterprise level projects.

In my career I have found classes like this to be helpful in advancing my career and I wanted to make courses for people that really showed you end to end classes that weren't as simple as "Hello World". My goal as an instructor is to drive you to the next level in your careers, and if you want to do that, it takes 3 things. Knowledge, Leadership, Ingenuity. These are the 3 skills that i have used to take my career to the next level.

I have also been a father for 9 years. Throughout those years I have learned so much about myself and raising children. I have been on both sides of the fence from raising step-children and now raising my own son. It has been the experience of a lifetime and I would love to share any of my experiences with you so that you don't have to go through all the same learning curves that I did.

Ready to start learning?
Take This Course