Beginners Class 30

What is SQL? SQL stands from Structured Query Language. It is used to communicate with several relational databases such as MySQL, Oracle and MS SQL Server. Using SQL queries, you can fetch, update, delete and manipulate data that is stored in the form of rows and columns. SQL became the de facto standard programming language for relational databases after they emerged in the late 1970s and early 1980s. It can also permit users to perform specific tasks on tables, procedures, and views. Wishing you the best of learning experience. For any question or assistance kindly contact me on: awesome8emmanuel@gmail.com

• Lecture1.1
  1.1 Course Introduction 05 min
• Lecture1.2
  1.2 MySQL Download and Installation 07 min
• Lecture1.3
  1.3 The Workbench Overview 10 min
• Lecture1.4
  1.4 The SELECT Statement 09 min
• Lecture1.5
  1.5 The Select Clause 11 min
• Lecture1.6
  1.6 The WHERE Clause 08 min
• Lecture1.7
  1.7 The ORDER BY Clause 07 min
• Lecture1.8
  1.8 The LIMIT Clause 04 min
• Lecture1.9
  1.9 The AND, OR and NOT Operator 07 min
• Lecture1.10
  1.10 The IN Operators 05 min
• Lecture1.11
  1.11 The BETWEEN Operator 03 min
• Lecture1.12
  1.12 The LIKE Operator 13 min
• Lecture1.13
  1.13 The REGEXP Operator 15 min
• Lecture1.14
  1.14 The NULL Operator 05 min
• Lecture1.15
  1.15 Inner Join 15 min
• Lecture1.16
  1.16 Joining Across Database 07 min
• Lecture1.17
  1.17 Self Join 07 min
• Lecture1.18
  1.18 Joining Multiple Tables 15 min
• Lecture1.19
  1.19 Outer joins 10 min
• Lecture1.20
  1.20 Outer Joins Between Multiple Tables 11 min
• Lecture1.21
  1.21 Self Outer Join 03 min
• Lecture1.22
  1.22 The USING Clause 10 min
• Lecture1.23
  1.23 Natural and Cross Joins 08 min
• Lecture1.24
  1.24 Unions 14 min
• Lecture1.25
  1.25 Inserting a Single Row(Column Attributes) 17 min
• Lecture1.26
  1.26 Inserting a Multiple Rows 07 min
• Lecture1.27
  1.27 Create a Copy of a Table 09 min
• Lecture1.28
  1.28 Updating a Single Row 08 min
• Lecture1.29
  1.29 Updating a Multiple Rows 06 min
• Lecture1.30
  1.30 Exporting Query Output 12 min

Advance Class 16

• Lecture2.1
  2.31 Creating a Database and Table 16 min
• Lecture2.2
  2.32 Importing Excel file to MySQL Database 11 min
• Lecture2.3
  2.33 SubQueries in MySQL 08 min
• Lecture2.4
  2.34 SubQuery across tables 07 min
• Lecture2.5
  2.35 VIEWS in MySQL Part 1 12 min
• Lecture2.6
  2.36 VIEWS in MySQL Part 2 12 min
• Lecture2.7
  2.37 Stored Procedure 1 07 min
• Lecture2.8
  2.38 Stored Procedure 2 06 min
• Lecture2.9
  2.39 Stored Procedure 3 08 min
• Lecture2.10
  2.40 Trigger in MySQL 10 min
• Lecture2.11
  2.41 Introduction to Function in MySQL 07 min
• Lecture2.12
  2.42 String Functions in MySQL 14 min
• Lecture2.13
  2.43 The Number Function in MySQL 06 min
• Lecture2.14
  2.44 The Date Functions in MySQL 10 min
• Lecture2.15
  2.45 Aggregate Function in MySQL 05 min
• Lecture2.16
  Course Review and Further Learning 04 min