SQL Operators

SQL Operators

SQL Tutorial, SQL Language Elements, Arithmetic operators, Comparison operators, Logical operators, and usage of operators in SQL statements. SQL Operators An operator is a reserved word or a character used primarily in an SQL statement’s WHERE clause to perform an operation(s), such as arithmetic, comparisons, and Logical operations. Operators are used to specifying conditions in … Read more

Data Manipulation Language

Data Manipulation Language

SQL – Data Manipulation Language Data Manipulation Language (DML) is one of the Subsets of SQL, others are, i. Data Definition Language ii. Data Control Language etc… Database Engine is required to practice/execute SQL Commands, We can use Database Engine from Oracle or MS SQL Server or MySQL etc, I installed MS SQL Server Express … Read more

Introduction to SQL

Introduction to SQL

Introduction to SQL, What is SQL, Purpose of SQL, Who should learn SQL?, Subsets of SQL, SQL Language Elements, and SQL Environment Setup. Introduction to SQL 1. What is SQL? 2. Purpose of SQL 3. Who should learn SQL? 4. What are the subsets of SQL? 5. Data Definition Language 6. Data Manipulation Language 7. … Read more

SQL Tutorial

SQL Tutorial

SQL Tutorial for Beginners, SQL Language Elements, SQL Queries, Data Definition Language, Data Manipulation Language, and Data Control Language. SQL (Structured Query Language) is a standard language for storing, manipulating, and retrieving data in databases. SQL was initially developed at IBM in the 1970s, It became a standard of the American National Standards Institute (ANSI) … Read more

Software Testing Study Material

Software Testing Full Course Material

Software Testing Study Material, Software Test Levels, Software Test Types, Software Test Design Techniques, and Software Test Life Cycle. Software Testing Full Course Material 1.0. Software Development Life Cycle (SDLC) Software Development Life Cycle 2.1. SDLC Models – Waterfall Model Waterfall Model 2.2. SDLC Models – V Model V Model 2.3. SDLC Models – Spiral … Read more

SQL Tutorial for Beginners

SQL Tutorial

SQL Tutorial for Beginners, Data Definition Language, Data Manipulation Language, Data Control Language, and write SQL Queries & Subqueries. SQL (Structured Query Language) is a standard language for storing, manipulating, and retrieving data in databases. SQL was initially developed at IBM in the 1970s, It became a standard of the American National Standards Institute (ANSI) in 1986. SQL … Read more

SQL Syllabus

SQL Tutorial

SQL Syllabus, SQL can be used by Database developers to create & manipulate databases, Database Administrators for Database Administration, and Software Testers to conduct Database Testing. SQL (Structured Query Language) is a standard language for storing, manipulating, and retrieving data in databases. SQL was initially developed at IBM in the 1970s, It became a standard … Read more

SQL Online Test

SQL Online Practice Test 1) SQL (Structured Query Language) was initially developed at…… a) Micro Soft b) Oracle c) IBM d) HP 2) SQL is not used for…… a) Create New Databases b) Create New Tables in a Database c) Join Tables to Retrieve data d) Join Databases 3) Which is not a subset of … Read more