Information Practices

I will explain Computer fundamentals

Basics of Python Programming:

Interactive Mode:

Script Mode:

Structure of a program   

Character Set, TOKENS, identifiers, keywords, Constants, variables, data types 

Python Character Set:

Tokens:

Keywords:

Identifiers:

Literals / Constants:

String Literals:

Numeric Literals:

Integer Literals:

Floating Point Literals:

Boolean Literals:

Special Literal None:

Variables 

DATA TYPES:

Types of operators, precedence of operators 

Arithmetic or Mathematical Operators:

Relational Operators:

Logical Operators:

Truth Tables for Logical Operators:

Assignment Operators:

Identity Operators:

Membership Operators:

Expressions:

Precedence of Operators:

Functions:

Types of Statements:

INPUT AND OUTPUT IN PYTHON PROGRAMMING:

Debugging:

Control Statements:

The if statement:

The if–elif Statement:

The nested if statement:

while loop, for loop 

List

The list() Constructor 

Dictionary:

 

All concepts regarding RDBMS/ MySql/SQL

MYSQL:

Syntax to Create and Use a Database:

View Tables Of A Database:

Data Types:

SYNTAX AND USES FOR CREATING A TABLE:

SYNTAX FOR INSERTING DATA INTO A TABLE:

Retrieving (Displaying) Data Of A Table:

Displaying Current Database:

Categories Of SQL Commands:

Viewing Structure Of A Table:

Changing Structure Of A Table USING ALTER TABLE Command:

Adding an attribute to a Table:

Removing an attribute of a Table:

Modifying datatype of an attribute of a Table:

Add Primary Key constraint to a Table:

Removing Primary Key from a table:

Adding Foreign Key constraint to a Table:

Adding UNIQUE constraint to a Table:

Adding DEFAULT constraint to a Table:

Adding NOT NULL constraint to a Table:

Using Arithmetic Operators With SELECT:

Using Column Alias:

Putting Text In Query Output:

Relational Operators:

Logical Operators:

Based On Range condition (Using BETWEEN):

Condition Based On A List (Using IN):

Pattern Matching (Using LIKE Clause):

Precedence Of Operators:

Sorting The Results (Using ORDER BY):