Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
550 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Coding in SQL, Python, VBA, JQuery and OfficeScript using AI tools Part one of an eight-part series of blogs |
---|
One of the immediate and obvious ways to use AI tools is to boost your productivity as a programmer. This blog shows how you can use ChatGPT 4 and Google's Bard to write programs in SQL, Python, VBA, JQuery and Office Script (probably the 5 languages Wise Owl use most).
|
There is a lot of speculation about how mankind will use AI tools like ChatGPT and Bard in the future (wiping out the species? rendering armies of white-collar workers unemployed?), but there's already one obvious and concrete way in which they can improve your productivity. This series of blogs compares how ChatGPT 4 and Bard would solve the following problems:
Language | Question |
---|---|
SQL | "Write an SQL program for SQL Server to show the most-read books, joining a table of authors and a table of books together" |
Python | "Create a Python function which - given a passage of text - will return a dictionary containing all of the unique words" |
VBA | "Write a VBA program which will loop over the members of staff in a worksheet, finding all the staff members whose salaries are more than a given number and writing their personnel number, name and salary to a separate workbook" |
C# | "Write a C# function which takes in a comma-delimited string of numbers and returns a list of integers" |
OfficeScripts | "Write an OfficeScript program to loop over all of the worksheets in a given workbook, counting the number of active cells in each and presenting this information in a table in a separate workbook" |
JQuery | "Create a JQuery block of code which will loop over all of the table cells in an HTML table which have a given class name, listing out the text contents of each cell returned" |
I've deliberately committed myself to asking these questions in advance, as I don't want to second guess the skills of each AI tool. It's exciting: I genuinely don't know at this point of writing how each tool will fare!
Of course if you want human help on any of the above, you can get it at our SQL, Python, VBA, OfficeScript or C# training pages ...
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.