Learn SQL and Database Testing from Scratch+ Unix material
4.5 (282 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.
2,222 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL and Database Testing from Scratch+ Unix material to your Wishlist.

Add to Wishlist

Learn SQL and Database Testing from Scratch+ Unix material

Every IT Job needs SQL Knowledge, and this course fullfills that requirement by teaching everthing from scratch
Best Seller
4.5 (282 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.
2,222 students enrolled
Created by Rahul Shetty
Last updated 3/2016
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 15 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You will be able to create Databases and modify them
  • You will get proficient knowledge on writing SQL Queries
  • You can validate and test Database Schema
  • Indepth understanding of advanced SQL concepts to test Database
  • JDBC ODBC Java programming knowledge to handle database
  • You can Clear any Interview on SQL with the Interview questions covered
View Curriculum
Requirements
  • ******You need NOT have any proir SQL knowledge to start this course*********
  • Though these are online Lectures.You will have Life Time instructor support.You can contact me any time for your Queries,Will respond back with in 12 hours
  • All Installation setup including Database basics is taken care as part of course
  • Theoretical Material,Code dump and Interview Guide are available for download
Description

You are about to Master in SQL QUERIES AND DATABASE TESTING

"No more Boring slides or Definitions. Understand how things work Practically with real time scenarios"

********************************************************************************************************* .Get Access to Top class 60 + Lectures on SQL + Database Testing + Material + Interview Questions + Resume Preparation + Life Time Instructor Support *********************************************************************************************************

On course completion You will be Mastered in SQL Language with DataBase Testing and can implement Successfully it in your work place or will surely land on High Paying Job

This course covers :

Introduction to SQL -- MySQLOverview -- Start up commands to Setup Database andTables -- Database testing to validate Schema -- Altering Table Schema operations -- Queries to retrieve Data Logical operators on Queries -- Wild cards usage in Queries -- SQL Functions with real time scenarios -- Importance of Group By in SQL -- Advanced SQL Concepts -- SubQueries syntax and usage -- SQL Joins usage and its advantages -- Importance of views in Database -- SQL String functions -- Dataconstraints with DataBase Testing perspective -- Practise Exercises for Interviews with Solutions -- SQL glossary on discussed topics

Who is the target audience?
  • Any IT professional no matter in what field they are into
  • QA Testers who want to enhance their skill on Data base Testing
  • Freshers/Graduates who want to learn computer science foundations
Students Who Viewed This Course Also Viewed
Curriculum For This Course
64 Lectures
06:22:31
+
Getting Started with Queries to retrieve Data
5 Lectures 27:14
+
Altering Table Schema operations
5 Lectures 25:25
Adding and modifying records in a table
06:57

Deleting records and droping database
04:48

Updating rows in a table
07:32

Modifying operations example
05:55

+
Getting Started with Queries to retrieve Data
7 Lectures 47:51
Select Distinct keyword in queris
06:50

SQL WHERE command usage
09:27

Logical operators on Queries AND OR - 1
07:07

Logical operators 'In' 'Between'- 2
08:37

Regular expressions Introduction
07:18

Wild cards usage in Qeuries -1
08:04

+
Advanced SQL Concepts - 1
7 Lectures 41:44
SORT by usage in Queries
05:23

SQL Functions Introduction with real time scenarios
08:53

SQL Functions Part - 2
06:58

Importance of Group By in SQL
08:50

Combination of GroupBy and SQL functions
06:26

Practical Examples on Group By
04:51

+
Advanced SQL Concepts -2
12 Lectures 01:22:22

SubQueries Example
06:07

SQL Joins usage and its advantages
05:46

SQL Joins Example
07:30

Relation on subqueries and Joins
09:34

Practical examples on Joins and subqueries
10:25

Importance of views in Database
07:55

views example on Database
07:18

String functions - 1
09:23

String functions - 2
03:43

String functions -3
06:11

+
Dataconstraints with DataBase Testing perspective
6 Lectures 36:27
NOT NUll constraint -1
06:12

Not Null Constraint Validations and Testing - 2
08:10

Default Constraint Validations and Testing - 3
06:28

Unique Constraint Validations and Testing - 4
05:43

Primary Key Constraint validaton and Testing -5
09:45

SQL glossary on discussed topics
00:09
+
Practise Exercises for Interviews with Solutions
5 Lectures 10:04
Practise Practise Practise !!!
04:54

Practise Exercise/Interview Questions- 1
02:07

Practise Exercise/Interview Questions- 2
02:15

Solutions for Exercise - 1
00:24

Solutions for Exercise -2
00:23
+
JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req
4 Lectures 31:43
Jdbc odbc programming-Creating Project
07:03

Creating Database Tables and connecting to Jdbc java code
16:48

Retrieving data from Database with Java code
07:39

jdbc code download
00:13
+
SQL Injection - Database Security Testing
5 Lectures 38:23
What is SQL Injecting
07:32

How to identify SQL loop holes in web application
13:19

Exposing Security loop holes with malcious SQL syntax
09:20

List of urls Pattern which can cause attack with SQL
07:34

Material for reference
00:38
1 More Section
About the Instructor
Rahul Shetty
4.3 Average rating
13,698 Reviews
46,223 Students
12 Courses
The "Testing school" to boost your career

Nothing is Impossible . It all depends on how you are Trained on it!

Teaching is our Passion. And its our Profession. The only Business We know is Spreading the Knowledge

So Our Testing school is here at Udemy to share all our 10 Years IT Experience Knowledge to QA Colleagues and Students

As an Director , Coming to my Teaching Profile I  have had Trained over 21000+ students in the below Technologies

**********************************************************************************************************

Selenium -Web Automation in Java and Python Soap UI - Webservices/ REST API Testing Appium - Mobile Automation in Android and IOS Jmeter - Performance Testing Software Testing Process Security Testing Automation Framework Building

********************************************************************************************************* Worked with various CMM level orgranizations. Managed in setting up of QA Process for the projects