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.

 

Student rating

5.00 Out Of 54 Students

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
ADP
price waterhouse cooper 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 *

Course type
  • Featured
  • In-House
  • Self-Paced
Student rating

5.00

Course length

83 Lectures

14 Hours

On-Demand training
Memberships

Prefer to go at your own pace?

Check out our membership options to help you go from zero to Data Science (Super)Hero. You receive access to all Pierian Training on-demand Data Science courses, including this course, plus live office hour sessions with a real instructor and/or 1:1 tutoring.

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