Learning Path
Database / SQL
In this course, you will learn to create relational databases, write SQL statements to extract data to fulfill the business logic requests, create entity relationship diagrams (ERDs) to design schema, and analyze table designs for excessive redundancy.
Course curriculum
Module 1: Tutorials - PDF
- 1.1 DATABASES SQL
- 1.1 Normalization
- 1.1 SQL Join
- 1.1 Schema
- 1.1 PL/SQL
- 1.1 Database Testing
Module 2: DB Introduction and Concepts - Videos
- 2.1 Database Introduction
- 2.1 DBMS Intoduction
- 2.1 Understanding FrontEnd and BackEnd
- 2.1 DBMS Architecture
Module 3: Data Models and Related Concepts
- 3.1 DATA Models
- 3.1 E-R Model
- 3.1 Attributes in E-R Model
- 3.1 Types of Entity
- 3.1 Cardinality
- 3.1 Relational Data Model
- 3.1 DBMS vs RDBMS
- 3.1 DBMS Keys
Module 4: Normalization Concepts
- 4.1 DataRedundancy
- 4.1 Database Anamolies
- 4.1 Normalization Introduction
- 4.1 2 Normal Form
- 4.1 3 Normal Form
Module 5: ACID
- 5.1 ACID Property
Module 6: SQL
- 6.1 SQL Introduction
- 6.1 Getting Started with SQL
- 6.1 Create Database
- 6.1 Create Table in DB
- 6.1 Insert Values in Table
- 6.1 Show Table
- 6.1 SQL Select Statement
- 6.1 SQL Clauses
- 6.1 SQL Like Command
- 6.1 SQL Join Introduction
- 6.1 SQL Join Query
Module 7: Practice Lab - DDL
- 7.1 Create Database
- 7.1 Create Table
- 7.1 Alter Table
Module 8: Practice Lab - DML
- 8.1 Select statement
- 8.1 Select Distinct
- 8.1 SQL Where
- 8.1 SQL AND Clause
- 8.1 SQL OR Clause
- 8.1 SQL AND & OR Clause
- 8.1 SQL ORDER BY Clause
- 8.1 SQL LIMIT Clause
- 8.1 SQL LIKE
- 8.1 SQL Wildcards
- 8.1 SQL IN
- 8.1 SQL BETWEEN
- 8.1 SQL Aliases
- 8.1 SQL JOIN
- 8.1 SQL INNER JOIN
- 8.1 SQL LEFT JOIN
- 8.1 SQL RIGHT JOIN
- 8.1 SQL FULL OUT JOIN
- 8.1 SQL UNION
- 8.1 SQL INSERT
- 8.1 SQL UPDATE
- 8.1 SQL DELETE
Module 9: Practice Lab - SQL Functions
- 9.1 SQL AVG()
- 9.1 SQL COUNT()
- 9.1 SQL MAX()
- 9.1 SQL MIN()
- 9.1 SQL SUM()
- 9.1 SQL GROUP BY
- 9.1 SQL HAVING
Module 10: Checklist
- 10.1 Database/SQL checklist
Python For Testers
Course curriculum
Module 1: Python Introduction
- 1.1 What is Python Programming?
- 1.1 Python Installation
- 1.1 Download Links
Module 2: Python For Testers
- 2.1 Python First Program
- 2.1 Python Comments
- 2.1 Python Data Structure
- 2.1 Python Basic Codes
- 2.1 Python Data Types - Numbers
- 2.1 Python Data Types - Boolean
- 2.1 Python Data Types - Strings
- 2.1 Python Data Types - Lists
- 2.1 Type Casting in Python
- 2.1 Looping Statements in Python - For Loop
- 2.1 Looping Statements in Python - While Loop
- 2.1 Conditional Statement in Python (if-elif-else)
- 2.1 Arithmetic Operators in Python
- 2.1 Comparison Operators in Python
- 2.1 Logical Operators in Python
Java for Automation Testing
Java for tester course is designed for Software tester who want to switch from Manual testing to Automation testing with Selenium tool or want to start the career in Software testing field. In this course, you will get the concepts and knowledge of different topics, APIs and libraries of Java what will help you in Automation testing with Selenium.
Course curriculum
Module 1: Java Introduction
- 1.1 What is Java?
- 1.1 Download Links
- 1.1 How Java Works?
Module 2: Installation and First Program
- 2.1 [PDF] - JAVA Setup
- 2.1 Setup JDK
- 2.1 Setup Eclipse IDE
- 2.1 Environment variable setup
Module 3: Basics of Java
- 3.1 main() Method in Java
- 3.1 System.out.println() in Java
- 3.1 Hello World in Java
- 3.1 Printing Multiple Text Lines
- 3.1 Identifiers in Java
- 3.1 Perform Mathematical Operations
- 3.1 Perform Mathematical Operations (with Variables)
- 3.1 Join Text With Text
- 3.1 Join Text With Text (with Variables)
- 3.1 Join Text With Numbers
- 3.1 Join Text With Numbers (with Variables)
- 3.1 Input Using ScannerClass
- 3.1 Basic of Java Practice Quiz
Module 4: Data Types in Java
- 4.1 Variables - (Data Types in Java)
- 4.1 Numeric DataType
- 4.1 String DataType
- 4.1 Boolean DataType
- 4.1 Type Casting in Java
- 4.1 Boolean DataType
- 4.1 Implicit Type Casting
- 4.1 Explicit Type Casting
- 4.1 Implicit Type Casting
- 4.1 Type Casting in Java
- 4.1 Explicit Type Casting
- 4.1 Boolean DataType
- 4.1 Implicit Type Casting
- 4.1 Explicit Type Casting
Module 5: Operator in Java
- 5.1 Arithmetic Operator
- 5.1 [code] Arithmetic Operator
- 5.1 Assignment Operators
- 5.1 [code]Assignment Operators
- 5.1 Relational Operators
- 5.1 [code]Relational Operators
- 5.1 Unary Operators
- 5.1 [code]Unary Operators
- 5.1 Bitwise Operators
- 5.1 [code]Bitwise Operators
- 5.1 Java Operator Practice Quiz
Module 6: Control flow
- 6.1 True False Condition
- 6.1 Control Statements
- 6.1 Control Flow
- 6.1 if Statement
- 6.1 [code] If Else
- 6.1 Nested if..else Statement
- 6.1 [code]Nested if..else statement
- 6.1 Switch Case in Java
- 6.1 [code]Switch Case in Java
- 6.1 Looping Statements in Java
- 6.1 For Loop in Java
- 6.1 [code]For Loop Example
- 6.1 [code]For Each Loop Example
- 6.1 While Loop Example
- 6.1 Program to create prime number
- 6.1 Pattern printing program
- 6.1 Java Control Practice Quiz
Module 7: OOPs (for Testing)
- 7.1 Object Creation
- 7.1 [code]Object Creation
- 7.1 Calling Class Examples
- 7.1 Importing Classes & Creating Objects
- 7.1 Constructor
- 7.1 this in Java
- 7.1 [Code] this
- 7.1 super keyword
- 7.1 [Code] Super
- 7.1 OOP Concepts in Java
- 7.1 Inheritance in Java
- 7.1 [Code] Inheritance
- 7.1 Interface in Java
- 7.1 [Code] Interface
- 7.1 Method overriding
- 7.1 Method overloading
- 7.1 Polymorphism in Java
- 7.1 [Code] Polymorphism
- 7.1 Access Modifiers in Java
- 7.1 [Code] Access Modifier
- 7.1 Abstract Classes in Java
- 7.1 [Code] Abstract Class
- 7.1 Encapsulation in Java
- 7.1 [Code] Encapsulation
- 7.1 Java OOPs Practice Quiz
Module 8: Array
- 8.1 Arrays in Java
- 8.1 Array concept
- 8.1 Initialization of array
- 8.1 Array input from user
- 8.1 Mutli-dimensional array
- 8.1 Sorting in Java
- 8.1 [code]Sorting in Java
- 8.1 Java Array Practice Quiz
Module 9: Exception Handling
- 9.1 Exception example
- 9.1 finally
- 9.1 Java Exception Practice Quiz
Module 10: File Handling
- 10.1 Write File
- 10.1 Create
- 10.1 Read
Module 11: Interview Questions
- 11.1 Question for tester