Welcoem to posts!!
in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c
A gentle reminder that....
Today is the last day of the Diwali sale of 33 percent off on NamasteSQL (valid on recorded courses only and not combos/coding problems)
Use code DIWALI33
and also the EARLYBIRD discount of 15 percent on live SQL and analytics engineering bootcamps.
Link to register :
www.namastesql.com/courses
#sql #analytics
19 - 4
Happy SQL wali Diwali!🪔🎇🎉🪔
May your Diwali be filled with :
Success in your queries
Quality learning experiences, and the
Light of knowledge.
#sql #diwali
116 - 9
Diwali sale is live on NamasteSQL 🎇🎇
Get 33 percent discount on SQL (English and Hindi) , Python and Tableau self paced courses.
Please note that the offer is not valid on combos , live bootcamps and coding problems.
Use coupan code DIWALI33 at checkout.
www.namastesql.com/courses
Wishing you all a happy and prosperous diwali 🪔🪔
#sql #diwali #sale
54 - 40
Here is the end to end logical flow of analytics engineering bootcamp.
The starting point will be SQL as it will be our bread and butter for the rest of the bootcamp.
Next will be normalisation and relational data modeling to understand how data is maintained in operational(OLTP) databases. We will build ER diagrams of some popular online businesses.
Then we will understand why we can't do analytics on OLTP system and the need of data warehousing.
Next dive deep into dimensional modeling which includes , various facts , dimensions , slowly changing dimensions, star schema etc.
Time to build a OLAP system/ Data warehouse on snowflake using traditional methods.
Then we will dive deep into snowflake architecture and various features. At the end we will create an end to end pipeline using various snowflake features to build a data warehouse with OLTP as a source system.
When we are done with the pipeline we will know how complex is our pipeline and realise it's difficult to maintain it.
That's when we will start learning dbt and see the magic of building production ready pipelines using dbt modelling , unit tests , documentation and data flow diagrams.
The end goal of any analytics project is to build stories using visualisation and so whats better than learning the most popular tool power bi 😊
I can't wait to share my analytics knowledge and experience with all of you. 😍
The Bootcamp is starting on November 9th. More details from the link below
www.namastesql.com/course-detail/analytics-enginee…
Use code EARLYBIRD. Valid for 3 more days.
#analytics #engineering
164 - 12
A quick summary of data modelling concepts to read before your next interview ⬇️
What is data modeling, and why is it important?
Answer: Data modeling is the process of creating a visual representation of the data structure and relationships within a database. It is important because it helps in understanding the data requirements, designing efficient databases, ensuring data integrity, and facilitating communication between stakeholders.
What are the different types of data models?
Answer: There are three main types of data models:
Conceptual data model: Represents high-level entities and relationships without considering implementation details.
Logical data model: Defines the structure of the data without considering how it will be physically implemented.
Physical data model: Specifies the physical implementation of the database, including tables, columns, indexes, etc.
What is normalization and denormalization?
Answer: Normalization is the process of organizing data in a database to reduce redundancy and dependency by dividing large tables into smaller ones and defining relationships between them.
Denormalization, on the other hand, involves adding redundant data to improve query performance by reducing the need for joins.
What are surrogate keys and natural keys?
Answer: Surrogate keys are artificial keys generated solely for identifying records in a table, while natural keys are attributes that already exist in the real world and can uniquely identify records.
Explain the differences between OLTP and OLAP.
Answer: OLTP (Online Transaction Processing) is designed for transaction-oriented applications that involve frequent, short transactions, while OLAP (Online Analytical Processing) is optimized for complex queries and analysis of large volumes of data.
What is a star schema and snowflake schema?
Answer: A star schema is a data warehouse schema that consists of one or more fact tables referencing any number of dimension tables. In a snowflake schema, dimension tables are normalized into multiple related tables, resulting in a more normalized structure.
How do you handle slowly changing dimensions (SCDs) in data modeling?
Answer: Slowly changing dimensions are dimensions that change over time. They can be handled using various techniques such as Type 1 (overwrite), Type 2 (add new row), and Type 3 (add new column). The choice depends on the specific requirements of the business.
What is cardinality in data modeling?
Answer: Cardinality refers to the relationship between rows of two tables. It describes the number of instances of one entity that can be associated with a single instance of another entity.
I am covering all of these concepts with practical implementation in my upcoming Analytics Engineering Bootcamp. Check the details below :
www.namastesql.com/course-detail/analytics-enginee…
#datamodelling #dataanalytics #sql
209 - 11
This time Think SQL zero to hero live bootcamp has got bigger and better.
In the upcoming SQL bootcamp we will cover data modelling and data warehousing in detail. Following topics will be covered :
1- Relational data modelling
2- Normalisation and The 3 normal forms.
3- Will build ecommerce data models
4- data warehousing
5- kimballs dimensional modelling
6- various types of fact and dimension tables
7- star and snowflake schema
8- Will build data models for big data warehouses
9- Why we need data warehouses.
10- Last but not the least one big table.
This is going to be the top class content and highly interactive classes.
The bootcamp starts on November 9th. Checkout the curriculum from the link below :
SQL bootcamp: www.namastesql.com/course-detail/think-sql-go-from…
Entire 18 weeks analytics bootcamp :
www.namastesql.com/course-detail/analytics-enginee…
Use code EARLYBIRD for a 15 percent discount on both the bootcamps .
#sql #analytics
90 - 36
The Analytics Engineering Live Bootcamp is here! (Duration : ~18 weeks)
On this auspicious day of Dussehra, I am excited to launch a bootcamp that will take you from data newbie to analytics pro.
I’ve been working tirelessly over the last few months to make this bootcamp the ultimate learning experience!
Here’s what we’ll cover in detail:
1. **SQL for Data Analytics (Zero to Hero)** – 5 weeks
2. **Data Modeling & Data Warehousing** – 2 weeks
3. **Snowflake (Analytics at Scale)** – 4 weeks
4. **dbt (Data Build Tool)** – 3 weeks
5. **Power BI** – 4 weeks
Want to master SQL? You can enroll in the SQL Bootcamp separately, which includes data modeling and data warehousing!
Note: Individual enrollments for other topics won’t be available to maintain the bootcamp flow.
**Bootcamp kicks off on November 9th!** Every weekend at 11 AM IST.
Registration link below. Use code **EARLYBIRD** for 15% off!
Entire bootcamp :
www.namastesql.com/course-detail/analytics-enginee…
SQL : www.namastesql.com/course-detail/think-sql-go-from…
Jai Shree Ram ♈
#SQL #Analytics #Engineering
243 - 60
This is one of the sweetest messages I’ve ever received from a student. It gave me goosebumps, made me proud, and also emotional.
I truly believe that the most important aspect of any course is its flow. Putting topics in the right order is key to making complex concepts easy to understand.
My favorite line from this message is:
"Lijiye Ankit Bansal ka NamasteSQL course,
Aaya samjh main sab kuch, bina kisi force!"
It’s moments like these that remind me why I do what I do. When a student can grasp even the most challenging topics with ease, that’s when you know you’re truly teaching. 🙏
Jai Mata Di. Let’s rock! 🚀
#SQL #Analytics
175 - 15
I have said it before multiple times.
All you need is 2500 bucks and 2-3 months of dedication to master the art of SQL and crack the SQL interviews like a PRO.
Here is the 3 step plan :
1- Complete the Namaste SQL course along with assignments (after each class) and projects. (30-45 days)
2- After that practice from my YouTube channel playlist. (30-45 days)
3- Start giving Interviews along with daily practice.
Only 3 Months left in this year and you can do it before 2024 ends 💪💪
Link to the course, coupon code and playlist below.
Use code ILOVESQL for 15 percent discount :
www.namastesql.com/course-detail/think-sql-go-from…
Complex SQL Questions for Interview Preparation: www.youtube.com/playlist?list...
#sql #analytics
287 - 21
Pleased to announce a 2 hour long video to learn SQL for data analysis on my YouTube channel.
In this video I will take you through the very fundamentals of SQL and how to think like SQL.
We will cover various important topics and how to approach the problems.
If you are struggling to learn SQL for data analytics then this video is a great starting point. Trust me 🙏
Link to the video : https://youtu.be/iDBznYIMuw4
#sql #analytics
282 - 7
I am a Data Engineer at Amazon. I have 13 years of experience into Data Analytics/Engineering . During these years I have worked on multiple tools and technologies.
SQL is one technology which I have constantly worked on through out these 11 years and I just love writing SQLs each and everyday. I have decided to share my knowledge via youtube videos. Videos will be mix of concepts and scenerio based questions.If you want to fall in love with SQL , do subscribe to the channel. I will be sharing content around SQL, Tableau and Python.
Business Enquiries : ankitbansal1988@gmail.com