English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 6h 13m | 1.29 GB
Every IT Job needs SQL Knowledge, and this course fulfills that requirement by teaching everything from scratch
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.
On course completion, You will be Mastered in SQL Language with DataBase Testing and can implement Successfully it in your workplace.
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
Table of Contents
Introduction to SQL and Database Testing
1 Course FAQ’s
2 Introduction to Database
3 Introduction to SQL and MySQL
4 Downloading MySQL server with workbench
5 Overview of SQL Editor with basic features
SQL Injection – Database Security Testing#
6 What is SQL Injecting
7 How to identify SQL loop holes in web application
8 Exposing Security loop holes with malicious SQL syntax
9 List of urls Pattern which can cause attack with SQL
Getting Started with Queries to retrieve Data
10 Creating Database and pointing to it
11 Creating Tables in Database
12 Inserting records into Table
13 Retrieving records from the Table
Altering Table Schema operations
14 Adding and modifying records in a table
15 Deleting records and dropping Database
16 Updating rows in a table
17 Modifying operations example
Getting Started with Queries to retrieve Data#
18 Select distinct keyword in queries
19 SQL WHERE command usage
20 Logical operators on Queries AND OR – 1
21 Logical operators ‘In’ ‘Between’- 2
22 Regular expressions Introduction
23 Wild cards usage in Queries -1
Advanced SQL Concepts – 1
24 SORT by usage in Queries
25 SQL Functions Introduction with real time scenarios
26 SQL Functions Part – 2
27 Importance of Group By in SQL
28 Combination of GroupBy and SQL functions
29 Practical Examples on Group By
Advanced SQL Concepts -2#
30 SubQueries syntax and usage
31 SubQueries Example
32 SQL Joins usage and its advantages
33 SQL Joins Example
34 Relation on subqueries and Joins
35 Practical examples on Joins and subqueries
36 Importance of views in Database
37 Views example on Database
38 String functions – 1
39 String functions – 2
40 String functions – 3
Dataconstraints with Database Testing perspective#
41 NOT NUll constraint -1
42 Not Null Constraint Validations and Testing – 2
43 Default Constraint Validations and Testing – 3
44 Unique Constraint Validations and Testing – 4
45 Primary Key Constraint validation and Testing -5
Practise Exercises for Interviews with Solutions
46 Practise Practise Practise !!!
JDBC Connectivity for Integration with Selenium (Basic Automation Knowledge req#
47 Jdbc odbc programming-Creating Project
48 Creating Database Tables and connecting to Jdbc java code
49 Retrieving data from Database with Java code
Resolve the captcha to access the links!