SQL Essentials: The Beginner’s Guide to SQL Language

4


Learn (or improve!) your SQL skills – write SELECT queries with table joins (INNER, OUTER, etc) quickly and efficiently!

The course has everything you need to start writing your own SQL queries.

What you’ll learn

  • Write SELECT queries for relational databases..

Course Content

  • Introduction. SQL Overview..
  • Installation and Setup for Lab Exercises.
  • Creating Tables. Relationships Between Tables..
  • Basic Queries – SELECT … FROM … WHERE….
  • Working with NULL values.
  • Aggregations – GROUP BY, HAVING, DISTINCT.
  • Table Joins – INNER JOIN, OUTER JOINs, SELF JOIN, CROSS JOIN.
  • Set operators – UNION, EXCEPT and INTERSECT.
  • Functions and Operators.
  • Changing data: INSERT, UPDATE, DELETE.
  • Course Summary.

SQL Essentials: The Beginner's Guide to SQL Language

Requirements

  • No prior knowledge is required. Only your desire to learn..
  • It is recommended to have a Windows or MAC laptop/PC for lab exercises..

Description

The course has everything you need to start writing your own SQL queries.

The SQL language seems simple – and that’s true. However, some topics can cause mistakes – things like NULL values, duplicate rows and missing rows, etc. This course covers the frequent mistakes, and how to avoid them.

You will learn SQL syntax applicable to most relational databases.  In the practice exercises you will use PostgreSQL, but the knowledge is easily transferable to other databases.  The standard SQL is the same in all ANSI-compliant SQL databases.

The course has English subtitles (closed captions) manually created!

Check out the free preview videos for more information!

I’ll be happy to see you inside the course!

Who this course is for:

  • Those who do not know SQL at all.
  • Those who know some SQL commands, but are not quite comfortable using them.

Get Tutorial



Leave A Reply

Your email address will not be published.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Privacy & Cookies Policy