SQL Tutorial: Learn SQL with MySQL Database - Beginners to Expert

Pradnyankur Nikam, Freelancer PHP & WordPress developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
127 Lessons (10h 47m)
    • 1. Course Introduction

      1:13
    • 2. What is SQL

      2:23
    • 3. Who should learn SQL

      2:17
    • 4. Download & Install MySQL 8.0.11 on Windows 10 Operating System

      16:33
    • 5. Download & Install MySQL 5.7.20 on MAC OS X Operating System

      12:32
    • 6. Download & Install MySQL 5.7.20 on Linux Ubuntu 16.04 Operating System

      6:28
    • 7. How to add a new database user and add privileges

      8:53
    • 8. What is DBMS and RDBMS

      3:02
    • 9. Database Engine Database Server and Database Software

      2:31
    • 10. What is database How to create database

      5:53
    • 11. What is database table How to create database table

      8:44
    • 12. How to add the data rows to database table

      7:19
    • 13. Understand Keywords Identifiers Constants and Clauses

      2:56
    • 14. Learn about SQL Statements

      1:30
    • 15. Data Definition Language and Data Manipulation Language

      2:34
    • 16. Create example databases tables and data rows

      10:50
    • 17. Learn about SQL SELECT Clause

      5:33
    • 18. SQL SELECT DISTINCT Statement

      5:16
    • 19. Learn about SQL FROM Clause

      3:10
    • 20. Learn about SQL WHERE Clause

      4:56
    • 21. SQL True Condition

      4:18
    • 22. SQL False Condition

      4:42
    • 23. SQL AND Operator

      5:59
    • 24. SQL OR Operator

      6:58
    • 25. SQL IN Operator

      5:09
    • 26. SQL EXISTS Condition

      7:49
    • 27. SQL NOT IN or NOT EXISTS Conditions

      4:48
    • 28. SQL Comparison Operators

      4:17
    • 29. SQL LIKE Operator

      5:40
    • 30. SQL BETWEEN Operator

      4:35
    • 31. SQL Numeric Operators

      4:14
    • 32. SQL Concatenation Operator

      2:22
    • 33. SQL Temporal Operator

      1:59
    • 34. Learn about SQL GROUP BY Clause

      7:34
    • 35. Learn about SQL HAVING Clause

      5:45
    • 36. Learn about SQL ORDER BY Clause

      4:53
    • 37. SQL LIMIT or TOP Clause

      2:55
    • 38. SQL Wildcards

      4:56
    • 39. SQL Aliases

      6:05
    • 40. SQL Dates

      4:07
    • 41. Add the data rows in a table using INSERT INTO Statement

      6:04
    • 42. SQL INSERT INTO SELECT Statement

      6:10
    • 43. Update data rows using UPDATE Statement

      7:10
    • 44. Delete data rows using DELETE Statement

      3:38
    • 45. What is SQL Injection and How to secure a database

      5:49
    • 46. What are JOINS in SQL Types of SQL JOINS

      5:01
    • 47. Learn about INNER JOIN in SQL

      10:32
    • 48. Learn about LEFT OUTER JOIN in SQL

      7:31
    • 49. Learn about RIGHT OUTER JOIN in SQL

      7:32
    • 50. Learn about FULL OUTER JOIN in SQL

      3:52
    • 51. Learn about CROSS JOIN in SQL

      4:29
    • 52. SQL UNION Operator

      4:31
    • 53. SQL VIEWS

      8:12
    • 54. Derived Tables or Inline Views

      5:22
    • 55. Functions in SQL and Types of SQL functions

      1:17
    • 56. SQL COUNT Function

      5:44
    • 57. SQL FIRST Function

      2:26
    • 58. SQL LAST Function

      2:47
    • 59. SQL SUM Function

      2:52
    • 60. SQL MIN Function

      3:27
    • 61. SQL MAX Function

      3:14
    • 62. SQL AVG Function

      3:12
    • 63. SQL UCASE Function

      2:27
    • 64. SQL LCASE Function

      2:13
    • 65. SQL MID Function

      2:51
    • 66. SQL LEN Function

      2:25
    • 67. SQL ROUND Function

      3:23
    • 68. SQL FORMAT Function

      2:48
    • 69. SQL SUBSTRING Function

      3:05
    • 70. SQL COALESCE Function

      2:43
    • 71. SQL CHAR LENGTH Function

      2:45
    • 72. SQL CAST Function

      3:41
    • 73. SQL CASE Function

      6:25
    • 74. SQL NULLIF Function

      6:12
    • 75. What is data type in SQL

      2:04
    • 76. Integer Numbers in SQL Exact Values

      3:01
    • 77. Fixed Point Numbers in SQL Exact Values

      3:30
    • 78. Floating Point Numbers in SQL Approximate Values

      3:12
    • 79. CHAR and VARCHAR in SQL String Values

      2:47
    • 80. NCHAR and NVARCHAR in SQL String Values

      1:12
    • 81. CLOB and BLOB in SQL String Values

      0:57
    • 82. DATE TIME and TIMESTAMP in SQL Temporal Values

      1:33
    • 83. Learn how to create and display databases

      4:11
    • 84. Select and use existing database

      2:45
    • 85. Remove or delete database from database management system

      2:57
    • 86. Learn how to create the database table using right method

      3:41
    • 87. Modify or update the database table details

      6:10
    • 88. Remove or delete an existing table

      2:16
    • 89. Understand Constraints in SQL

      1:00
    • 90. NOT NULL Constraint in SQL

      8:05
    • 91. UNIQUE Constraint in SQL

      6:45
    • 92. PRIMARY KEY Constraint in SQL

      3:23
    • 93. FOREIGN KEY Constraint in SQL

      10:32
    • 94. CHECK Constraint in SQL

      0:55
    • 95. DEFAULT Constraint in SQL

      4:19
    • 96. AUTO INCREMENT or SEQUENCE in SQL

      4:03
    • 97. What is Data Control Language (DCL)

      0:58
    • 98. The GRANT statement

      14:45
    • 99. The REVOKE statement

      6:11
    • 100. What is Transaction Control Language (TCL)

      3:35
    • 101. The COMMIT statement

      6:30
    • 102. The ROLLBACK statement

      14:29
    • 103. The SAVEPOINT statement

      10:09
    • 104. The SET autocommit

      5:07
    • 105. Understand Database Relationship in SQL

      1:43
    • 106. One to One 1 1 Relationship in SQL

      8:45
    • 107. One to Many 1 M Relationship in SQL

      5:27
    • 108. Many to Many M M Relationship in SQL

      7:08
    • 109. What is Database Normalization in SQL

      2:32
    • 110. First Normal Form 1NF in database normalization

      1:14
    • 111. Second Normal Form 2NF in database normalization

      1:30
    • 112. Third Normal Form 3NF in database normalization

      1:19
    • 113. What is SQL Export and Import

      1:17
    • 114. How to Export the database using SQL statement

      8:32
    • 115. How to Import the database using SQL statement

      5:16
    • 116. What is MySQL Workbench

      5:14
    • 117. Create a new user and connect to database using MySQL Workbench

      4:20
    • 118. Create Alter Drop database using MySQL Workbench

      3:38
    • 119. Create Alter Drop table using MySQL Workbench

      7:34
    • 120. Insert Read Update Delete data rows using MySQL Workbench

      4:19
    • 121. Database Export and Import using MySQL Workbench

      8:07
    • 122. Extra: Download & Install MySQL 5.7.10 on Windows 7 Operating System

      13:31
    • 123. Extra: Download & Install MySQL 5.7.20 on Windows 10 Operating System

      21:12
    • 124. Extra: Download & Install MySQL 5.7.10 on MAC OS X Operating System

      12:49
    • 125. Extra: Download & Install MySQL 5.5.46 on Linux Ubuntu 14.04 Operating System

      6:58
    • 126. Extra: MySQL shortcut for Windows users

      6:40
    • 127. SQL Tutorial Thank You

      1:20
11 students are watching this class