DEV Community

Emanuel Gustafzon
Emanuel Gustafzon

Posted on

1

SQL Course: Get Started.

Learn SQL in a funny way by building a social media database. The database will contain users, profiles, posts with likes and users will also be able to follow each other.

I will reference to w3schools.com during this series so you can learn a bit more about the theory and this series will teach you how to put it into practice.

Setup

I am using SQLite for this course. If you use another database it’s fine but maybe the syntax will be slightly different. But w3schools gives examples of different syntax.

I am also using Replit for this tutorial as IDE. You can easily create an account and create a new Repl with the SQLite template. That makes it easy to set up and you can also code in your browser or on your phone or IPad so you can take this tutorial on the go.

https://replit.com/

What we will learn

  • Creating Tables with primary and foreign keys.
  • One to one relationships.
  • One to many relationships.
  • Many to many relationships.
  • Query data.
  • Inner joins, left joins and self joins and nested joins.

Image of AssemblyAI tool

Transforming Interviews into Publishable Stories with AssemblyAI

Insightview is a modern web application that streamlines the interview workflow for journalists. By leveraging AssemblyAI's LeMUR and Universal-2 technology, it transforms raw interview recordings into structured, actionable content, dramatically reducing the time from recording to publication.

Key Features:
🎥 Audio/video file upload with real-time preview
🗣️ Advanced transcription with speaker identification
⭐ Automatic highlight extraction of key moments
✍️ AI-powered article draft generation
📤 Export interview's subtitles in VTT format

Read full post

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay