Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Skillshare Database Management System(DBMS) and Commands of SQL/Qracle with real life example.

Video Introducing this tutorial

1. Lecture 1: Introduction
2. History of Traditional File Based System
3. Introduction to Database Management System(DBMS)?
4. Database Approach and Advantages
5. Database Users
6. Data Modals
7. Why we need a Key?
8. Super Key
9. Primary key
10. Alternate key
11. Foreign key
12. Candidate key
13. Introduction to SQL
14. Components of SQL
15. Standard and Best Practices of SQL
16. Data Types Used in SQL
17. Introduction to Data Defination Language(DDL)
18. CREATE COMMAND:CONCEPT
19. CREATE COMMAND:CODE
20. CONSTRAINTS while Creating a Table
21. CONSTRAINTS on CREATE COMMAND:CODE
22. Foreign Key CONSTRAINTS:CODE
23. ALTER COMMAND:CONCEPT
24. ALTER COMMAND:CODE
25. TRUNCATE COMMAND:CONCEPT
26. TRUNCATE COMMAND:CODE
27. DROP COMMAND:CONCEPT
28. TRUNCATE VS DROP COMMAND
29. Introduction to Data Manipulation Language(DML)
30. INSERT COMMAND:CONCEPT
31. INSERT COMMAND :CODE
32. UPDATE COMMAND:CONCEPT
33. UPDATE COMMAND:CODE
34. DELETE COMMAND:CONCEPT
35. DELETE COMMAND:CODE
36. DELETE VS TRUNCATE
37. Introduction to Transaction Control Language(TCL)
38. Transaction Control Language(TCL) Commands: SAVEPOINT ,ROLLBACK AND COMMIT
39. LOCKING: IMPLICIT AND EXPLICIT
40. Introduction to Data Control Language(DCL)
41. GRANT COMMAND:CONCEPT AND CODE
42. REVOKE COMMAND :CONCEPT AND CODE
43. Introduction to JOINS
44. Cartesian Product Vs JOINS
45. EQUI JOIN
46. OUTER JOIN
47. LEFT OUTER JOIN
48. RIGHT OUTER JOIN
49. FULL OUTER JOIN
50. NATURAL JOIN
51. SELF JOIN
52. How to JOIN Multiple Tables?
53. Introduction to SUBQUERY
54. Types of SUBQUERY and Operators used for SUBQUERY