Welcome to the comprehensive knowledge hub, where I delve into the exciting realms of Data, SQL, and Cloud. Whether you're a seasoned data professional
or just starting your journey, the curated content covers a spectrum of concepts, projects, and tool setups in the field of data engineering.
| Sr. No. |
Subpage |
Description |
| 1. |
Big Data |
Explore the fascinating world of big data, understanding its challenges and opportunities. |
| 2. |
Data Modeling |
Learn about various data models and the art of data modeling. |
| 3. |
Data and Databases |
Delve into the intricacies of databases, their types, and effective database management systems. |
| 4. |
Data Warehouse and Data Lake |
Gain a comprehensive understanding of data warehousing and datalakes, exploring their functionalities. |
| 5. |
Data warehouse dimensional Modeling |
Learn about various data warehouse dimensional modeling. |
| 5. |
Data Mining |
Uncover the secrets of data mining, exploring its applications and methodologies. |
| 6. |
Data protection policies |
What are the best data protection policies?. |
| 7. |
Data Mining at AWS |
Dive into a model project on AWS, showcasing the application of data mining in real-world scenarios. |
| 1. |
SQL Basics |
Establish a solid foundation in SQL, covering fundamental concepts and query languages. |
| 2. |
SQL Basic Details |
Explore the depths of SQL, understanding its intricacies and advanced functionalities. |
| 3. |
SQL Joins |
Various types of joins in SQL is discussed here. |
| 4. |
PostgreSQL |
Take a deep dive into PostgreSQL, a powerful open-source relational database management system. |
| 5. |
Slowly Changing Dimension (SCD) |
Understand the concept of Slowly Changing Dimensions and its application in near real-time data streaming on AWS ecosystem. |
| 6. |
SQL Project in postgreSQL |
Explore a comprehensive SQL project in the e-commerce domain, showcasing practical applications. |
| 7. |
NOSQL & MongoDB |
Explore a Fundamentals of NoSQL and MongoDB. |
| 8. |
Neo4j & Graph theory |
We will discuss graph-oriented databases via one of their most used representatives: Neo4J. |
| 9. |
Elasticsearch |
It is often used to enable search functionality for applications and websites. |
| Sr. No. |
Topic |
Description |
| 1. |
Cloud Computing Fundamentals |
Learn the fundamentals of cloud computing, understanding its architecture and benefits. |
| 2. |
AWS and GCP |
Compare and contrast Amazon Web Services (AWS) and Google Cloud Platform (GCP) to make informed cloud decisions. |
| 3. |
Amazon S3 |
Gain in-depth insights into Amazon S3, including details on creating buckets and its role in real-time data streaming projects. |
| 4. |
EC2 Configuration |
Explore the configuration of EC2 machines in the context of real-time data streaming projects. |
| 5. |
Snowflake Basics |
Understand the basics of Snowflake, a cloud-based data warehousing platform. |
| 6. |
Snowflake Task and Stream |
Explore the generation of Snowflake tasks and streams for near real-time data streaming from the AWS ecosystem. |
| 7. |
Docker Basics |
Learn the essentials of creating Docker containers, an integral part of the real-time data streaming project. |
| 7. |
Docker Container Creation |
Learn about the components of Docker containers, in the context of my project on real-time data streaming on AWS |
| 8. |
Jupyter and NiFi |
Explore the installation and access of Jupyter notebooks, Python, and NiFi in the context of real-time data streaming projects. |
