SQL Academy Bangladesh

25/12/2023

Let's argue about Left and Right joins.
When which join to use. Why both exist?
Can we use left instead of right outer join, or right outer join instead of left join?

In this video you'll know about left outer and right outer join and why both are present in SQL.When we should use which one.

30/10/2023

📊 Choosing the Right Chart for Data Analysis 📈

When diving deep into data visualization, the power lies not just in presenting beautiful graphics, but in conveying the right message with clarity. For freshers and even seasoned professionals, choosing the apt chart can sometimes be overwhelming. Here’s a handy guide from me to making your charts not just look good, but also tell the right story:

🔍 Comparison:
Bar, Column, Grouped bar/column, Lollipop, Bullet, Dot plot, and many more.
🌍 Geospatial Visualization:
Geographic heatmap, Choropleth map, Sankey, Network diagram, etc.
🔗 Correlation:
Heatmap, Bubble chart, Scatter plot, Hexagonal binning, etc.
🍰 Part-to-whole & Hierarchical:
Stacked bar/column, Pie chart, Donut, Treemap, Funnel, etc.
⏳ Temporal (Data over Time):
Area, Line, Spline, Candlestick, Gantt, Barcode, etc.
📊 Distribution:
Density, Histogram, Box chart, Violin plot, and others.

Remember, the key isn’t just to pick a chart that looks good, but one that complements your data's narrative. The right visualization can make your insights stand out, while the wrong one can overshadow them. Choose wisely!
Feel free to share, bookmark, or comment with your experiences.
Follow SQL Academy Bangladesh to know more about drive data-driven storytelling! 🚀

10/09/2021

ডেটাবেজ নরমালাইজেশন 2NF

Database Normalization 2NF in full Bangla for the beginners and them who wants to learn database normalization

10/09/2021

ডেটাবেজ নরমালাইজেশন - 1NF

Database Normalization - 1NF in Bangla

08/09/2021

ডেটাবেইজ নরমালাইজেশন কনসেপ্ট

Database Normalization in Bangla.This tutorial is for the academic purpose and for them who wants to learn database engineering and work with databases.

08/08/2021

Shebaclinic

19/07/2021

04/04/2019

We are planning to start next Oracle DBA batch from mid of April. If anybody interested to join then please confirm. For more information please call me in this number: 01613-065090 or 01817-089201.

Thanks,
Mamun

27/12/2018

We are planning to start a Oracle DBA course and Oracle Developer course from January 1st week. If anybody interested to join then please confirm.

Thanks,
Mamun

11/12/2018

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.
Course Topics

1. Introduction to database management systems and databases
2. Relational Database Model and Installing Oracle database software
3. Managing the Oracle Instance
4. Oracle Database Architecture
5. Managing Database Storage Structures
6. Configuring the Oracle Network Environment
7. User Administration and Security
8. Managing Schema Objects
9. Managing Data and Concurrency
10. Managing Undo Data
11. Implementing Oracle Database Security
12. Proactive Maintenance
13. Performance Management
14. Used Managed (Manual) Backup and Recovery
15. RMAN Backup and Recovery
16. Performing Flashback
17. Oracle database upgrades
18. Oracle Utilities
19. Performance Tuning
20. Real world life of an Oracle DBA

Class Schedule : Friday and Saturday (3 hours).
Course Duration : 4 months
Course Fee : 20,000/=

After completing this course one can be an expert Database Administrator. He can apply any company for the post of ‘Database Administrator’. So be hurry to confirm your presence and take the opportunity to expertise yourself. Please call me in this number: (01817-089201 or 01911-299228) for more details or email to: [email protected]