Tutor Brief :-
Shilpa Jain has 10+ year of experience in imparting Training to variety of audience and for 5+ Years delivering in various domain to corporate.
Trained more than 3,000 professional & Trainees on various technologies with flair of handling queries/escalations from trainees.
Working as Freelance Corporate Trainer – nearly 5 Years now Working as Freelance Data analyst– nearly 2 Years now Professional Experience
CERTIFICATION
-
MICROSOFT OFFICE SPECIALISTS (2013, 2016)
-
GOOGLE SHEETS SPECIALISTS
-
CIA COURSE CERTIFICATION FROM INSTITUTE OF COMPUTER ACCOUNTANT
-
B.COM – VIVEKANANDA COLLEGE (DELHI UNIVERSITY)
Topics to be Covered
1. SQL ─ Overview
2. SQL ─ RDBMS Concepts
3. SQL ─ RDBMS Databases
4. SQL – Syntax
5. SQL ─ Data Types
6. SQL – Operators
7. SQL – Expressions
8. SQL – CREATE Database
9. SQL ─ DROP or DELETE Database
10. SQL ─ SELECT Database, USE Statement
11. SQL ─ CREATE Table 1
2. SQL ─ DROP or DELETE Table
13. SQL ─ INSERT Query
14. SQL ─ SELECT Query
15. SQL ─ WHERE Clause
16. SQL ─ AND & OR Conjunctive Operators
17. SQL ─ UPDATE Query
18. SQL ─ DELETE Query
19. SQL ─ LIKE Clause
20. SQL ─ TOP, LIMIT or ROWNUM Clause
21. SQL ─ ORDER BY Clause
22. SQL ─ Group By
23. SQL ─ Distinct Keyword
24. SQL ─ SORTING Results
25. SQL ─ Constraints
26. SQL ─ Using Joins
27. SQL ─ UNIONS CLAUSE
28. SQL ─ NULL Values
29. SQL ─ Alias Syntax
30. SQL – Indexes
31. SQL ─ ALTER TABLE Command
33. SQL ─ Using Views
Total No. of Classes - 20
Available Days - Monday, Wednesday & Friday
