BASIC SQL CLASS (Vimeo Links).
| S.no | Video | Vimeo Link | Password | Topic Description |
| 1 | Class-1 | https://vimeo.com/285140850 | sql | Introduction to DBMS. What is SQL? History of SQL? Features of SQL? What are Codd Rules? |
| 2 | Class-2 | https://vimeo.com/285330531 | sql | Oracle installation on windows platform. Explanation about codd rules. |
| 3 | Class-3 | https://vimeo.com/286653538 | sql | Data Retrieval Language. select statement and SQL operators. |
| 4 | Class-4 | https://vimeo.com/286653605 | sql |
Data Definition Language.
Statements Create,Alter,Rename,Truncate and Drop. |
| 5 | Class-5 | https://vimeo.com/286653644 | sql |
Data Manipulation Language
Statements INSERT,UPDATE and DELETE. Transaction Control Language. Statement COMMENT,ROLLBACK,SAVEPOINT. Data Control Language. Statement GRANT,REVOKE. |
| 6 | Class-6 | https://vimeo.com/286653935 | sql | What Is Joins? Introduction about joins . |
| 7 | Class-7 | https://vimeo.com/286917115 | sql | DATABASE OBJECTS LIKE views. |
| 8 | Class-8 | https://vimeo.com/287770809 | sql |
What is Object?
What is Database Object? Space demanding objects and No-Space demanding objects. Types of Database objects?? What is a view?? Advantages of View?? Types of views?? How to create a view?? Demo on view. |
| 9 | Class-9 | https://vimeo.com/287771449 | sql | Functions |
| 10 | Class-10 | https://vimeo.com/288287775 | sql | Function class -2, Multiple row functions. Group by clause. |
| 11 | class-11 | https://vimeo.com/288724281 | sql | What is a Constraints ? Types of constraints? Unique key Not Null Primary Key Foreign key Check . |
Note: Please test scripts in Non Prod before trying in Production.
Loading...
