Norwich 4 Jobs ‘Three year anniversary’ event
Norwich 4Jobs (N4J) Three Year Anniversary Event
Date: Friday 22 January 2016.
Times: 07:30-10:30am
Venue: Lancaster Suite, Holiday Inn (Norwich Airport), Cromer Road, Norwich, NR6 6JA.
member
Forthcoming Open Days
Join us at our Norwichstudy centre to find out more about how studying a professional accounting qualification with Kaplan can help boost your career. You’ll get the chance to meet our expert tutors and course advisors, find out about ways to fund your course and take a look around our study centre. Plus you’ll also be able to find out more about our Apprenticeships.
Register online or by phone, or join us on the day:
www.kaplanfinancial.co.uk 01603 617 638
Workshop: An introduction to working with a relational database using SQL
Where: The King’s Centre, King Street, Norwich, NR1 1PH
How much: £99
You can sign up here
Level: Beginner
Prerequisites: Laptop
This one day workshop is designed to provide a familiarity with basic RDBMS concepts and the syntax required to construct simple SQL statements used to create, manipulate and report upon database records.
The workshop will be problem-centred and attendees will be invited to think about example problems in order to facilitate their appreciation of what a database is and why databases are used.
Once the basic concepts have been introduced, the remainder of the day will entail hands on practice writing and testing SQL statements using a database client program (Postgres). A worksheet will be provided to help guide this process. There will also be time for breaks and joint questions.
Attendees should be comfortable with running desktop applications (e.g. using Microsoft Word or Excel). No specialist knowledge is required to attend. Attendees are expected to bring their own laptops with them. As a preliminary to the workshop, attendees who do not have the relevant software installed will be guided through the installation process. Attendees will therefore need their relevant passwords to authenticate installation.
Summary of presentation
Installation procedure – est. 45 minutes
1. A few remarks about learning new ideas, and new technologies. Distinguishing ‘what a thing is’ from ‘the value of thing’ – est. 30 minutes
2. The value of an SQL RDBMS – est. 90 mins
2.1 The idea of data persistence.
2.2 A shopping transaction history at a superstore example using index cards (an everyday example is used to allow everyone to focus upon what is new for them).
2.3 An example of using text files to persist the data is shown. The pros and cons of using text files as a form of persistence is discussed.
2.4 An example using a spreadsheet to persist the data is shown. The pros and cons of using spreadsheets is discussed.
2.5 The idea of a data persistence media that supports queries.
2.6 A summary of key limitations of the use of index cards, text files and spreadsheets is presented and discussed.
2.7 An SQL RDBMS is introduced as something that helps to resolve the problems previously identified.
2.8 Discussion
3. The basic structure of an SQL RDMBS – est. 90 mins
3.1 What a relation is in this context of a relational database
3.2 Databases, tables, & records
3.3 SQL as a set of expressions to be used to manipulate and query databases, tables, and records including a brief glance through standard SQL commands, a step by step introduction to the SQL commands for CRUD and a brief caveat on syntactic differences used by different database vendors.
3.4 Some additional problems that relational databases help to resolve
3.5 A summary of what has been covered so far.
3.6 Discussion
[Break for lunch]
4. Working through the worksheets provided that elaborate on the shopping transacton data previously introduced – est. 240 mins
4.1 Simple use of the four commands
4.2 Applying the commands to multiple rows of a table
4.3 Data types in more depth
4.4 Performing queries that use ids
4.5 Performaing other queuries
4.6 Additional exercises using different databases (optional)
5 Questions and discussion about what has been covered – est. 0 to 60 mins
6 What next? – est. 30 mins
6.1 A reminder about learning other commands in order to maintain a database
6.2 The complexities of database design: Inroductory steps into an important component of information technology.
6.3 References for further study
6.4 Closing remarks and feedback forms
Twitter Chat on Health and Safety
A chance to ask any Health and Safety questions! I am being interviewed live by James Twigg of PPE.ORG follow me on @RedCatSarah, and the chat on #PPEtalk
Alternatively just contact we with any questions!
Taking the stress out of Social Media
Giving you the basics of creating an easy-to-use content plan to help you ditch the overwhelm and start loving social media again.
Jordan Domin-Goddard
Jordan is the Founder and Content Queen of Curlyworm Creative. The one who speaks to clients, creates the strategies, and does all the words, it’s her job to make sure everything sounds as “you” as possible. She understands how difficult it is to juggle all the responsibilities you have as a business owner while still somehow also having a personal life, which is why she founded the business.
Female empowerment is a huge thing for her, so she’s incredibly proud to work with countless other fierce female-led businesses across the world. When she’s not magically getting inside your head, she loves going to the beach and playing with her two dogs, Teddy and Kenny.
Curlyworm Creative
Curlyworm Creative helps you ditch the overwhelm through the content we create for your business. All about work/life balance you won’t find us bragging about being part of the “5am club”. In fact, we love a good lie-in. Curlyworm Creative was founded to give the team the freedom to live life on their own terms. And that’s exactly what we do for clients. Hell, we’ve even helped people give up their 9-5s, all through the awesome content we create.
To quote Sister Sledge, “We are family”, and this gives us a unique edge. We know each other inside out and work closely together to bring your brand to life wherever it appears. We’re not quite able to read each other’s minds, but things do work suspiciously seamlessly.
Tech event: BBC Micro:bit – What is it & What can you do with it?
Come to the University Technical College Norfolk in February to hear about the new BBC Micro:bit, an exciting new piece of mini-tech to be handed out in schools across the country. The small, codeable device will be given to pupils in year 7 throughout the UK in a bid to introduce them to technology and coding. The small-but-perfectly formed computer will be Bluetooth enabled, have scrolling LEDs as well as an accelerometer and magnetometer.
Find out more and register for the event here, which also includes a tour of the Technical college.
Date: Thursday 4th February 2016 from 6:30pm
Naked Element also have details on their website.
History Bridge Course Open Evening
Join us at the History Bridge Course Open Evening to find out more information about the course onTuesday 12 April 2016, 6-8pm.
For further details and to register your attendance, clickhere.
TheHistory Preparation for Undergraduate Study (Bridge Course)is a 12 week preparatory course for those who wish to progress toundergraduate study in the School of History, but for a wide range of reasons, had a gap in their studies.
Customs Procedures and Documentation – BCC Accredited
Do you understand the role of HMRC, rules of origin and Intra-EC trade? Understanding complicated customs procedures is vital to help save you time and money when importing and exporting goods.
This half day course will provide you with the information you need to be able to understand how to comply with customs and the procedures in place.
Aims: • To understand the role of HMRC, the rules of origin and Intra-EC trade • Understand key pieces of information on a customs entry and what they mean • Know why it is essential that goods are classified correctly and who is responsible • How to work out the VAT and Duty to be applied to your import • Be able to explain ‘free circulation’
Who Should Attend? This course is suitable for anyone involved in the export or import process such as; accounts, purchasing / buyers, freight forwarders, shipping, goods inward staff and many more
Testimonials “Very detailed and informative course. The trainer was more than happy to answer all of my questions at the end.”
“All aspects of the subject were covered. I would definitely recommend this course to a colleague.”
“Great course – the trainer is very passionate and knowledgeable.”
Cancellation Policy 15% of fee payable if delegates cancel more than 7 days in advance. If less than 7 days the full fee is payable.
One of the ‘core 10’ courses accredited by British Chambers of Commerce (BCC). Candidates achieving Pass or Merit in the course will receive a certificate. Those who pass 6 individual courses will achieve a nationally recognised Foundation Award in International Trade.
Get Set for Success – Employability Skills Day
CAN YOU HELP OUR YEAR 10 STUDENTS WITH CV AND INTERVIEW SKILLS?
Following previous successful events, we will be holding the ‘Get Set for Success’ Employability Day for Year 10 students during Enrichment Week and are looking for business mentors to work with small groups.
This year it will be on Wednesday 27th June, with two sessions running, one in the morning (9an – 11.30am) and one in the afternoon (1.30pm – 3.45pm) . Each will be two hours long. Mentors can choose to help out at one or both of these sessions, which are supervised at all times by a team of staff.
We provide booklets for both mentors and students, and mentors guide their group through the activities and discussions, covering skills and qualities, the basics of CV writing and interview skills, and ending with a mock interview.
The support from mentors was much appreciated last year and they enjoyed the event – those who can are even returning again this year!
If you are interested in taking part, please contact me and I can send you more details.
Liz Edwards
British Library – Inspiring Entrepreneurs
Inspiring Entrepreneurs: Internet Icons Find out how to become the next internet sensation. Online businesses are bigger than ever with entrepreneurs and investors eager to spot the next big internet phenomenon. If you’re a small business owner with big online ambitions, take this opportunity to quiz our panel of internet icons and find out how they have created some of the best-known global internet brands. Hear from: Justine Roberts, founder and CEO of Mumsnet Ning Li, Co-founder and CEO MADE.com Renaud Visage, Co-founder of Eventbrite Moderated by Nadine Dereza, Journalist and TV Broadcaster This event will be live webcast. Follow all the action and tweet your questions on #BLicons16 We’ll be screening the event live in Norwich.
THE AUDITORIUM, THE FORUM, NORWICH
EMAIL: [email protected]
TEL: 01603 774740
In The Spotlight! Financing – Funding
In The Spotlight! Financing – Funding
Join Tiago Botelho from Norwich Business School, UEA to find out more about Crowdfunding.
Norfolk & Norwich Millennium Library
The Vernon Castle Room, Business Library
Second Floor, The Forum,
Norwich, NR2 1AW
FREE EVENT
TEL: 01603 774740
EMAIL: [email protected]
East Anglian Air Ambulance Runway Run – Team Hugh J Boswell
Hugh J Boswell are entering a team of 20-30 runners into the East Anglian Air Ambulance Runway Run on the 30th September at Tibenham Airfield. There is a 5k or 10k option. The majority of Hugh J Boswell runners have opted for the 10k option.
If you wish to take part in the event, Independently or as part of the Hugh J Boswell team, please contact Paul Utting on 01603 626155.
To support our efforts please donate via: https://www.justgiving.com/hughjboswell-runwayrun All donations received are very much appreciated.