Track
Software Development
Duration
30 hours
Skill Level
Beginner
Language
English
About this Course
Connect PHP with MySQL to build basic data-driven web applications.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Introduction
- how to set up SQL SERVER
- How to set up SQL Management Studio
- Managing the Database
- Introduction
- Characteristics of SQL
- Advantages of SQL
- Backing & Restoring Data
- Sql in Real Life
- What is Database
- olap vs oltp
- structural vs procedural language
- Introduction
- History of DBMS
- Purpose of Database Systems
- Advantages of using the DBMS approach
- Controlling Data Redundancy, Elimination of Inconsistency
- Better service to the users, Flexibility of the System is Improved
- Integrity can be improved,Standards can be enforced,Security can be improved
- Organization’s requirement can be easily identified,Provides backup and Recovery
- Disadvantages of using the DBMS approach
- DBMS and its applications
- Enterprise Information
- Banking and Finance
- Example of a Database (with a Conceptual Data Model)
- Simple example of real world entities and their relationships
- Types of SQL Commands
- DDL and DML
- Select and Where sql Command
- Check Constraint
- SQL Operators
- Sql Insert and Delete command
- Having SQL Commands
- SQL AVG, IN command and AS(Aliasing)
- SQL Order By Group By
- SQL Min & Max
- Sql Like, Count & Distinct
- SQL all commands with example
- SQL Insert and Delete command
- Introduction
- The Union and Intersect Operation
- Joins with Examples
- Introduction
- The Union and Intersect Operation
- Joins
- Joins with Examples
- Joinning two tables
- Joinning Three Tables
- Fetching the data and linking of different tables
- Example of Join
- The Except Operation
- Introduction
- Importance of Data Models
- Advantages of Data Models
- Relational Database
- Why RDBMS is important?
- File Management Systems
- Schemas , Domains and COnstraint
- Hierarchical Databases
- Network Databases
- Introduction
- Entity
- Weak Entity
- Strong Entity
- Attribute and Its Types
- Relationship
- One on One
- One to Many
- Many to Many
- Degree
- Advantages and Disadvantages of EAV model
- Relational Schema
- Cardinality
- Constraints in Relational Model
- Anomalies in Relational model
- Codd Rules
- Advantages of Using Relational Model
- Disadvantages
- Logical Views of Data & its Characterstics
- Attributes
- Tuples
- Keys
- Feature of Good Relational Model Design
- Null values
- Primary Key
- Queries with Example
- Unique Key
- Queries with Example
- Default Key
- Queries with Example
- Foreign Key
- Queries with Example
- Default Value
- Queries with Example
- Check Integrity Constraints
- Data Abstraction
- View Leval
- Conceptual Leval
- Physical Leval
- SQL Indexing
- Types of Indexing
- Primary Indexing
- Secondary Indexing
- Clustering Index
- Creating a Index
- Deleting a Index
- Indexing Strategy Guidelines
- Introduction
- Creation of views
- Selecting a Data From View
- Updating Views
- Destroying A view
- Nested Queries
- Complex Queries
- Example of Complex queries
- Set Membership
- Set Comparison
- Test for Empty Relations
- Introduction
- 1NF
- 1NF Example
- 2NF
- How to Decompose table in 2NF
- 2NF Example
- 3NF
- How to Decompose table in 3NF
- 3NF Example
- BCNF
- How to Identify BCNF
- BCNF Example
- ACID Properties
- Transaction States
- Lost Update Problem
- Serial schedule vs non Serial schdeule
- View and Conflict Serializablity
- Examples
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 Foundations of MySQL and PHP?
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