ITM Classes Notes

Step to create Sub Domain: Step 1: Login to your hosting account. (Hostinger) Step 2: Click on Manage hosting Step 3: Select your Domain Name from the left Dropdown. Step 4: Go to Domains Menu -> Click on Subdomains Step 5: Enter Your Prefix. Step 6: Click on Create Button Step to install WordPress on subdomain: Step 7: Now, Click on Overview menu on sidebar Step 8: Click on WordPress   Overview Step 9: Scroll Down and look for "Install Another Wordpress" and click on Install. Step 10: Pop Up will show up -  a) Enter website name b) enter admin email to receive notifications related to website. c) create username and password (eg: parteek , Parteek@ 12##) d) click on Advanced - Select Sub Domain in which you want to install Wordpress. e) Enter database password. (Keep Password same as above) f) Click Next and Install. Login to Wordpress Account using username and password: Step 1: Domain-name/wp-admin (ex: https://parteek.vicharvibes.com/wp-admin) Step 2: Enter us...

 Stored Procedure is a prepared code that you can save and you can use that code over and over again. example: select * from tbemp; Stored Procedure Syntax: create PROCEDURE pro_name AS sql_query GO; Execute the Stored Procedure: EXEC procedure_name; Example: CREATE PROCEDURE getAllEmployee AS select * from tbemp GO; DELIMITER $$ CREATE PROCEDURE `allEmp`() BEGIN select * from tbEmp; END; Excecution: Exce getAllEmployee;  //MSSQL call allEmployees();   // MYSQL DELIMITER $$ CREATE PROCEDURE `allEmployeeDetail`() BEGIN select e.emp_id as ID, e.emp_dept as Department, e.name, s.student_email, s.is_active from tbEmp e inner join stdn s on e.emp_id=s.student_id where s.password_hash!=''; END; DROP PRocedure allEmployeeDetail; call allEmployeeDetail();

 WordPress Plugins: WordPress plugins are add-ons that extend the functionality of a WordPress site without requiring you to code everything from scratch. They work like “apps” for your website—installing them can add new features, improve performance, enhance SEO, secure your site, and more. 1. What Are WordPress Plugins? Small software packages that integrate with WordPress. Can be free, freemium, or premium. Stored in the /wp-content/plugins/ directory. Installed via the WordPress Plugin Directory (official) or manually uploaded. 2. How to Install a Plugin Go to Dashboard → Plugins → Add New . Search for the plugin name. Click Install Now , then Activate . Configure settings if needed. 3. Types of WordPress Plugins a) SEO Plugins Yoast SEO – SEO optimization & readability analysis. Rank Math – Lightweight alternative with rich snippets. All in One SEO Pack – Beginner-friendly SEO features. b) Security Plugins Wordfence – Firewal...