ITnium
Our Office
2nd Floor Creative Plaza, Ram Mandir, Civil Hospital Road, Sangli.
Email Us
support@itnium.com
Call Us
+91 9423868881
+91 7588949388

Courses

Home

Software Courses

SQL-Programming
 
SQL (Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables. SQL offers two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, e.g. with or without an index.
 

Course Content


  1. Understanding Core Database Concepts
    • Understand how data is stored in tables
    • Understand relational database concepts
    • Understand data manipulation language (DML)
    • Understand data definition language (DDL)

  2. Creating Database Objects
    • Choose data types
    • Understand tables and how to create them.
    • Create views
    • Create stored procedures and functions

  3. Manipulating Data
    • Select data
    • Insert data
    • Update data
    • Delete data

  4. Understanding Data Storage
    • Understand normalization
    • Understand primary,foreign,and composite keys
    • Understand indexes

  5. Administering a Database
    • Understand database security concepts
    • Understand database backups and restore

© All Rights Reserved. Designed by ITnium