SQL Training for Testers and Absolute Beginners

Course Summary

Are you struggling to learn SQL and find it tricky to master.
Are you an absolute beginner or fresher from college who wants to understand how do we use SQL in Software Testing and Development.
Then, this course is for you.
The course will cover topics from very basic including real life examples so you do not forget the SQL concepts in future.
Become a pro SQL user and learn to use SQL in your Software Testing Projects effectively.

Course Curriculum

Introduction
3 Lessons
- Introduction to SQL Course and Course Contents
  Preview
- What is SQL? | What is Database?
  Preview
- What is DBMS and RDBMS | DBMS vs RDBMS
  Preview
Installing MySQL on Windows
1 Lesson
- How to Install MySQL on Windows
  Preview
Understand SQL Statements and Syntax
1 Lesson
- Understanding SQL Statements and Syntax
  Preview
DDL and DML
1 Lesson
- SQL DDL vs DML | Difference and Examples
  Preview
Create Database and Tables
2 Lessons
- How to Create Database and Tables in MySQL
  Preview
- How to Insert Data in SQL Table
  Preview
SQL Select Statement - All you need to know
2 Lessons
- SELECT Statement in SQL | SQL SELECT Tutorial -Part 1
  Start
- SELECT Statement in SQL | SQL SELECT Tutorial- Part 2
  Start
SQL Operators
8 Lessons
- SQL AND Operator | SQL OR Operator | SQL Operators
  Start
- SQL IN and NOT IN Operators
  Start
- SQL EXISTS and NOT EXISTS Operator
  Start
- SQL Comparison Operators | Comparison Operators SQL
  Start
- BETWEEN Operator in SQL | SQL BETWEEN Operator
  Start
- SQL LIKE Operator | How to use LIKE in SQL
  Start
- SQL IS NULL and IS NOT NULL | SQL NULL Values
  Start
- SQL Arithmetic Operators | Arithmetic Operators in SQL
  Start
SQL Clauses
4 Lessons
- SQL GROUP BY Clause | GROUP BY SQL explained
  Start
- SQL HAVING Clause | HAVING Clause in SQL Example
  Start
- SQL ORDER BY Clause | ORDER BY Keyword in SQL
  Start
- SQL LIMIT | SQL TOP | SQL FETCH FIRST Clause
  Start
SQL Data Types
1 Lesson
- SQL Data Types | Data Types in MySQL
  Start
Updating and Deleting Data from SQL tables
3 Lessons
- How to Update Data in SQL | SQL UPDATE Statement
  Start
- How to Delete Data in SQL Table
  Start
- SQL INSERT INTO SELECT Statement Example
  Start
SQL Functions
4 Lessons
- Date and Time Functions in SQL
  Start
- String Functions in SQL Explained with Examples
  Start
- Aggregate Functions in SQL | SQL Aggregate Functions
  Start
- SQL Mathematical Functions | Math Functions in SQL
  Start
SQL Joins
4 Lessons
- SQL Join | SQL Inner Join | SQL Joins Tutorial
  Start
- RIGHT JOIN in SQL | SQL RIGHT OUTER JOIN
  Start
- LEFT JOIN in SQL | SQL LEFT OUTER JOIN
  Start
- SQL FULL JOIN | FULL OUTER JOIN in SQL
  Start
SQL Views
1 Lesson
- SQL Views
  Start
SQL Subquery
1 Lesson
- SQL Subquery
  Start
SQL Constraints
4 Lessons
- SQL Constraints Not Null
  Start
- SQL Constraints Default
  Start
- SQL Constraints Unique
  Start
- SQL Constraints Primary Key
  Start

Manish Verma

Course Pricing

One Time Price
$10 USD
Buy Now
Lifetime access
Any new updates to course