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 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
MS SQL Server