Coupon Code: GETWITH10
Mysql is a database for software development since 1995. Thus, there will be a lot of application are using it now and it is hard to be replace by other technology.
In this course, you will learn the basic things that you should know before you go for advance in Mysql. The basic that I will talk in this course include:
I will use a simple scenario to create the database and do the query. You can learn the basic from this and apply it into your application.
Will show you how to do the installation for the phpmyadmin that we need to use for mysql
Explain to you with the table structure and show you what are the column in each table and the datatype for each column. Other than that, I will show you the constraint that used for our scenario.
Will explain to you how to create database and the table.
Will show you how to do insertion and there is few ways to do it.
WIll show you how to select data and demonstrate few way to do it to achieve different purpose.
WIll show you how to update data and demonstrate few way to do it to achieve different purpose.
WIll show you how to delete data and demonstrate few way to do it to achieve different purpose.
WIll show you how to use Left Join and Right Join
Will show you how to use Inner Join
Thank you joining this course and finished it.
Hi everyone, my name is Dalvin from Malaysia. I am a Software Developer for around 2 years now.
In this time of period, experience of using .Net development, database development, laravel web development.
I like to learn new stuff and would love to share my knowledge with you and I hope my lecture can help you and solve your problems.