Long answer - you may decide SQL and REST may serve you really well, but there are some deeper questions you need to also explore that will tell you if those are right for you: Toolkits like apps/programs/concepts that help you build whatever you need. Short answer - my original meaning for that comment was looking into investing in tools for yourself, not just the actual tools you will use for your current/next job. These are tools you can use no matter what your job demands.įor me, those have been Emacs, Python and PostgreSQL, but for you they may be different. Your toolkit should include a good cross platform text editor you can count on for your whole career, a robust and mature programming language, and a free, runs-anywhere, RDBMS that you can experiment with. I suggest picking a toolkit for yourself that will stand the test of time, and get used to learning. Having been on the data/ETL/analytics side of the industry for a few decades now, I always say that the tools are always less important than the concepts and ecosystems - every company I’ve ever been at used a different toolkit, albeit with a few commonalities. But even in these shops that have invested in BI tools, you’ll still see that Excel runs everywhere. There’s also quite a bit of MicroStrategy, SAP Business Objects, and Cognos in the Business Intelligence market as well. For smaller databases, MySQL/MariaDB is still widely used, and companies that can burn money to heat the building still buy a lot of Oracle. PostgreSQL is probably the biggest up-and-comer of the last decade, making a lot of strides into the enterprise, especially with Cloud offerings and derivatives like Amazon’s Redshift. MS SQL Server provides a really solid toolkit for analysts, and T-SQL is still widely used for analytics. I do see a lot of Python, Jupyter, R, Tableau, and in some pockets Hadoop/Spark. Unless you’re going into development, I don’t see a large benefit to NoSQL environments in the analytics space. If someone cares about that data for more than the most basic analytics, it is usually ETL’ed into another environment and remodeled for reporting. NoSQL tools are used mainly in the web development space. Thanks to -sniff- for the awesome header image! You should post these to /r/learnsql instead. Note /r/SQL does not allow links to basic tutorials to be posted here. Please view the Wiki for online resources. Learning SQLĪ common question is how to learn SQL. SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3įor those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this: This will greatly increase your chances of receiving the help you desire. If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own. If you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform. When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so: The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |