Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Learn SQL in Practical + DataBase Testing from Scratch
Introduction to SQL and DataBase Testing
Course FAQ's (Must watch) (10:12)
Introduction to DataBase (9:55)
Introduction to SQL and MySQL (6:27)
Downloading MySQL server with workbench (7:29)
Overview of SQL Editor with basic features (5:26)
SQL basic Material for reference
SQL Start up commands to Setup Database and Tables
Agile Scrum Master certification course coupon
creating Database and pointing to it (4:47)
Creating Tables in database (8:01)
Inserting records into Table (7:55)
Retrieving records from the Table (6:22)
SQL commands glossary on discussed Topics
Altering Table Schema operations
Adding and modifying records in a table (6:57)
Deleting records and droping database (4:48)
Updating rows in a table (7:32)
Modifying operations example (5:55)
SQL Glossary on discussed topics
Getting Started with Queries to retrieve Data
Select Distinct keyword in queris (6:50)
SQL WHERE command usage (9:27)
Logical operators on Queries AND OR - 1 (7:07)
Logical operators 'In' 'Between'- 2 (8:37)
Regular expressions Introduction (7:18)
Wild cards usage in Qeuries -1 (8:04)
SQL glossary on discussed topics
Advanced SQL Concepts - 1
SORT by usage in Queries (5:23)
SQL Functions Introduction with real time scenarios (8:53)
SQL Functions Part - 2 (6:58)
Importance of Group By in SQL (8:50)
Combonation of GroupBy and SQL functions (6:26)
Practical Examples on Group By (4:51)
SQL glossary on discussed topics
Advanced SQL Concepts -2
SubQueries syntax and usage (8:08)
SubQueries Example (6:07)
SQL Joins usage and its advantages (5:46)
SQL Joins Example (7:30)
Relation on subqueries and Joins (9:34)
Practical examples on Joins and subqueries (10:25)
Importance of views in Database (7:55)
views example on Database (7:18)
String functions - 1 (9:23)
String functions - 2 (3:43)
String functions -3 (6:11)
SQL glossary on discussed topics
Dataconstraints with DataBase Testing perspective
NOT NUll constraint -1 (6:12)
Not Null Constraint Validations and Testing - 2 (8:10)
Default Constraint Validations and Testing - 3 (6:28)
Unique Constraint Validations and Testing - 4 (5:43)
Primary Key Constraint validaton and Testing -5 (9:45)
SQL glossary on discussed topics
Practise Exercises for Interviews with Solutions
Practise Practise Practise !!! (4:54)
Practise Exercise/Interview Questions- 1
Practise Exercise/Interview Questions- 2
Solutions for Exercise - 1
Solutions for Exercise -2
JDBC Connectivity for Integration with Selenium (Basic Automation knowledge required)
Jdbc odbc programming-Creating Project (7:03)
Creating Database Tables and connecting to Jdbc java code (16:48)
Retrieving data from Database with Java code (7:39)
jdbc code download
SQL Injection
What is SQL Injection (7:32)
How to identify SQL loop holes in web application (13:19)
Exposing Security loop holes with malcious SQL syntax (9:20)
List of urls Pattern which can cause attack with SQL (7:34)
Material for reference
SQL Functions Introduction with real time scenarios
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock