Introduction to PHP and MySQL

• A widely-used, open-source scripting language especially suited for web development.
• PHP scripts are executed on the server.
• It can be embedded into HTML.

MySQL

• An open-source relational database management system (RDBMS).
• It uses Structured Query Language (SQL) to interact with the database.
• Known for its reliability, flexibility, and ease of use.

Basic Concepts

PHP Basics:

• Variables: Used to store data.
• Data Types: Integers, Floats, Strings, Arrays, Objects.
• Control Structures: If-else statements, switch cases, loops.
• Functions: Blocks of code that can be reused, can take parameters and return values.

MySQL Basics

• Databases: Containers for tables, which store data.
• Tables: Organized into rows and columns.
• Data Types: Various types to define the nature of data, like INT, VARCHAR, DATE, etc.
• Primary Key: A unique identifier for table records.

Advanced Concepts

Prepared Statements

• Used to execute the same SQL statement repeatedly with high efficiency.
• Helps prevent SQL injection attacks.

Error Handling

• Handling potential errors that occur during database interactions.
• Using try-catch blocks for exception handling.

Getting Started with Photoshop

• Introduction to the Photoshop interface.
• Basic tools and their functions.
• Opening and saving files.

Basic Photo Editing

• Cropping and resizing images.
• Adjusting brightness and contrast.
• Basic color correction.

Using Layers

• Understanding layers and their importance.
• Creating and managing layers.
• Layer blending modes.

Advanced Photo Editing

• Using the healing brush and clone stamp tools.
• Advanced color correction techniques.
• Retouching portraits.

Working with Text

• Adding and editing text.
• Using text effects and styles.
• Creating text masks.

Using Filters and Effects

• Applying and customizing filters.
• Using smart filters.
• Creating custom effects.

Lesson 7: Creating Rules

• Applying Class and ID Selectors
• Linked Style Sheets
• Rules in Conflict – Cascading Orders

Lesson 8: Design and usage techniques

• Dynamic Link Colors
• Cursor Styles
• Styling form elements

CorelDraw

Overview: 

• Developer: Corel Corporation
• Platform: Windows (with limited support on macOS via Parallels)
• Usage: Primarily used for vector graphic design, layout, and illustration.

Features

•  

  • User Interface: Known for its user-friendly interface with customizable toolbars and layouts.
• Tools: Offers a variety of tools for vector illustration, page layout, and typography.
• File Compatibility: Supports a wide range of file formats including AI, EPS, PDF, and SVG.
• Versatility: Good for both print and digital design; includes features for web design and document creation.
• Price: One-time purchase or subscription model; often considered more affordable than Adobe Illustrator.

Pros

• Ease of Use: Generally considered easier to learn and use, especially for beginners.
• Cost-Effective: One-time purchase option available.
• Robust Features: Includes unique tools like the ‘LiveSketch’ tool for drawing.

Cons

• Platform Limitations: Primarily available on Windows, with limited macOS support.
• Industry Standard: Less commonly used in some industries compared to Adobe Illustrator.

Adobe Illustrator

Overview:

• Developer: Adobe Inc.
• Platform: Available on both Windows and macOS.
• Usage: Industry-standard tool for vector graphic design, used extensively in professional environments.

Features:

• User Interface: Highly customizable and integrated with other Adobe Creative Cloud apps.
• Tools: Offers a comprehensive set of tools for vector design, including advanced drawing, coloring, and type tools.
• File Compatibility: Excellent compatibility with other Adobe products and supports a wide range of file formats.
• Integration: Seamless integration with Adobe Creative Cloud, making it easy to work with other Adobe tools like Photoshop and InDesign.
• Subscription: Available only via a subscription model, part of Adobe Creative Cloud.