15% off on all trending courses. Contact us now! +91-7530088009 +91-4446311234
+91-7530088009 +91-4446311234 Home Courses Instructor Labs

SQL training with MySQL Database - Beginner to Expert

Learn SQL and Database Development to effectively build database applications in MySQL, SQL Server, Oracle and in Big Data technologies.

Beginner ( Ratings) Students Enrolled
Created By Pradnyankur Nikam Last Updated English
What Will I Learn?
  • You will get familiarize with various terminologies in Database and SQL fundamentals.
  • You will learn basics and advanced concepts including Database Normalization, Relationships JOINS and many more.
  • You will learn Data modeling, DBMS concepts which will be very useful for clearing job interviews.
  • After completing this free online SQL video-based training, you will master SQL statements and will be able to write SQL queries in any Database.
  • Every SQL concept explained with practical examples.
  • You will learn MySQL installation, how to use the most famous MySQL workbench.
  • Excellent support from SparkDatabox

Requirements
  • English language
  • Basic computer knowledge
+ View More
Description

Why should you enroll in this free SQL video course?

  • You will be learning and practicing a lot of SQL through this video-based free SQL course.
  • Once you complete this course, you will be able to write SQL in several databases efficiently
  • You will learn advanced database concepts like Database designing, modeling, RDBMS concepts.
  • You will be learning Database relationships
  • This free video-based SQL tutorial course will equip you with excellent SQL skills using which you can master any database development.
  • You have quizzes with answers based on SQL interview questions.
  • We will hear your questions: Someone from SparkDatabox will respond to all of your queries within a day.
  • You will have full access to this online video-based SQL tutorial for life as long as you are a registered member.
  • This online video-based SQL course is ABSOLUTELY free from SparkDatabox! 
Curriculum For This Course
136 Lessons 11 Hours
  • What is SQL? 00:02:23 Preview
  • Quiz: Basics
  • 1. Download & Install MySQL 8.0.11 on Windows 10 Operating System 00:16:00 Preview
  • 2. Install MySQL database server on Mac operating system - MySQL 5.7.20- 00:12:32
  • 3. Install MySQL database server on Linux operating system -MySQL 5.7.20- 00:06:28
  • 4. How to add a new database user and add privileges 00:08:53
  • Quiz: Setup a Testing Environment 00:00:00
  • 1. What is DBMS and RDBMS? 00:03:02
  • 2. Difference between Database Engine, Database Server and Database Software 00:02:31
  • 3. What is a database How to create and use a database 00:05:53
  • 4. What is a database table How to create and use a database table 00:08:44
  • 5. How to add the data rows to a database table 00:07:20
  • 6. Understand Keywords, Identifiers, Constants and Clauses 00:02:56
  • 7. Learn about SQL Statements 00:01:30
  • 8. DDL - Data Definition Language and DML - Data Manipulation Language 00:02:34
  • Quiz: An Overview of SQL 00:00:00
  • 1. Create example databases, tables and data rows 00:10:50
  • 2. Learn about SQL SELECT Clause 00:05:33
  • 3. SQL SELECT DISTINCT Statement 00:05:16
  • 4. Learn about SQL FROM Clause 00:03:10
  • 5. Learn about SQL WHERE Clause 00:04:56
  • Quiz: Important SQL Clauses (Data Manipulation Language) 00:00:00
  • 1. SQL True Condition 00:04:18
  • 2. SQL False Condition 00:04:42
  • 3. SQL AND Operator 00:05:59
  • 4. SQL OR Operator 00:06:58
  • 5. SQL IN Operator 00:05:09
  • 6. SQL EXISTS Condition 00:07:49
  • 7. SQL NOT IN or NOT EXISTS Conditions 00:04:48
  • 8. SQL Comparison Operators 00:04:17
  • 9. SQL LIKE Operator 00:05:40
  • 10. SQL BETWEEN Operator 00:04:35
  • 11. SQL Numeric Operators 00:04:14
  • 12. SQL Concatenation Operator 00:02:22
  • 13. SQL Temporal Operator 00:01:59
  • Quiz: Conditions and Operators (Data Manipulation Language) 00:00:00
  • 1. Learn about SQL GROUP BY Clause 00:07:34
  • 2. Learn about SQL HAVING Clause 00:05:45
  • 3. Learn about SQL ORDER BY Clause 00:04:53
  • 4. SQL LIMIT or TOP Clause 00:02:55
  • 5. SQL Wildcards 00:06:05
  • 7. SQL Dates 00:04:07
  • Quiz: Data grouping, sorting, select and dates (Data Manipulation Language) 00:00:00
  • 1. Add the data rows in a table using INSERT INTO Statement 00:05:58
  • 2. SQL INSERT INTO SELECT Statement 00:06:10
  • 3. Update data rows using UPDATE Statement 00:07:10
  • 4. Delete data rows using DELETE Statement 00:03:38
  • 5. What is SQL Injection and How to secure a database? 00:05:50
  • Quiz: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language) 00:00:00
  • 1. What are JOINS in SQL Types of SQL JOINS? 00:05:01
  • 2. Learn about INNER JOIN in SQL 00:10:32
  • 3. Learn about LEFT OUTER JOIN in SQL 00:07:31
  • 4. Learn about RIGHT OUTER JOIN in SQL 00:07:32
  • 5. Learn about FULL OUTER JOIN in SQL 00:03:52
  • 6. Learn about CROSS JOIN in SQL 00:04:29
  • 7. SQL UNION Operator 00:04:31
  • 8. SQL VIEWS 00:08:12
  • 9. Derived Tables or Inline Views 00:05:22
  • Quiz: SQL JOINS (Data Manipulation Language) 00:00:00
  • 1. Functions in SQL and Types of SQL functions 00:01:17
  • 2. SQL COUNT() Function 00:05:44
  • 3. SQL FIRST() Function 00:02:26
  • 4. SQL LAST() Function 00:02:47
  • 5. SQL SUM() Function 00:02:52
  • 6. SQL MIN() Function 00:03:27
  • 7. SQL MAX() Function 00:03:24
  • 8. SQL AVG() Function 00:03:12
  • 9. SQL UCASE() Function 00:02:27
  • 10. SQL LCASE() Function 00:02:13
  • 11. SQL MID() Function 00:02:51
  • 12. SQL LEN() Function 00:02:26
  • 13. SQL ROUND() Function 00:03:23
  • 14. SQL FORMAT() Function 00:02:48
  • 15. SQL SUBSTRING() Function 00:03:05
  • 16. SQL COALESCE() Function 00:02:43
  • 17. SQL CHAR_LENGTH() Function 00:02:45
  • 18. SQL CAST() Function 00:03:41
  • 19. SQL CASE() Function 00:06:25
  • 20. SQL NULLIF() Function 00:06:12
  • Quiz: SQL Functions 00:00:00
  • 1. What is data type in SQL? 00:02:04
  • 2. Integer Numbers in SQL (Exact Values) 00:03:01
  • 3. Fixed-Point Numbers in SQL (Exact Values) 00:03:30
  • 4. Floating-Point Numbers in SQL (Approximate Values) 00:03:12
  • 4. Floating-Point Numbers in SQL (Approximate Values) 00:03:12
  • 5. CHAR and VARCHAR in SQL (String Values) 00:02:47
  • 6. NCHAR and NVARCHAR in SQL (String Values) 00:01:12
  • 7. CLOB and BLOB in SQL (String Values) 00:00:57
  • 8. DATE, TIME and TIMESTAMP in SQL (Temporal Values) 00:01:33
  • Quiz: SQL Datatypes 00:00:00
  • Data Definition Language 00:00:00
  • 1. Learn how to create and display databases 00:04:11
  • 2. Select and use existing database 00:02:45
  • 3. Remove or delete database from database management system 00:02:57
  • 4. Learn how to create the database table using right method 00:03:41
  • 5. Modify or update the database table details 00:02:16
  • 6. Remove or delete an existing table 00:02:17
  • 7. Understand Constraints in SQL 00:01:00
  • 8. NOT NULL Constraint in SQL 00:08:05
  • 9. UNIQUE Constraint in SQL 00:06:45
  • 10. PRIMARY KEY Constraint in SQL 00:03:23
  • 11. FOREIGN KEY Constraint in SQL 00:10:33
  • 12. CHECK Constraint in SQL 00:00:55
  • 13. DEFAULT Constraint in SQL 00:04:19
  • 14. AUTO INCREMENT or SEQUENCE in SQL 00:04:03
  • 1. What is Data Control Language (DCL)? 00:00:58
  • 2. The GRANT statement 00:14:46
  • 3. The REVOKE statement 00:06:11
  • 1. What is Transaction Control Language (TCL) ? 00:03:35
  • 2. The COMMIT statement 00:06:30
  • 3. The ROLLBACK statement 00:14:29
  • 4. The SAVEPOINT statement 00:10:09
  • 5. The SET autocommit 00:05:08
  • 1. What is Database Normalization in SQL? 00:02:32
  • 1. What is Database Normalization in SQL? 00:02:32
  • 2. First Normal Form (1NF) in database normalization 00:01:14
  • 3. Second Normal Form (2NF) in database normalization 00:01:30
  • 4. Third Normal Form (3NF) in database normalization 00:01:19
  • 1. Understand Database Relationship in SQL 00:01:43
  • 2. One-to-One (11) Relationship in SQL 00:08:45
  • 3. One-to-Many (1M) Relationship in SQL 00:05:27
  • 4. Many-to-Many (MM) Relationship in SQL 00:07:08
  • Database Relationships 00:00:00
  • 1. What is SQL Export and Import? 00:01:17
  • 2. How to Export the database using SQL statement ? 00:08:32
  • 3. How to Import the database using SQL statement? 00:05:16
  • 1. What is MySQL Workbench 00:05:14
  • 2. Create a new user and connect to database using MySQL Workbench 00:04:20
  • 3. Create, Alter, Drop database using MySQL Workbench 00:03:38
  • 4. Create, Alter, Drop table using MySQL Workbench 00:07:34
  • 5. Insert, Read, Update, Delete data rows using MySQL Workbench 00:04:19
  • 1. Install MySQL database server on Windows 10 operating system 00:21:12
  • 2. Install MySQL database server on Windows 7 operating system 00:13:21
  • 3. Install MySQL database server on Mac operating system 00:12:49
  • 4. Install MySQL database server on Linux operating system 00:06:58
  • 5. MySQL shortcut for Windows users 00:06:40
+ View More
Other Related Courses
7 Hours
0 83 Free
18 Hours
Updated Sun, 29-Sep-2019
5 275 Free
14 Hours
Updated Mon, 28-Oct-2019
0 1 $ 200 $ 25
27 Hours
Updated Thu, 14-Nov-2019
0 0 $ 200 $ 9.99
9 Hours
Updated Mon, 28-Oct-2019
0 0 $ 54 $ 20
6 Hours
Updated Mon, 18-Nov-2019
0 47 Free
3 Hours
Updated Fri, 18-Oct-2019
0 44 Free
34 Hours
Updated Fri, 01-Nov-2019
0 2 $ 200 $ 9.99
8 Hours
0 0 $ 94.99 $ 13
5 Hours
Updated Sat, 16-Nov-2019
0 1 $ 99 $ 9.99
10 Hours
Updated Thu, 31-Oct-2019
0 0 $ 99 $ 13
1 Hours
0 13 Free
10 Hours
Updated Sat, 02-Nov-2019
0 0 $ 129.99 $ 12.99
3 Hours
Updated Sun, 03-Nov-2019
0 15 Free
2 Hours
Updated Sun, 03-Nov-2019
0 15 Free
7 Hours
Updated Sun, 03-Nov-2019
0 0 $ 149.99 $ 12.99
7 Hours
Updated Mon, 04-Nov-2019
0 1 $ 199.99 $ 12.99
2 Hours
Updated Mon, 11-Nov-2019
0 7 Free
7 Hours
0 1 $ 199.99 $ 27.99
8 Hours
0 0 $ 199.99 $ 14.99
5 Hours
Updated Thu, 07-Nov-2019
0 6 Free
1 Hours
Updated Thu, 07-Nov-2019
0 6 Free
1 Hours
Updated Thu, 07-Nov-2019
0 3 Free
15 Hours
Updated Fri, 08-Nov-2019
0 5 Free
5 Hours
Updated Mon, 11-Nov-2019
0 13 Free
0 Hours
Updated Mon, 11-Nov-2019
0 5 Free
10 Hours
0 0 $ 34.99 $ 12.99
About The Instructor
  • 0 Reviews
  • 100 Students
  • 1 Courses
+ View More

Pradnyankur is a passionate software engineer with more than 15+ years of industry experience. He has 8+ years of teaching experience and loves teaching. 

Student Feedback
0
Average Rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
Free
Includes:
  • 11 Hours On Demand Videos
  • 136 Lessons
  • Full Lifetime Access
  • Access On Mobile And Tv