SQL Syllabus

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.

Database Testing

Database Testing Tutorial for Beginners

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.

Some common relational database management systems that use SQL are MySQL, MS SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, etc.

Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. ex: Pl/SQL in Oracle.

Subsets of SQL are Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).

SQL (Structured Query Language) Syllabus

1. Introduction to SQL

(What is SQL?, Purpose of SQL, Who should learn SQL?, What are the subsets of SQL?, Data Definition Language, Data Manipulation Language, Data Control Language, and SQL vs. NoSQL)

2. Introduction to Databases and RDMBS

(What is a Database?, Database Objects, Database Tables, Table Records, Types of Database Management Systems, Relational Database Management Systems, and SQL/Relational Databases vs. No SQL Databases)

3. Install a Database Engine

(Download MS 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 Syntax

(Focus on SQL Syntax, SQL keywords, SQL is not case sensitive, SQL Comments, SQL Commands, and writing SQL Statements.)

5. SQL Data Types

(SQL Numeric data types, Date and Time data types, Character and String data types, Unicode character string data types, Binary data types, and Miscellaneous data types.)

6. SQL Operators

(SQL Arithmetic Operators, Comparison Operators, Logical Operators, and Bitwise Operators)

7. SQL Expressions

(SQL Boolean Expression, SQL Numeric Expression, and SQL Date Expression)

8. SQL Comments

(SQL Comments, Comments are used to explain sections of SQL statements, or to prevent the execution of SQL statements. Single-Line Comments, and Multi-line Comments)

9. SQL – Data Definition Language Commands and Operations.

(SQL Data Definition Language Commands, Create, Alter, Drop, Truncate, and Rename.

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

10. SQL – Data Manipulation Language Commands and Operations

(Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE.

Data Manipulation Language Operations, Retrieving data from a table, Inserting data into a table, Updating existing data into a table, and Deleting all records from a table.)

13. SQL – Data Control Language Commands

14. DCL Operations

(Providing the users the access or privileges to the database objects, and Taking back or canceling the privileges or permissions previously allowed or denied to the users.)

15. SQL Functions

16. SQL Queries and Sub Queries

17. SQL Clauses

18. SQL Joins

19. SQL Views

20. SQL Indexes

21. SQL Transactions

22. SQL Injection

SQL vs. NoSQL

Note: This SQL Syllabus for Database Developers, Database Administrators, and Database Testers.


Popular Relational Database Management Systems

Oracle

MS Access

MS SQL Server

MYSQL

SyBase

DB2

DB/400

Etc.


Python Programming Language Syllabus
Java Programming Language Syllabus
Manual Testing Syllabus
Selenium Syllabus

G C Reddy

G C Reddy, Working as a Software Testing Trainer in Hyderabad, India.

You may also like...