MySQL Database MasterClass: Go From Pupil To Master!
4.5 (97 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,300 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL Database MasterClass: Go From Pupil To Master! to your Wishlist.

Add to Wishlist

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.5 (97 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,300 students enrolled
Created by Rico Rodriguez
Last updated 9/2015
English
Current price: $10 Original price: $20 Discount: 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 13 Articles
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • You don't need to know anything before taking this 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!

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
46 Lectures
04:41:39
+
What Is A Database
4 Lectures 06:52

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

Preview 9 pages

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.

Full SQL DB Schema Is Avaialbe On This Link
00:01

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

Preview 03:42

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

Preview 03:09

section 1 quiz

section 1 quiz
6 questions
+
Designing Your First Database
4 Lectures 38:27

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

Course Slides and Material For Designing Your Database
16 pages

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

Preview 04:30

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.

Designing Your First MySQL Database Creating Our First Table
16:50

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.

Getting Into More Detail About Tables
17:07

Section 2 quiz

Section 2 quiz
6 questions
+
Keys Both Primary and Foreign
2 Lectures 16:38

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.

Course Slides and Material For Primary and Foreign Keys
8 pages

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.

Keys Both Primary and Foreign in MySQL
16:38

Section 3 quiz

Section 3 quiz
6 questions
+
The Select Statment in MySQL
6 Lectures 34:27

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.

Course Slides and Material For The Select Statement in MySQL
9 pages

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!


The Anatomy of the Select
08:33

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!
Excercise on Select Statement
00:47

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.
Answers to the Excercise
05:38

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!

More Great Examples Of Select Concat and Addition etc..
19:14

Hi there!

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

Try it and see the results.

Useful Queries from this section
00:15

Section 4 quiz

Section 4 quiz
9 questions
+
The Order By and A Deep Dive Into The Where Clause
5 Lectures 36:31

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.

Course Slides and Material For Order By And Where Clause Lectures
6 pages

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!
The Order By Clause Almost As Cool As Santa
05:02

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!

Deep Dive Into The Where Clause
21:20

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.

Group By The Power in Grouping Your Analytics
09:45

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.

Useful SQL Statements for this section
00:24

Section 5 quiz

Section 5 quiz
8 questions
+
Analytics With the Group By Feature
3 Lectures 08:01

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!

Course Slides and Material For Analytics And The Group By Feature
5 pages

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.


Analytics 101
07:42

Here it is!

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

Useful Sql Statments For Group By and Analytics
00:19

Group by

Section 6 Quiz
3 questions
+
Sub Queries
3 Lectures 10:47

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?
Course Slides and Material For Sub-Queries
5 pages

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.

Sub-queries
10:33

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

Useful Subquery Sql Statements
00:14

Sub Queries.

Section 7 Quiz
5 questions
+
Joins In MySQL
5 Lectures 19:41

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.

Course Slides and Material For Joins
4 pages

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.

Inner Joins
08:20

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

Useful Inner Join SQL Statements
00:08

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.

Left Outer Joins
10:42

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

Useful Left Outer Join SQL Statements
00:30

MySQL Joins

Section 8 Quiz
4 questions
+
Installing MySQL Locally
3 Lectures 07:37

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.

Link to MySQL
00:06

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.

Installing MySQL Locally And Exporting Your Database From PHP My Admin
05:33

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.

Importing Our Exported Data
01:58
+
Creating Our First Views And Stored Procedures
5 Lectures 19:08

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.

Creating Our First View
05:57

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.

Code: Creating Our First View
00:06

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!

Creating Our First Stored Procedures
09:18

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.


Code: Creating Our First Stored Procedures
00:24

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.

Basic Scalar UDF
03:23

Section 10 quiz
1 question
1 More Section
About the Instructor
Rico Rodriguez
4.1 Average rating
545 Reviews
22,181 Students
8 Courses
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.