Breif Contents

1. Difference between Liner & Non Liner Databases
2. What is No SQL Database, What is ATL32-U Database, Object Oriented Database
3. How to Setup Virtual Machine, How to Install Database on Windows Environment
4. How to Install Database on Linux Environment, How to Test Database after installation
5. Trouble Shooting of Database During Installation
6. Introduction of Data Structure, Introduction of Table Structure
7. Select Statement, Database Keys, Distinct Statement, Joining of Tables
8. Null Values, NVL Values, Table Alias
9. Identification of Data, Identification of Primary & Foreign Key
10. Arithmetic Expressions, Add Running Total, Add Union Intersections
11. Null If Function, Data Sorting, To Date & Automatic Date Calculations Formulas
12. Introduction of Sub Query, Return Single Row from Sub Query,
13. Return Multiple Row from Sub Query, Where Claus in Sub Query ,
14. Inner Joins, Outer Joins,
15. Conversion of Data, Conversion of Data Num To Char, Conversion of Dates
16. What is Aggregation Rule, What is Group by & Having Functions
17. Applying Aggregation Rules, Applying Group by Functions, Apply Having Function
18. Use Multiple Tables in Group By Function, Conversion of Data,
19. Conversion of Data Num To Char, Sorting of Data, Order By of Data
20. Introduction of Tables, Creation of Tables, Update Table Columns, Drop Table Columns
21. How to Define Primary Key, How to Define Foreign Key
22. What is Star Schema, How to Build Star Schema, How to Drop Table
23. Update of Data in Tables, Insert of Data in Tables, Introduction of Sequences
24. How to Build Auto Incremental Columns, How to Build Sequence in Table Columns
25. What is Loop Functionality, How to Insert Data in Tables through Loop Functionality
26. How to Update Data in Tables Through Loop, How to Delete Data from Tables
27. How to Clone Tables, How to Fetch Query from Multiple Databases Tables
28. How to Display all Tables in User, How to Check Table Space,
29. How Count Rows of Tables, Rownum Function in Tables, Introduction of Functions
30. Type of Functions, How to Build Function in Database, How to Run Function in Database
31. How to use Data Types in Functions, Method to Create Function, Method to Alter Functions
32. Purpose of Functions, Method to Call Function in Database Query
33. How to Optimize Query Through Functions
34. Introduction of Data Views, De-Normalize Table Data in Views, Hierarchy of Views
35. Method to Create Data Views, Method to Alter Data Views,
36. What is Procedure, Why we use Procedures, How to Build Procedure
37. Insert, Update & Delete Data Through Procedure
38. Alteration of Procedure, Drop Procedures
39. What is Package, How to Build Package, Purpose to Build Package
40. How to Send E-Mail Through Database Package
41. List of Major Architecture Components of Database, Explain the Memory Structures
42. Describe the Background Process, Correlate the Logical and Physical Storage Structures
43. What are Database Management Tools, How to Use Database Management Tools
44. Download Latest Laravel Framework via ComposerHow to Install Database Management Tools, Start & Shut Down Database Services
45. Difference Between Immediate Start/Shutdown & Immediate Start/Shutdown Services
46. View Database Logs, What is Network Environment,
47. How to Configure Network Environment
48. What is TNS Listener, How to Configure TNS Listener,
49. Trouble Shooting of TNS Listener Services
50. How to Configure Network Side Configurations
51. What is Table Space, What is Table Partition, How to Manage Table Spaces
52. What is Undo Data, How to Apply Patches on Database,
53. Difference Between Undo & Redo Data, Space Management of Databases
54. Managing Database Roles, Changing Database Privilege
55. Database Compressions, Describing the Locking Mode, Unlocking of Data
56. Release of Expired Users, Database Backup Description, How to Backup Database
57. How to Restore Database Through Dumps, Backup Database without shutting it down
58. Generate Database Alerts, Small Briefing of Database Auditing
59. What is Database Patch, How to Download & Apply Database Patches
60. What is Database Scheduler, Create Schedule of Database Jobs,
61. Use Task Manager for Database Scheduler, Cloning of Database, Duplication of Database
62. Move Database From One Server to Another Server
63. Introduction of RMAN, How to Use RMAN from SQL Plus,
64. How to Connect Database with RMAN, Use SQL in RMAN
65. What is Recovery Catalog, How to Configure Recovery Catalog in RMAN
66. How to Generate Scripts for Recovery Catalog in RMAN, Export & Import Recovery Catalog
67. What is Data backup Through RMAN,
68. Create Backup Plan Strategy using RMAN Database Backup
69. Configuring Fast Recovery Data, How to Use Incremental Backup
70. Manage Backups, Backup Database on No Archive & Archive Mode
71. How to Backup Non-Database Files, Secure Backup
72. Cloning of Database Using RMAN, Duplication Database using RMAN,
73. CDB & PDB Database Management, What is Flash Recovery of Database
74. Use Flashback Query, Use Flashback Table Operations,
75. Recover Table Data From Flashback Recovery,
76. Recover Columns Data from Flashback Recovery
77. Restore Table from Recycle Bin, Manage Pluggable & Container Database
78. Manage Security of Database Through RMAN
79. Database Audit Concepts, Database Security Auditing
80. Generate Database Documentation From Database Tools
81. Auditing of User Privileges, Checking of Login Audits, Checking of Unused Spaces
82. Audit of Unused Memory , Query Optimization & runtime