SQL Brochure


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
SQL
10) Data Definition 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 and 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, and Database Administrators.

Database Testing can be done in ways,
1) Manual Testing
2) Automated Testing,
for these two scenarios SQL Knowledge is mandatory. 
---------------------------------------------------------------
Also Read:

SQL Interview Questions and Answers

SQL Tutorials

0 comments:

Post a Comment