DEV Community

Aruna Arun
Aruna Arun

Posted on

Day 2 : Basic of Python and SQL

Compiler-total line code run (java)
Interpreter -line by line execute(Python)

PYTHON
Python is a high-level, general-purpose programming language.
It is an interpreted language, meaning code is executed line by line.
Speeds up the development process.

Key Features of Python:
1.Easy to Learn and Read
2.Interpreter Language
3.Free and Open source

Components of Programming Language:
1.Data types(eg.int,float,etc...)
2.variables(eg.store the data)
3.Operators(eg.arithmetic,logical,etc..)
4.Control Structure (eg.if,else,etc..)
5.Libraries(eg.Numpy,Pandas)

Python version:
Python 2.7(lack of support for this version)
Python 3.13(new project only)

Editor:
1.IDLE(beginners and basic scripting)
2.Pycharm(powerful)
3.Sublime Text(fast and highly customisable)
4.Jupiter

SQL(Structured Query Language)

Primary key- unique id or name
Foreign key-link with both tables in id or name

RDBMS(Relational Database Management System)
such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
RDBMS is stored in database called tables.
A table is a collection of related data entries .
It consists of columns and rows.

S3
No SQL(Mongo DB,AWS document DB)

Index(exact position of the variable)
Partition (split the data)

Top comments (1)

Collapse
 
raja_sekaran_a1319259e6f1 profile image
Rajasekaran Palraj

Nice one