Python Programming & Unit Testing

Relational Database - SQL – 6 Days

Introduction to databases and RDBMS

Read, update and delete operations on tables. Working with nulls

Joins in SQL and working examples

SQL set based operations and data aggregation, Sub-queries in SQL

EBS(Elastic Block Storage),VPC

Database creation, concept of relation and working examples

Querying tables: Select statement, examples and its variations

Insert, Update, Delete operations and working examples

Normalization and de-normalization: Views and Temporary tables, Transactions in SQL

EBS volumes and Snapshots

Creating tables. Design view of the table, Alter table operations & Key Constraints

Filtering, Sorting, Predicates and working examples

Scalar functions in SQL and working examples

SQL programming, Creating stored procedures, Cursors in SQL

RDS

Python Programming - 6 Days

Introduction to Python

Python Functions

Scope of Variables

List and Tuple

Map and filter functions

Set and Dictionary

Python Data types and Conditions

Default arguments

Global specifier

List Methods

String

Exception Handling

Control Statements

Functions with variable number of  args

Working with multiple files

List Comprehension

List comprehension with conditionals

File Handling