SQL Step by Step Videos

A beginner’s guide to SQL

SQL Step by Step Videos, Introduction to SQL, SQL Data Definition Language, SQL Data Manipulation Language, and SQL Data Control Language. SQL Knowledge is required for Database Developers, Database Administrators, and Database Testers (Manual Testers and Automated Testers). SQL (Structured Query Language) is a domain-specific language used for storing, manipulating and retrieving data in databases. … Read more

SQL Functions

SQL Functions

SQL Functions, Structured Query Language Fundamentals, Aggregate Functions, String Functions, Date & Time Functions, and SQL Scalar functions. SQL Built-in Functions A function is a database object in Sql Server. Basically, it is a set of SQL statements that accepts only input parameters, performs actions and returns the result. The function can return only a … Read more

Database Fundamentals

Database Fundamentals

Relational Database Fundamentals, Database Object, What is Database?, Database server, Database Management System, and Types of Databases. SQL or Relational Database Fundamentals for Database Developers, Database Administrators, and Database Testers. Database Fundamentals 1. What is Data? In computing, data is information that has been translated into a form that is efficient for movement or processing. … Read more

Data Definition Language

Data Definition Language

Data Definition Language, SQL Fundamentals, Subsets of SQL, Create a Database, Use Database, Drop Database, Create a Table, and Drop a Table. Data Definition Language (DDL) SQL (Structured Query Language) is for Database Developers, Database Administrators, and Database testers. Three main subsets of SQL: i) Data Definition Language ii) Data Manipulation Language iii) Data Control … Read more

Domain Knowledge for Software Testers

Domain Knowledge for Software Testers

Domain Knowledge for Software Testers, Banking Domain Knowledge, Insurance Domain, ERP Domain Knowledge, and Healthcare Domain Knowledge. Domain Knowledge is required for Software Testers, Software Developers, and Business Analysts. Domain Knowledge for Software Testers 1. Banking Domain Knowledge for Testers Banking Domain Knowledge for Testers, What is Banking, Types of Banks, Types of Bank Accounts, … Read more

SQL Brochure

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 … Read more