Pierian Training
Project Management Academy
Six Sigma Online
United Training
Velopi
Watermark Learning
Login
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.
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
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.
Instructor-Led
Learn directly from our expert instructors via live webinar. Also includes the full video-on-demand course.
On-Demand
Get access to this self-paced Introduction to SQL training course plus the entire Pierian on-demand Data Science Training Library with a Data Science Hero membership.
Starting at
$99
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.