README

drawing

Welcome to CDAC Notes

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

☕ Core Java

• Intro, Features, JDK JRE

• OOPs,Major and Minor piller

• Data Types, Memory Management, Constructor, this

• Garbage Collector, Array

• Association Relation, Wrapper Classes

• Packages,IDE

• Inheritance,super(),Overriding, Dynamic Binding, Debug, Scanner

• class objects, c-o overiding

• Multilevel Inheritance,foreach, Abstraction, Access Specificer

• geter/seter,final,Interface

• typecast, instanceof, interface of java8

• Exception Handling

💾 Database Technologies

• Agenda

• DBMS

• RDBMS

• SQL

• MySQL

  • Getting started with MySQL

  • Database logical layout

  • Database physical layout

  • MySQL data types

  • CHAR vs VARCHAR vs TEXT

  • INSERT – DML

  • SQL scripts

  • SELECT – DQL

    • SELECT – DQL – ORDER BY

    • SELECT – DQL – WHERE

  • UPDATE – DML

  • DELETE – DML vs TRUNCATE – DDL vs DROP – DDL

  • Seeking HELP

  • DUAL table

  • SQL functions

    • Numeric & String functions

    • Date-Time and Information functions

    • Control and NULL and List functions

    • Group functions

  • GROUP BY clause

  • # Transaction

  • Row locking

  • Entity Relations

    • Cross Joins

    • Inner Join

    • Left Outer Join

    • Right Outer Join

    • Full Outer Join

    • Set Operators

    • Self Joins

    • Multi-table Joins

    • Sub queries

  • Views

  • Data Control Language

  • Index

➿ Data Structure

🐧 Operating system

---

Compiled by Shreeshail Vitkar

Feel free to fork @ C-dac Notes

---