MKCL SystemEngineer PT2023 Syllabus
MKCL SystemEngineer PT2023 Syllabus
Video Tutorial
https://youtu.be/VvXzJTkzTLM
https://www.youtube.com/watch?v=0j6-QFnnwQk
● Troubleshooting PC hardware
○ Troubleshooting BIOS Settings
○ POST related Issues
○ Troubleshooting Motherboards
○ Troubleshooting Display Devices
○ Troubleshooting Adapter Cards
Page 1 of 6
MKCL’s System Engineer - Project Trainee Recruitment 2023
○ Troubleshooting RAM
○ Troubleshooting Cooling System
○ Troubleshooting Storage Devices
○ Troubleshooting Printers
Resources
• Book
Troubleshooting and Maintaining Your PC by Dan Gookin
https://www.booksfree.org/troubleshooting-and-maintaining-your-pc-by-
dan-gookin-pdf-free-download/
• Videos
○ Top 15 computer problems with solution:
https://www.youtube.com/watch?v=nBpoZOo9RfQ
• Additional reference
• https://www.pluralsight.com/blog/tutorials/troubleshooting-hardware
• https://www.tomshardware.com/best-picks
Page 2 of 6
MKCL’s System Engineer - Project Trainee Recruitment 2023
● Introduction to SQL
○ Overview of the SQL Query Language
○ SQL Data Definition
○ Basic Structure of SQL Queries
○ Additional Basic Operations
○ Set Operations
○ Null Values
○ Aggregate Functions
○ Nested Subqueries
○ Modification of the Database
○ Join Expressions
○ Views
○ Transactions
○ Integrity Constraints
○ SQL Data Types and Schemas
○ Accessing SQL From a Programming Language
○ Functions and Procedures
○ Triggers
● Database Design
○ The Entity-Relationship Model
○ Constraints
○ Normalization
● Transaction Management
○ Transaction Concept
○ ACID properties
Resources
• Book
○ DATABASE SYSTEM CONCEPTS by Abraham Silberschatz, Henry F.
Korth and S. Sudarshan, Sixth edition
• DBMS tutorial
○ https://www.w3schools.com/sql
○ https://www.javatpoint.com/dbms-tutorial
Page 3 of 6
MKCL’s System Engineer - Project Trainee Recruitment 2023
• Mongo Overview
○ https://www.tutorialspoint.com/mongodb/mongodb_overview.htm
• Memory Management
○ Allocating and managing computer memory
■ Virtual memory
■ Paging
■ Segmentation
■ Memory allocation strategies
■ Memory hierarchy.
• File Systems
○ File organization
○ Directory Structures
○ File operations
○ File permissions
○ File system types (e.g., FAT, NTFS, ext4)
• Device Management
○ Device drivers
○ Device allocation
○ Input/output operations
○ Interrupt handling
○ Device scheduling
• CPU Scheduling
○ Scheduling algorithms (e.g., FCFS, SJF, Round Robin)
○ Context switching
○ Process priorities
• Deadlock
○ Deadlock prevention, avoidance, detection, and recovery.
Page 4 of 6
MKCL’s System Engineer - Project Trainee Recruitment 2023
• Virtualization
o Virtual machines (VMs)
o Hypervisors
o Containerization
o Advantages of virtualization.
Page 5 of 6
MKCL’s System Engineer - Project Trainee Recruitment 2023
o Replication
o Data lifecycle management.
Reference : https://www.guru99.com/cloud-computing-for-beginners.html
Page 6 of 6