Software Testing Videos (Manual, Selenium, UFT, SQL, and Java)
SQL Brochure
1) SQL Introduction
• History
• Purpose
2) Database Fundamentals
• Data
• Database
• Table
• Record
3) Database Management Systems
• Hierarchical Model
• Network Model
• Relational Model
4) SQL Syntax
5) Overview of SQL Language Elements
• Identifiers
• Data Types
• Operators
• Functions
• Clauses
• Expressions
• Queries
• Statements
6) SQL Data Types
• Exact Numeric Data Types
• Approximate Numeric Data Types
• Data & Time Data Types
• Character String Data Types
• Binary Data Types
• Other Data Types
7) SQL Operators
• Arithmetic Operators
• Comparison Operators
• Logical Operators
• Operators used to negate conditions
8) SQL Functions
• Aggregate Functions
• String Functions
• Date Functions
9) Subsets of SQL
• Data Definition Language
• Data Manipulation Language
• Data Control Language
10) Data Definition Language
• Create Databases, Tables
• Alter Databases, Tables
• Drop
• Truncate
• Comment
• Rename
11) Data Manipulation Language
• Select
• Insert
• Update
• Delete
12) Data Control Language
• Grant
• Revoke
• Deny
13) SQL Keys
• Super Key
• Primary Key
• Foreign Key
• Composite Key
• Unique Key
• Alternate Key
13) SQL Queries
• Expressions
• Clauses
• Sub Queries
14) SQL Joins
• Self Join
• Inner Join
• Outer Join
• Cross Join
15) SQL Views
• Create Views
• Modify Views
• Drop Views
• Advantages & Disadvantages of Views
16) Normalization
• First Normal Form
• Second Normal Form
• Third Normal Form
• Boyce and Codd Normal Form (BCNF)
17) SQL Security
18) Database Development
19) Database Testing
20) Database Administration (DBA)
Note: SQL is for Database Developers, Database Testers, and Database Administrators.
Database Testing can be done in ways,
1) Manual Testing
2) Automated Testing,
for these two scenarios SQL Knowledge is mandatory.
Also Read: