Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 13 hours on-demand video
  • 25 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Software Testing SQL

Learn SQL +Security(pen) testing from Scratch

Step by step Tutorial to learn SQL and Web Security testing with real time examples
Bestseller
Rating: 4.6 out of 54.6 (1,432 ratings)
9,449 students
Created by Rahul Shetty
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • You will gain the ability to design any complex SQL to query a database- (SQL)
  • Indepth understanding of GROUP BY,Subqueries,aggregate functions, SQL Server functions,HAVING clauses -(SQL)
  • Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN- (SQL)
  • You will understand the Importance of Session Hijacking Mechanisim and their confidential data use -(Security Testing)
  • You can investigate application behavior with Parameter Tampering and Brute force attacks-(Security Testing)
  • You will get the knowledge of all basics with Http that might cause attacking malicious inputs-(Security Testing)
  • Create or interact with existing databases and test the Database for schema validations - (SQL)
  • Detect Request forgery Designs if present any in Web applications --(Security Testing)
  • You can Clear any Interview on SQL with the Interview questions covered - (SQL)
Curated for the Udemy for Business collection

Course content

25 sections • 117 lectures • 13h 30m total length

  • Preview06:55
  • Preview00:13

  • Preview09:55
  • Preview06:27
  • Downloading MySQL server with workbench
    07:29
  • Overview of SQL Editor with basic features
    05:26
  • Preview00:01

  • Preview04:47
  • Creating Tables in database
    08:01
  • Inserting records into Table
    07:55
  • Retrieving records from the Table
    06:22
  • Preview00: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
  • Preview00:22

  • 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
  • SORT by usage in Queries
    05:23
  • Preview00:37

  • Importance of Group By in SQL
    12:38
  • Combination of GroupBy and SQL functions(Min,Max,Avg)
    07:49
  • Usage of Having keyword with GroupBy and Aggregate functions
    11:24
  • Difference between Having and Where keyword and when to use them
    11:21
  • Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword -1
    07:53
  • Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword- 2
    09:31
  • Preview00:34

  • Preview08:08
  • 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
  • Left and Right joins importance in SQL
    10:33
  • Practical example on Inner joins, Left join, Right Join
    16:15

  • Importance of views in Database
    07:55
  • views example on Database
    07:18
  • String functions - 1
    09:23
  • String functions - 2
    08:48
  • String functions -3
    06:11
  • SQL glossary on discussed topics
    00:36

Requirements

  • ******You need NOT have any proir SQL/Security testing 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

SQL and Security Testing are Additional skills which every software Engineer need to have irrespective of their role in Project. And this course fulfills the gap by teaching both these topics and also  gives you an edge compared to other Engineers at your work .And of course these are one of the common skills which are tested in every Software Engineer Interview.

  • What make this course special for beginners?
    "No more Boring slides or Definitions. I will write every SQL query before you in lecture and teach every topic needed to master in SQL with Practical examples

  • And also This Tutorial will give all the weapons you needed to investigate and unlock the Security Holes in the Web application with powerful Penetration testing approach

  • Course lectures are conceptually driven with root level explanations and bring you to the level where you can write any kind of SQL query and detect any kind of security bugs in the application


This course covers :


MYSQL :

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

Security Testing :

Course Contents: Basics of Security Testing Terminologies involved in Security Domain Top OWASP principles Cross site Scrpiting Xss examples Cookies Importance Danger with stealing of cookies Session Hijacking Cross site forgery Attacks Parameter Tampering Methods to Intercept requests Account Management Password security guidelines Brute force mechanism Importance of Client side validations 

Who this course is for:

  • Any IT professional no matter in what field they are into
  • QA Testers who want to enhance their skill on Data base Testing and Security testing
  • Freshers/Graduates who want to learn computer science foundations

Instructor

Rahul Shetty
Teacher/Founder of RahulShettyAcademy.com (Testing School)
Rahul Shetty
  • 4.5 Instructor Rating
  • 127,761 Reviews
  • 317,150 Students
  • 18 Courses

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

Teaching is my Passion. And its my Profession. The only Business I know is Spreading the Knowledge

"Every QA Professional have a wish of learning trending Automation courses but somehow 90% of them are giving up their thoughts “

Its not due to the lack of courses available in the Market,   but its about finding the right Mentor who can guide,teach and understand student's pulse with their background education"

So to full fill all these Gaps, I have established "RahulShettyAcademy"  few years ago, And after successful completion of more than 300 offline Training batches.. I am finally 
 here at Udemy to share all my 13 Years IT Experience Knowledge to QA Colleagues and Students

And you know?? Already 2,00,000 Happy Students are taking advantage with my courses here at Udemy with overwhelmed responses

Below are the course I teach here in this platform and many more on the way!

For Web Automation Testing :
1.Selenium Tutorial - In Java and Python
2. Protractor Tutorial - Java Script Automation for Angular
3.Selenium- Frameworks
4. Cucumber Framework Tutorial

For Mobile Automation Testing
3. Appium Mobile Testing Tutorial

For API Automation Testing :
4. SoapUI API Automation
5. Rest API Automation

For Performance Testing:
6. Jmeter Tutorial

For complete QA Process:
Software Testing comprehensive Tutorial

For Security and Data Base Testing :
Web Security Testing tutorial
SQL-Data Base Testing Tutorial

For Core Java-
Complete Java for Automation Tutorial

*********************************************************************************************************
Please note that All  RAHUL SHETTY  courses offer life time query support and we have dedicated discussion board where you can post your questions.. I will answer all of them in less than 24 hours...
*********************************************************************************************************

All The Best :) Looking forward to meet you all in my courses

- Rahul Shetty Academy
(Teacher)





  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.