The number one goal for this course is to get up and running as quickly and efficiently as possible. I'll make sure that we cover everything you need to know so you are never confused!
Have you been learning software development, and want to start using databases to make your programs more powerful? Or maybe you already have some experience, and you're looking for a refresher course to bring you up to speed.
This course is a careful, measured consolidation of all the SQL knowledge you need to get started interacting with databases, extracting data, and managing your server.
To get you started, we'll cover:
I pride myself in providing excellent support and feedback to every single student. I am always available to guide you personally, and answer questions for your benefit.
Don't wait, and sign up today to begin your database journey!
I'll see you on the inside.
Welcome to the course! I'm here to get you set up and understanding SQL (and more specifically, PostgreSQL) as quickly and efficiently as possible. I've made sure to cover all the things you need to get started today.
Installing databases has always been a huge pain! However, EnterpriseDB gives us a fantastic installer that makes things really easy. You can download it from here:
Download the test data for this course in this lecture or the previous one. It's easy to use this test data, make sure to follow along with the course to retain the maximum amount of knowledge!
This quiz will test you on the basic building blocks of SQL queries that we have learned this section.
Careful with this one! Missing part of a query can be very dangerous...
I've been teaching computer science and playing and teaching music (grades 1 to 8) for over four years, to students of all ages and all skill levels. Here's my story so far.
I started programming at the age of 10, just a couple years after I started studying music, when my dad, excited that I had showed interest in similar things to himself, taught me the basics of Marin Saric's METAL. Shortly thereafter we moved on to RealBASIC, and from there I started learning, after a couple years, Java and C.
Ever since I started learning programming I knew I wanted to study Computer Science or something along those lines. Half a decade ago I ended up at the University of Dundee, studying Applied Computing.
The University of Dundee is one of the most prestigious for computing-related courses, and I was offered the chance to participate in their computing scholarships due to academic achievement.
I have worked for "Eseye", an M2M company, as an intern doing mainly backend developing, writing PHP scripts and programming Zenoss ZenPacks, and currently work for Skyscanner, one of Scotland's largest technology companies, programming mainly in Python and web languages.
At the moment I enjoy programming in Python, Java and C, playing and recording music, usually as an accompanying pianist for singers, and sports and bodybuilding. I hope that my courses are interesting to you, enjoyable and that you learn from them!