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

Learn SQL and Database Testing from Scratch (including Unix Material) [Video]

Learn SQL and Database Testing from Scratch (including Unix Material) [Video] Book Cover
Preview in Mapt
Code Files

Learn SQL and Database Testing from Scratch (including Unix Material) [Video]

Rahul Shetty

Every IT Job Needs SQL Knowledge. This Course Teaches All you Need to Know from Scratch
Quick links: > Table of contents > What will you learn?
Mapt Subscription
FREE
€29.73/m after trial
Video
€9.73
RRP €101.13
Save 90%
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
€9.73
€29.74 p/m after trial
RRP €101.13
Subscription
Video
Start 14 Day Trial

Frequently bought together


Learn SQL and Database Testing from Scratch (including Unix Material) [Video] Book Cover
Learn SQL and Database Testing from Scratch (including Unix Material) [Video]
€ 101.13
€ 9.73
Learn SQL and Database Testing from Scratch (including Unix Material) [Video]
Feb 2018
6 hours and 12 minutes
€ 9.73
Learn Network Hacking From Scratch (WiFi and Wired) [Video] Book Cover
Learn Network Hacking From Scratch (WiFi and Wired) [Video]
€ 96.37
€ 9.73
Learn Network Hacking From Scratch (WiFi and Wired) [Video]
Apr 2018
5 hours and 56 minutes
€ 9.73
Buy 2 for €19.46
Save €149.62
Add to Cart

Video Details

ISBN 139781789133844
Course Length6 hours and 12 minutes

Video Description

This course covers: Introduction to SQL, MySQL overview, start up commands to setup databases and tables, database testing to validate Schema, altering table schema operations, queries to retrieve data logical operators on queries, wild cards usage in Qqeries, SQL functions with real time scenarios, the importance of group by in SQL, advanced SQL concepts, sub-queries in syntax and usage, SQL joins usage and its advantages, the importance of views in databases, SQL string functions, data constraints with database testing perspective, practice exercises for interviews with solutions, and an SQL glossary on the discussed topics.

Style and Approach

On course completion, you will have Mastered the SQL Language with Database Testing and will be able implement these new skills successfully intoyour 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 become proficient in writing SQL queries
  • You will be able to validate and test database schema
  • You will have an in-depth understanding of advanced SQL concepts to test databases
  • JDBC ODBC Java programming knowledge to handle databases
  • You will ace SQL interviews with the included questions

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 12 minutes
Read More

Read More Reviews

Recommended for You

Learn Network Hacking From Scratch (WiFi and Wired) [Video] Book Cover
Learn Network Hacking From Scratch (WiFi and Wired) [Video]
€ 96.37
€ 9.73
Learn Network Hacking From Scratch (WiFi and Wired) [Video]
Apr 2018
5 hours and 56 minutes
€ 9.73
Learn Website Hacking / Penetration Testing From Scratch [Video] Book Cover
Learn Website Hacking / Penetration Testing From Scratch [Video]
€ 182.05
€ 9.74
Learn Website Hacking / Penetration Testing From Scratch [Video]
Apr 2018
9 hours and 6 minutes
€ 9.74
Learn Ethical Hacking From Scratch [Video] Book Cover
Learn Ethical Hacking From Scratch [Video]
€ 186.81
€ 9.73
Learn Ethical Hacking From Scratch [Video]
Apr 2018
12 hours and 40 minutes
€ 9.73
Learn Social Engineering From Scratch [Video] Book Cover
Learn Social Engineering From Scratch [Video]
€ 182.05
€ 9.74
Learn Social Engineering From Scratch [Video]
Apr 2018
12 hours and 1 minute
€ 9.74
Learn Hacking Using Android From Scratch [Video] Book Cover
Learn Hacking Using Android From Scratch [Video]
€ 96.37
€ 9.73
Learn Hacking Using Android From Scratch [Video]
Apr 2018
4 hours and 15 minutes
€ 9.73
Learn Database Design with MySQL [Video] Book Cover
Learn Database Design with MySQL [Video]
€ 39.25
€ 7.85
Learn Database Design with MySQL [Video]
Apr 2018
6 hours and 14 minutes
€ 7.85