SQL in an Hour with PostgreSQL
4.3 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
31 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL in an Hour with PostgreSQL to your Wishlist.

Add to Wishlist

SQL in an Hour with PostgreSQL

Get comfortable with an essential language in record time!
4.3 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
31 students enrolled
Created by Jose Salvatierra
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $45 Discount: 78% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • No-nonsense introduction to SQL and PostgreSQL
  • Understand the building blocks of SQL queries
  • Extract data effectively using JOINs and aggregation
  • Manage databases and tables, as well as understand what indices are
View Curriculum
Requirements
  • A computer running Windows, Mac OS or Linux
  • All the software used in this course is free, and I'll guide you through setting it up!
Description

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:

  • The building blocks of SQL queries, including retrieving data, filtering, ordering, grouping, and more;
  • Fully understand JOINs, and using them to extract meaningful data from our databases;
  • Delve into database management and indices, essential for performance in some situations;

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.

Who is the target audience?
  • Students learning software development who want a lightning fast and efficient introduction to SQL
  • Business employees with a need to extract and manipulate data using SQL directly
  • Anyone wanting to learn a bit more about one of the most popular programming languages in the world
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
01:37:13
+
Welcome to the course
5 Lectures 24:18

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.

Preview 01:04

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:

http://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Preview 04:50

Setting up pgAdmin 3
06:17

Get your test data for the course!
11:53

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!

Download the test data from this lecture
00:14
+
SQL Query Building Blocks
7 Lectures 21:45

Filtering with the WHERE clause
03:09

The LIMIT clause
02:28

Ordering results with ORDER BY
02:30

This quiz will test you on the basic building blocks of SQL queries that we have learned this section.

SQL Query Building Blocks
4 questions

The UPDATE statement and its dangers
04:42

The DELETE statement and its dangers
02:56

Fuzzy filtering with LIKE
02:10

Careful with this one! Missing part of a query can be very dangerous...

Updating and Deleting
3 questions
+
More advanced querying
4 Lectures 25:44
What are JOINs?
11:40

Revise JOINs in this short quiz. Make sure to remember which is which!

JOINs
3 questions

JOINs in code
05:18

GROUP BY on JOINs for more advanced data extraction
05:48

+
Database management and indices
5 Lectures 23:43
pgAdmin CREATE scripts
02:30

Data management with pgAdmin
07:09

The SERIAL type in PostgreSQL
01:51

Primary and Foreign key constraints
06:26

Indices in SQL
05:47
+
Conclusion
2 Lectures 01:44
Conclusion of the course
00:19

Other courses and resources
01:25
About the Instructor
Jose Salvatierra
4.5 Average rating
3,362 Reviews
23,384 Students
6 Courses
Founder of School of Code and Computer Science instructor

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!