1) SQL Introduction
• History
• Purpose
2) Database Fundamentals
• Data
• Database
• Table
• Record
3) Database Management Systems
• Hierarchical Model
• Network Model
• Relational Model
4) SQL Syntax
5) Overview of SQL Language Elements
• Identifiers
• Data Types
• Operators
• Functions
• Clauses
• Expressions
• Queries
• Statements
6) SQL Data Types
• Exact Numeric Data Types
• Approximate Numeric Data Types
• Data & Time Data Types
• Character String Data Types
• Binary Data Types
• Other Data Types
7) SQL Operators
• Arithmetic Operators
• Comparison Operators
• Logical Operators
• Operators used to negate conditions
8) SQL Functions
• Aggregate Functions
• String Functions
• Date Functions
9) Subsets of SQL
• Data definition Language
• Data Manipulation Language
• Data Control Language
• Create Databases, Tables
• Alter Databases, Tables
• Drop
• Truncate
• Comment
• Rename
11) Data Manipulation Language
• Select
• Insert
• Update
• Delete
12) Data Control Language
• Grant
• Revoke
• Deny
13) SQL Keys
• Super Key
• Primary Key
• Foreign Key
• Composite Key
• Unique Key
• Alternate Key
13) SQL Queries
• Expressions
• Clauses
• Sub Queries
14) SQL Joins
• Self Join
• Inner Join
• Outer Join
• Cross Join
15) SQL Views
• Create Views
• Modify Views
• Drop Views
• Advantages & Disadvantages of Views
16) Normalization
• First Normal Form
• Second Normal Form
• Third Normal Form
• Boyce in addition to Codd Normal Form (BCNF)
17) SQL Security
18) Database Development
19) Database Testing
20) Database Administration (DBA)
---------------------------------------------------------
Note: SQL is for Database Developers, Database Testers, in addition to Database Administrators.
Database Testing tin strength out survive done inwards ways,
1) Manual Testing
2) Automated Testing,
for these ii scenarios SQL Knowledge is mandatory.
---------------------------------------------------------------
Also Read:
SQL Interview Questions in addition to Answers
SQL Tutorials