• Berhampur, Odisha
  • +801 803 3055
  • info@aceit.in

SQL: Step by step Learning

4.00PM - 6.00PM Everyday 2020-11-24
Review
  • (0 Reviews)
Categories Web Development

Course Description

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system

Course Sylabus

  1.     RDBMS Introduction
  2.     Normalization in RDBMS
  3.     Create database objects i.e. Create Table
  4.     Delete database objects i. e. Delete Database
  5.     Alter database objects i.e. Change Column Name
  6.     Create, alter and delete constraints
  7.     Relation Database Management System (RDBMS)
  8.     Normalization
  9.     Create Database objects
  10.     Data Types in SQL
  11.     Alter Table Statements
  12.     Drop Table Statements
  13.     Various Constraints
  14.     Creating Views
  15.     Hands-on/Demo/Use-case:
  16.     Create Table With Predefine Columns
  17.     Add New Column to Existing Table
  18.     Check the constraints on a table
  19.     Add Primary Key and Foreign Key on Table
  20.     Remove Unique Constraint
  21.     Insert record/data in tables
  22.     Modify/Update the existing data
  23.     Retrieve the data from database from single table
  24.     Use of operators for data retrieval
  25.     Delete the data from tables
  26.     Insert Statements
  27.     Insert As- Select Statement
  28.     Update Statements
  29.     Delete Statements
  30.     Truncate Statements
  31.     Select Statement
  32.     Sorting and Filtering
  33.     SQL wildcard
  34.     CASE Expression
  35.     Self-Join
  36.     Inner Join
  37.     Left Join
  38.     Right Join
  39.     Cross Join
  40.     Conversion Function
  41.     Logical Functions
  42.     Math Function
  43.     Aggregate Functions
  44.     String Functions
  45.     Date Functions
  46.     Trigger
  47.     Procedure
  48.     SQL Maintenance

Share: