SQL Step by Step Tutorials

SQL Step by Step Tutorials
SQL for Software Testers
1) SQL Tutorial 1: Introduction to SQL

(Structured Query Language Commands and Operations, What is SQL?, Purpose of SQL, Who Should Learn SQL?, Subsets of SQL, Data Definition Language, Data Manipulation Language and Data Control Language. SQL Introduction for Database Developers, Database Administrators and Database Testers)

2) SQL Tutorial 2: SQL Overview

(Overview of SQL, Structured Query Language Syntax, SQL Data Types, SQL Operators, SQL Built in Functions, SQL Queries and Sub Queries. Data Definition Language, Data Manipulation Language and Data Control Language Commands.)

3) SQL Tutorial 3: SQL Environment Setup / MS SQL Server Installation

(MS SQL Server Express Edition Installation , Download and Install SQL Server for practicing SQL Commands. Download SQL Server or Oracle or MySQL Database Engine, and Install. Launch SQL Server Management studio, Select New Query, and launch SQL Query. Type SQL Commands and Execute.)

4) SQL Tutorial 4: Database Fundamentals, SQL Elements

(Database Fundamentals, Database Server, Database Objects, Database management systems, Types of DBMS, and Advantages of Relational Database management System. SQL Language Elements, SQL Identifiers, Constants, SQL Data Types, SQL Operators, SQL Functions, SQL Clauses, SQL Queries, and SQL Statements. Install Database Engine, Launch SQL Query Editor, and Write & Execute SQL Commands.,)

5) SQL Tutorial 5: Data Definition Language 

(Overview of Database Management System, Database engine, Database Server, Databases and Tables & Records. 
Subsets of Structured Query Language, Data Definition Language, Data Manipulation Language, and Data Control Language.
SQL - Data Definition Language Commands and Operations, DDL Create, Alter, Rename, Truncate, and Drop Commands.
Data Definition Language Operations, Create a Database, Use Database, Rename a Database, Drop Database, Create a Table, Rename Table, Add a Column to exiting Table, Add Multiple columns to existing Table, Modify an existing column, Rename a Column, Drop a Column, Truncate a Table, and Drop a Table.)

6) SQL Tutorial 6: Data Manipulation Language

(Structured Query Language subsets, Data Definition Language, Data Definition Language, and Data Control Language. DML (Data Definition Language) Commands and Operations, Select, Insert Into, Update, and Delete. SQL for Database developers, Database Testers, and Database Administrators.)

7) SQL Tutorial 7: SQL Operators

(SQL Operators, Arithmetic Operators, Comparison Operators, Compound Operators, and Logical Operators. SQL Operators examples with SQL Where clause to form single and multiple Conditions.)

8) SQL Tutorial 8: The Select Query 

(SQL Select Query examples, Create a Database, Create a Table, Enter Some Records into the Table, Write select Statement to fetch all Records from a table, Write a Select statement to fetch some columns from a table, SQL Where Clause, write condition in Select Statements using Where clause, and write multiple conditions in Select statements using where clause & SQL Logical operator like And & Or.)

9) SQL Tutorial 9: SQL Joins

(SQL Query Examples for Database Developers, Create a Database, Create Tables in the Database, Insert Records, and retrieve data by joining two or more tables.)

SQL Interview Questions and Answers

(SQL Interview Questions and Answers on RDBMS Fundamentals, SQL Syntax, SQL Data Types, SQL Operators, SQL Functions, Data Definition Language, Data Manipulation Language, and Data Control Language)


hello sir, kindly send me the banking domain real time ETL testing test cases.

Sir you are incredible. Simple, transparent, details, organized, highly efficient, focused and high professional. You are an icon in my eyes.

Post a Comment