This SQL tutorial is designed for beginners. You will learn what is a database, what is the difference between relational databases and no-SQL dbs, how to set up and use RDBMS. Learn SQL commands in less than 1 hour!

The Railsware Academy team has prepared a SQL practice sheet for you to test SQL right away. Create your personal copy: https://bit.ly/rw-sql-practice
In our SQL basics studies, we will use SQLite: https://www.sqlite.org/index.html
Download SQLite browser to create and modify databases: https://sqlitebrowser.org/dl/

Use these timestamps to jump right to a specific topic:
1:53 - The most common tasks you can perform using SQL
2:28 - What is a database? Relational vs. non-relational databases
3:47 - SQL table structure
4:30 - SQL constraints and NULL value
6:23 - What is a database management system (DBMS)? RDBMS vs. no-SQL DBMS
9:53 - 10 key facts about SQL
11:18 - How to create a database? How to add a table via .csv in SQLite?
15:40 - How to use SELECT, FROM
18:40 - How to use WHERE
21:31 - How to use SQL LIKE, IN, BETWEEN to set criteria
23:20 - Aggregate functions SUM, COUNT, AVG
24:00 - How to state alias for fields and tables in SQL using AS
25:24 - SQL GROUP BY, HAVING, ORDER BY, LIMIT
29:09 - Full SQL syntax
29:47 - SQL JOIN - how to connect multiple tables using INNER, LEFT, RIGHT, and FULL JOINs

Start using Coupler.io to streamline your data flows: https://bit.ly/sqlbasic-coupler-mp
Visit Coupler.io to learn more about the product: bit.ly/sqlbasic-coupler-ws
Contact Railsware to build your software product http://bit.ly/contactrailsware
Join Railsware team http://bit.ly/railswarecareers
Subscribe to Railsware and learn the most efficient data analytics tools with us!

Design: Vlad Shagov
Video editor: Oleg Gorovoi
Cases: Elvira Nassirova, Alexey Vasiliev, Anastasiia Avramenko
Speaker: Anastasiia Avramenko