Track
Software Development
Duration
30 hours
Skill Level
Foundation
Language
English
About this Course
Understand relational databases and master SQL for data manipulation and queries.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Introduction
- History of DBMS
- Purpose of Database Systems
- Advantages of using the DBMS approach
- Disadvantages of using the DBMS approach
- DBMS and its applications: Enterprise Information & Banking and Finance
- Example of a Database
- Architecture of DBMS
- Data Models, Schemas and Instances
- Categories of Data Models
- Database Schema vs Database State
- Data-Manipulation Language (DML)
- Data-Definition Language (DDL)
- Database Administrators and Database Users
- Database Users and User Interfaces
- The Database System environment
- Database System Utilities
- Centralized and Client/Server Architecture for DBMS
- High-Level Conceptual Data Models
- Introduction to ER Model
- Symbols in ER Diagram
- Entity types
- Entity sets
- Attributes
- Entity-Set and Keys
- Relationship
- Relational Model Integrity
- CONSTRAINTS
- Keys in DBMS
- ER DIAGRAM
- Naming Conventions
- ER Design Issues
- Structural constraints Weak entity types
- Generalization
- Specialization
- Relational Model Concepts
- Informal Definitions
- Formal Definitions
- Structure of Relational Databases
- Database Schema
- Characteristics of Relations
- Relational Integrity Constraints
- Other Types of Data Constraints
- Domains, Attributes, Tuples and Relations
- Represent all the Entities and Relationships in Tabular Fashion
- PRELIMINARIES
- Selection and Projection
- Unary Operations
- The SELECT Operation
- PROJECT Operation
- Sequences of Operations and the RENAME Operation with an Example
- Set Theory Operations
- The UNION, INTERSECTION and MINUS Operations - Examples
- The CARTESIAN PRODUCT (CROSS PRODUCT) Operation
- Binary Relational Operations and additional relational operations
- List of Operators with Purpose
- Additional Relational Operations and Generalized Projection
- Relational Database Design using ER-to-Relational mapping
- Procedure to Create a Relational Schema from an Entity-Relationship (ER)
- Mapping of Binary 1: N Relationship Types
- Introduction
- SQL Data Definition and commands
- Operators and Expressions
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
Ready to start Database Management and SQL Mastery?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
Other MKCL Courses
-
Python
120 hours -
Mobile App Development
120 hours -
Advanced C# Programming Techniques
30 hours -
Advanced Concepts of C#
60 hours