An Introduction To

Databases – SQL (PostgreSQL)

3 Week Part-Time Course

New start dates for this live course will be announced soon. In the meantime, watch the class recordings from the last live course.

View Class Recordings

Learn how to:

Understand the difference between SQL and NoSQL databases and what they’re used for

Create and use PostgreSQL as a database for CRUD based operations

Plan the next steps in your learning path to become a better database or application developer

Learn introductory SQL skills with PostgreSQL, and understand basic database design concepts which can lead to many paths in the world of technology and development.

In this course students will learn to build basic databases with PostgreSQL. They will also learn to use and manage data inside their database. They will learn to create, read, update and delete the data in a PostgreSQL table.

Students will create a basic database and populate it with data in order to access and manipulate it throughout the course.

Topics will include:

  • NoSQL vs SQL

  • SQL terminology

  • Design considerations with SQL databases

  • CRUD operations with SQL

  • Backups and restores with MongoDB

Students will leave this course with an introductory level knowledge of database design and usage, particularly in regards to SQL. The knowledge gained in this course will be an excellent introduction to managing data in a full-stack application that utilizes any SQL type database.

The course content assumes knowledge of how to use the computer including installing software. No prior programming knowledge is required.

Students should have a smoothly running Windows, Mac, or Linux computer to use for the duration of the course.

  • By the end of the course students will:

  • Create a PostgreSQL database and populate it with data

  • Learn how to access and manipulate the data in their database

  • Plan the next steps in their learning path to become a better database or application developer

Curriculum

Class 1: Introduction to SQL

  • What is CRUD?
  • What is a relational database?
  • Let’s query some data!

Class 2: Design a Small Database

  • Entities and Attributes
  • Tables and Fields
  • Create an Entity Relationship Diagram (ERD)

Class 3: Build Our Small Database

  • Create the table structure
  • Populate our tables with some data
  • Explore Join statements

Class 4: Practice Some Queries and Keywords

  • JOIN, WHERE, LIKE, AS and a lot more
  • Sort some records

Class 5: Alter Our Table Data and Structure

  • Insert and Delete table columns
  • Update, Delete, and Insert table data

Class 6: A Little Further with SQL

  • Creating Stored Procedures
  • Exploring security benefits
  • Temp tables

How It Works

100% Online

Participate from the comfort of your own home

Expert-Led Live Training

Learn from seasoned developers who love to teach

Learn by Doing

Create real-wold projects you’re proud to share

Guaranteed Acceptance

Skip the application process! All students admitted

Interactive Virtual Classroom

Stay engaged with our ask-a-question and messaging features

Never Miss A Class

All classes are recorded for easy playback

Explore the Virtual Classroom

Our virtual classroom lets you interact with the instructor and other students in real-time.

Joining the classroom is as simple as it gets – no software downloads, nothing to install on your computer. Everything runs directly from your browser window.

The webcam and screenshare broadcast is one-way, meaning only the instructor shares his video/audio. This ensures the privacy of our students and camera-shy participants.

The instructor’s live webcam lets you put a face to the name, streaming in high-definition.
Follow the instructor’s screenshare as they write code in real-time, present slides, and more.
Ask questions and get immediate answers – this is live training at its best. Students upvote / downvote questions, so the teacher can prioritize what’s most important.
Get to know the other students in the classroom and communicate with the instructor.

Meet Your Instructor

Victor Wilkinson

Victor has more than 18 years of software development experience under his belt.

He has experience with technologies ranging from VB6 to VB.NET and C# with plenty of SQL Server and Oracle database experience as well!

The last 12 years includes adjunct instructor work teaching databases, programming, and beginning level networking courses online, in the classroom, and remotely.

Upcoming Dates & Class Schedule

New start dates for this live course will be announced soon. In the meantime, watch the class recordings from the last live course.

View Class Recordings

Enjoy our Early Access pricing while we're still in beta - 50% off!

Ready To Enroll?

Enjoy unlimited courses for $59 $29/month.

Join Beta ProgramJoin Beta Program