Skip to main content

Posts

Showing posts from 2016

Merry Christmas

Yesterday was the last working day before Christmas  at GRE Towers. We’ve got today off. So this is just a short post for the Friday before Christmas. 
Wishing you all a very merry Christmas.

Treat Yourself to a Training Christmas Present

Its the week before Christmas. Party season is in full swing. Its a time for reflection on the year gone and a look forward to what is coming next year. Why not make your New Year's resolution early. Invest in your career in 2017 and get yourself some excellent value training.

With all courses in this weeks Learning Tree listed running in the New Year get booked up now so you don't miss out. You can relax and enjoy the Christmas period with comfort of knowing you'll be learning new skills and growing your career early in 2017.

All courses are £750 plus VAT.

Drop an email to training@gethynellis.com or use the contact us page if you would like more information or would like to book a seat


319         Technical Writing Introduction     10th January
2411       Windows Server 2012 Administration  10th January
2413       Microsoft Azure Infrastructure Services10th January
535         Developing High-Performance SQL Server Databases  16th January
296         Project Management: …

Bree's first blog post... Amazing training deals

Gethyn will be getting me to update this every week, there are some awesome training deals available for £750 + VAT. Use the contact page to get in touch if you have any questions or if you would like to book a course.

Course 3821 Professional Services Professional: Business Executive  20th December 16

Course 2322 Building Web Applications with React 19th December 16

Course 1198 Achieving ITIL® Practitioner Certification   26th January 17

Course 902  Business Relationship Management: Aligning IT & the Business  22nd February 17

An early Christmas present - Great Value SQL Server Training the Decemeber

Do you know anything about firebird?

Has anyone in my network or readers my blog have any experience of a database called Firebird?

If you have and are potentially interested in a short (maybe 1 day, maybe more days) consulting gig, please do get in touch.



http://firebirdsql.org/

I have a client who uses it and needs a little help.

If you're in my network and think you might know somebody with such skills please do share.

Just some caveats though, you will likely need to be UK based (The work will be in South Wales) and will be delivered on site. However if you have knowledge of the Firebird database and think you can help get in touch anyway.

Leave a comment, tweet me @gethyn_ellis email me{at}gethynellis.com if you can help

Big Data, Network Security, SQL Programming, PRINCE2, Baby save a little 2 for me

This weeks Learning Tree deals are in. If you want to learn about big data, Network security and with the Tesco bank issues publicised earlier this week you might! and with SQL and PRINCE2 on top you have to be interested in these deals. email training@gethynellis.com to enrol 
Management Skills     Course290                         6th Dec Hadoop Architecture & Administration for Big Data Solutions      Course1252      6th Dec Apache Spark Programming with Scala for Big Data Solutions      Course1262    13th Dec System and Network Security Introduction                                      Course468    13th Dec SQL Programming Language Introduction                                         Course925 14th Dec PRINCE2® Practitioner and Re-registration Certification                 Course178      15th Feb

Trick or Treat...Have I got an IT Training treat for you...

It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT Training Deals are out with a long and varied list of courses.
All the courses listed below are running the LEC in London from  December 2016 to February 2017. The start date of each course is listed in the table below. If you can't get to London, or you can't travel or if would just prefer to attend from the comfort of your own home or office you can attend online using Anyware.
All the courses listed here are £750 plus VAT. If you want to take advantage of this offer, just send an email to training@gethynellis.com state the course number you'd like to attend and I'll get you booked on. 
Spaces are limited so if you do want attend I'd recommend booking sooner rather than later.
Crs NumberStart DateCourse title 4611                       30th Nov               Excel® PivotTables: Building Dashboards 1176                       30th Nov               PRINCE2® Achiev…

Autumn Update - Trick or Treat

Its been a busy few weeks for me, most of that outside of gethynellis.com I’m in the process of moving home and as such much of my spare time has been taken up packing my things at my old house. That process is still on going and likely to last at least for the next few weeks so activity on the blog will be slower than normal but I wanted to make some time to publish a post today, the 1st of November. A new month and I wanted to put a post here to let you know what will be up and coming

The weekly SQL Server weekly roundup post will return in due course, I haven’t read many blogs over the last month or so as most of free time has been taken with that but as soon as things return to normal.

The deal on Learning Tree courses has been extended, we have done a deal with learning tree where they will offer readers of gethynellis.com some offers on courses running at the London Education Centre – most of which you can attend either in class in London or online using Anyware. The offers will…

You don't need any Training? OK...I believe you.

This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop an email etc. 
Running in London or if you prefer you can attend online. Courses are running this November and December. 
Get in early when they are full, they are full. 
You can even do some shopping while your in London. Oxford street if just two tube stops away!!!
Leading Teams: Improving Productivity Through Teamwork Course222                          9th November Microsoft Project Introduction                                                  Course3702                       9th November Building Web Applications with Angular 2                                           Course2324                       8th November Python Programming Introduction                                                          Course 1905                       6th December Organisational Change Management: Achieving APMG Change Management™ Practitioner Certification Course288                          12th Decembe…

SQL Friday: Weekly Round up 30th September

This week has been a relatively relaxed week for me. I had a one-day onsite event in Cardiff on Wednesday for one of Learning Tree's clients. I have been there on several occasions over the summer and each one of these events has been great fun with some good discussions.

Next week is SQL Relay and David Postlethwaite is delivering his SQL Server 2016 new features  along with his azure talk. If you are going, go and say hello.He's at all the events bar Nottingham.

SQL ServerDynamically Generate SQL Server BCP Format Files by Jeffery Rao
Proxy Settings & Backup to URL (Azure Blob Storage) - Jack Li
Why I'm running for the PASS Board - Allen White
Masking Your Data with SQL Server 2016 - Greg Larsen R ProgrammingConnecting to Twitter with R and Studio - by Gethyn Ellis
The Financial Times uses R for Quantitive Journalism AzureNew P2 Instance Type for Amazon EC2 – Up to 16 GPUs -  By Jeff Barr Contacting/Professional developmentWhy a generalised CV does not get you hired

Want to Win a Free @LearningTree Course? #LtreRox - @tangentc is the first ever twitter winner!!!

As regular readers of this blog will know I teach some data courses for Learning Tree. Recently Learning Tree has introduced a new Twitter competition. Attendees current, past and present who tweet about their experiences on their respective Learning Tree courses. What they have learned, key take-away points or if you haven't been on a course yet what you want to learn on a future course. Mark you tweet with the #LtreRox hashtag and also tag @LearningTree in your post and you will be entered into a draw to win a free @learningtree course.



This week's winner, the first ever winner of this competition is @tangentc. Carolina's winning tweet is here:

The reason behind my excitement, Carolina was an attendee on the course I delivered in London a week back. The course was 534 Developing SQL Queries for SQL Server and Carolina attended via Anyware...She was an online student.

It'll be interesting to see what course Carolina picks as her free course. Ironically i was speaking …

Connecting to Twitter with R and RStudio

Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect to  using R and RStudio (and a whole bunch of other languages too) to analyse twitter data.

In this post we will simply look at how we go about connecting to twitter with R and Studio

Assuming you R and R Studio downloaded and installed
You need a Developer Account Well actually, first up you'll need a twitter account. I'll assume that you have one. If you don't head over to twitter and signup. 
With your twitter account setup the first things first you need to do is create an application in twitter get  access to the Twitter API. This is a simple process. To do this you need to visit https://apps.twitter.com signing with your twitter account if you haven't done so already . When you have signed in, click on the create APP button.  
You will see a form called Create an Application. You will need to provide some application details: Name - give your app a n…