Mysql basic tutorial need to know for Beginners
4.5 (9 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.
289 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mysql basic tutorial need to know for Beginners to your Wishlist.

Add to Wishlist

Mysql basic tutorial need to know for Beginners

Introduce the Mysql query for beginners to use. Example like Insert, Select, Update, Delete, and Join Table.
4.5 (9 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.
289 students enrolled
Created by Dalvin Teng
Last updated 12/2016
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • The basic concept of define relationship between table
  • Suitable Datatype to use in Table
  • Mysql's insert, update, and delete
View Curriculum
Requirements
  • Programming Basic Concept
  • Venn Diagram Knowledge
Description

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:

  • Relationship for tables
  • Datatype
  • Constraint
  • Create database and table
  • Basic query like Insert, Select, Update, Delete
  • Join table concept

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.

Who is the target audience?
  • Student that want to learn Mysql Query
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:14:56
+
Introduction Of This Course
3 Lectures 14:30

Will show you how to do the installation for the phpmyadmin that we need to use for mysql

Preview 02:10

WIll explain our scenario for the table relationship. Other than that, I will explain the datatype and when to use it. Lastly, I will explain what are the contraint.

Preview 10:33
+
Create Database & Table
2 Lectures 14:00

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.

Table Structure
03:43

Will explain to you how to create database and the table.

Create Database & Tables
10:17
+
Mysql Basic Query
4 Lectures 30:31

Will show you how to do insertion and there is few ways to do it.

Insert Data
08:52

WIll show you how to select data and demonstrate few way to do it to achieve different purpose.

Select Data
09:09

WIll show you how to update data and demonstrate few way to do it to achieve different purpose.

Update Data
06:48

WIll show you how to delete data and demonstrate few way to do it to achieve different purpose.

Delete Data
05:42
+
Mysql Join Query
2 Lectures 14:53

WIll show you how to use Left Join and Right Join

Left Join & Right Join
06:54

Will show you how to use Inner Join

Inner Join
07:59
+
Conclude
1 Lecture 01:02

Thank you joining this course and finished it.

Thank You
01:02
About the Instructor
Dalvin Teng
4.3 Average rating
23 Reviews
381 Students
2 Courses
Software Developer

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.