🌟 Course Overview: Learn the fundamentals of digital and social media marketing, from setting up social media accounts to running paid campaigns and analyzing performance. Ideal for students, content creators, freelancers, and small business owners starting their digital journey.
Module 1: Introduction to Digital Marketing
- Case study review (e.g., a brand that went viral digitally)
- Quiz: Channels of digital marketing
Module 2: Website Basics & Content Strategy
- Create a basic landing page using Google Sites or Wix
- Plan a content calendar for 1 week
Module 3: Social Media Marketing (SMM)
- Create and schedule 1 week of posts using Canva + Meta Business Suite
Module 4: Meta Ads (Facebook & Instagram)
- Design a sample ad (image + text)
- Set up a mock Facebook ad campaign (no payment required)
Module 5: SEO Basics
- SEO audit of a simple blog/website
- Write a blog post with SEO best practices
Module 6: Google Ads
- Create a mock Google Search Ad for a product or service
Module 7: Email Marketing
- Create a basic email campaign (Welcome Email + Product Offer)
Module 8: Analytics & Reporting
- Analyze performance of a post or mock campaign
- Create a basic monthly marketing report
Bonus Module: Using AI in Marketing
- How to use ChatGPT for content ideas, ad copies, captions
- Canva AI Tools for design
- Video script generation using AI
🎓 Final Project / Certification Task
Create and present a basic digital campaign plan for a mock business including:
🧰 Tools You'll Learn to Use
(Design)
(Ubersuggest)
(AI Content)
🗂 Course Delivery Format
| Week | Modules | Format |
|---|---|---|
| Week 1 | Modules 1–2 | Live Zoom / Recorded |
| Week 2 | Module 3 | Live Demo + Practice |
| Week 3 | Module 4 | Workshop Style |
| Week 4 | Modules 5–6 | Hands-On SEO/Ads |
| Week 5 | Modules 7–8 | Reporting + Final Project |
🗄️ Database Management
Structured Query Language (MS SQL / mySQL)
- Introduction
- ER Diagrams
- SQL Syntax
- Connecting to and Disconnecting from the Server
- Creating SQL Statements in MS SQL
- Common SQL Statements: SELECT, INSERT, UPDATE, DELETE, CREATE
- Advanced SQL Statements: JOIN, UNION, IN
- Creating functions, triggers, views
- User privileges and security
- Query optimization
Oracle based on OCA Syllabus
- Introduction to Oracle SQL
- Relational and Object Relational Database Management System
- ER model
- Communicating with a RDBMS Using SQL
- SQL Statements syntax
- Writing SQL Statements using SELECT, INSERT, DELETE, UPDATE, REVOKE, GRANT
- Using Arithmetic Operators and Precedence
- Logical and Other Conditions
- SQL functions, conversion
- Working with multiple tables
- Aggregating Data Using Group Functions
- Producing Readable Output with iSQL*Plus
- Create and Invoke Index, Table, View, Function, Procedure, Triggers
- Oracle Program with PL/SQL
- Declaring and Handling Variables and Data types
- Use of DBMS_OUTPUT.PUT_LINE
- Working with SQL Implicit and Explicit Cursor
- Conditional Statements: IF THEN ELSE CASE WHEN
- Loop Statements: BASIC FOR WHILE
- Handling Exceptions
- Privileges of the user management
💻 Operating Systems
- Microsoft Windows
- LINUX
🚀 Software Project Guidance
How to start a software project? Pre-conditions to follow.
Sample Project Proposals:
- Absence Request and Vacation Schedule Management System
- Online Examination and Evaluation System
💡 For more guidance: Online Individual / Group classes in English / Sinhala / Tamil. Sample Projects/Assignments, Exam Papers, Tutorials, Notes and Answers will be provided.
No comments:
Post a Comment