SQL Tutorial For Tester
3.8 (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.
111 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Tutorial For Tester to your Wishlist.

Add to Wishlist

SQL Tutorial For Tester

Course on SQL query for testers and developers
3.8 (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.
111 students enrolled
Created by S D Academy
Last updated 10/2016
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • User would be quite comfortable in querying database
  • become expert in sql query
  • write learn data retrieval, table creation, database creation, joining tables, create view
  • answer any of the interview question related to basics of sql query
View Curriculum
Requirements
  • Need basic understanding of computer
  • Should be familiar with application installation
Description

SQL Query Tutorial For Beginners has been designed specially for all the beginners who wants to learn sql query with real time examples with practical examples. 

In today's IT Industry , Sql Query is equally good for Testers and Developer and it is most important skill set in today's market and with big data boom now data analysis has become the need of minute and whole world is trying to tune up their SQL query skill. This tutorial has been design in a very systematic way and it covers most of the areas. 

This course is going to cover

1- Relational database introduction
2- Data retrieval using Select Statement
3-  Creation of database, data table, insertion of data
4-  Difference between delete, drop and truncate
5- Concept of Join
6- Constraints implementation in sql
7- Setting sql_mode in mysql for better result of Constraints in mysql

Software User in this course
1- XAMPP for setting up mysql
2- SQLYog as mysql database administrative tool and it will be used to execute all the sql queries.

Who is the target audience?
  • Any one with some computer knowledge can take this course
  • Any Quality Engineer who is inspired to make career in database or ETL
  • Any developer who has just started career and want to learn all basic queries of SQL
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
01:02:21
+
Introduction of SQL and Database
2 Lectures 02:31
+
Basic Queries
7 Lectures 19:56

Creating database
01:42

Creating Table
04:50


Update Data in Table
01:25

Deleting table data
02:38

Deleting table using drop statement
01:42

Practice Activity 2
6 questions
+
Select Statement
7 Lectures 21:33

Where clause with Select Statement
03:49

Select Distinct
01:57

Like operator for pattern matching
04:43

Between Operator in SQL
01:04

In Operator in SQL
01:30

Sorting data using order by
05:30

Practice Activity 3
5 questions
+
Aggregate Functions , Group By, Having Clause
6 Lectures 10:05
Max() function in SQL
01:11

Min() function in SQL
00:46

Avg() function in SQL
00:52

Sum() function in SQL
00:51

Count() function in SQL
00:43

Group by and Having Clause in SQL
05:42
+
Joins in SQL
3 Lectures 08:16
What is Join
03:07

Inner Join in SQL
03:23

Left and Right Outer Join
01:46
About the Instructor
S D Academy
4.0 Average rating
7 Reviews
132 Students
2 Courses
Founder

S D Academy is best place to start  learning about testing and development where academician with enriched experience from industry try to teach with practical scenario.

More information:

As founder, I always try to bring best learning to students and for the same i am working to bring more simplicity what ever we are teaching in our classroom or in our online course with good blend of practical and indsutry honed examples. I have more than 5+ years of experience in IT Industry.I have a very good experience of teaching Selenium WebDriver using Java, Python, SOAPUI, Groovy, Geb,  and now these days grooming my self for XML, XSLT since whole world is talking about Reporting and becoming more and more result oriented. 

As an IT person have worked with many CMM level organisation with good understanding of product life cycle.