# README

![drawing](https://images.unsplash.com/photo-1483546416237-76fd26bbcdd1?crop=entropy\&cs=srgb\&fm=jpg\&ixid=MnwxOTcwMjR8MHwxfHNlYXJjaHwyfHxub3Rlc3xlbnwwfHx8fDE2MzM4ODU5NDA\&ixlib=rb-1.2.1\&q=85)

**Welcome to CDAC Notes**

| Core Java | Database Technologies | Data Structure | Operating System |
| --------- | --------------------- | -------------- | ---------------- |
| ☕         | 💾                    | ➿              | 🐧               |

#### ☕ Core Java

* [Intro, Features, JDK JRE](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#core-java--195introfeaturesjdkjre-)
* [OOPs,Major and Minor piller](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#205-oopsmajor-and-minor-piller)
* [Data Types, Memory Management, Constructor, this](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#215-data-types-memory-management-constructor-this)
* [Garbage Collector, Array](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#225-garbage-collector-array)
* [Association Relation, Wrapper Classes](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#2405-association-relation-wrapper-classes)
* [Packages,IDE](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#2505-packageside)
* [Inheritance,super(),Overriding, Dynamic Binding, Debug, Scanner](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#2605inheritancesuperoverriding-dynamic-binding-debug-scanner)
* [class objects, c-o overiding](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#275-class-objects-c-o-overiding)
* [Multilevel Inheritance,foreach, Abstraction, Access Specificer](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#285multilevel-inheritanceforeach-abstraction-access-specificer)
* [geter/seter,final,Interface](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#295geterseterfinalinterface)
* [typecast, instanceof, interface of java8](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#315typecast-instanceof-interface-of-java8)
* [Exception Handling](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Core%20Java#exception-handling)

#### 💾 Database Technologies

* [Agenda](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#agenda)
* [DBMS](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#dbms)
* [RDBMS](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#rdbms)
* [SQL](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#sql)
* [MySQL](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#mysql)
  * [Getting started with MySQL](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#getting-started)
  * [Database logical layout](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#database-logical-layout)
  * [Database physical layout](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#database-physical-layout)
  * [MySQL data types](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#mysql-data-types)
  * [CHAR vs VARCHAR vs TEXT](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#char-vs-varchar-vs-text)
  * [INSERT – DML](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#insert--dml)
  * [SQL scripts](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#sql-scripts)
  * [SELECT – DQL](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#select--dql)
    * [SELECT – DQL – ORDER BY](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#select--dql--order-by)
    * [SELECT – DQL – WHERE](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#select--dql--where)
  * [UPDATE – DML](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#update--dml)
  * [DELETE – DML vs TRUNCATE – DDL vs DROP – DDL](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#delete--dml-vs-truncate--ddl-vs-drop--ddl)
  * [Seeking HELP](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#seeking-help)
  * [DUAL table](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#dual-table)
  * [SQL functions](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#sql-functions)
    * [Numeric & String functions](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#numeric--string-functions)
    * [Date-Time and Information functions](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#date-time-and-information-functions)
    * [Control and NULL and List functions](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#control-and-null-and-list-functions)
    * [Group functions](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#group-functions)
  * [GROUP BY clause](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#group-by-clause)
  * [# Transaction](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#-transaction)
  * [Row locking](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#row-locking)
  * [Entity Relations](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#entity-relations)
    * [Cross Joins](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#cross-joins)
    * [Inner Join](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#inner-join)
    * [Left Outer Join](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#left-outer-join)
    * [Right Outer Join](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#right-outer-join)
    * [Full Outer Join](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#full-outer-join)
    * [Set Operators](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#set-operators)
    * [Self Joins](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#self-joins)
    * [Multi-table Joins](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#multi-table-joins)
    * [Sub queries](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#sub-queries)
  * [Views](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#views)
  * [Data Control Language](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#data-control-language)
  * [Index](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Database%20technologies#index)

#### ➿ [Data Structure](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Data%20structure)

#### 🐧 [Operating system](https://github.com/shreeshailaya/C-DAC-Notes/tree/main/Operating%20system)

***

Compiled by [Shreeshail Vitkar](https://github.com/shreeshailaya)

Feel free to fork @ [C-dac Notes](https://github.com/shreeshailaya/c-dac)

***


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://shreeshail.gitbook.io/c-dac-notes/readme.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.