ABSTRACT
[Draw your reader in with an engaging abstract.
It is typically a short summary of the document.
When you’re ready to add your content, just
click here and start typing.]
Apna Coder
[Course title]
Full STAck development
Complete Course
📖 C Language Full Course
Summary
📌 Introduction to C
What is C Language?
History and Features
Structure of a C Program
Compiling and Running a C Program
Header Files and Preprocessors
📌 Basic Syntax
Tokens: Keywords, Identifiers, Constants, Strings, Operators
Semicolons ;
Comments // and /* */
main() Function
📌 Variables and Data Types
Declaring Variables
Data Types: int, float, char, double
Type Modifiers: long, short, signed, unsigned
Format Specifiers: %d, %f, %c, %s, %lf
📌 Input and Output
printf() and scanf()
getchar() and putchar()
gets() and puts()
📌 Operators in C
Arithmetic Operators: +, -, *, /, %
Relational Operators: ==, !=, >, <, >=, <=
Logical Operators: &&, ||, !
Bitwise Operators: &, |, ^, ~, <<, >>
Assignment Operators: =, +=, -=, *=, /=
Increment and Decrement: ++, --
Conditional Operator: ?:
📌 Control Statements
Decision Making
if statement
if-else
nested if
switch-case
goto
Looping
for loop
while loop
do-while loop
📌 Arrays
1D Array
2D Array (Matrix)
Multi-Dimensional Array
Array Initialization
📌 Strings
Declaring Strings
String Functions: strlen(), strcpy(), strcat(), strcmp()
Character Array vs String
📌 Functions
Function Declaration and Definition
Calling Functions
Types of Functions:
o With Argument & With Return Value
o With Argument & No Return Value
o No Argument & With Return Value
o No Argument & No Return Value
Recursion
Scope: Local, Global, Static Variables
📌 Pointers
Declaration and Initialization
Pointer Arithmetic
Pointer to Pointer
Array of Pointers
Pointer to Function
Dynamic Memory Allocation: malloc(), calloc(), realloc(), free()
📌 Structures and Unions
Defining Structure
Accessing Members
Nested Structures
Array of Structures
Pointer to Structure
Union Definition and Usage
Difference between Structure and Union
📌 File Handling
File Opening and Closing: fopen(), fclose()
Reading and Writing: fgetc(), fputc(), fgets(), fputs(), fprintf(), fscanf()
File Modes: r, w, a, r+, w+, a+
End of File: feof()
File Pointers
📌 Storage Classes
auto
register
static
extern
📌 Preprocessor Directives
#include
#define
#ifdef, #ifndef, #endif
Macros
📌 Important C Programs for Practice
Swapping two numbers (with and without third variable)
Factorial (using recursion)
Fibonacci Series
Armstrong Number
Palindrome Number
Sorting an Array (Bubble Sort)
Matrix Addition and Multiplication
String Reversal
File Read/Write Program
📖 HTML Full Course Summary
📌 Introduction to HTML
What is HTML?
History and Evolution (HTML4 → HTML5)
HTML Structure: <!DOCTYPE html>, <html>, <head>, <body>
📌 Basic HTML Elements
Headings: <h1> to <h6>
Paragraphs: <p>
Line Breaks: <br>
Horizontal Rule: <hr>
Comments: <!-- comment -->
📌 Text Formatting Tags
Bold: <b> / <strong>
Italic: <i> / <em>
Underline: <u>
Superscript / Subscript: <sup>, <sub>
Highlight: <mark>
Strike-through: <del>
📌 Links (Hyperlinks)
<a href="URL">Text</a>
Attributes: target="_blank", title, download
📌 Images
<img src="[Link]" alt="description">
Attributes: width, height, title
📌 Lists
Ordered List: <ol>
Unordered List: <ul>
Description List: <dl>, <dt>, <dd>
📌 Tables
<table>, <tr>, <td>, <th>
Attributes: colspan, rowspan
Table Caption: <caption>
📌 Forms
<form action="" method="POST/GET">
Form Elements:
o <input
type="text/password/email/checkbox/radio/file/hidden/submit/res
et/button">
o <textarea>
o <select> & <option>
o <label>
📌 HTML5 Semantic Elements
<header>
<nav>
<section>
<article>
<aside>
<footer>
<main>
<figure>, <figcaption>
<details>, <summary>
📌 Multimedia in HTML
Images: <img>
Audio: <audio controls>
Video: <video controls>
Embed External Content: <iframe>
📌 Meta Tags (Inside <head>)
<meta charset="UTF-8">
<meta name="description" content="">
<meta name="keywords" content="">
<meta name="viewport" content="width=device-width, initial-
scale=1.0">
📌 Entities & Symbols
→ space
© → ©
< → <
> → >
& → &
📖 CSS Full Course Summary
📌 Introduction to CSS
What is CSS?
Why Use CSS?
CSS Syntax
Adding CSS to HTML:
o Inline CSS
o Internal CSS (<style> tag)
o External CSS (<link> tag)
📌 CSS Selectors
Universal Selector *
Element Selector h1
Class Selector .classname
ID Selector #idname
Group Selector h1, p
Descendant Selector div p
Child Selector div > p
Adjacent Sibling Selector h1 + p
Attribute Selector input[type="text"]
📌 Colors in CSS
Color Names
HEX Codes
RGB, RGBA
HSL, HSLA
📌 Text and Font Styling
color
font-family
font-size
font-weight
font-style
text-align
text-decoration
letter-spacing
word-spacing
line-height
text-transform
📌 CSS Box Model
Content
Padding
Border
Margin
box-sizing: border-box
📌 Background Properties
background-color
background-image
background-repeat
background-position
background-size
background-attachment
Multiple Backgrounds
📌 Borders and Outlines
border
border-radius
outline
outline-offset
📌 Lists Styling
list-style-type
list-style-position
list-style-image
📌 CSS Display and Visibility
display: block | inline | inline-block | none | flex | grid
visibility: visible | hidden
📌 Positioning Elements
position: static | relative | absolute | fixed | sticky
top, right, bottom, left
z-index
📌 CSS Flexbox
display: flex
flex-direction
justify-content
align-items
align-content
flex-wrap
flex-grow, flex-shrink, flex-basis
📌 CSS Grid
display: grid
grid-template-columns
grid-template-rows
grid-gap
grid-column
grid-row
grid-area
📌 CSS Pseudo-classes and Pseudo-elements
Pseudo-classes: :hover, :active, :focus, :first-child, :last-child, :nth-
child(n)
Pseudo-elements: ::before, ::after, ::first-letter, ::first-line
📌 CSS Transitions and Animations
Transitions
o transition-property
o transition-duration
o transition-delay
o transition-timing-function
Animations
o @keyframes
o animation-name
o animation-duration
o animation-iteration-count
o animation-direction
o animation-delay
o animation-timing-function
📌 Media Queries (Responsive Design)
Syntax: @media (max-width: 600px) { ... }
Breakpoints for different devices
Responsive images and layouts
📌 CSS Variables (Custom Properties)
Declaring: --primary-color: #ff6600;
Using: color: var(--primary-color);
📌 CSS Functions
calc()
clamp()
min()
max()
var()
url()
📌 CSS Important Rules
!important
inherit
initial
unset
📌 Best Practices
Use external CSS files
Minimize inline styles
Use semantic class names
Maintain a consistent design system
Use CSS variables for color schemes
📌 Project Ideas for Practice
Personal Portfolio Website
Responsive Navigation Menu
Card Design with Hover Effects
Image Gallery with Grid & Flexbox
Animated Loading Spinner
Responsive Login/Signup Form
📖 JavaScript Full Course
Summary
📌 Introduction to JavaScript
What is JavaScript?
History and Features
How to add JavaScript to HTML:
o Inline
o Internal (in <script> tag)
o External (linked .js file)
📌 Basic Syntax
Statements & Semicolons
Comments: //, /* */
Case Sensitivity
Variables:
o var (old)
o let (block-scoped)
o const (constant value)
📌 Data Types
Primitive Types:
o String
o Number
o Boolean
o Undefined
o Null
o BigInt
o Symbol
Non-Primitive:
o Object
o Array
o Function
📌 Operators
Arithmetic Operators: +, -, *, /, %
Assignment Operators: =, +=, -=
Comparison Operators: ==, ===, !=, >, <
Logical Operators: &&, ||, !
Bitwise Operators
Ternary Operator: condition ? true : false
Type Operators: typeof, instanceof
📌 Control Statements
Conditional Statements:
if
if-else
if-else if-else
switch
Loops:
for
while
do-while
for-in (object properties)
for-of (iterable values)
break and continue
📌 Functions
Function Declaration
Function Expression
Arrow Functions () => {}
Function Parameters and Return
Default Parameters
Rest Parameter (...args)
Callback Functions
Anonymous Functions
IIFE (Immediately Invoked Function Expression)
📌 Arrays
Creating Arrays
Accessing Elements
Common Methods:
o push(), pop()
o shift(), unshift()
o splice(), slice()
o concat()
o join()
o indexOf(), includes()
o forEach(), map(), filter(), reduce()
📌 Objects
Object Literals
Accessing Properties:
o Dot notation [Link]
o Bracket notation object["key"]
Methods within Objects
this keyword
Object Destructuring
[Link](), [Link](), [Link]()
📌 String Methods
length
charAt()
substring(), substr()
indexOf(), lastIndexOf()
includes()
replace()
toUpperCase(), toLowerCase()
split()
Template Literals: `Hello ${name}`
📌 Date and Time
new Date()
getFullYear(), getMonth(), getDate()
getHours(), getMinutes(), getSeconds()
setFullYear(), setMonth(), etc.
📌 Math Object
[Link](), [Link](), [Link]()
[Link]()
[Link](), [Link]()
[Link]()
[Link]()
📌 DOM (Document Object Model) Manipulation
getElementById()
getElementsByClassName()
getElementsByTagName()
querySelector(), querySelectorAll()
Changing Content:
o innerHTML
o innerText
o textContent
Changing Attributes:
o setAttribute(), getAttribute()
Adding/Removing Elements:
o createElement()
o appendChild()
o removeChild()
📌 Events
onclick, onmouseover, onmouseout
onchange, onkeydown, onkeyup
addEventListener()
Event Object event
📌 Error Handling
try-catch-finally
throw keyword
📌 JSON (JavaScript Object Notation)
[Link]()
[Link]()
📌 Modern JavaScript (ES6+) Features
let and const
Arrow Functions
Template Literals
Destructuring (Arrays & Objects)
Default Parameters
Spread Operator ...
Rest Parameters
[Link](), filter(), reduce()
Modules: import / export
Promises
async / await
📌 Asynchronous JavaScript
Callbacks
Promises
async and await
Fetch API for making HTTP Requests
📌 Local Storage & Session Storage
[Link](), getItem(), removeItem()
[Link](), etc.
📌 Project Ideas for Practice
Digital Clock
Calculator
To-Do List
Image Slider
Weather App using API
Quiz Game
Form Validation
Expense Tracker
📖 SQL Full Course Summary
📌 Introduction to SQL
What is SQL? (Structured Query Language)
Why Use SQL?
SQL Database Systems: MySQL, MS SQL Server, Oracle, PostgreSQL
SQL is case-insensitive (except for string values)
📌 Basic SQL Syntax
SQL Statements end with ;
Basic Query Structure:
SELECT column1, column2 FROM table_name;
📌 SQL Data Types
INT, BIGINT
VARCHAR, CHAR, TEXT
DATE, TIME, DATETIME, TIMESTAMP
BOOLEAN
DECIMAL, FLOAT, DOUBLE
📌 SQL Commands
DDL (Data Definition Language)
CREATE
ALTER
DROP
TRUNCATE
DML (Data Manipulation Language)
INSERT
UPDATE
DELETE
DQL (Data Query Language)
SELECT
DCL (Data Control Language)
GRANT
REVOKE
TCL (Transaction Control Language)
COMMIT
ROLLBACK
SAVEPOINT
📌 Creating and Managing Tables
CREATE TABLE
ALTER TABLE
o ADD, MODIFY, DROP COLUMN
DROP TABLE
TRUNCATE TABLE
Example:
CREATE TABLE students (
id INT PRIMARY KEY,
name VARCHAR(50),
age INT
);
📌 Inserting Data
INSERT INTO students (id, name, age)
VALUES (1, 'Rahul', 21);
📌 Reading Data (SELECT Statement)
SELECT * FROM table_name;
SELECT column1, column2 FROM table_name;
Using DISTINCT
WHERE Clause
Logical Operators: AND, OR, NOT
Comparison Operators: =, !=, <, >, BETWEEN, IN, LIKE
Example:
SELECT * FROM students WHERE age > 20;
📌 Updating Data
UPDATE students
SET age = 22
WHERE id = 1;
📌 Deleting Data
DELETE FROM students
WHERE id = 1;
📌 Constraints
PRIMARY KEY
FOREIGN KEY
UNIQUE
NOT NULL
CHECK
DEFAULT
📌 Sorting and Filtering
ORDER BY (ASC/DESC)
GROUP BY
HAVING
Example:
SELECT department, COUNT(*)
FROM employees
GROUP BY department
HAVING COUNT(*) > 5;
📌 Joins
INNER JOIN
LEFT JOIN (or LEFT OUTER JOIN)
RIGHT JOIN (or RIGHT OUTER JOIN)
FULL JOIN (or FULL OUTER JOIN)
SELF JOIN
CROSS JOIN
Example:
SELECT [Link], [Link]
FROM students
INNER JOIN orders
ON [Link] = orders.student_id;
📌 Aggregate Functions
COUNT()
SUM()
AVG()
MIN()
MAX()
Example:
SELECT COUNT(*) FROM students;
📌 Subqueries
Subquery in SELECT, FROM, or WHERE
Correlated Subqueries
Nested Subqueries
Example:
SELECT name
FROM students
WHERE age > (SELECT AVG(age) FROM students);
📌 Views
CREATE VIEW
DROP VIEW
Example:
CREATE VIEW student_view AS
SELECT name, age FROM students;
📌 Indexes
CREATE INDEX
DROP INDEX
UNIQUE INDEX
📌 Transactions
START TRANSACTION
COMMIT
ROLLBACK
SAVEPOINT
📌 Stored Procedures (Intro)
CREATE PROCEDURE procedure_name()
BEGIN
SELECT * FROM students;
END;
📌 Common SQL Functions
String Functions: CONCAT(), LENGTH(), UPPER(), LOWER(), SUBSTRING()
Date Functions: NOW(), CURDATE(), DATE_FORMAT(), DATEDIFF()
Numeric Functions: ROUND(), CEIL(), FLOOR(), ABS()
📌 Important SQL Project Ideas
Student Management System
Inventory Management
E-Commerce Orders & Products Database
Library Management System
Hospital Appointment System
📖 C# Full Course Summary
📌 Introduction to C#
What is C#?
Developed by Microsoft as part of .NET
Strongly typed, object-oriented, modern language
Used for Windows apps, Web apps ([Link]), APIs, Games (Unity), Cloud services
📌 Basic Syntax
Case-sensitive
Statements end with ;
Code blocks with { }
Main() method is the entry point
Example:
using System;
class Program {
static void Main() {
[Link]("Hello World");
}
}
📌 Variables and Data Types
int, float, double, decimal
string, char
bool
var (implicit typing)
Nullable types: int?
📌 Constants
const double Pi = 3.14;
📌 Type Conversion
Implicit
Explicit (Casting)
Convert.ToInt32(), ToString()
📌 Operators
Arithmetic: +, -, *, /, %
Relational: ==, !=, >, <
Logical: &&, ||, !
Bitwise
Ternary: condition ? true : false
📌 Control Statements
Conditional:
if, else if, else
switch
Loops:
for
while
do-while
foreach
break, continue
📌 Methods (Functions)
Declaring and Calling
Parameters & Return values
Optional and Named Parameters
ref and out keywords
Method Overloading
Static vs Instance Methods
📌 Arrays
1D, 2D, Jagged Arrays
foreach for iteration
Example:
int[] nums = {1, 2, 3};
foreach(int n in nums)
[Link](n);
📌 Strings
Immutable
Common Methods: Length, ToUpper(), Substring(), IndexOf(), Replace()
String Interpolation: $"Hello {name}"
StringBuilder for performance
📌 Object-Oriented Programming (OOP)
Class and Object
Fields, Properties, Methods
Constructors
this keyword
Inheritance: :
Method Overriding (virtual, override)
base keyword
Encapsulation (private, public, protected)
Abstraction (Abstract Classes)
Interfaces
Polymorphism
📌 Exception Handling
try, catch, finally
throw keyword
Custom Exceptions
Example:
try {
int x = 10 / 0;
} catch(Exception ex) {
[Link]([Link]);
}
📌 Collections
ArrayList
List<T>
Dictionary<TKey, TValue>
Queue, Stack
HashSet
📌 LINQ (Language Integrated Query)
from ... in ... where ... select ...
Method Syntax: .Where(), .Select(), .OrderBy()
ToList(), ToArray()
Example:
var result = [Link](x => x > 10).ToList();
📌 File Handling
[Link]
File, FileInfo
StreamReader, StreamWriter
Reading and writing text files
Example:
[Link]("[Link]", "Hello");
string content = [Link]("[Link]");
📌 Delegates and Events
Type-safe function pointers
delegate keyword
Multicast Delegates
Events for event-driven programs
📌 Async and Await
Asynchronous programming
async methods
Task and Task<T>
Example:
async Task PrintAsync() {
await [Link](1000);
[Link]("Done");
}
📌 Namespaces and Assemblies
using directive
Organize code
Assemblies: compiled output as .exe or .dll
📌 Access Modifiers
public
private
protected
internal
protected internal
📌 Structs and Enums
Value types
enum for constants set
Example:
enum Days { Sun, Mon, Tue }
📌 Important Project Ideas
Library Management System
Student Result Management
Employee Record App
Banking System Console App
Basic Inventory Manager