SQL tutorials and code examples

Card image cap

SQLite & MySQL with Python

In this post we'll take a look at using Python with SQL - more specifically a SQLite datebase and MySQL to do simple CRUD functions.

Read More →
Card image cap

SQL basics with SQLite

In this post we look at the basics of a database including creating a database in SQLite, creating tables, selecting data and removing data.

Read More →
Categories
Web development
About me

My name is Charlie Jackson, and I currently work as a technical SEO in a small digital marketing agency. Through working in SEO I discovered Python, and all the beautiful applications that it could be used for; in the world of SEO we are often crawling websites, scraping data, text mining and much more, which Python is fantastic for. I am only fairly new to programming, and there are a number of topics I am hoping to blog about including:

  • Data science; with python, SQL and possibly R
  • Machine learning with python
  • Natural language processing
  • SEO
  • Web development

As noted, I am not a developer or data scientist although I am eager to learn as much as possible, and apply to my background in SEO. I am largely writing this blog for myself to document my studies (and use as a code base), although it it happens to help somebody else that would be great.

Feel free to drop me a line: charlieojackson at gmail dot com.