The Wayback Machine - https://web.archive.org/web/20180221090120/https://www.packtpub.com/application-development/learn-sql-and-database-testing-scratch-unix-material-video

Learn SQL and Database Testing from Scratch+ Unix material [Video]

Learn SQL and Database Testing from Scratch+ Unix material [Video] Book Cover
Preview in Mapt
Code Files

Learn SQL and Database Testing from Scratch+ Unix material [Video]

Rahul Shetty

Every IT Job needs SQL Knowledge, and this course fulfills that requirement by teaching everything from scratch

Quick links: > What will you learn?> Table of content

Mapt Subscription
FREE
£24.99/m after trial
Video
£18.00
RRP £89.98
Save 79%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
£0.00
£18.00
£25.00 p/m after trial
RRP £89.98
Subscription
Video
Start 14 Day Trial

Frequently bought together


Learn SQL and Database Testing from Scratch+ Unix material [Video] Book Cover
Learn SQL and Database Testing from Scratch+ Unix material [Video]
£ 89.98
£ 18.00
Learn SQL and Database Testing from Scratch+ Unix material [Video]
Feb 2018
6 hours and 13 minutes
£ 18.00
From 0 To 1: SQL And Databases - Heavy Lifting [Video] Book Cover
From 0 To 1: SQL And Databases - Heavy Lifting [Video]
£ 45.58
£ 9.12
From 0 To 1: SQL And Databases - Heavy Lifting [Video]
Jan 2018
14 hours and 24 minutes
£ 9.12
Buy 2 for £24.96
Save £92.18
Add to Cart

Video Details

ISBN 139781789133844
Course Length6 hours and 13 minutes

Video Description

This course covers: Introduction to SQL – MySQL Overview -- Start up commands to Setup Database and Tables -- 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 – Data constraints with Database Testing perspective -- Practice Exercises for Interviews with Solutions -- SQL glossary on discussed topics.

Style and Approach

On course completion, You will be Mastered in SQL Language with DataBase Testing and can implement Successfully it in your workplace.

Table of Contents

Introduction to SQL and Database Testing
Course FAQ's
Introduction to Database
Introduction to SQL and MySQL
Downloading MySQL server with workbench
Overview of SQL Editor with basic features
Getting Started with Queries to retrieve Data
Creating Database and pointing to it
Creating Tables in Database
Inserting records into Table
Retrieving records from the Table
Altering Table Schema operations
Adding and modifying records in a table
Deleting records and dropping Database
Updating rows in a table
Modifying operations example
Getting Started with Queries to retrieve Data
Select distinct keyword in queries
SQL WHERE command usage
Logical operators on Queries AND OR - 1
Logical operators 'In' 'Between'- 2
Regular expressions Introduction
Wild cards usage in Queries -1
Advanced SQL Concepts – 1
SORT by usage in Queries
SQL Functions Introduction with real time scenarios
SQL Functions Part - 2
Importance of Group By in SQL
Combination of GroupBy and SQL functions
Practical Examples on Group By
Advanced SQL Concepts -2
SubQueries syntax and usage
SubQueries Example
SQL Joins usage and its advantages
SQL Joins Example
Relation on subqueries and Joins
Practical examples on Joins and subqueries
Importance of views in Database
Views example on Database
String functions - 1
String functions - 2
String functions - 3
Dataconstraints with Database Testing perspective
NOT NUll constraint -1
Not Null Constraint Validations and Testing - 2
Default Constraint Validations and Testing - 3
Unique Constraint Validations and Testing - 4
Primary Key Constraint validation and Testing -5
Practise Exercises for Interviews with Solutions
Practise Practise Practise !!!
JDBC Connectivity for Integration with Selenium (Basic Automation Knowledge req
Jdbc odbc programming-Creating Project
Creating Database Tables and connecting to Jdbc java code
Retrieving data from Database with Java code
SQL Injection - Database Security Testing
What is SQL Injecting
How to identify SQL loop holes in web application
Exposing Security loop holes with malicious SQL syntax
List of urls Pattern which can cause attack with SQL

What You Will 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
  • In-depth 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

Authors

Table of Contents

Introduction to SQL and Database Testing
Course FAQ's
Introduction to Database
Introduction to SQL and MySQL
Downloading MySQL server with workbench
Overview of SQL Editor with basic features
Getting Started with Queries to retrieve Data
Creating Database and pointing to it
Creating Tables in Database
Inserting records into Table
Retrieving records from the Table
Altering Table Schema operations
Adding and modifying records in a table
Deleting records and dropping Database
Updating rows in a table
Modifying operations example
Getting Started with Queries to retrieve Data
Select distinct keyword in queries
SQL WHERE command usage
Logical operators on Queries AND OR - 1
Logical operators 'In' 'Between'- 2
Regular expressions Introduction
Wild cards usage in Queries -1
Advanced SQL Concepts – 1
SORT by usage in Queries
SQL Functions Introduction with real time scenarios
SQL Functions Part - 2
Importance of Group By in SQL
Combination of GroupBy and SQL functions
Practical Examples on Group By
Advanced SQL Concepts -2
SubQueries syntax and usage
SubQueries Example
SQL Joins usage and its advantages
SQL Joins Example
Relation on subqueries and Joins
Practical examples on Joins and subqueries
Importance of views in Database
Views example on Database
String functions - 1
String functions - 2
String functions - 3
Dataconstraints with Database Testing perspective
NOT NUll constraint -1
Not Null Constraint Validations and Testing - 2
Default Constraint Validations and Testing - 3
Unique Constraint Validations and Testing - 4
Primary Key Constraint validation and Testing -5
Practise Exercises for Interviews with Solutions
Practise Practise Practise !!!
JDBC Connectivity for Integration with Selenium (Basic Automation Knowledge req
Jdbc odbc programming-Creating Project
Creating Database Tables and connecting to Jdbc java code
Retrieving data from Database with Java code
SQL Injection - Database Security Testing
What is SQL Injecting
How to identify SQL loop holes in web application
Exposing Security loop holes with malicious SQL syntax
List of urls Pattern which can cause attack with SQL

Video Details

ISBN 139781789133844
Course Length6 hours and 13 minutes
Read More

Read More Reviews

Recommended for You

From 0 To 1: SQL And Databases - Heavy Lifting [Video] Book Cover
From 0 To 1: SQL And Databases - Heavy Lifting [Video]
£ 45.58
£ 9.12
From 0 To 1: SQL And Databases - Heavy Lifting [Video]
Jan 2018
14 hours and 24 minutes
£ 9.12
Design Selenium Test framework from scratch-Architect level [Video] Book Cover
Design Selenium Test framework from scratch-Architect level [Video]
£ 89.98
£ 18.00
Design Selenium Test framework from scratch-Architect level [Video]
Feb 2018
8 hours and 44 minutes
£ 18.00
Complete Java for Automation Testers from Scratch [Video] Book Cover
Complete Java for Automation Testers from Scratch [Video]
£ 179.98
£ 36.00
Complete Java for Automation Testers from Scratch [Video]
Feb 2018
7 hours and 45 minutes
£ 36.00
REST API Automation testing from scratch-(REST Assured java) [Video] Book Cover
REST API Automation testing from scratch-(REST Assured java) [Video]
£ 178.78
£ 35.76
REST API Automation testing from scratch-(REST Assured java) [Video]
Jan 2018
15 hours and 59 minutes
£ 35.76
Appium(Selenium)-Mobile Automation Testing from Scratch [Video] Book Cover
Appium(Selenium)-Mobile Automation Testing from Scratch [Video]
£ 178.78
£ 35.76
Appium(Selenium)-Mobile Automation Testing from Scratch [Video]
Jan 2018
11 hours and 45 minutes
£ 35.76
From 0 to 1: Learn Java Programming - Live Free, Learn To Code [Video] Book Cover
From 0 to 1: Learn Java Programming - Live Free, Learn To Code [Video]
£ 19.18
£ 3.84
From 0 to 1: Learn Java Programming - Live Free, Learn To Code [Video]
Feb 2018
16 hours and 49 minutes
£ 3.84