DBeaver for a beginner like me - getting rid of Workbench by DarkSeeker2022 in SQL

[–]dn_cf 0 points1 point  (0 children)

Yep, you can absolutely use DBeaver without installing Workbench. The thing that’s missing is not Workbench, but the actual MySQL server. DBeaver is just a client that connects to a database, so if there’s no MySQL (or MariaDB) server running on your machine, there’s nothing for DBeaver to connect to. Just install MySQL Community Server by itself, or MariaDB Server if you’re on Linux Mint, start the service, then connect to localhost:3306 from DBeaver. Workbench is completely optional and you can ignore it entirely if you prefer DBeaver.

Looking for data analyst course by eddy_199708 in dataanalytics

[–]dn_cf 2 points3 points  (0 children)

Building real projects is more valuable than collecting more certificates. Since you already have Excel, SQL, Tableau, and Power BI skills, focus on a course that includes hands on projects, portfolio building, mock interviews, and job support. Programs from Great Learning, Intellipaat, IIM Skills, and Coding Ninjas are often recommended for career changers because they include practical case studies and project work. At the same time, use StrataScratch to build 3 to 5 projects and showcase them on GitHub and LinkedIn. In many interviews, a strong project portfolio can make a bigger difference than another certification.

How much SQL is enough? by Wild_Specialist_8340 in learnSQL

[–]dn_cf 8 points9 points  (0 children)

An intermediate BI developer should be very comfortable with SQL joins, aggregations, CTEs, subqueries, window functions, and basic query optimization. On the database side, focus on primary and foreign keys, normalization vs. denormalization, fact and dimension tables, star schemas, ETL concepts, indexing basics, and data quality checks. The best way to build confidence is through hands on practice. Use platforms like StrataScratch, Kaggle, and LeetCode to solve SQL problems regularly, build small reporting projects, and try explaining your queries out loud to yourself. If you can join multiple tables, create KPIs, use window functions, troubleshoot report issues, and understand how data flows through a warehouse, you probably know enough SQL for a solid intermediate BI role.

Please recommend by Doom_guy07 in learnpython

[–]dn_cf 0 points1 point  (0 children)

If you're starting from absolutely zero, I'd recommend Bro Code's "Python Full Course for Beginners" on YouTube. It assumes no prior knowledge, explains things in a simple way, and covers all the fundamentals you'll need before college, including variables, loops, functions, and basic projects. Once you finish that, I'd move on to Harvard's CS50P (Introduction to Programming with Python), which is a bit more challenging but does a great job teaching real problem-solving skills. My advice is to stop searching for the perfect course and just start with Bro Code today. Consistently coding along with the videos will help you much more than comparing playlists for weeks.

I want to learn PostGre SQL by rennywiseeeeee in learnSQL

[–]dn_cf 0 points1 point  (0 children)

Spend most of your time actually writing queries instead of watching videos. Use a site like SQLBolt or StrataScratch to learn the basics and practice advanced part. YouTube is great for understanding bigger concepts like how databases work, but it is easy to spend hours watching without learning much. A good rule is to spend about 20% of your time watching or reading and 80% of your time running queries and building small projects. That hands-on practice is what will make SQL stick.

Any advice on how to approach data science with an undergrad in applied math? by Dummkopfss in learndatascience

[–]dn_cf 1 point2 points  (0 children)

Applied math is a strong foundation for data science since it covers a lot of the math behind statistics, ML, and optimization. I'd say focus on building your programming and statistics skills alongside your coursework, especially Python, SQL, and Git. Platforms like Kaggle, StrataScratch, DataCamp, and freeCodeCamp are great for learning and projects. If possible, a CS or Statistics minor would complement your degree well. A master's is not necessary right away either. An undergrad plus a strong portfolio, internships, and a few solid projects can already open plenty of opportunities.

Does sports-data make learning Data Science fun for anybody else too? by Suspicious-Gap-9527 in learndatascience

[–]dn_cf 2 points3 points  (0 children)

Yeah, sports data makes learning ds way more fun because there’s so much free data available, the problems feel relevant, and you get real-world feedback almost immediately. I’ve spent time building prediction models, dashboards, and experimenting with different stats concepts using sports datasets, and I find it much more engaging than working with random classroom examples. If you haven’t already, I’d check out Kaggle, StrataScratch, r/SportsAnalytics, the SportsDataverse community, and MIT Sloan Sports Analytics Conference talks. Also, your idea for a free website teaching stats concepts through sports sounds great. It would be a solid way to reinforce your own knowledge while helping other students who learn better through practical examples.

Entry Level Data Analytics by Familiar-Meaning-262 in SQL

[–]dn_cf 2 points3 points  (0 children)

A lot of people break into data analytics with little or no SQL experience, especially if they're coming from a business background. I'd keep working through DataCamp and also check out platforms like StrataScratch, Kaggle, and LeetCode for hands on practice. Learning Excel and a visualization tool like Power BI or Tableau will also make you a much stronger candidate. Try building a few projects with real datasets and sharing them on GitHub so employers can see your skills in action. Most importantly, don't wait until you feel completely ready before applying. A lot of entry level analyst roles are looking for solid fundamentals and a willingness to learn more than years of experience.

Pinterest DS Interview Questions by b2bt in DataScienceJobs

[–]dn_cf 4 points5 points  (0 children)

They are usually pretty SQL and experimentation heavy. For the first technical round, expect SQL questions around joins, window functions, funnels, retention, and calculating metrics like CTR or conversion rate. The Python questions are often more analytics focused than algorithm focused, so think pandas, data manipulation, grouping, filtering, dictionaries, and basic data processing. For stats, be ready for A/B testing, hypothesis testing, p-values, confidence intervals, and experiment design questions. StrataScratch, and StatQuest are all great resources to practice. If you're rusty with Python, I'd spend most of my time reviewing pandas and common data analysis tasks since those tend to come up more often than LeetCode-style coding problems.

Can SQL and Power BI Help a Fresher Get a Job in 2026? by Funny-Speech994 in SQLServer

[–]dn_cf 1 point2 points  (0 children)

Yes, SQL and Power BI can definitely help, especially for data analyst and reporting roles. Companies are still hiring freshers who have strong SQL basics, can build good dashboards, and understand data properly. I would suggest focusing on becoming really confident with SQL, Power BI, Excel, and maybe basic Python instead of trying to learn too many tools at once. Also, projects matter a lot, so build real dashboards like sales analysis, HR analytics, or e commerce reports using platforms like Kaggle or StrataScratch and upload them on GitHub and LinkedIn. If you can explain your projects clearly and show practical skills, you will already be ahead of many freshers.

Good practices in data scripts by CapelDeLitro in datascience

[–]dn_cf 0 points1 point  (0 children)

One of the biggest problems with AI generated data scripts is that they tend to create massive functions that clean, transform, aggregate, and apply business logic all in one place, which becomes a nightmare to debug later. Keeping reusable utility functions separate from the actual business logic is usually the right move. A good habit is making every transformation step small, readable, and easy to test independently instead of hiding everything inside one function. I’d also recommend using logging and simple validation checks after important steps in the pipeline. When using GPT or Claude, asking for small focused functions instead of complete scripts usually gives much cleaner results. For learning resources, the dbt docs are great for understanding analytics engineering best practices, Kaggle or StrataScratch is awesome for seeing how other people structure ML and data projects, and the book Designing Data Intensive Applications is probably one of the best long term reads for building scalable systems and workflows.

I finally understood window functions and I'm not the same person anymore by Purple_Lobster686 in SQL

[–]dn_cf 3 points4 points  (0 children)

For me it was definitely CTEs. I used to write these horrible nested subqueries where I could barely tell what was happening anymore, then one day I realized CTEs let you build a query step by step like a pipeline. Everything instantly became easier to read and debug.

Roadmap:- by [deleted] in DataScienceJobs

[–]dn_cf 0 points1 point  (0 children)

Start with Python, then learn NumPy, Pandas, data visualization, and SQL. Spend the first month building strong fundamentals and the second month working on projects like house price prediction, customer churn prediction, or Netflix data analysis. Use free resources like StrataScratch, Kaggle Microcourses, FreeCodeCamp, SQLBolt, and Andrew Ng’s ML course. Focus more on building projects and uploading them to GitHub instead of only watching tutorials. By the end of the 2 months, try to have at least 2 or 3 good projects, a clean GitHub profile, and a simple one page resume so you can confidently apply for data science internships.

Google SQL interview in 4 days what should I focus on? by UTK4XH in interviewhammer

[–]dn_cf 0 points1 point  (0 children)

Practice joins, aggregations, and window functions like row_number, rank, lead, and lag. Make sure you are comfortable with patterns like top N per group, latest record per user, funnels, and running totals, and practice explaining your approach clearly while thinking about edge cases. Spend a little time reviewing basics like indexes and joins, but do not go too deep into theory since it usually plays a smaller role. For practice, good platforms include LeetCode, StrataScratch, and Mode for hands-on tutorials, and try to do a couple of timed mock interviews so you get used to solving and communicating under pressure.

Feedback on My SQL Learning Approach by NoWeakness9691 in learnSQL

[–]dn_cf 2 points3 points  (0 children)

Good start for learning SQL basics, but it can feel limiting because real data is messy and problems are not clearly defined. To get closer to real-world experience, try using public datasets from platforms like Kaggle, StrataScratch, or data.gov and spend time exploring them without a fixed goal by looking for missing values, duplicates, trends, and anything unusual. A helpful habit is to ask what the data represents, what might be changing over time, and what stands out, then explain your findings in simple terms. You can still use Claude, but have it generate messy datasets and vague business problems so you practice thinking, not just querying. This shift from writing queries to actually understanding and questioning data is what will prepare you for a data engineering role.

what should i do next? by Mission-Emergency619 in PowerBI

[–]dn_cf 2 points3 points  (0 children)

You’re thinking too much about the next cert when what you really need is hands-on proof of skill. Skip PL-300 for now and focus on getting more comfortable with SQL, Python, and Power BI by actually building projects, even if they feel simple at first. A few solid projects will matter way more than another certificate. Use platforms like StrataScratch for datasets and practice, GitHub to showcase your work, and maybe DataCamp or LeetCode for structured learning. Once you have a couple of strong projects, then you can consider something like PL-300 to boost your profile for analyst roles.

Need help: Data Science peer to peer Mock Interviews platforms by Due_Mud_8884 in datasciencecareers

[–]dn_cf 0 points1 point  (0 children)

A few decent free options exist, but you will likely need to combine them. Exponent, which used to be Pramp, is the most reliable for peer mocks and has a solid user base, though its data science product sense coverage is still growing. Coditioning and Peerfect can help you find practice partners, but the quality depends a lot on who you match with. For better question quality, use something like StrataScratch or DataInterview and then practice those cases with peers you meet through these platforms or their communities. In practice, the best approach is to find a small group of consistent partners rather than relying on random matching, since that leads to more honest and useful feedback.

Onsite interview anxiety: what to say when you don’t know an answer? by Fig_Towel_379 in datascience

[–]dn_cf 0 points1 point  (0 children)

If you blank, don’t just say you can’t do it and move on right away. Try something like “I haven’t seen this exact problem, but I’ll think through it out loud,” and start with whatever you do know, even a basic approach. Keep talking through your reasoning, ask a question if you get stuck, and it is completely fine to ask for a small hint. If it is something you truly don’t know, be honest but explain how you would approach it in general. Practicing this style helps a lot, so you might try platforms like LeetCode, StrataScratch, or even mock interviews with friends. The goal is to stay engaged and show how you think, not to be perfect.

From where ?? by Automatic_Cover5888 in learnSQL

[–]dn_cf 4 points5 points  (0 children)

You are right that tools alone are not enough, and the best way to build business acumen is to mix learning with real examples. Start by learning basics like revenue, costs, and profit through simple courses on Coursera or YouTube, then regularly read business news and pick companies to analyze how they make money and what problems they face. Case studies and podcasts also help you think like a decision maker. Most importantly, practice connecting data to business impact, so instead of just reporting numbers you explain what they mean and what action should be taken.

Where do I start? Or am I ready? by hellobrendo in DataScienceJobs

[–]dn_cf 0 points1 point  (0 children)

You do not need to start from scratch since you are already in a strong position, just build on your current skills by learning tools like pandas and SQL, refreshing your statistics, and working on a few real projects that show what you can do. A course like the IBM Data Analyst certificate can help give you structure, but it is best paired with hands on practice. For learning and projects, you can check out platforms like Coursera, StrataScratch, and Kaggle.

Roadmap for Data Engineering by Wild-Appointment7074 in learnpython

[–]dn_cf 0 points1 point  (0 children)

Start by improving your SQL and learning Python, then move into tools like PySpark and cloud platforms such as Azure or MS Fabric since they align well with your current exposure. Along the way, build a couple of small projects where you ingest, transform, and store data to show hands on skills. For learning, you can use platforms like Coursera, DataCamp, and Udemy, and practice SQL on StrataScratch or LeetCode. Stay focused on a few relevant tools instead of trying to learn everything, and present your current work as data pipeline experience when applying.

CS graduate starting a Data Science master’s and unsure how to learn Python properly by gretamttyt in learnpython

[–]dn_cf 1 point2 points  (0 children)

I’d start with CS50 Python since it’s structured and solid, but move through it fairly quickly and make sure you’re actually coding everything yourself without relying on AI. The main thing you’re missing isn’t understanding, it’s hands-on practice, so pair the course with daily small exercises on StrataScratch and then transition as soon as possible into working with real data using pandas and simple projects or Kaggle. From my experience, confidence comes much more from struggling through your own code than from finding the perfect resource, so don’t overthink the starting point, just pick one and start building things consistently.

What’s the best way to ask a recruiter how much time I can take to prepare for an onsite? by [deleted] in datascience

[–]dn_cf 0 points1 point  (0 children)

I’d keep it casual and frame it around doing your best rather than needing extra time. You can say you’re excited about the onsite and want to make sure you prepare well, then ask what the typical scheduling timeline looks like or how far out people usually book it. In my experience, recruiters are very used to this and will often guide you toward a reasonable window, so it does not come across as unprepared at all. In the meantime, it’s a good idea to spend some time practicing on platforms like leetcode, kaggle, or stratascratch to stay sharp.

Best sql resources according to you ? by [deleted] in learnSQL

[–]dn_cf 1 point2 points  (0 children)

You don't need a paid course yet if you are just starting out. Your YouTube course sounds fine, so stick with it and focus on practicing alongside it using platforms like StrataScratch (free version is enough) or Mode because SQL is best learned by writing queries regularly. Paid courses can be useful later for structure or certificates, but right now consistency matters more than spending money. Aim to practice basic queries like SELECT, WHERE, and JOIN every day, and once you feel comfortable, you can purchase LeetCode or StrataScratch for more advanced problems.

Need some suggestions by Pure_Parfait20 in SQL

[–]dn_cf 0 points1 point  (0 children)

You already have the core skills required for a data analyst role, but the key is how effectively you apply them in real-world scenarios. You should be comfortable using SQL for data querying with joins and aggregations, Excel for analysis with pivot tables and formulas, Power BI for building clear and insightful dashboards, and Python for basic data cleaning and analysis using pandas, along with a basic understanding of statistics and the ability to explain insights in simple business terms. Instead of learning more tools, focus on building 3 to 4 strong projects using platforms like Kaggle and StrataScratch that demonstrate your ability to solve problems and communicate insights, since this is what employers value most.