Search this site
Embedded Files
CITSWORLD
  • Home
  • CSA
    • network
      • Network Architecture
      • Applications & Network Management:
      • Network Security
    • JAVA
      • Object Oriented Programming and JAVA Language
      • JAVA Program Flow Control
        • JAVA Number, Character and String Classes.
      • JAVA Classes, Overloading and Inheritance
      • Multithreading and Exception Handling in JAVA
      • Abstract Classes and Interfaces in JAVA
      • AWT
    • DBMS
      • Database Concepts
      • Queries
      • Joins and Functions
      • Stored Procedures, Triggers and Cursors
    • JavaScipt
      • Introduction to Java Script
  • Exam Preparation
    • CSA PRACTICES SET
      • CSA MOCK TEST
      • CSA MOCK TEST 2
      • csa mock test 3
      • CSA MOCK TEST 4
      • MOCK TEST CSA
      • Mock test CSA 6
    • SEWING TECHNOLOGY PRACTICE SET
      • mock test 1
      • mock test 2
      • mock test 3
      • mock test 4
      • mock test 5
      • mock test 6
      • Mock test 7
      • mock test 8
    • Training Methodology (POT)
      • pot test 1
      • POT Test 2
      • POT mock 3
  • CITS MOCK TEST
  • Study Material
    • How to Download Windows 10 ISO file
    • create a bootable USB flash drive
    • Lesson & Demo Plan Daily Dairy Formats
    • lesson plan ppt
  • Gallery
  • Training Methodology
    • Lesson & Demo Plan Daily Dairy Formats
    • Unit-1
    • Unit 2
    • Unit-3
    • Unit:-4
    • Unit:-5
    • Unit:-6
    • Unit:-7
  • Sewing Technology
    • Revision of the CTS contents. Concepts of Drafting, Pattern making, Grading
    • Trade Knowledge Role of CAD in garment industry.
  • Syllabus
    • Soft Skills
  • ...
CITSWORLD
  • Home
  • CSA
    • network
      • Network Architecture
      • Applications & Network Management:
      • Network Security
    • JAVA
      • Object Oriented Programming and JAVA Language
      • JAVA Program Flow Control
        • JAVA Number, Character and String Classes.
      • JAVA Classes, Overloading and Inheritance
      • Multithreading and Exception Handling in JAVA
      • Abstract Classes and Interfaces in JAVA
      • AWT
    • DBMS
      • Database Concepts
      • Queries
      • Joins and Functions
      • Stored Procedures, Triggers and Cursors
    • JavaScipt
      • Introduction to Java Script
  • Exam Preparation
    • CSA PRACTICES SET
      • CSA MOCK TEST
      • CSA MOCK TEST 2
      • csa mock test 3
      • CSA MOCK TEST 4
      • MOCK TEST CSA
      • Mock test CSA 6
    • SEWING TECHNOLOGY PRACTICE SET
      • mock test 1
      • mock test 2
      • mock test 3
      • mock test 4
      • mock test 5
      • mock test 6
      • Mock test 7
      • mock test 8
    • Training Methodology (POT)
      • pot test 1
      • POT Test 2
      • POT mock 3
  • CITS MOCK TEST
  • Study Material
    • How to Download Windows 10 ISO file
    • create a bootable USB flash drive
    • Lesson & Demo Plan Daily Dairy Formats
    • lesson plan ppt
  • Gallery
  • Training Methodology
    • Lesson & Demo Plan Daily Dairy Formats
    • Unit-1
    • Unit 2
    • Unit-3
    • Unit:-4
    • Unit:-5
    • Unit:-6
    • Unit:-7
  • Sewing Technology
    • Revision of the CTS contents. Concepts of Drafting, Pattern making, Grading
    • Trade Knowledge Role of CAD in garment industry.
  • Syllabus
    • Soft Skills
  • ...
  • More
    • Home
    • CSA
      • network
        • Network Architecture
        • Applications & Network Management:
        • Network Security
      • JAVA
        • Object Oriented Programming and JAVA Language
        • JAVA Program Flow Control
          • JAVA Number, Character and String Classes.
        • JAVA Classes, Overloading and Inheritance
        • Multithreading and Exception Handling in JAVA
        • Abstract Classes and Interfaces in JAVA
        • AWT
      • DBMS
        • Database Concepts
        • Queries
        • Joins and Functions
        • Stored Procedures, Triggers and Cursors
      • JavaScipt
        • Introduction to Java Script
    • Exam Preparation
      • CSA PRACTICES SET
        • CSA MOCK TEST
        • CSA MOCK TEST 2
        • csa mock test 3
        • CSA MOCK TEST 4
        • MOCK TEST CSA
        • Mock test CSA 6
      • SEWING TECHNOLOGY PRACTICE SET
        • mock test 1
        • mock test 2
        • mock test 3
        • mock test 4
        • mock test 5
        • mock test 6
        • Mock test 7
        • mock test 8
      • Training Methodology (POT)
        • pot test 1
        • POT Test 2
        • POT mock 3
    • CITS MOCK TEST
    • Study Material
      • How to Download Windows 10 ISO file
      • create a bootable USB flash drive
      • Lesson & Demo Plan Daily Dairy Formats
      • lesson plan ppt
    • Gallery
    • Training Methodology
      • Lesson & Demo Plan Daily Dairy Formats
      • Unit-1
      • Unit 2
      • Unit-3
      • Unit:-4
      • Unit:-5
      • Unit:-6
      • Unit:-7
    • Sewing Technology
      • Revision of the CTS contents. Concepts of Drafting, Pattern making, Grading
      • Trade Knowledge Role of CAD in garment industry.
    • Syllabus
      • Soft Skills
    • ...

Database Concepts

Database Concepts

Database Concepts

  • Concept of DBMS, RDBMS.

  • Data Models, Concept of DBA, Database Users.

  • ER Model & Diagram, Database Schema.

  • Designing Database using Normalization Rules.

  • Various data types Data integrity, DDL DML and DCL  statements.

  • Enforcing Primary key and foreign key.

  • Adding Indices.

Concept of DBMS, RDBMS

Data Models, Concept of DBA, Database Users.

ER Model & Diagram, Database Schema

Designing Database using Normalization Rules.

Various data types Data integrity, DDL DML and DCL statements.

Enforcing Primary key and foreign key.

Adding Indices

Back

This article is contributed by Abhay Mishra. If you like citsworld and would like to contribute, you can also write an article and mail your article to abhaymishra0001@hotmail.com.


FacebookInstagramYouTubeTwitterFacebook
Copyright © 2024 Terms Feed®. All rights reserved 
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse