3.93 out of 5
3.93
7 reviews on Udemy

Advance MySQL for complete End to End Testing

MySQL for Testing Requirement
Instructor:
Big Data Engineer
242 students enrolled
At the end of this course, students would understand the MySQL Query writing and they can start working in testing profile.

This course is for Testing profile candidate who wanted to build there career into Testing profile. So I have designed this course so they can start with basic MySQL Query concepts to big data testing. All the users who are working in QA profile and wanted to move into testing domain should take this course and go through the complete tutorials.

I have included the material which is needed for testing profile and it has all the necessary contents which is required for learning MySQL.

It will give the detailed information for different MySQL queries which is needed by the tester to move into bigger umbrella i.e. Testing Arena.

This course is well structured with all elements of different MySQL Queries in practical manner separated by different topics. Students should take this course who wanted to learn MySQL from scratch.

MySQL Introduction

1
Introduction

After completing this session, students would get to know the different topics we are going to cover in this complete tutorial so that they have all the knowledge about MySQL database.

2
Whats is MySQL and what all are its terminology?

After completing this session, students would get to know all about the MySQL database and its default terminology which we use in it while working.

3
How to Clear MySQL Terminal on Ubuntu Machine?

After completing this session, students would get to know how they can remove the content of the MySQL terminal when they wanted to do.

4
How to Create/Use Database and Tables?

After completing this session, students would get to know how they can get all the databases available in MySQL and how they can get the tables inside particular database. 

5
Create Table and Insert Value in Table

After completing this session, students would get to know how they can create a table and how to insert data inside the table. Also, they will get to know about the select query to view the table records.

6
MySQL Where Condition in Different Query Implementation

After completing this session, students would get to know how they can work with different conditions with different query using MySQL table.

7
Different MySQL Joins i.e. Left Outer, Right Outer and Inner Join

After completing this session, students would get the detailed practical knowledge of different joins i.e. Inner Join, Left Outer Join and Right Outer Join implementation in MySQL database.

8
Full Outer Join Implementation
9
Self Join Implementation
10
Update and Delete Query Implementation
11
Delete, Drop and Truncate Implementation
12
Group By, Having and Order By Implementation
13
Copy Existing Table with INSERT INTO SELECT
14
CONCAT and SubString in MySQL Query
15
LIKE and WildCards in MySQL Query
16
MIN, MAX, AVG and COUNT Functions
17
MYSQL LIMIT or TOP Clause
18
Where Condition with Equal and not equal Implementation
19
Comparison Operators in MySQL Query
20
How to Compare Two MySQL Table to Get the Distinct Records?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.9
3.9 out of 5
7 Ratings

Detailed Rating

Stars 5
4
Stars 4
0
Stars 3
0
Stars 2
3
Stars 1
0
9d3b99516bf500fd04a7bff2963ebcec
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion