Intro to … SQL on Workshop Wednesday the 26th

SQL

Continuing on from our **Intro to series, James and Ben are going to be hosting an intro to SQL session on the 26th of January at our Workshop Wednesday

They’ll be presenting some slides on SQL, relational databases and how to use them to store information. Then there will be at least one database server to play with, so please bring a laptop and you can try a few things.

We’ll look at how we create a database, query a database and, if we have time, structure it to optimise for different tasks.

Draft topics

How relational databases store information

  • Data types, columns and rows
  • Create a first table
  • Query a first table
  • Create a second, related table
  • Query both tables
  • Different ways of joining tables
  • How databases search tables
  • Indexes and why we use them
  • Create your own database and add some tables with data
  • Other clever tricks: views, triggers
  • Advanced ideas: stored procedures

Sign up on our meetup page here responding with SQL to teh attending question

SG Digital: sponsoring Workshop Wednesday

SG Digital logo

For our Workshop Wednesday on the 11th of March, we are pleased to announce that we have a great sponsor with SG Digital. They are currently recruiting in Bristol and are taking the opportunity to reach out and engage with the community, which we fully applaud. If you are interested in coming along outside of any of the workshops then feel free to sign up and respond with SG Digital on our meetup page here. Also, check out their job availabilities here and if you want to have a chat with them then pop along and speak at the meeting – we will post the Bristol Jobs on our Jobsboard also so you can check them out there too.

Continue reading “SG Digital: sponsoring Workshop Wednesday”

Workshop Wednesdays: “INTRODUCTION TO PYTHON WORKSHOPS”

Python Training

We are really pleased to announce the return of the Python workshops from our very wonderful volunteers Kathryn and Alex (BIG THANKS!!). They have done some analysis of the feedback based on feedback from the attendees last year and have spent their time and energy putting together something more structured for you all. For those wanting to understand Python this is the perfect free intro with support from some great volunteers looking to support our members wanting to improve their skillsets and to get coding. Join up here.

Audience

This workshop is for those interested to learn Python and is aimed at both beginners and those with a little Python experience. The topics and examples are chosen such that you can directly use Python for a Data Science project afterwards. Someone who comes to all the sessions (and does some practising at home) will have covered the pre-requisites for a typical Data Science bootcamp by the end of the workshop.

Note that it is not necessary to come to all the sessions – you can pick the ones of interest to you if there are only some topics you want to cover. 

While it is not mandatory to bring your own laptop, it is highly recommended to bring one if you want to practise with us.

Format of the sessions

Each session will stretch for a duration of max. 2 hours and will be divided into two parts: a theory part and a practice part.

During the first hour of each session, we will present the topic and show a few examples on how to apply the theory. We will be using a combination of PowerPoint slides and Jupyter notebooks for this.

During the second hour, you can practise what you learned – either on your own or in small groups, as you prefer. A range of examples and mini-projects will be provided so that you can select an appropriate level according to your experience and ambition. It will also provide an opportunity to discuss any unclarities on previous weeks’ topics.

Discussions can continue during/after pizza, according to demand.

All material will be available online afterwards and we welcome questions anytime both during the sessions and afterwards.

Proposed Syllabus

Session Date Topic area Covering:
1 15 Jan ‘20 Setting up the Python environment Overview of workshops; Python installation; Anaconda; Jupyter notebooks; PyCharm IDE for debugging Packages and environments
2 29 Jan ‘20 Data Structures Data Types (strings, integers, floats); Lists; Dictionaries; Arrays (Numpy package)
3 12 Feb ‘20 Programming fundamentals Conditionals: For/while loops; Try/except statements
4 26 Feb ‘20 Programming fundamentals Functions; Debugging in PyCharm
5 11 March ‘20 Working with data Introduction to Pandas; Loading/saving/manipulating data with Pandas
6 25 March ‘20 Visualizations Introduction to Matplotlib
7 8 April ‘20 Testing Testing in Python OR Code Quality (Pep8) OR something else? (TBD)

We’re on a Steve Jobs style retreat this week

seasise retreat

In Falmouth

Okay not exactly a retreat more of a bit of a breakdown, re-energize and feedback on the year coupled with a bit of fresh air, shopping, exercise and we suspect some drinking (apparently Jacobs Ladder is the place to be). We’ve listened to the great TEDxBristol folk and will re:BOOT!

We have a lot of interest from companies wishing to engage and sponsor the Workshop Wednesdays which is great news. We will be putting together some packages to better support companies and enable us to feed ourselves (and pay for Falmouth! [just joshing as that’s out of our own pockets])

Whilst we are away though our lovely friends and members are stepping in for us to host our

Workshop Wednesdays

Continue reading “We’re on a Steve Jobs style retreat this week”

This week it’s all about TEDxBristol!

TEDx speakers lineup

A big thanks to all our lovely sponsors and volunteers that came to our tech3shed careers fair on Saturday, you are what makes it worth it. We had some great discussions and it was brilliant to also see so many of our women who have got back into the industry and see you all doing so well!

We’re super excited to be partnered with TEDx Bristol and will be there on the 17th to meet all the lovely attendees and speakers.

There is a brilliant line up of speakers for this year’s TEDxBristol! 

They are an unbelievably inspiring group of individuals with a whole spectrum of ideas, from how we tackle antibiotic resistance, to rebooting the way we teach young people about sex, or the fashion industry’s attitude to disabled people. These really are Bristol’s trailblazers and innovators. 

You can be there and join them at Reflect: Rethink: Reboot on 17 November at Bristol Old Vic – a day of live inspirational talks and activities focused on not just surviving, but thriving in uncertain times. Tickets are on sale now!

Tech-wise theres a talk from Paul Wiseall from DEATH.io which helps plan around things such as your digital death, Drew Benvie talking about how to reboot social media and Stephanie Campbell CEO of Bristol-based OKKO Health rethinking how we approach health in the digital age. There’s loads of other great speakers there too that should pique your interest and you can use our discount as one of our members TEDXFRIEND19.

Bristol GirlGeekDinners

We are pleased to announce our final Girl Geek Dinners meetup of the year will be at Cookpad on the 14th of November. We are really excited to have Viki Johnson for GGD #79 User Experience in AR – sign up here. It’s our first ever visit to cookpad and we know they have a super cool kitchen so we really can’t wait.

Continue reading “This week it’s all about TEDxBristol!”