FB

Learn the Basics of SQL

Get started with SQL in the database vendor of your choice: Oracle, SQL Server, MySQL, or PostgreSQL

Introduction to SQL Course

The Introduction to SQL course will help you get started with learning the basics of SQL. Applicable to four different vendors (Oracle, SQL Server, MySQL, and PostgreSQL).

The course includes videos on each of these topics:

  • Introduction
  • Download and install the database software (e.g. Oracle Express, SQL Server, MySQL, PostgreSQL)
  • Download and install an SQL Editor (SQL Developer, SSMS, MySQL Workbench, DBeaver)
  • Connect to your database
  • Create your first table
  • Add data to the table
  • View data in the table
  • Update data in the table
  • Delete data from the table
  • Create a second table
  • Joining two tables together
  • Add a primary key and foreign key
  • Ordering your results
  • Selecting from three tables
  • Using table and column aliases
  • Adding other constraints to your database

It also includes a quiz to test your knowledge and a PDF version of the course.

Want to take this course?


This course, and many others, are all available as part of...

Database Star Academy

Database Star Academy is a membership focused on SQL development and database development.

You'll get immediate access to a range of courses on

Oracle, SQL Server, MySQL, and PostgreSQL.

More courses and content are constantly added to ensure you get the most out of the membership.

Enroll today!


Here’s What You’ll Get When You Sign Up

Once you sign up, you'll get immediate access to
20+ courses on Oracle, SQL Server, MySQL, and PostgreSQL.

PDF files for each course for easy download

Bonus guides for a range of SQL and database design topics

Practice exercises, assignments, and exams, to test and improve your knowledge

Learn Anywhere, Immediately

You get immediate access to all material. You'll also be able to log in right away and access the material whether you're at work or in the comfort of your own home.

Learn From Someone With Experience

I've had 10+ years of experience working in software and with databases. It's my focus, which allows me to give you much more than just basic SELECT statements.

Monthly Or Annual Pricing

A pricing model that fits your learning preference. Pay a monthly fee (just like Netflix!). Or pay a discounted annual fee. You can cancel at any time with only a few clicks.

Track Learning, Certificates & More

Many platform features such as the ability to track which videos you have watched, quizzes on some courses, a course or knowledge roadmap, course completion certificates, PDF downloads, and more.

Nancy T

Database Star Academy member

Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand. The "SQL Interview Questions & Answers", which I nearly didn't read, was full of answers I had on how to use CTE, DBMS-Output, temp tables. And then I put them all in a folder that are easy to refer back to. On top if it all, I don't have to sift through a 10 minute you tube to find the 10 seconds of information I'm looking for. I also get emails from Database Star on topics I didn't even knew I had questions on - like how to manage your time, and book recommendations like "Clean Code" by Robert C. Martin.

Korlahalli S

Database Star Academy member

I think I am one of the guys who joined you almost from the beginning of the launch of your academy (correct me if I am wrong). And, this is the first time in my IT career I have ever subscribed to any site such as yours. After being with you for some time, I now feel that I have not made any mistake by subscribing to your site. I have learnt a lot by following your site which cannot be described in words. Examples given after each topic are very useful. The videos are simple, informative and easy to understand. There is also a lot of general content which is very useful in developing the subject. I am extremely grateful to you for that. I am also happy to see you coming up with different flavors of SQL (SQL Server, MySQL & Postgress SQL). It would be easy for a person to refer to one single site for everything. In fact, I am looking forward to detailed stuff related to Oracle DBA and other related topics. Hope, it is on the way.

What's Included In Database Star Academy?

The courses cover the following topics:

  • Downloading and setting up your database and IDE (Oracle, SQL Server, MySQL, or PostgreSQL)
  • Creating tables and populating them with sample data
  • Basic SELECT, INSERT, UPDATE, and DELETE queries
  • Filtering and ordering data in Select queries
  • Getting data from multiple tables using joins
  • Identifying and relating data using primary keys and foreign keys
  • Improving and simplifying queries with table aliases and column aliases
  • Improving data quality with check constraints, unique constraints, and not null constraints
  • Using bind variables for performance and security
  • Aggregate functions and grouping
  • Using subqueries
  • Lookup tables
  • Limiting the number of rows
  • A complete process of improving the performance and measuring your SQL query
  • Inserting many rows in one statement
  • Automatically generating values using auto-increment features
  • Creating units of work using transactions
  • Getting started with Oracle PL/SQL
  • Learn how to use tools such as SQL Developer, Toad for Oracle, and SQL*Plus
  • Learn the topics covered in the Oracle Certified Associate (OCA) exam
  • Learn how to design an effective database and follow normalisation techniques
  • Learn a range of advanced data modeling techniques you can use
  • Understand what a data warehouse is and learn how to set one up
  • Learn what Common Table Expressions are and how they can help your queries

Bonus

What Else Do You Get?

You'll get more than just the courses as part of the Database Star Academy. Here's what else you get:

Videos
Single Videos

There are over 20 single videos that cover a range of topics, such as converting a UNION query to one that uses a CASE statement to improve performance, EAV table design, grouping data, and much more.

PDF
Many PDF Guides

There are many PDF guides available to enhance your SQL skills.

Some of these guides are:

- Oracle Joins Guide

- Oracle Best Practices

- Database Normalisation Checklist

- SQL Cheat Sheets

- Many more!

scripts
SQL Scripts For Each Course

Learning from video and PDF guides is one thing.

But the process is much easier when you have the scripts used in the course.

The SQL scripts used are available for download, so you can follow along with the course and practice your skills.

VIDEOS
Case Studies

There are several case study courses in the Academy, which take a problem and show you step-by-step how to solve it.

PDF
Timesaver PDFs

Low on time? There are several PDFs that show you how to use different tools easier.

Most of the courses come with a PDF version of the course, so you can read and learn when you can't watch the videos.

QUIZZES
Quizzes Available

Most of the courses come with a quiz to test your knowledge. You can also take them before the course to see if you already know the material or want to learn more.

practice
Practice Exercises

A range of practice exercises to help you learn and get better at SQL and database development.

practice
Assignments

Larger projects to practice your skills in working with data, SQL queries, table design, and more.

QUIZZES
Badges, Achievements, Leaderboard

Earn points and badges from various activities, and see how you compare to other members on a Top 10 Leaderboard.

About The Course Teacher,
Ben Brumm

I've been working with databases and SQL for many years, after completing my computer science degree in 2007, majoring in Oracle databases. I've been a software consultant ever since.


I've also obtained the Oracle SQL Expert certification.

I created this membership to teach SQL and database skills to many people. I want you to be able to improve your knowledge and skills with SQL and databases.

This Is For You If...

You want to get better at working with databases
You don't have a lot of time to study and improve your skills and want to know the right thing to study.
You want to solve problems you're having on your database
You want to make your queries run faster
You want to understand how certain SQL features work

Why Enrol in Database Star Academy?

You'll get immediate access to all materials.

You'll learn from someone who has experience with databases and SQL.

You'll get focused education, not broad education like you get in college.

You can cancel at any time.

You don't have to pay thousands to travel or enrol in an in-person training class

Pay Monthly

All material, and you pay the same amount each month.

$

19/month

  • Lifetime Access
  • Immediate Start
  • Access to All Modules
  • Certificates of Completion
Pay Annually

All material, where you pay one amount once per year.

$

190/year

  • Lifetime Access
  • Immediate Start
  • Access to All Modules
  • Certificates of Completion

All prices in USD.

100% Satisfaction Guarantee for 30-Days

If you are not satisfied with your membership, then let me know within the first 30 days of purchasing, and I will provide you with a full refund.


I'm confident that you'll get some value for your membership within the first 30 days!

Frequently Asked Questions

Why should I join your membership?

Can I cancel my membership?

What happens after I buy?

Can I sign up, download all the material, then cancel?

Pay MOnthly

Recurring monthly payment. Cancel anytime.

$

19/month

  • Lifetime Access
  • Immediate Start
  • Access to All Modules
  • Certificates of Completion
Pay Annually

Recurring annual payment. Cancel anytime.

$

190/year

  • Lifetime Access
  • Immediate Start
  • Access to All Modules
  • Certificates of Completion

All prices in USD.

One more thing...

The Database Star Academy is what I'm most proud of on my website. I truly enjoy helping and teaching others to improve their skills and solve problems.

If you're interested in learning and improving your SQL and database skills, I encourage you to enrol in Database Star Academy today.

Elevated Online Services Pty Ltd