Course content 05h 21m
Overview

61 Videos | Watch Time: 05h 21m

  • Course Introduction 02:53
  • Database Definition 08:06
  • Difference between MySQL & SQL 04:06
  • Database Models - Relational Model 10:06
  • MySQL Installation 11:19
  • MySQL Installation for Linux 02:15
  • MySQL Workflow 03:46
  • Creating Database 06:02
  • Data Definition Language 03:16
  • Data Type 16:14
  • Primary Key & Foreign Key 08:00
  • Adding and Removing Columns 11:01
  • Deleting Table 02:35
  • Truncating Table 07:17
  • Creating and Texting Database 05:59
  • Adding and Removing Primary Key 08:04
  • Composite Primary Key 08:04
  • Removing Composite Primary Key 02:35
  • Adding and Removing Foreign Key 12:51
  • Adding Constrain 04:00
  • Change Table Name 02:29
  • Change Column Name 04:28
  • Change Column Data Type 03:14
  • Insert Data into Table 08:15
  • Update Data within Table 05:59
  • Deleting Data from Table 04:15
  • Select Statement 03:50
  • Where Class 04:18
  • Null, In, Not In 05:53
  • Between 03:22
  • Like 06:20
  • Order By 04:28
  • Distinct 04:56
  • Limit 04:12
  • Alias 03:35
  • Join 06:18
  • Inner Join 05:13
  • Left Join 06:08
  • Right Join 10:35
  • Join Multi Tables 06:37
  • Normalization 02:17
  • First Normal Form 08:28
  • Second Normal Form 08:41
  • Third Normal Form 04:55
  • Relationship 01:37
  • Relationship One to One 02:27
  • Relationship One to Many 02:10
  • Relationship Many to Many 04:30
  • Constraint 02:02
  • Aggregate Function 02:04
  • Min, Max 03:30
  • Average 01:42
  • Count 01:57
  • Sum 02:13
  • Group By 03:24
  • Having 05:36
  • Subqueries 05:53
  • MySQL Functions 02:10
  • Concatenation 03:44
  • Upper, Lower 02:35
  • Date Function 07:09
0 Notes
Start a free trial to continue learning Start your free trial to get access to hundreds of more courses and articles on Ulearna
This course is completed You can get now your certificate of completion

Learn SQL: Learn SQL using MySQL and Database Design

Shirzai Hanifi. Web Developer

Learn SQL: Learn SQL using MySQL and Database Design

Shirzai Hanifi .Web Developer
No Discussions
Discussions have not yet been initiated on this course, but you should start one

Login to start discussion

Cookies

We use cookies to ensure you get the best experience on Ulearna.You can check our cookies policy here.