Internship - Semester

1. What is the internet?
2. How does the web work?
3. The role of HTML and CSS
4. Setting up a development environment (code editor, browser)
5.HTML Basics
6. Structure of an HTML document

1. Text formatting (headings, paragraphs, emphasis)
2.Lists (ordered and unordered)
3.Links (anchors)
4. Image

1. Creating input fields (text, number, email, etc.)
2. Buttons (submit, reset)
3. Labels
4. Form validation

1. Introduction to CSS
2. Selectors (element, class, ID)
3. Properties and values
4. Styling text (font, color, size)
5. Styling elements (background, border, margin, padding)

1. Block, inline, and inline-block elements
2. Float and clear properties
3. CSS Grid
4. Advanced CSS Topics

1. Positioning (relative, absolute, fixed)
2. Units of measurement (pixels, percentages, ems, rems)
3. Color theory and color models
4. Media queries for responsive design

1. Plan and design a basic website (e.g., a personal portfolio or a score board)
2. Implement the HTML structure
3.Apply CSS styles for layout and appearance
4. Test and debug the website

1. What is a database?
2. Define a database and its components (tables, records, fields)
3. Explain the role of a DBMS (Database Management System)
4. Introduction to SQL
SQL as a language for interacting with databases
Basic SQL syntax and structure
Common SQL commands (SELECT, FROM, WHERE, ORDER BY)
5. Data types in SQL
Numeric (INT, DECIMAL, FLOAT)
Character (CHAR, VARCHAR)
Date and Time (DATE, TIME, DATETIME)
Boolean (BIT)
6. Creating tables
Using the CREATE TABLE statement
Defining columns, data types, and constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL)

1. Inserting data
Using the INSERT INTO statement
Handling NULL values
2. Updating data
Using the UPDATE statement
Updating multiple rows
3. Deleting data
Using the DELETE statement
Deleting rows based on conditions
4. Filtering data
Using the WHERE clause with comparison operators (=, <, >, <=, >=, !=)
Using logical operators (AND, OR, NOT)
Combining conditions

1. Sorting data
Using the ORDER BY clause to sort results
Ascending and descending order
2. Grouping data
Using the GROUP BY clause to group rows
Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
3. Joins
Inner join, left join, right join, full outer join
Combining data from multiple tables
4. Subqueries
Nested queries within a SELECT, WHERE, or HAVING clause
5. Correlated subqueries

1. Indexes
Creating indexes to improve query performance
Types of indexes (clustered, non-clustered)
2. Performance tuning
Identifying performance bottlenecks
Query optimization techniques (explain plans, query rewriting)
3. Stored procedures
Creating and executing stored procedures
Passing parameters
Returning results
4. Functions
Creating and using functions
Scalar functions and table-valued functions

1. Transactions
Defining transactions
Committing and rolling back transactions
2. ACID properties
Atomicity, consistency, isolation, durability
3. Database design principles
4. Entity-relationship (ER) diagrams
5. Normalization (1NF, 2NF, 3NF)
6. Normalization techniques
7. Identifying functional dependencies
8. Eliminating anomalies

1. Database security
User accounts and permissions
Encryption
Auditing
2. Database backup
Creating backups
Restoring databases

1. Practice exercises
2. Applying SQL concepts to real-world scenarios
3. Troubleshooting common SQL errors
4. Question and answer Class
5. Addressing learners' questions and concerns

1. What is version control?
2. Why is it important?
3. What is Git?
4. What is GitHub?
5. Setting up Git and creating a GitHub account
6. Version control terminology:
Repository
Branch
Master
Stage
Commit
Clone
Push
Pull
Fetch
7. VS Code Integration

1. Staging and Committing Changes
2. Repository Management Commands
3. Branching and Merging
4. Viewing and Comparing Changes
5. Adding a Remote Repository

1. Working on an Existing Repository
2. Undoing Changes

1. What is the .NET Framework?
2. What is ?
3. Why use ?
4. Installing Visual Studio
5. Creating a new Console App project
6. Output
7. Comments

1. Variables
2. Constants
3. Data types
4. Type casting
5. Operators:
6. Arithmetic operator

1. operators continued:
Assignment Operators
Comparison Operators
Logical Operators
2. Control structures:
if statement
if...else statement
if...else ladder
switch case

1. Loops:
While loop
Do...while loop
For loop
Break and continue statements

1. Arrays
2. 2D arrays
3. Foreach loop

1. Methods/functions:
Creating a method
Calling a method
Parameters and arguments
Default parameter values
Return values
Named arguments
Method overloading

1. What is OOP?
2. Classes and members
3. Constructors
4. Constructor parameters

1. Access modifiers
2. Encapsulation
3. Properties
4. Inheritance

1. Polymorphism
2. Abstraction
3. Interfaces

1. Exceptions: try...catch, throw
2. Generics: introduction, generic classes
3. Generic collections:
List
Dictionary
SortedList
Queue
Stack

1. Files and directories
2. Streams
3. Creating, opening, writing to, and reading from files
4. Serialization:
Object to binary file stream
Object to XML file stream
Object to JSON string
5. Asynchronous Programming
asynchronous programming

1. Setting up the development environment
2. Creating a new ASP.NET Core Web API project
3. Understanding the project structure
4. Building a basic REST API endpoint
5. HTTP methods (GET, POST, PUT, DELETE)
6. JSON serialization and deserialization

1. Implementing CRUD operations (Create, Read, Update, Delete)
2. Handling HTTP status codes
3. Error handling and exception management
4. Data validation and input sanitization
5.Authentication and authorization (basic authentication, JWT)
6. Versioning REST APIs

1. Using Http Client to make HTTP requests
2. Deserializing JSON responses
3. Asynchronous programming and task-based asynchronous pattern (TAP)
4. Consuming third-party APIs

1. What is JavaScript?
2. Why is it called JavaScript?
3. What can in-browser JavaScript do?
4. JavaScript and VS Code
5. Code structure

1. Variables: let, var, const
2. Data Types:
Number
String
Boolean
Null
Undefined
Objects
3. Typeof operator
4.Operators:
Mathematical Operators & their precedence
Comparison Operators
Logical Operators

1. If statement
2. If...else statement (including ternary operator)
3. Else if ladder
4. Switch case

1. While loop
2. Do...while loop
3. For loop

1. Functions:
Function Declaration
Local variables
Outer variables
Parameters
Default values
Returning a value
Naming a function  
2. Objects: the basics

1. Objects: continued
2. Strings: properties and methods

1. Arrays: creation, access, manipulation.
2. Array functions: map, filter, reduce, etc.

1. Classes
2. Constructors
3. Getters and setters
4. Inheritance

1. Querying and selecting elements
2. Traversing elements
3. Creating elements
4. Updating elements
5. Removing elements

1. Event listeners
2. OnClick event
3. Mouse events
4. Keyboard events

1. Introduction to React
2. Setting Up the Development Environment

1. Modern JavaScript Features

1. JSX and Components
2. State Management
3. Styling in React

1.State and Props
2.State Management Strategies

1. Component Composition
2. Advanced Patterns

1. Fundamental Hooks

1. Component Lifecycle
2. Performance Optimization

1. Controlled and Uncontrolled Components
2. Advanced Form Handling

1. React Router
2. Single-Page Applications (SPAs)

1. Fetching Data
2. Advanced Data Fetching

1. SSR Basics
2. Advanced SSR with Next.js

1. Redux Basics
2. Redux Toolkit

1. Error Boundaries
2. Authentication and Authorization

1. Deploying React Apps
2. Setting Up CI/CD

1. Building Real Projects

1. Design and implement a user-friendly interface using modern web technologies.

1. Build efficient database schemas using SQL or NoSQL databases.

1.Develop RESTful APIs for seamless frontend-backend communication.

1. Master version control and collaboration using Git.

1. Deploy your application to the Azure cloud for scalability and security.

1. What is Cloud Computing?
2. Types of Clouds
3. Cloud Computing Models – SaaS / PaaS / IaaS
4. Data Centres and Availability Zones
5. Overview of a Cloud Platform (Microsoft Azure)
6. Exploring Various Cloud Resources

1. What is DevOps?
2. Azure DevOps Walkthrough

1. Continuous Integration
2. Continuous Deployment

1. AI and its Applications
Explore real-world AI use cases.

2. Machine Learning Concepts
Learn the fundamentals of machine learning.

3. Difference Between Machine Learning and AI
Understand the distinctions between AI and ML.

1. Generative AI, LLM, and Prompt Engineering
Delve into generative models and prompt creation.

2. Natural Language Processing
Study techniques for processing and understanding human language.

3. AI-Based Hands-on Project
Apply AI concepts in a practical project.

1. Project Based Learning
2. Project Viva Preparations
3. Project Report

1. Project Based Learning
2. Deeper learning of Project
3. Improved critical thinking and problem-solving skills
4. Increased motivation and engagement

1. Deep Learning of Frame work.
2. Frontend
3. Backend

1. Title
2. Acknowledgment
3. Abstract
4. Table of Contents
5. List of Figures and Tables
6. Certificate of Completions

1.Problem Solving

1. Problem Solving Question.
2. How to solve Question in time limit.

1. Dress professionally
2. Choose conservative colors
3. Pay attention to fit
4. Grooming is key
5. Research the company culture

1. Communication Skills:
2. Time Management Skills
3. Problem-Solving Skills
4. Teamwork and Collaboration
5. Adaptability and Flexibility
6. Leadership Skills