"Python

- pep8 and python coding conventions

- variadic arguments in python
- using **kwargs in function
- sorting array using a key in elements that are dicts
- printing array element using fstring
- list comprehension with condition to filter
- understand data type of i in ""for i in list""
- looping through a dict to print all keys and values
- using decorators
- packages and modules

Django
- components of a URL
- Parts of an HTTP request
- Where is cookie attached in an HTTP request
- HTTP Status code 403
- Getting query params in view function
- Getting headers in a view function
- venv
- init.py
- product/:id in url pattern, how to access id in view function

SQL
- Transaction
- Requirements for a join
- WHERE vs HAVING
- TEXT vs VARCHAR
- Removing fk constraint

Theory 6
Practical 4"

"Python
- pep8 and python coding conventions
- syntax of a constructor
- variadic arguments in python
- writing methods and using attributes in them
- printing dict value using fstring (list[n]['key'])
- looping a dict to print its keys and values separately
- decorators

Django
- understand what port is
- accessing query params in a view function
- Common HTTP status codes
- accessing headers inside a view function
- different kinds of browser storages
- Parts of an HTTP request

SQL
- transaction rollback
- adding a foreign key constraint
- removing a foreign key constraint

Theory6
Practical 4"

"Python
- pep8 and python coding conventions
- variadic arguments in python
- using **kwargs in function
- sorting array using a key in elements that are dicts
- printing array element using fstring
- list comprehension with condition to filter
- understand data type of i in ""for i in list""
- looping through a dict to print all keys and values
- using decorators
- packages and modules

Django
- components of a URL
- Parts of an HTTP request
- Where is cookie attached in an HTTP request
- HTTP Status code 403
- Getting query params in view function
- Getting headers in a view function
- venv
- init.py
- product/:id in url pattern, how to access id in view function

SQL
- Transaction
- Requirements for a join
- WHERE vs HAVING
- TEXT vs VARCHAR
- Removing fk constraint

Theory 6
Practical 4"

Theory Topics:

Entity and relation

Types of relation
Relation vs relationship
Tuple and field
Domain and attribute
Records
Database Schema
Alternate key
DDL, DML, DCL, TCL
Truncate
Aggregate functions
Scalar functions
Set operations (Union, union all, intersect, minus)
Difference between union and union all
Create role
Grant and revoke
Create constraints
Functional dependency
Cross Join
Indexing
Trigger
View
Transaction
ACID
DBMS vs file system
Union vs joins
Properties of a transaction
User grant privilege command
Aggregate functions
Index
Types of SQL commands
Add a new column in a table
Aggregate key
Insert, update, and delete anomalies
Three-schema architecture
Delete vs drop
Indexing and its types
Rename DB, table, and column
Create views
Procedure

SQL
How To Create Tables
Creating Tables Without Constraints
Creating Tables with Constraints
Insert Into
Insert Into Example
Generate 1000 Rows with Mockaroo
Select From
Order By
Distinct
Where Clause and AND
Comparison Operators
Limit, Offset & Fetch
IN
Between
Like And iLike
Group By
Group By Having
Adding New Table And Data Using Mockaroo
Calculating Min, Max & Average
Sum
Basics of Arithmetic Operators
Arithmetic Operators (ROUND)
Alias
Coalesce
NULLIF
Timestamps And Dates Course
Adding And Subtracting With Dates
Extracting Fields From Timestamp
Age Function
What Are Primary Keys
Understanding Primary Keys
Adding Primary Key
Unique Constraints
Check Constraints
How to Delete Records
How to Update Records
On Conflict Do Nothing
Upsert
 What Is A Relationship/Foreign Keys
Adding Relationship Between Tables
Updating Foreign Keys Columns
Inner Joins
Left Joins
Deleting Records With Foreign Keys
Exporting Query Results to CSV
Serial & Sequences
Extensions
Understanding UUID Data Type
UUID As Primary Keys
Practical Work Topics:

SQL query writing and execution

Creating and managing databases
Defining tables and relationships
Adding, modifying, and deleting records
Creating database schemas
Creating roles and managing permissions
Implementing constraints
Writing and testing triggers
Creating and managing views
Transaction management
Index creation and optimization
Joining tables (inner join vs outer join)
Foreign key implementation (one to many relationships)
Cascading actions (e.g., cascade delete)
Using truncate cascade
Writing and executing stored procedures
▪Entity and relation
Types of relation
Relation vs relationship
▪Tuple and field
▪Domain and attribute
▪Records
▪Database Schema
Alternate key
▪DDL, DML, DCL, TCL
truncate
▪Aggregate functions
▪Scalar functions
▪Set operations
Union, union all, intersect, minus
Diff btw union and union all
▪Create role
▪Grand and revoke
▪Create constraints
▪Functional dependancy
cross Join
▪Indexing
▪Trigger
▪View
▪Transaction
ACID
▪Dbms vs file system
Union vs joins
Properties of a transaction
User grant privilege command
Aggregate functions
index
TYPES OF SQL COMMANDS
add new column in a table
Aggregate key
Insert, update and delete anomalies
3 schema architect
delete vs drop
indexing and its types
trigger
view
inner join vs outer join
db vs file
foregin key vs one to many
cascade
truncate cascade
rename db , table and column
crearte views
procedutre

"Advantages of ORM
Use case of proxy model inheritance
Explicit primary key
Decimal field args
on_delete options
Datefield
Adding data in fkey field
Select related workout
Aggregate annotate workout
Cover all topics
Theoty:5
Workout:3"

Pending Topics:
Improve the UI,
Why python,
Call method,
Features of django,
Types of views,
Types of models,
Migrations,
Types of database,
Why SQL in django,
BCNF,
Super key,
Rules for defining a tree,
Heap,
Applications of heap,
Applications of BST,
Queue implementation

Task/Django:
- Understand how authentication works
- Understand requests and response flow between Django components
- Deep dive into predefined functions and understand what exactly is doing inside
that.
Python:
- Understand how the decorator works
- Method resolution order and multiple inheritances in Python
SQL:
- having vs where
- case sensitivity of SQL language
- practice SQL queries for practical use cases
DS:
- Need to work on data structure
- Understand the problem well before proceeding
- Understand the pros and cons of each data structure well
- Understand complexity analysis and analyse the complexity of a solution

coding not finished:

dictionary related
repeated letter in a word
cumulative sum

shallow copy

SQL
one to many vs frgn key

Magic methods
MRO
Python memory management
Copy by value and copy by reference
CSRF
Request-response cycle - needs improvement
authorization
sql update column command
tuncate with cascade
understand dictionary ds
find 2nd largest in a list
generator

Purpose of views in MVT

context in templates
Custom middleware
Select query in ORM
pycache
Asgi and wsgi
Session based auth clarity
Responsibilities of a dbms
3 schema arch
ER diagram
Acid properties - consistency, isolation
Super key
Create table sql queries
Join query
2nf, 3nf
Print a list in reverse using while loop, for loop
Print key value pairs in a dict
Capitalize each word in ‘my name is ashiq”
Advantages of OOPs
Polymorphism in python
Access modifiers
Destructor
Purpose of constructor
Static and instance var in python
Swapping in python
Is
Switch case in python

Python Basics

python coding conventions

- multiple threads
- concurrency and parallelism
- GIL
- writing to sys.stdout
- copy a file in chunks
- reading a file in python
- learn fs operations in python
- package, _ini_.py
- generate n random numbers, re-roll if duplicate is generated
- date 45 days before now
- unix timestamp
- don’t overwrite built-in type names
- non-repeating strings in list
- list comprehension to filter strings with length less than 5
- decorator to prepend string to return value
- packing and unpacking
- making an instance variable readonly
- class methods, class attribs
- singleton class
- customizing class description (_str_)
- _name_
- what’s in os package?
- type(os)
- virtual memory
- tail recursion
- stack underflow
- double ended queue
- SLL palindrome or not
- load factor
- implement stack without using lists, add peek operation
- complexity of sorting algorithms when input is already sorted
- flatten a 2d array that may contain integers in the first level

Pending

Constructors and Destructors

Exception Handling
List Comprehension
Modules and package
Decorators
Generators
Modules
Decorators
purpose of venv
- packages, init.py
- what files should be 'static'
- types of browser storages
- request methods
- User-Agent
- CORS, same origin policy
- middleware
- parts of HTTP request and response
- changing HTTP status code for a response
- query params, using them in view
- parts of a URL
- path/url params
- context preprocessor
- forms, formset
- CSRF
- class based views
- ALLOWED_HOSTS
- understand cookies and session request-response cycle well. Understand how header
plays a role in this.
- mixins
Explore web and HTTP in more depth
Django pros and cons
Asgi vs wsgi
Admin.py
Middlewares - need deep understanding
Purpose of 3 schema arch
Properties of transaction
Acid - consistency,
Joins vs unions
Create table with fkey
Int type usage
Improve basic crud queries

Pendings:
REACT/REDUX
mixins
thunk

DJANGO/REST/ORM
custom middlewares
custom model manager
raw and cursor
reverse and reverse lazy
generics in rest

Python
closure
duck typing

most rpt letter in a string

second largest number in a list

SQL
rollback
commit
save point
TCL
Trigger

cross join query

having grp by query

Django 5
React 6
Python 3
SQL 3

python
why python
advantages of python
python interpret
disadvantages of python
variable
what is infer language
what is dynamic typing
rules for creating a variable
multi word variables
single value assign
multi value assign
casting
local variable
global variable
static variable
instance variable
how to delete a variable
premitive data type
non premitive data type
fundamental data type
derivative daa type
data types in python
learn about datetime
random number ( learn OTP generation using random)
string and methods
list and methods
set and methods
dictionary and methods
f string
array
Aliasing
deep copy and syntax
shallow copy and syntax
function
argument
parameter
pass by value
pass by reference
pass by object reference
pass by assignment
type of argument...
formal argument
actual argument

position argument, keyword argument, default argument, variable length argument

arbitrary argument
scope of local variable
scope of global variable
escape character
unpacking and packing
pickling
asterisks
recursion
anonymous or lambda function
3 method in lamba function
decorator
iterator (iter, next)
generator
special variable
name mangling
access modifier

_variable and __varible ( single underscore and double underscore varible different
use )
_name_
constructor
why python high level language
class
object
class properties

@property
@static method
@class method
@instance method
what is self
how to decide a size of object
name space
encapsulation
setter ans getter
accesor and muttator
magic method or dunder method
inheritance
polymorphism
duck typing
method overloading
method overriding
error type and how to handle
thread concept
file in python
is python combiled or interpreted? why
python vertual mechine

implementation of python
pychache
.pyc
binary search
lenear search
module vs package vs library vs framework
asset statement
type coercion
closue
meta class
splat operator
GIL
abstraction
pure function
variadic function
yield
list comprehension
dict comprehension
garbage collector
reference count
memory management in python

Pendings & Updates:

Python
- pep8
- id()
- ellipsis (...)
- ints and strs are not mutable
- NoneType
- current version of python
- cpython, python vm, pycache
- metaclass
- slots
- pickling
- creating venv
- environment variable
- try except else finally
- singleton
- polymorphism
- pure function
- closure
- currying
- add/remove key in dict
- looping a dict
- combine two dicts
- 1 | 2 vs 1 or 2
- :=
- function to check if list is sorted or not
- remove nth element from list
Score: 3

DB
- types of triggers
- atomicity
- SQL injection
- correlated subquery
- composite key
- cross join
- increase salary by 1000 where employee has less than average salary
- add a new column
- number of employees in each department
Score: 4

Framework
- SECRET_KEY
- reverse vs reverse_lazy
- view mixins
- signals
- commit=False in form
- static files
- related_name
- prefetch_related, select_related
- defer()
- values_list(flat=True)
- unique together
- ALLOWED_HOSTS
- HTTP OPTIONS
- structure of HTTP request and response
- query params
- path params
- browser cache
- localStorage
- WSGI
-
"Pendings:
makemigrations and migrate (need more understanding)
revert migration (unapply)
middlewares (need improvement)
context processor
mixin concept
db connection
Score:
Theory:5
Coding:5"

"Pendings:
Multiple inheritance
Exceptional handling exact syntax
Iist comprehension exact concept
Score:
Theory:5
Coding:5.5
Reviewer updated that he can move to the next week
(week 4)""Pending Topics

- dataclasses
- metaclass
- pickling
- using destructor
- docstrings
- init.py
- super()
- name
- don’t overwrite builtin names
- add key in object
- using dict values in fstrings
- lambda function to return last element of list
- ternary syntax
- list comprehension to extract small strings
- variadic function to return sum of all args

Need to conduct week 3 once again

Theory : 5
Coding : 3""Review postponed on : 26-Feb-2024
Reason : Incompletion of task
Next review date : 27-Feb-2024

Pending Topics

Magic methods
MRO
list to string
Dict key value swap
Do more practical workouts

Theory : 6
Coding : 3""Review postponed on : 19-Feb-2024
Reason : Incompletion of task
Next review date : 21-Feb-2024

Pending Topics
List operations
Dictionary operations
Do more practicals with dict
Ternary operator
List vs tuple memory management
Generators
Decorators
For loop vs while loop

Find duplicate element from list without modifying the list

List comprehension with if else condition

Key value pairs from string

Key will be elements in the string and value will be the counts of each element in
the string

Theory : 3
Coding : 3""Pendings:
makemigrations and migrate (need more understanding)
revert migration (unapply)
middlewares (need improvement)
context processor
mixin concept
db connection
Score:
Theory:5
Coding:5"
message library concept in django
Joins in sql
relations concept in sql
Durablity and Consistancy in sql
Constructor concept in python
Multilevel inheritance concept
asgi vs wsgi
middlewears in django
Migration commands working
Django session management

- Sign in automatically after sign up

- indexing
- SQL injection
- transaction
- keyword and identifIers
- functions vs classes
- static methods
- constructers
- Exceptions
- Self
- Iterators
- Migrations
- Query sets
- signals
- ORM
- CSRF
- classes
- functions
- needs to practice more
Django 6
Python 3
DB 6

Django features
MVT alternatives
Default middleware
Csrf
http request/response format
http methods, status codes
OOPs advantages
Encapsulation
Polymorphism
OOPS workouts
Don’t override python keywords
Find second largest number in a list
Replace first and last char in a string
Find key with longest value in a dict
Purpose of 3 schema
Partial dep
Explore more types in sql

magic methods - reason behind name

primary key vs unique key
authorization
anagram string
truncate table

Python
*Singleton
*@classmethod and @staticmethod
*Duck typing
*Filehandling using python
*cls argument in class