Corso Understanding Basic SQL Syntax

Course delivered in English
Lessons: 5
Livello: Foundational
Access: Free Online Course (Audit)

This course takes approx 1,5 hours to complete

Course Path

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

1. Describe basic SQL syntax rules along with requirements for the names of tables, and the naming and data type requirements for table columns (fields).
2. Use the SELECT command and FROM clause to control the columns that are displayed and the order in which they display in query output.
3. Limit the rows retrieved by an SQL query by applying the WHERE clause with one or more conditions.
4. Use the ORDER BY clause to modify the sort order of the rows returned from an SQL retrieval query.
5. Code an SQL retrieval query that uses the JOIN command to retrieve data rows from tables that are related via a common column.

In this project you will learn to identify and use correct syntax when writing SQL retrieval queries. Through hands-on activities in SQLiteStudio, you will gain experience with the SQL syntax used to display specific columns, filter for specific rows, and determine the sequence of those columns and rows in query output. Familiarity with SQL syntax is a marketable skill for both Information Technology professionals and non-IT super users.

Offered by Coursera as a free course (at the time of publishing). 

Be aware platform might change it to Pay course at a later stage without notice

Included in this Guided Project:

• All learning materials, including the interactive workspace and final quiz
• Instant access to the necessary software packages through Rhyme
• A split-screen video walkthrough of each step, from a subject-matter expert
• Free download of what you create
• Ability to access your cloud desktop across six different sessions

This course is organized by the external partner Coursera. In order to take this course you will need to register on their Academy platform where you can take advantage of this and many other courses on offer. 

About Coursera:

• Coursera offers a 7-day Free Trial
• Enroling to Coursera can cost €32 per month to continue learning after trial ends.
• Unlimited access to all courses in the Certificate
• Watch lectures, try assignments, participate in discussion forums, and more.
• Cancel anytime.
• No penalties - simply cancel before the trial ends if it's not right for you.
• Go as fast as you can - the faster you go, the more you save.
• Certificate when you complete.
• Share on your resume, LinkedIn, and CV.
• Learn on your own schedule
• Course videos and readings
• Graded quizzes and assignments
• No degree or experience required for many programs

Once you have finished the course, go back to the course page in Guilds42 to upload proof of completion (jpg / png / pdf). 

Your document will be evaluated and if appropriate and verifiable, you will find this certification validated in the dashboard.