SQL Training
IT Techmania is the Best Institute for SQL Training in Pathankot. This course is specifically designed for students of 15 years and above. In this course, student learns about Fundamentals of SQL using MYSQL that is required for developing backend for applications. Students, Job seekers, working professionals can join this course. We provide 100% practical based training of the course so that trainee becomes eligible for any database related job.
ELIGIBILITY
- Minimum 14 Years of Age
COURSE CONTENT
1. Basics of SQL
2. Types of SQL Statement
3. DDL statements
- Create
- Alter
- Drop
4. DML statements
- Select
- Insert
- Update
- Delete
5. TCL statements
- Commit
- Rollback
- Savepoint
6. DCL statements
- Grant
- Revoke
7. SQL Operators
8. Strings Functions
9. Mathematical Functions
10. Date Functions
11. Aggregate Functions
12. Clauses
- Where
- Order by
- Distinct
- In
- Between
- Like
- Group by
- Having
- Exists
- Any
- All
- Null
- AutoIncrement
13. Constraints
- Not Null
Unique - Primary Key
- Foreign Key
- Check
- Default
14. Joins
- Equi Join
- Non-Equi Join
- Natural Join
- Inner Join
- Outer Join
- Left Join
- Right Join
- Full Join
15. Stored Procedures
- Functions
- Subroutines
- Variables
- Literlas
- Control Structures
- Cursor
- Trigger
- Exception Handling
CRITERIA
- Student may choose this course to understand SQL in detail.
DURATION
- 2 Months.
ADVANTAGES OF COURSE
- Ready for database jobs.
- School/College Projects can be easily developed.