Loading...
Answers
MenuWhere can I learn SQL for business professionals? I need only the reporting part. I can run basic queries, but want to do more heavy queries.
Ive done the CodeAcademy SQL for Business by Periscope. But was short and pretty basic. I need exercises and more concepts of data manipulations, joins, etc. Im interested in a tutor or a course.
Answers
There are a few options. If you've done the basics through Codecademy, then you're ready to move on to the specifics of a platform (such as PostgreSQL as you've mentioned). Though this can equally be a minefield.
The reporting engines/formats differ from platform to platform. As does SQL believe it or not, in the sense each of the mainstream vendors adds their own specific bits to the standard. They are all compliant for the basics though. All of them will support the latest version of SQL (ANSI standard 2011), but PL/SQL is different to Transact-SQL in the way it uses cursors.
In addition, each has an even bigger variation when it comes to multidimensional queries such as MDX, since there is no standard for MDX and some vendors use their own expressions and languages to carry out such queries.
I can certainly help with tutoring, having been working in SQL since 1997 (and still do), although I think it's worth focussing on getting a little better at the specifics of the SQL vendor extensions you want to use, including their Cube, Pivot and Grouping functions as well as more complex joins, as they'll be the baseline skills for future reporting exercises, including analytical processing.
Hello, my name is Erik and I'm a Senior Analyst Programmer. To build more complex queries you must practice, practice and practice. Challenge yourself! Think of complex results you want in a report and do the query, however how long it will take. Over time, you'll become more efficient in building queries and you'll be able to analyse any data.
If you need help to get a step by step guideline to follow or want private SQL training, I'm available to help you.
Regards,
Erik
Since you are already good on SQL basics, it will be easy for you to get into advanced concepts. There are plenty of SQL tutorials available online, I like this one on w3schools -
https://www.w3schools.com/SQl/sql_join.asp
You can start with the SQL JOIN chapter, (or recap the basic concepts again if you wish). They have good examples and are detailed but simple enough for beginner like you.
If you are doing PostgreSQL, you can follow their online documentation here for reference on any topic. Its very detailed.
https://www.postgresql.org/docs/9.4/static/index.html
Also to get even further, buy any advanced SQL programming book, and read it offline. Books are the best way to improve your SQL skills, knowledge and concepts shared in books are usually not found online or at-least not in once place.
Depending where you live there is a great organization I teach for that has locations all over the US. It's called General Assembly. Website: https://generalassemb.ly/
I teach a Data Viz 101 there but they have, at the very least access to, lots of professionals who are more than qualified to help you out. I may be able to help or, depending on what you need, can put you in touch with someone who can.
Related Questions
-
What are ways to start / launch a coaching program targeted to healthcare professionals (helping them grow their practice)?
Assuming you are qualified to create this kind of offering, I think you can safely determine that there is need for this service. I know many doctors who struggle with the business of their practice and could benefit from coaching. That being said, if you believe this is an area you want to devote years of your life to, I would consider the infrastructure that will be required to support your success. Over time, you're going to want to build out the following (or a version thereof): Creating your brand identity Building your website Developing your funnel to generate leads Developing your pricing model Inbound marketing strategy and execution Social media strategy and execution Sales strategy Long-form content creation for email capture Short-form content creation for traffic generation SEO for organic traffic Advertising for paid traffic Presentation planning and coaching Possibly a book I would recommend thinking about as much of this ahead of time as possible to give yourself the greatest chance for success.CM
-
How to find the right business coach? And not spend thousands searching for them?
If you spent that money on Clarity ($200 with an expert) and you didn't get value, email support@clarity.fm for a full refund. We offer 100% money back guarantee. Alternatively, you can sort by ratings and price. If you want a great coach - call John, he's awesome https://clarity.fm/johnramey Also, Marcy if you can afford her https://clarity.fm/marcyswensonDM
-
How to get past the fear of hiring full-time employees?
Growing up from 1+subs to a team like you're saying is a classic problem in consulting. The financial math is not in your favor until you get a consistent team. Here's an article of mine detailing the issues and also detailing solutions: http://blog.asmartbear.com/consulting-company-accounting.html Having said that, I would also say you're trying to do too many things at once with not enough resources, which means the chance of being successful with each one is diminished. For example, you could focus on consulting revenue so you can build up your bench, so that you truly can self-fund the development of a product without distraction. Or you could focus on product, investing time/money there with consulting only to pay for that, even using subs for that, until the revenue there gets to the point that it's scaling (which will be hard, as you can already see). Building a product or a successful consultancy is individually very hard -- most fail. So trying to do both at the same time means you'll almost certainly fail. Which is a shame, because that's "failure due to time-management / strategy" as opposed to actual market forces. i.e. something fixable! I hope some of this helps, although I agree with you that talking through the details would probably be more helpful. The specific details of your situation matter.JC
-
What is the difference between a mentor and a business coach?
Some key differences to consider: - Coaching is based most often on a monthly retainer. Mentoring can be as well, but is usually offered without a fee, often based on a personal request or referral. - Coaches rarely give advice, coming from the perspective that the client has the answers within. Empowering yes, but there are times when you just want someone to give you a straight answer or share their experience. Mentors (and consultants) provide this more naturally. I've worked with entrepreneurs who've had both, and I've done so myself. If you're looking for personal development within your business, I'd lean towards coaching. If you're more after advice and experience, I'd look for a mentor. Both are helpful and can make the world of difference in the right circumstances.SA
-
Where can one become a certified business and/or life coach?
I would recommend http://erickson.edu/ME
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.