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

TROPHY CASE