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.)

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)

0 comments:

Post a Comment