Topics :

What is an Application?

Overview of applications and their significance.

Types of Applications

Classification and examples of various application types.

Fundamentals of Web Applications

Basic concepts and components of web applications.

Web Application Architecture

Structure and design patterns in web application architecture.

Web Technologies used in Projects

Key technologies and frameworks used in web application development.

Topics :

Introduction to Software Development Life Cycle

The phases, importance, and overview of SDLC.

Application Lifecycle Management - ALM

Tools, processes, and overview of ALM.

SDLC Methodologies

Examination of different methodologies used in software development.

DevOps Process

Understanding the principles, practices, and benefits of DevOps.

Topics

1. Introduction To Agile & Scrum

Fundamental overview of Agile methodologies and the Scrum framework.

2. The Principles of Agile Methodology

Core principles of Agile focusing on iterative development and customer collaboration.

3. Scrum Framework: Roles, Artifacts, and Events

Key components of Scrum, including its roles, artifacts, and structured events.

4. Implementing Agile with Scrum

Strategies for applying Agile and Scrum practices in software development projects.

5. Agile Project Management Best Practices

Essential practices for leading Agile projects, emphasizing communication and continuous improvement.

Topics :

Introduction to Linux OS

Exploring the fundamentals of the Linux operating system.

Linux Distributions and Architecture

Understanding different distributions and the architecture of Linux.

Command Line Interface (CLI) & Filesystem

Mastering the CLI and navigating the Linux filesystem.

File Management and vi Editor

Managing files and editing them using the vi editor.

Archives and Package Management

Utilizing tar, zip utilities, and managing packages in Linux.

System Installation and Package Managers

Installing software on Ubuntu, using .deb files, and the APT package manager.

Users, Groups, and Permissions

Managing users and groups, and configuring permissions.

Networking Basics: IP Address, Protocols, & Ports

Introduction to networking in Linux: IP addresses, protocols, and ports.

Firewalls and Security Measures

Configuring firewalls and understanding basic security measures.

Load Balancers

Basics of load balancing in a Linux environment for optimizing performance and reliability

Topics Covered:

Database Basics: OLTP, DWH, OLAP, HTAP

Introduction to RDBMS and the advantages of PostgreSQL

PostgreSQL history, open-source contributions, and real-time applications

Installation on both Windows and Linux (RHEL, Ubuntu)

Topics Covered:

Mastering pgAdmin and PSQL command-line tools

Core SQL operations: DDL, DML, and SELECT statements

Advanced SQL features: Subqueries, Aliases, and Operators

Topics Covered:

Detailed transaction management: ACID properties, COMMIT, and ROLLBACK

Database and table operations using PSQL

Managing databases with schemas and environment configurations

Topics Covered:

Constraints and keys: Primary, Foreign, Unique, and Check constraints

Entity Relationship (ER) modeling and database design

Managing identity columns and custom sequence generation

Topics Covered:

Comprehensive exploration of SQL Joins: INNER, OUTER, CROSS, and SELF joins

Practical use of joins in real-world data manipulation

Advanced querying techniques for complex data structures

Topics Covered:

Introduction to PL/pgSQL for procedural programming

Creation and management of stored procedures and functions

Implementing and managing triggers for automated database interactions

Topics Covered:

Deep dive into PostgreSQL server architecture and processes

Understanding utility processes like Bgwriter, WAL, and Autovacuum

Memory management in PostgreSQL and performance monitoring

Topics Covered:

Comprehensive security management: User roles, access controls, and permissions

Backup strategies and tools: Logical vs. Physical backups, using pg_dump and pg_restore

Implementing row-level security and using pg_hba.conf for connection security

Topics Covered:

Indexing strategies, partitioning, and query optimization

Configuring and managing high availability and disaster recovery solutions

Replication configurations and maintaining performance under load

Topics Covered:

Effective lock management and strategies to avoid deadlocks

Techniques for successful database migrations

Handling large-scale and complex PostgreSQL deployments

Topics:

Introduction to Databases and SQL: Understanding relational databases and the role of SQL.

SQL Syntax Overview: Keywords, statements, and clauses.

Basic SQL Commands: SELECT, FROM, WHERE, and ORDER BY.

Filtering Data: Using conditions to retrieve specific data (AND, OR, NOT).

Topics:

Understanding Table Relationships: Primary keys, foreign keys, and the importance of relationships in databases.

Join Operations: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

Subqueries and Nested Queries: Using subqueries in the SELECT, FROM, and WHERE clauses.

Aggregating Data: Using GROUP BY and aggregate functions (COUNT, SUM, AVG, MIN, MAX).

Topics:

Data Manipulation Commands: INSERT, UPDATE, DELETE.

Managing Tables: Creating and altering tables (CREATE TABLE, ALTER TABLE, DROP TABLE).

Advanced Filtering Techniques: Using LIKE, IN, BETWEEN, and wildcard characters.

Working with Dates and Times: Understanding and manipulating date and time data.

Topics:

Advanced SQL Functions: String functions, mathematical functions, and date functions.

Window Functions: Overviews of ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, and their applications.

Query Performance Optimization: Indexes, query planning, and execution paths.

Common Table Expressions (CTEs): Writing cleaner and more readable queries with WITH clause.

Topics:

Analytical SQL for Reporting: Building complex queries to answer analytical questions.

Pivoting Data: Transforming rows to columns (PIVOT) and columns to rows (UNPIVOT).

Data Warehousing Concepts: Introduction to data warehousing practices and how they apply to SQL querying.

Integrating SQL with Data Analysis Tools: Connecting SQL databases with tools like Excel, Power BI, and Python for deeper data analysis.

Topics :

Cloud Concepts

Understanding the benefits and considerations of using cloud services.

Exploring Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS), Software-as-a-Service (SaaS).

Differentiating between Public Cloud, Private Cloud, and Hybrid Cloud models.

Topics :

Azure Compute

Introduction to the types of compute services offered by Azure and their use cases.

Azure Storage

Overview of Azure's storage options and recommendations for different data types and usage scenarios.

Azure Networking

Basic concepts of Azure networking solutions including virtual networks, subnets, and connectivity options.

Azure Database Services

Introduction to Azure's database services for relational and non-relational data.

Topics :

Azure Pricing and Support

Understanding Azure pricing, cost management tools, and Azure support plans and services.

Azure Governance

Azure governance methodologies, including Role-Based Access Control (RBAC), resource locks, and Azure Policy.

Topics :

Azure Portal and Azure CLI

Utilising the Azure Portal and Azure Command-Line Interface (CLI) for managing Azure services.

Azure Management Tools

Introduction to Azure management tools like Azure Monitor, Azure Resource Manager, and Azure Policy for efficient resource management.

Topics :

App Services

Overview of Azure App Service plans, networking for an App Service, and container images.

Understanding how to deploy and manage web apps and APIs using Azure App Services.

Topics Covered:

Overview of Azure Databases for PostgreSQL

Relational Database as a Service (DBaaS) Explained

Advantages and Implementation Options of PostgreSQL in Azure

Understanding Deployment Models: Single Server, Flexible Server, HyperScale (Citus)

Topics Covered:

Key Azure Resources and Services for Database Management

Managing Storage in Azure: Blob Storage, File Shares, and Storage Tiers

Azure Active Directory (AAD): Creating Users and Managing Permissions

Service Principals and Identity Access Management (IAM)

Topics Covered:

Steps to Create and Configure PostgreSQL Server Instances on Azure

Flexible Server Deployment Options and Their Benefits

Security Configurations: Firewall Settings and Connection Security

Database Creation, Data Insertion, and Query Performance in Azure

Topics

Topics Covered:

Strategies for Migrating Databases from On-Premise to Azure

Using Azure Data Movement Service (DMS) for Efficient Migrations

Handling Schema Migrations and Network Configurations

Best Practices for Using Virtual Networks and Security Groups during Migration

Topics:

Monitoring Tools and Techniques in Azure for PostgreSQL

Implementing Robust Security Measures: TDE, SSL, VA

High Availability (HA) and Disaster Recovery (DR) Strategies

Planned Maintenance, Patching, and Real-Time Operational Adjustments

Each module is designed to provide not only theoretical knowledge but also practical insights and steps for effective management of PostgreSQL databases on Azure, making it ideal for database administrators looking to leverage Azure's cloud capabilities.

Topics:

Cloud Computing Fundamentals: Overview of cloud service models (IaaS, PaaS, SaaS) and deployment models (public, private, hybrid).

Basics of DevOps: Understanding the DevOps culture, practices, and its significance in cloud environments.

Data on the Cloud: Exploring cloud storage solutions, databases, and big data services provided by major cloud providers (AWS, Azure, Google Cloud).

Introduction to Infrastructure as Code (IaC): Concepts and tools for managing infrastructure through code.

Topics:

Cloud Storage Solutions: Differences between object storage, file storage, and block storage. Use cases for each.

Cloud Databases: Overview of relational and NoSQL database services in the cloud (e.g., AWS RDS, Azure SQL Database, Google Cloud Firestore).

Data Warehousing and Big Data Solutions: Introduction to cloud-based data warehousing services (e.g., Amazon Redshift, Google BigQuery, Azure Synapse Analytics).

Data Migration to Cloud: Strategies and tools for migrating data to cloud environments.

Topics:

Automated Data Pipelines: Designing and implementing automated data pipelines using cloud services.

Continuous Integration and Continuous Delivery (CI/CD) for Data: Applying CI/CD practices to data pipeline development, including version control, testing, and deployment strategies.

Monitoring and Logging: Tools and practices for monitoring cloud resources and data pipelines, understanding logs and metrics for troubleshooting.

Infrastructure as Code (IaC) for Data Systems: Using IaC tools (e.g., Terraform, CloudFormation) to provision and manage cloud data infrastructure.

Topics:

Serverless Data Processing: Leveraging serverless architectures for data processing tasks (e.g., AWS Lambda, Azure Functions).

Containerization and Data Services: Using containers (e.g., Docker, Kubernetes) for deploying and scaling data applications and services in the cloud.

Machine Learning and AI in the Cloud: Introduction to cloud-based machine learning services and integrating AI capabilities into data pipelines.

Data Analytics and Visualization: Tools and services for analyzing and visualizing data directly in the cloud (e.g., Amazon QuickSight, Google Data Studio, Power BI on Azure).