O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Video Description

Every IT Job Needs SQL Knowledge. This Course Teaches All you Need to Know from Scratch

About This Video

  • You need no prior SQL knowledge to start this course
  • All installation and setup instructions, including database basics are part of the course
  • Theoretical material, code dump and interview guide are available for download

In Detail

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.

Table of Contents

  1. Chapter 1 : Introduction to SQL and Database Testing
    1. Course FAQ's 00:10:13
    2. Introduction to Database 00:09:56
    3. Introduction to SQL and MySQL 00:06:17
    4. Downloading MySQL server with workbench 00:07:29
    5. Overview of SQL Editor with basic features 00:05:26
  2. Chapter 2 : Getting Started with Queries to retrieve Data
    1. Creating Database and pointing to it 00:04:48
    2. Creating Tables in Database 00:08:01
    3. Inserting records into Table 00:07:55
    4. Retrieving records from the Table 00:06:22
  3. Chapter 3 : Altering Table Schema operations
    1. Adding and modifying records in a table 00:06:57
    2. Deleting records and dropping Database 00:04:48
    3. Updating rows in a table 00:07:33
    4. Modifying operations example 00:05:55
  4. Chapter 4 : Getting Started with Queries to retrieve Data
    1. Select distinct keyword in queries 00:06:50
    2. SQL WHERE command usage 00:09:28
    3. Logical operators on Queries AND OR – 1 00:07:07
    4. Logical operators 'In' 'Between'- 2 00:08:37
    5. Regular expressions Introduction 00:07:18
    6. Wild cards usage in Queries -1 00:08:04
  5. Chapter 5 : Advanced SQL Concepts – 1
    1. SORT by usage in Queries 00:05:24
    2. SQL Functions Introduction with real time scenarios 00:08:54
    3. SQL Functions Part – 2 00:06:59
    4. Importance of Group By in SQL 00:08:50
    5. Combination of GroupBy and SQL functions 00:06:26
    6. Practical Examples on Group By 00:04:51
  6. Chapter 6 : Advanced SQL Concepts -2
    1. SubQueries syntax and usage 00:08:08
    2. SubQueries Example 00:06:08
    3. SQL Joins usage and its advantages 00:05:47
    4. SQL Joins Example 00:07:31
    5. Relation on subqueries and Joins 00:09:35
    6. Practical examples on Joins and subqueries 00:10:26
    7. Importance of views in Database 00:07:56
    8. Views example on Database 00:07:18
    9. String functions – 1 00:09:23
    10. String functions – 2 00:03:43
    11. String functions – 3 00:06:11
  7. Chapter 7 : Dataconstraints with Database Testing perspective
    1. NOT NUll constraint -1 00:06:12
    2. Not Null Constraint Validations and Testing – 2 00:08:10
    3. Default Constraint Validations and Testing – 3 00:06:28
    4. Unique Constraint Validations and Testing – 4 00:05:43
    5. Primary Key Constraint validation and Testing -5 00:09:45
  8. Chapter 8 : Practise Exercises for Interviews with Solutions
    1. Practise Practise Practise !!! 00:04:54
  9. Chapter 9 : JDBC Connectivity for Integration with Selenium (Basic Automation Knowledge req
    1. Jdbc odbc programming-Creating Project 00:07:04
    2. Creating Database Tables and connecting to Jdbc java code 00:16:49
    3. Retrieving data from Database with Java code 00:06:46
  10. Chapter 10 : SQL Injection - Database Security Testing
    1. What is SQL Injecting 00:07:33
    2. How to identify SQL loop holes in web application 00:13:19
    3. Exposing Security loop holes with malicious SQL syntax 00:09:21
    4. List of urls Pattern which can cause attack with SQL 00:07:34