Advance MySQL for complete End to End Testing
4.2 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
225 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advance MySQL for complete End to End Testing to your Wishlist.

Add to Wishlist

Advance MySQL for complete End to End Testing

MySQL for Testing Requirement
4.2 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
225 students enrolled
Last updated 12/2016
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of this course, students would understand the MySQL Query writing and they can start working in testing profile.
View Curriculum
Requirements
  • As such there is no prerequisite required for this course and it is useful for any level of tester. Any Tester profile candidate can start this tutorial.
Description

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.

Who is the target audience?
  • Any Level of Testing Profile Candidate is the target audience for this course.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
20 Lectures
02:39:14
+
MySQL Introduction
20 Lectures 02:39:14

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.

Preview 03:07

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.

Whats is MySQL and what all are its terminology?
07:01

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

How to Clear MySQL Terminal on Ubuntu Machine?
01:32

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. 

How to Create/Use Database and Tables?
04:30

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.

Preview 08:05

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

MySQL Where Condition in Different Query Implementation
07:42

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.

Different MySQL Joins i.e. Left Outer, Right Outer and Inner Join
24:30

Full Outer Join Implementation
09:01

Self Join Implementation
05:53


Delete, Drop and Truncate Implementation
05:53

Group By, Having and Order By Implementation
11:21

Copy Existing Table with INSERT INTO SELECT
08:37

CONCAT and SubString in MySQL Query
12:07

LIKE and WildCards in MySQL Query
08:27

MIN, MAX, AVG and COUNT Functions
07:12

MYSQL LIMIT or TOP Clause
03:26

Where Condition with Equal and not equal Implementation
04:21

Comparison Operators in MySQL Query
04:29

How to Compare Two MySQL Table to Get the Distinct Records?
12:50
About the Instructor
Big Data Module Lead QA Engineer Big Data QA
3.4 Average rating
201 Reviews
4,934 Students
12 Courses
Big Data QA Module Lead

Having more than 9 yrs industry experience.

Worked on different big data tools like Hadoop, Cassandra, HBase, Hive, Pig, Sqoop, Flume etc. 

ISTQB Certified professional. I have worked with CMMi level 5 companies and provided services to clients in fortune 15 companies like AT&T.

Trained more than 100 professionals in classroom training and more than 50 professionals online.

Training has been my passion and I am on my way to create courses which should help any beginner to step by step learn and be able to become a Big data QA expert.