Database Management System and SQL

Database Management System and SQL

Regular price Rs. 999.00 Sale

COURSE CONTENT:

  • Database Concept - Overview of DBMS, Components, Architecture
  • ER Model
  • RDBMS Concept - Relational Data Model, Keys, Relational Algebra, Operators, Joins, Convert ER model to relational model
  • Normalization - 1NF, 2NF,3NF, BCNF, 4NF, 5NF
  • SQL Basics - SQL Data types, Operators
  • SQL Commands - DDL, DML, DCL, TCL Commands
  • SQL Constraints - Different types of constraints
  • DQL - SELECT, WHERE, Aggregate Functions, GROUP BY, ORDER BY, HAVING
  • Subquery, Correlated Subquery, Use of IN, Exists, Not Exists
  • Joins - Inner Join, Right Outer Join, Left Outer Join, Full Outer Join
  • SET Operation, CASE WHEN, DATE
  • SQL - Index and Views

HOW TO USE THIS PREPARATORY PACKAGE

Step 1: This is an Online Preparatory Course
Step 2: After purchasing the package, you will receive an email with an activation link
Step 3: Activate your account and set the password
Step 4: Login here: https://app.placementseason.com/ 
Step 5: Fill the basic details and click ‘save’. Then you can access the respective course.

The course will be valid for 1 year from the date of purchase.

Customer Reviews

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
x