Technology and Digital

SQL For Beginners Course

Teacher: Sebastien Polis - Data Scientist

  • Intermediate
  • 36612 students
  • 4.6
Start the course!

Co-certifies:

Online course description

SQL is one of the most important tools in the world of data analysis. It is the language used to work with the vast majority of the world's databases, allowing us to explore, analyze and summarize millions of records very quickly. As the world becomes more digitized, the greater the demand for professionals with SQL and database skills.

What will I learn?

In this course you will learn all the SQL necessary to be able to analyze your own data. Specifically, you will learn how to install SQL on your computer, how to make queries to explore, analyze and summarize data, and how to use the various SQL tools to work with different types of data.

Who is it aimed at?

Students
Entrepreneurs
Analysts
Anyone interested in data analysis

Requirements

Have access to a computer running MacOs or Windows

Content of the SQL For Beginners course

  • Module 1Software installationand basic theory

    5 Capsules 00:26:46

    • Capsule 1: Welcome
      Free View
    • Capsule 2: Course Curriculum
      Premium Access
    • Capsule 3: Databases 101
      Premium Access
    • Capsule 4: Windows installation
      Premium Access
    • Capsule 5: MacOS Installation
      Premium Access
  • Module 2Fundamentals ofSQL

    13 Capsules 01:02:12

    • Capsule 1: Introduction to the section
      Premium Access
    • Capsule 2: Introduction to data
      Premium Access
    • Capsule 3: Basic SQL Query
      Premium Access
    • Capsule 4: WHERE clause
      Premium Access
    • Capsule 5: SELECT and WHERE exercises
      Premium Access
    • Capsule 6: Distinct and Count
      Premium Access
    • Capsule 7: Distinct and Count Exercises
      Premium Access
    • Capsule 8: ORDER BY
      Premium Access
    • Capsule 9: LIMIT
      Premium Access
    • Capsule 10: ORDER BY and LIMIT exercises
      Premium Access
    • Capsule 11: BETWEEN and IN
      Premium Access
    • Capsule 12: LIKE AND ILIKE
      Premium Access
    • Capsule 13: Section Summary
      Premium Access
  • Module 3Aggregations

    8 Capsules 00:49:00

    • Capsule 1: Introduction to the section
      Premium Access
    • Capsule 2: GROUP BY
      Premium Access
    • Capsule 3: GROUP BY exercises
      Premium Access
    • Capsule 4: HAVING
      Premium Access
    • Capsule 5: Having Exercises
      Premium Access
    • Capsule 6: Window Functions
      Premium Access
    • Capsule 7: Exercises Ventaba Functions
      Premium Access
    • Capsule 8: Section Summary
      Premium Access
  • Module 4JOINS

    10 Capsules 00:52:56

    • Capsule 1: Introduction to the section
      Premium Access
    • Capsule 2: JOINS Theory
      Premium Access
    • Capsule 3: LEFT JOIN
      Premium Access
    • Capsule 4: LEFT JOIN Exercises
      Premium Access
    • Capsule 5: INNER JOIN
      Premium Access
    • Capsule 6: INNER JOIN Exercises
      Premium Access
    • Capsule 7: FULL OUTER JOIN
      Premium Access
    • Capsule 8: FULL OUTER JOIN Exercises
      Premium Access
    • Capsule 9: CROSS JOIN
      Premium Access
    • Capsule 10: Section Summary
      Premium Access
  • Module 5Advanced Operations

    7 Capsules 01:02:09

    • Capsule 1: Introduction to the section
      Premium Access
    • Capsule 2: CASE
      Premium Access
    • Capsule 3: CASE Exercises
      Premium Access
    • Capsule 4: COALESCE AND NULLIF
      Premium Access
    • Capsule 5: DATE_PART and DATE_TRUNC
      Premium Access
    • Capsule 6: Sub-Query
      Premium Access
    • Capsule 7: Analytical Project
      Premium Access
  • Module 6DB operations

    3 Capsules 00:19:05

    • Capsule 1: Introduction to the section
      Premium Access
    • Capsule 2: Data Types and Tables
      Premium Access
    • Capsule 3: Creating the DB
      Premium Access

Final examTo obtain your course pass certificate, you will have 2 attempts per day to pass a multiple-choice exam with more than 70%.

About our expert

Sebastien Polis SQL For Beginners course teacher

Sebastien Polis

Data Scientist

Data Scientist with more than 5 years of experience in data analysis and database management in various industries such as public sector, construction, and streaming. Master's degree in Data Analytics from Imperial College (UK). Certifications in AWS and Google Analytics. Currently working as a Data Scientist for the British "unicorn" DAZN, where he works with hundreds of databases and Big Data to constantly improve the way we consume sport.

Get certified and boost your career

On behalf of Saint Ignatius University
Optional certificate template for our course*San Ignacio University will certify all NETZUN students.

About the institutions

Netzun - online courses
Edtech company, founded in 2015 and specialized in virtual education based on the 'microlearning' methodology. Its purpose is to democratize the knowledge of extraordinary people throughout Latin America.
San Ignacio University certifies our courses
San Ignacio University is a U.S. university that stands out for offering a unique and cutting-edge academic experience. It has a highly qualified faculty committed to academic excellence and the integral development of its students.

Develop your skills with us

Benefits

Full access to course videos

Downloadable materials

Forum with other students

Certificate of Completion

- 81%

BUY COURSE

US$ 2.90Previously US$ 15.00

OFFER EXPIRES ON:

0 :

Dias

00 :

Hrs

00 :

Mins

00

Segs
Add coupon

Forever

Develop your skills with us

- 81%

BUY COURSE

US$ 2.90 Previously US$ 15.00

OFFER EXPIRES ON:

0 :

Dias

00 :

Hrs

00 :

Mins

00

Segs
Add coupon

BENEFITS

  • Full access to course videos
  • Downloadable materials
  • Forum with other students
  • Certificate of Completion
  • Forever
Online education for your professional growth
Short courses applying the micro-learning methodology
Short classes (micro-learning)
Learn with concise courses lasting an average of 2 hours, subdivided into videos of up to 10 minutes.
  • Concise information on specific skills
  • Easier to learn and super practical
Lifetime access to our courses
Lifetime access
If you purchase a course or specialization, you will have lifetime access to the recorded content.
  • Access your classes anytime, without schedules
  • Access your classes as many times as you want
Certified specializations with learning projects
PREMIUM
Project-Based Learning
All courses and specializations will have a final project so you can put your new skills into practice
  • Put your new skills into practice
  • You will have feedback from mentors
  • Create a portfolio of projects, improve your resume.
Certified courses
Get certified upon approval
your courses
Upon completion of a course, you will need to pass an exam, and we will issue you a digital certificate that validates your skills.
  • Certificate with a unique code
  • Improve your resume
  • Boost your professional career