Introduction to SQL

Our Introduction to SQL course is for data analysts, developers and engineers who want to learn SQL in a quick and effective way.

Course length

83 Lectures

14 Hours

Student rating

5.00 Out Of 54 Students

How to Become a Data Scientist

Sign up to receive this FREE ebook
written by Pierian Training founder Jose Portilla!

What You’ll Learn

  • Get started with PostgreSQL and PgAdmin - two of the world's most popular SQL tools
  • Learn the basics of SQL syntax
  • Analyze data using aggregate functions with GROUP BY commands
  • Run advanced queries with string operations and comparison operations
  • Learn to use logical operators to add logic flow to your SQL queries
  • Learn common SQL JOIN commands
  • Learn to create tables and databases with constraints on data entries

Top Companies Offer Our Courses

general electric (GE) logo transparent png
microsoft png logo
starbucks logo png
credit suisse logo
salesforce logo png transparent
capital one logo
mckinsey and company logo
cigna logo
us naval research laboratory logo

Course Content

You’ll learn how to read and write complex queries to a database using one of the most in demand skills – PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more. Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! 

  • SQL Syntax
  • Setup of PostgreSQL
    • Setup of PgAdmin – a powerful administration tool
  • Use SQL to query data:
    • Data Extraction from databases
    • GroupBy for data aggregation
    • Merging data via Joins
    • Advanced queries, such as comparisons
    • Using logical operators to add logical flow
    • Conditional expressions
  • Creation of databases and tables
    • Data Types
    • Primary and Foreign Keys
    • Data Insertion
    • Data Alteration
    • Data Deletion
    • Administration
  • Combination of PostgreSQL and Python

 

Analysts who need to learn how to create structured queries to a database (e.g. PostgreSQL, MySQL, MSSQL Server).

 

Course Description

Modern companies are generating more data every day, and key competitive advantages will stem from being able to query and understand this data. Data is often stored in relational databases, which are queried using a specific language: SQL. SQL, which stands for Structured Query Language, allows communication with relational databases and is one of the most demanded tech skills of the 21st century.  

What Students Are Saying

Loved it! Jose is a great instructor who has taught me a lot in his other courses; I bought this because of the positive experiences from those courses. I was not disappointed in the Complete SQL Bootcamp. :) thanks Jose, I appreciate you!

John Carmack

While I have known SQL for a little while, it's good to finally have something to prove it! This was a great course provided by Jose Portilla. I recommend this to anyone who wants to brush up on their SQL or to learn PostgreSQL from scratch.

Josh Skousen

UCCU

Great so far. Excellent teaching. Also helps that we can pause and rewind. Very well explained. Great pace. Not too fast or slow.

Victor Adra

The detailed explanation would help anyone learn SQL from Scratch. Your efforts are much appreciated.

Niranjana Vinnakota

Excited to share that I have successfully completed the SQL Bootcamp course by Jose Marcial Portilla. The lessons are clear and the assessments are challenging but rewarding. It is amazing to see what you can do with SQL and I look forward to using it at work. I learnt a lot and thoroughly enjoyed it!

Noa Maianski

Skai

I've enjoyed the course very much. It's straightforward, interesting, and I'm excited to learn a new skill.

Maximillian Hill

Really enjoyed this course. Went into it having meant to learn SQL for years but not knowing a great deal and came out of it feeling pretty knowledgeable and confident. A good mix of theory and practice means the course always feels useful and comprehensive in its scope.

Neil Leggett

I have less than zero SQL experience and am loving this course so far. It's very clear and easy to follow. Thank you!

Kimberly Thrush

I'm halfway there through the course and as for now I have to say it's amazing. I did one other beginner course on SQL and it was nowhere near as good as this. This one is very professional and understandable. The quality of materials and presentations is simply superb. I can't stop watching it!

Krzysztof Drzewiński

I like the hands-on ability to create databases and learn queries by doing in Postgres SQL that can be used for projects.

Prakash Shimpi
Leave Review
Add a review

Your email address will not be published. Required fields are marked *

Instructor-Led

Learn directly from our expert instructors via live webinar. Also includes the full video-on-demand course.

Private Groups

Train your whole team

Empower your employees with the latest technology skills to support professional development at your organization.

Instructor-led, on-demand, or hybrid cohort training approaches motivate employees and encourage team building while supporting the advancement of technical skills at your organization.

More Courses to Explore

  • Introduction to Python

    Our Introduction to Python course is designed to take complete beginners or experienced developers up to speed on Python’s capabilities, setting up students for success in using Python for their specific field of expertise.

  • Data Literacy for Business

    This Data Literacy for Business training is designed to give you a high-level overview of the key topics in Data Science and Machine Learning without needing to learn how to code or cover complex mathematics.
  • GCP Associate Cloud Engineer (ACE) Exam Prep

    This course prepares your for the Google Cloud Platform Associate Cloud Engineer (ACE), the first step towards certifying your expertise with Google Cloud. To best position your for a career in Google Cloud Platforms, we've also included the next level Professional Data Engineer (PDE) exam prep training course in the cost of this course. Prepare to become Google Cloud certified today!  
  • FREE GCP Associate Cloud Engineer (ACE) Practice Exam

    Prepare for the Google Cloud Platform Associate Cloud Engineer (ACE) exam with a FREE, full-length practice exam with Pierian Training to assess your progress against the core concepts tested on the exam.