But closer looks at some of the best online resources that can help beginners get started with SQL. Get tips from freelance services at their freelance websites.
Let’s start with websites that focus on SQL syntax and basic SQL concepts.
- W3schools – “SQL Tutorial”
W3schools claims to be the largest developer of the website on the Internet. It provides several tutorials and references in web development languages like HTML, CSS, JavaScript, PHP, SQL and jQuery, which covers most aspects of web programming.
A distinctive feature is the ability to test online queries. At the beginning of the tutorial, there is an example of a database that can be edited and restored to its original content at any time. The guide concludes with a simple questionnaire.
While the tutorial is available without registration
- Verbal Academy
Vertabelo Academy offers interactive SQL courses, available directly in the browser. You can learn more about SQL queries, data management and creating tables.
The “SQL Queries” course starts with simple queries, progressing in the GROUP BY query to advanced topics as sub-queries. You can also discover the subtle changes between different joining methods, including INNER JOIN, LEFT JOIN, JOIN, and RIGHT OUTER JOIN. Finally, you have the opportunity to test your knowledge on a comprehensive exam.
In the course “Using data in SQL,” you learn how to handle data in relational databases, that is, how to insert, update and delete information from a database.
In the “Creating SQL Tables” course, you will discover how to handle the structure of a relational database. You will learn how to create tables and define their different elements, such as primary keys, unique keys, and external keys. You will learn how to use and set restrictions. Finally, you’ll discover how to create views.
Each course features dozens of interactive exercises with a detailed explanation of the theory behind the lesson, and an interactive console that checks your solution. After completing all the lessons, you can take a final exam to evaluate your knowledge.
You can start the course without registration, but you will have to register after completing the first exercises. You can register your email address or social profiles (Facebook, Google+ and Twitter or GitHub).
- Codecademy – “Learn SQL”
Codecademy is an online platform that offers a wide range of free coding classes in programming languages such as HTML, JavaScript, jQuery, PHP, Python, and Ruby. In addition to these courses, Codecademy students can learn how to handle data with SQL.
Like others during Codecademy, “Learn SQL” free and interactive. It covers the basics of basic database tables, queries, aggregate functions, building advanced database queries and more.
The course consists of 4 classes that focus on:
SQL database commands to manipulate data stored in relational databases
SQL Commands most commonly used to query a table in a database
Using SQL to perform calculations during a query
Query multiple tables through joins
The user interface of each lesson is divided into three panels. The left contains a description of the exercise with a brief theoretical introduction. In the middle, there is an interactive SQL command line where the user writes to an SQLite SQL database. The right pane displays a visual representation of the database schema with the result of the query.
When completing a lesson, you can test your knowledge with a quiz, or master your skills with a real project to teach you how to apply what you learn in a convenient and convenient way. Unfortunately, both contest projects are only available to users who have subscribed to a Pro Codecademy version.
To participate in the course, you must register using an email address or Google or Facebook.
SQL antiscia
- Khan Academy – “Introduction to SQL”
Khan Academy offers its micro-conference users in the form of YouTube videos, lots of hands-on exercises, and a personalized learning board. Together, these tools allow students to study at their own pace inside and outside the classroom.
Among the many courses offered by Khan Academy, you can find a free SQL course called “Intro to SQL: Query and Data Management”.
Each lesson consists of two elements. The left window is a video tutorial, while the right window shows real-time changes in the database structure and the results of the SQLite database searches. The exercises are supported by documentation and helpful tips. After completing the first part of the course, students complete a more advanced project.
The complete course consists of 5 parts, starting with SQL databases. Continues to build more advanced SQL queries using operators (such as AND / OR, EN, LIKE, etc.) and unions. A final section called “What We Learn” provides helpful tips and links.
Khan Academy allows users to watch videos without registering; However, after registration (via Facebook, Google or e-mail) can ask questions about videos and participate in discussions.
- SQLZoo
SQLZoo is a beautiful free interactive SQL tutorial developed and maintained by Edinburgh Napier University.
Facilitator course features and interactive exercises for several types of databases such as MySQL, PostgreSQL, Oracle, SQL Server, and DB2.
This site has three main sections: tutorials, evaluations, and references. Get tips from freelance services at their freelance websites.
A tutorial is a set of exercises designed to familiarize you with new topics. It starts with SQL databases and then passes through nested sentences and aggregate functions (such as COUNT, SUM or AVG) and ends with more advanced operations JOIN. At any time, you can refer to the reference section for information on the appropriate theory, in the interactive examples explained.
After completing each tutorial, you can do a test to show how well you understand the topic.
The evaluations section provides several mini-projects; each includes 15 questions of different levels of difficulty.
However, the course is available without registration, can create an account with your email. This is recommended if you want to post comments or contribute to the site.
- Point Tutorials – “Learn SQL”
Point tutorials claim to be the largest library of tutorials on the web. In fact, it offers dozens of online courses in computer engineering, information technology, programming languages , and management.
If you’re looking to learn SQL or database concepts, here are several tutorials, including SQL, MySQL, PostgreSQL, SQLite, DB2, PL / SQL, and others.
The “Learning SQL” tutorial provides a good guide for basic SQL, its most useful features, and more advanced topics. There are many easy-to-understand examples, but no interactive exercises to practice what you have learned.
All courses available in TutorialsPoint.com, including “Learning SQL” tutorial, are accessible without registration.
It should be noted that you can download the entire tutorial as a PDF file to return to it at any time, even when you are disconnected.
- Udacité – “Introduction to Relational Databases”
Udacity offers interactive online courses to advance academic and professional skills. While Udacity focuses on benefits, some courses are free.
One of their free “Introduction to relational databases” course, which provides students with basic SQL concepts and database design. Since the course uses examples and programming exercises in Python, you will also know the Python API. For this reason, it requires the basics of Python. You do not need any previous database experience since this course is an introduction to entry into relational databases.
The course consists of video lessons, and each lesson includes the final questionnaire. The lessons are divided into four parts:
Relational concepts
Queries
Python DB-API (access to a relational database from Python code)
Advanced SQL (joins, standardization)
The course concludes with a project focused on building a Python module with the support of a database to run a game tournament.
You do not have to register to preview the course, but if you want full access, you must subscribe to your Google Mail, Google or Facebook account.
- SQL Troubleshooting
Problems and Solutions SQL is an interactive guide that allows you to view tables and queries run on a base instance. The tutorial will explain the basic concepts and constructs of SQL and provides examples for different levels of experience.
Once you have become familiar with SQL, you can practice your skills in sister “SQL Exercises”. Here you can create and test your DML SQL statements: there are exercises to retrieve and modify data using SELECT, INSERT, UPDATE and DELETE.
You can read the entire tutorial without registration, but if you want to write your own SQL queries on the interactive console and run on those databases, you must register your email address.
Most items are available without registration; however, some content requires users to sign up for an email account.