Database

What is Database?

• Databae is like how you might organize files and documents in physical folders, a database organizes information into digital tables.
• Database helps you keep your information organized, accessible, and manageable, making it a valuable tool for businesses and organizations to store and work with data.

Why learn Database?

• Learning about databases is essential for anyone working with data, information systems, software development, or technology in general.
• Many job roles, including database administrators, data analysts, software developers, business analysts, and IT professionals, require knowledge of databases.

What do we Provide?

• Mastery enables efficient database management, complex queries, streamlined data retrieval, and process automation within DBMS setups.

Syllabus

Module 1: Introduction to Database +

• Basic Concepts of DBMS
• Appplication and need of DBMS
• Datatypes
• Types of Query language
• Entity-Relational Model
• Keys and constraints
• Operators and Functions

View More

Module 2: SQL Basics +

• DDL comamnds(Create,Alter,Drop,etc)
• DML commands(Insert,Update,Delete)
• DQL commands(Select)
• DCL commands(Grant,Revoke)
• TCL commands (Commit,Rollback,Savepoint,etc)

Module 3: Joins +

• Need of Join
• Types of Join(Inner,Outer)
• Subqueries
• Aggregate functions
• Clauses

Module 4: Stored Procedures and Functions +

• What is Function?
• Create and Define Function
• What is Procedure?
• How to create Procedure?
• Examples on concept of Procedure
• Deleting Procedure

Module 5: View (DApps) +

• What is View?
• How to create View?
• Updating View
• Procedure with View
• View and Joins
• Dropping View

Module 6: Cursor +

• Basics of Cursor
• Implicit and Explicit Cursor
• Cursor using loops

Module 7: Security and Privileges+

• User authentication and authorization
• Granting and revoking privileges
• Securing MySQL server

Module 8: Triggers +

• Introduction to Triggers
• Types of Trigger
• Creating and managing views

×

Enquiry Form

Send OTP

Verify OTP

InfoStack Software Development, Training and Research Center, Solapur