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.
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!
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!
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.
Want a high-definition tutorial for effective learning environment? Check this out!
This chapter will introduce Databases by description, management, creation and its purpose in maintaining and accessing information.
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.
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.
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.
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].
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:
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.
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.
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.
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.
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.
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.
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.
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?
This chapter flashes lists of Music Legends in text file.
It contains the following:
1. Artist’s names [ FIRST NAME and LAST NAME ]
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!
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!
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]
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:
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!
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.
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:
Its like an action recorded and apply scripting automatically.
Everything is AWESOME.
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.
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.
See you after you are done with these exercises!!!
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.
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.
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.
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
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.
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.
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.
SECTION 2 of our tutorial ENDS here.
Excited for the next section.
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.
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.
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.
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.
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.
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.
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.
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.
How was it?[Lecture 40]
This is the answer of the previous challenge. You can try this one and discover it yourself.
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.
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.
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.
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.
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?
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.