Reetesh Diary

अपने अनिवार्य कार्य करो, क्योंकि वास्तव में कार्य करना निष्क्रियता से बेहतर है.

WINDOWS PROGRAMMING ---------------------  1. SOLUTION : COLLECTION OF PROJECT  2. PROJECT  : COLLECTION OF MODULES  3. MODULES  : FUNDAMENTAL UNIT OF PROJECT |--A. FORM   B. CLASS  4. SOLUTION EXPLORER : LIST OF SOLUTIONS AND PROJECT  5. TOOLBOX :  COLLECTION OF CONTROLL  6. CONTROLL: GRAPHICAL REPRESENATION OF OBJECT |--BUTTON/TEXTBOX/LABEL/CHECKBOX  7. DESIGN TIME : WHEN WE DESIGN THE FORM --TO CHANGE PROPERTY : SELECT CONTROLL--RCP--  8. RUN TIME : WHEN WE RUN THE FORM --TO CHANGE PROPERTY : CODING  FORM : PROPERTY :  |--TEXT | BACKCOLOR | FORECOLOR | FONT | BACKGROUND IMAGE    BACKGROUND IMAGE LAYOUT | FORMBORDER STYLE |    START POSITION  | WINDOSTATE | OPACITY       : RUN TIME FORM COLOR : CHANGE --------------------------------- CODE: FORM DOUBLE CLICK ------ private void Form1_Load(object sender, EventArgs e)     ...

/* .NET ------------- |--By Microsoft, It is a Kind of Framework (Collection of classes and Library)   --------For What -------------------- 1. Internet Programming 2. Application development 3. Mobile Apps 4. System Programming -------------------------- |--.NET : Advantage ----------------- 1. Multiple Language support / Language neutral   Language Independent   ---------------------------------------------- c# -- sum() ---vb.net 2. Having Pointer |--.NET : Architecure  Language ---Compiler --- MSIL(Microsoft Intermediate Lang) |      CLR(Common Language Runtime) |      .EXE |--Platform Indepedent    ---------------------- |---Can run on any platform : Windows / Linux --.NET : for Widnows --- --Can we run , .NET in linux --- NO ---MONO Software --- --------------------------------------------------------------...

SQL> -----JOINS --- SQL> ---ORACLE STND JOIN : EQUI JOIN , NON EQUI JOIN , OUTER JOIN , SELF JOIN SQL> ---SQL 1999 STND JOIN : INNER JOIN , LEFT OUTER JOIN , RIGHT OUTER JOIN SQL> --- FULL OUTER JOIN , CROSS JOIN SQL> ---JOIN : WHERE CONDITION , NUMBER OF CONDITION : N-1 SQL> ---EUQI JOIN SQL> SELECT E.ENAME,E.SAL,E.DEPTNO,D.DNAME,D.LOC FROM EMP E,DEPT D WHERE E.DEPTNO=   2  D.DEPTNO;

ORACLE ---------- ---BY ORACLE CORPORATION : 1973 : LAURENCE ELLSION   |     FIRST PRODUCT : SYSTEM/R :1975     ORACLE 2.0/3/4/5/6/7/7.3 : RDBMS     ORACLE 8.0  : ORDBMS     ORACLE 8I,9I,10G,11G : OODBMS ------------------------------------------------------ Q:  DBMS & RDBMS ??? ---------------------- ------X--- TYPES OF DBMS: -------------------- 1. HDBMS 2. NDBMS 3. RDBMS 4. ORDBMS 5. OODBMS ANS : E.F.CODE : 13 RULES (0-12) < 6= DBMS > 6= RDBMS ORACLE : 12.5 RULES Q: 8I / 9I : INTERNET | ORACLE JVM INBUILT ... JVM FOR JAVA : JAVA-LANG FOR INTERNET Q: 10G/11G : G : GRID COMPUTING --CHAIN OF SERVER ---  SERVER1     SERVER2   SERVER3     SERVER4    ----------------------------------- SHARING ORACLE ----------- | 1. SQL : ANSI STND LANGUAGE 2. SQL * PLUS : ENVIRONMENT ...

1.DATABASE : INTERVIEWS : 50%      |--ORACLE /SQL SERVER  : SAT / SUN 2.C# : CONSOLE PRG : 50% : MONDAY      : WINDOWS PRG :     : TUESDAY/WEDNESDAY 3. ASP.NET : HTML/CSS/JAVA SCRIPT / ASP.NET : THUS / FRID/ SAT 4. BOOTSTRAPER | JQUERY | MVC :SUNDAY 5. MONDAY : PROJECT : HOW TO DEVELOP PROJECT ..REQUIREMENTS    TEST : ----------------------------------------------------------------------- PROJECT : BACKEND +    FRONTEND     | | DATA STORE DESIGINING (JAVA/.NET/PHP)    (ORACLE/SQL SERVER/MYSQL) DATABASE -------------------- COMPANY     PRODUCT --------    ----------- MICROSOFT   SQL SERVER , MS ACCESS ORACLE CORP ORACLE         IBM         DB2 OPEN SOURCE MYSQL/POSTGRE    --------------------     LANGUAGE : SQL(CQL)   ---------------------------- DATABASE -------...