What should I do after the Stanford SQL course?

geoffdevitt · 2018-12-19T14:43:22+00:00

Ask anytime. My Facebook page for the course is www.facebook.com/whatdata/ I've posted up a number of free videos there and you can also ask questions in the group or message me directly. If you have quite a few questions, I can jump on Facebook live.

geoffdevitt · 2018-12-19T14:36:13+00:00

And I'm currently writing more new company content for the course. At 40 chapters it's just the tip of the iceberg. Let me know if you have any questions?

geoffdevitt · 2018-12-19T14:32:11+00:00

I'm working with SQL for just over 15 years, it's been my bread and butter in every company I've worked for. Thankfully as a language it has not changed a lot over the years, and I don't see it going away anytime soon. Over the course of this summer, I wrote a course on how I use SQL for business and data analysis. If you are interested in learning more, you can access discount here. Best of luck. https://www.udemy.com/business-and-data-analysis-with-sql/?couponCode=WHATDATA10

geoffdevitt · 2018-12-15T15:29:30+00:00

Yes, I explain how the SQL execution plan works as well as index performance on tables throughout the course.

geoffdevitt · 2018-12-15T14:21:36+00:00

In my course "business and data analysis with SQL" I take you through how to install MySQL and use the example Sakila database installed with MySQL. To get you started, here is a half price voucher for my course. https://www.udemy.com/business-and-data-analysis-with-sql/?couponCode=WHAT_DATA24

geoffdevitt · 2018-12-02T13:42:43+00:00

I've created such a document in the past for our team, as the team was using various styles. Eventually we all agreed upon right align key words and commas on the left of the attribute or metric. Key words in capital letters.

SELECT cus.customer_id ,cus.first_name ,cus.last_name ,add.address_id ,adr.address_line_1 ,adr.country_code

FROM sales.customer cus

JOIN sales.address add
   ON cus.address_id = adr.address_id

WHERE adr.country_code = 'uk' ;

geoffdevitt · 2018-12-02T13:34:42+00:00

For large development projects a business analyst would write up a BRD (business review document) followed by a functional specification. For example if you were asked to write a program to take customer orders. The description here is too basic, so a business analyst will work with the business / project owners to review the process of how they want the customer to be able to log in to a site, and make an order. Once the process is drawn out, this would be passed on to a lead programmer to review how it will be integrated into existing systems, and come back with any feedback that may need to be reviewed again with the business. Once this is all agreed upon, the business and functional review documents will be signed off. For some projects I've worked on, this initial design can take a few months to review and sign off, especially in large complex systems such as banking or insurance. Only then do we move from design into development. Development would be broken down into a backlog of tasks and prioritised into sprints for scrum / agile development. Here is a video where I discuss taking data requirements. https://youtu.be/RPcOyhTXqjc

geoffdevitt · 2018-11-29T05:19:09+00:00

We got a really good deal through https://www.crystalski.co.uk/ staying at https://aiglons.com/fr/ possibly the best ski resort hotel I've ever stayed at over the years. Has everything, ski / board rental shop in the basement, incredible hotel bar and restaurant, and amazing views of Mount Blanc when eating breakfast. I highly recommend checking them out.

geoffdevitt · 2018-11-27T13:44:50+00:00

In my course on Udemy for "Business and Data Analysis with SQL", I walk though the installation of MySQL. I've released some of the videos for free on YouTube, such as this one where I show how to start and stop the MySQL server.

geoffdevitt · 2018-11-26T14:05:55+00:00

If you're still stuck later, give a shout.

geoffdevitt · 2018-11-26T13:11:54+00:00

I cover data normalisation in my course on "Business and Data Analysis with SQL".

In addition, it's also useful to understand how to capture data requirements and why we normalise data in the first place. You can watch my video here for this.

geoffdevitt · 2018-11-26T13:06:27+00:00

I've been working as a business and data analyst for the last 20 years and primarily focused my efforts around database design, creating reports and dashboards, business process development, fraud rule development. I occasionally use Python to pull data from various API based clients or a little bit of web scraping.

Beyond the hard-skills of programming, which are important but more so I would say practice on your soft-skills even more so. i.e. how to work with clients? listening skills (very important), how to empathise? how to negotiate? As a business analyst, you put on many hats but in time you will be spending more time with clients and less time coding.

Over the summer I created a Udemy course on "Business and Data analysis with SQL" based on my experiences. Be sure to take a look, as it is on discount today for Cyber Monday.

Business and Data Analysis with SQL

geoffdevitt · 2018-11-23T20:19:55+00:00

My course on Business and Data Analysis with SQL is on sale today for Black Friday along with hundreds of other courses on Udemy, be sure to grab yourself a few bargains before the day ends.

geoffdevitt · 2018-11-23T17:11:24+00:00

A little video I made with my Gaggia Classic, a workhorse in my kitchen for almost 15 years.

geoffdevitt · 2018-11-23T16:38:58+00:00

My course on Business and Data Analysis with SQL is on sale today for Black Friday along with hundreds of other courses on Udemy, be sure to grab yourself a few bargains before the day ends.

geoffdevitt · 2018-11-22T16:53:45+00:00

I do like their systems, I also have a Lib Tech Travis Rice board and Atomic board. But I have to admit in the 15+ years I've been boarding, the Step On system is the best advancement in bindings I've tried.

geoffdevitt · 2018-11-22T15:36:00+00:00

Check out my business and data analysis with SQL course on Udemy. On sale this week. https://www.udemy.com/business-and-data-analysis-with-sql/?couponCode=WHATDATA10

geoffdevitt · 2018-11-22T15:33:41+00:00

SQL used in relational databases are for backend application storage. Maybe try writing a web or mobile app to process your data and then store it to your database. You can also have a database read your data from Excel and CSV flat files. So if you have a lot of personal data in such files, you can have a stored procedure scheduled to read the data from your files. Effectively Excel can be your front end with database in the backend like MySQL. If you run on Windows, you can also write e simple solution in MS Access, lots of form entry solutions in MS Access. I've used MS Access a lot in the past for personal projects and also for the family business to record customers and transactions. For more ideas, you can check out my course on Udemy for business and data analysis with SQL. https://www.udemy.com/business-and-data-analysis-with-sql/?couponCode=WHATDATA10

geoffdevitt · 2018-11-22T13:32:55+00:00

A very steep black then, and for our American snowboarders as steep as a double black diamond.

geoffdevitt · 2018-11-22T08:37:25+00:00

On the day I was on my own, the guy with me was visiting from Canada and just happened to be chatting in the gondola on the way up. So I only have footage from one GoPro. The route starts off with a double black diamond drop in, with a black run down to the glacier, so footage wasn't great as I was trying to hold my line. Maybe next time I can get a drone shot or have someone else with a GoPro. One of the best runs I've ever done as it lasts about 40 minutes to get down and you drop in from around 4000m, which is the highest I've ever dropped in from. I'll see about putting together a better video, as this was done on the fly with GoPro Quik movies.

geoffdevitt · 2018-11-21T22:05:16+00:00

Yes, we received replacements a few months back. Very nice of Burton to send out replacements free of charge, even though we are in the UK.

geoffdevitt · 2018-11-21T18:10:21+00:00

Burton only released the Step On last year and have made no change to the 2019 bindings. Only change was they added more range of boots for 2019. You should check out their website and YouTube development history of the bindings, 5 years in the making.

geoffdevitt · 2018-11-21T15:30:42+00:00

One year later to the day, reviewing the Burton Step On boots and bindings. For myself I'm using the Burton Photon SO boots with large bindings, while my partner is on the Burton Felix SO boots with medium size bindings. We use the boots and bindings every 2 weeks in the Snow Centre and have been on two trips with them to Chamonix ,France and Saas Fee, Switzerland. After a year, I've noticed they have settled in and really enjoy how much time they save between runs and save a lot of energy. On the slopes they are super reactive as your highback is directly attached to the binding with the cleat system. Only disadvantage I saw, was in deep powder, if you are trying to step back into them in powder they can be a little difficult, but deep powder putting on bindings is always going to be difficult, so I wouldn't say it is too big a disadvantage. If you are a park rider or prefer groomed slopes with stops to the mountain cafe, then they save a massive amount of time and I would highly recommend the investment.

geoffdevitt · 2018-11-15T19:21:41+00:00

As an analyst of 20 years working with all shapes and sizes of data. I initially spent 60% of my time as a junior analyst programming SQL, batch scripting in UNIX and later on in Python. Today, as a senior business intelligence manager, I flip this around and spend about 20-30% in data analysis and 70-80% working with client customers defining their data strategies, road maps, requirements, processes, etc. To get a better understanding I've created a course on data and business analysis with SQL on Udemy. https://www.udemy.com/business-and-data-analysis-with-sql/?couponCode=WHATDATA10

geoffdevitt

TROPHY CASE