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
How relational databases store
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
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.
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.
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.
of the sessions
will stretch for a duration of max. 2 hours and will be divided into two parts:
a theory part and a practice part.
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.
can continue during/after pizza, according to demand.
will be available online afterwards and we welcome questions anytime both during
the sessions and afterwards.
15 Jan ‘20
Setting up the Python environment
Overview of workshops; Python installation; Anaconda; Jupyter notebooks; PyCharm IDE for debugging Packages and environments
29 Jan ‘20
Data Types (strings, integers, floats); Lists; Dictionaries; Arrays (Numpy package)
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
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.
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.