Advance your skills as a data professional

Hands on training and certification for core SQL skills needed by today's data professionals

Learn More

This course will give skills to get data out of and into a database

To be a data professional, you need to get data.  Learn ...

  • Core concepts tied to practical examples
  • How to use Structured Query Language (SQL)  to get the data  you need
  • Create your own tables and views
  • Load data into tables

 

Learn the skills you need to succeed with HANDS ON exercises

Module1
Core Concepts

The path to sounding like you know what you're talking about and actually knowing what you're talking about starts here!

The essential knowledge you need before connecting to a database:

  • What a database is
  • Client-server architecture
  • What objects are in a database
  • Definition (and pronunciation) of SQL
Module2
Connect to a computer with the most widely used database software in the world: YOURS!

We will guide you step-by-step as you install the most widely-used database software on your Windows PC or Mac.

Foundational principles mastered with this database apply across the other major relational databases such as Oracle, Microsoft SQL Server and Teradata.

Module3
Being selective: Data Query Language

Now that you have database software running on your computer, you will learn how to get data from the database using test data installed in the previous module.

  • Get all data from a database table
  • Get only the columns you want
  • Retrieve only those records you care about
Module4
Form and Function

Similar to spreadsheets like MS Excel, databases have functions that allow you to manipulate data.  Topics in this module include:

  • Math functions: Sum, maximum and minimum
  • Date formats: 10/21/1985 vs Oct 21, 1985
  • Create dynamic content (CASE statements)

 

Module5
Keys to Relationships

Topics include:

  • Understanding database keys
  • Primary and foreign keys
  • Table constraints
  • Making sense of Entity Relationship Diagrams
Module6
Selecting Data from Multiple Tables

This is where it all starts to come together.  Relational databases often store their data across many tables, this lessons how to JOIN tables together to get all of the data you need.

Also included:

  • Find all records in one table, not in another
  • The dreaded Cartesian Product

YOUR BONUS LESSON...

  • #1
    Connect to your database via MS Excel!

    We will walk you step-by-step through the process of downloading the software you need to connect to your database using the data tool you are already the most familiar with: Microsoft Excel.

    You can then leverage the world's most popular spreadsheet program to do formatting and easily insert, update and delete data.

    We will give you the tips you need to avoid frustration from the most common installation problem.

THIS COURSE WAS CREATED WITH CERTAIN PEOPLE IN MIND

Talking this course is the solution in several different scenarios. It is the perfect course for someone with no database experience at all, even if you have never worked with any computer programming language before.

For those that do have experience with other programming language, you will appreciate that you can learn at your own pace. You have the option of watching each video or just follow the guide for each lesson.

For those that already know SQL, this is your opportunity to get third-party validation of your skills. You may choose to go straight to the test or finish the course in a single day.

Some people may have no programming experience at all. SQL was originally created with these people in mind. However, without training, the learning curve can be long and your database administrator may threaten to take away your access if you keep writing queries with Cartesian products. Don't know what a Cartesian product is? You will learn in this class and how to avoid it!

Those who have an entry-level job and want to do work that is more interesting and better paying. If you want to work with data, you should have a solid foundation of database skills this course offers.

Those seeking a different role using data. Perhaps you are changing careers and need to work with data. This will help you get up to speed more quickly.

Those with database experience can validate their skills by opting for the certification package

This course focuses first on what skills a database user needs in his or her day-to-day role and gives you only the theory you need. The focus is hands-on activities where you learn by doing.

Register Now!

HOW DO I GET STARTED AND HOW MUCH DOES IT COST?

Select the option that is best for you:

Training      $495

  • Video course
  • Virtual machine with pre-installed database and software
  • Hands-on Exercises-- Practice what you learn!

Training  + certification from Great SQL Training        $895

  • Video course
  • Virtual machine with pre-installed database and software
  • Hands-on Exercises-- Practice what you learn!
  • Practice test
  • Certification exam to validate that YOU have the foundational SQL skills required by today's data professionals.
    • Exam to be scheduled (generally nights and weekends)
    • Must have mobile device capable of video conferencing (Skype or Facetime)
    • Must have laptop or desktop with Internet access capable of video conferencing (Skype or Facetime)

Minimum Requirements

You should already have basic computer skills:

  • Browse the Internet
  • Download files from web pages
  • Install software
  • Copy/Paste text

You must have a somewhat modern laptop or desktop (Mac or PC)

  • Less than 5 years old
  • Minimum of 4 GB of RAM
  • 25 GB of space available on your hard drive
  • Administrative privileges
    • Some businesses and schools prevent users from installing software

30 Day Guarentee Risk Free

 Risk-Free, 30-day money back guarantee.

If you are not happy with the course within 30 days and before taking your certification exam, simply let us know what you don't like and if we can't resolve it to your satisfaction, you get your money back.

 

It's risk free, so start laying the foundation of solid database skills to continue your path as a data professional!

Training Only
$495
  • Video course
  • Guide that spells out the steps in the video
  • Hands-on Exercises-- Practice what you learn!
Sign Up
Training  + Certification
$895
  • Video course
  • Guide that spells out the steps in the video
  • Hands-on Exercises-- Practice what you learn!
  • Practice test
  • Certification exam to validate that YOU have the foundational SQL skills required by today's data professionals.
Sign Up