Course Objective:
To make our trainee expert in the following topics theoretically & practically.
- Commands
- Syntax
- Data Type
- CREATE Database
- ATTACH Database
- DETACH Database
- CREATE Table
- DROP Table
- INSERT Query
- SELECT Query
- Operators
- Expressions
- WHERE Clause
- AND & OR Clauses
- UPDATE Query
- DELETE Query
- LIKE Clause
- GLOB Clause
- LIMIT Clause
- ORDER By Clause
- GROUP By Clause
- HAVING Clause
- DISTINCT Keyword
- PRAGMA
- Constraints
- JOINS
- UNIONS Clause
- NULL Values
- ALIAS Syntax
- Triggers
- Indexes
- INDEXED By Clause
- ALTER Command
- TRUNCATE Command
- Views
- Transactions
- Subqueries
- AUTOINCREMENT
- Injection
- EXPLAIN
- VACUUM
- Date & Time
- Useful Functions
Note- We train our trainee until they are satisfied.
