Hola, mi nombre es Brais Moure.
What is this?
A free course for learning the fundamentals of SQL and relational databases from scratch, built for complete beginners.
A free course for learning the fundamentals of SQL and relational databases from scratch, built for complete beginners.Is this a video course or just written code?Both: a 7-hour video course on YouTube paired with this repository's SQL scripts and lesson notes for each topic covered.
Both: a 7-hour video course on YouTube paired with this repository's SQL scripts and lesson notes for each topic covered.How is the course organized and where do I start?Lessons are numbered sequentially from database basics through installation, reading data (SELECT, WHERE, JOIN...), writing data (INSERT/UPDATE/DELETE), table and database administration, relationships, and advanced topics like triggers and stored procedures, each linking to runnable .sql code files.
Lessons are numbered sequentially from database basics through installation, reading data (SELECT, WHERE, JOIN...), writing data (INSERT/UPDATE/DELETE), table and database administration, relationships, and advanced topics like triggers and stored procedures, each linking to runnable .sql code files.Which database do I need to follow along?The course mainly uses MySQL for the lessons, and also covers PostgreSQL later since it's one of today's most popular databases.
The course mainly uses MySQL for the lessons, and also covers PostgreSQL later since it's one of today's most popular databases.Will what I learn work on other database engines?Yes — SQL is a standard language, so once you learn it with MySQL/PostgreSQL you can apply the same knowledge to other database systems with little difficulty.
Yes — SQL is a standard language, so once you learn it with MySQL/PostgreSQL you can apply the same knowledge to other database systems with little difficulty.Do I need prior programming experience?No, it's aimed at absolute beginners with no prior knowledge required.
No, it's aimed at absolute beginners with no prior knowledge required.How was this course made?It was created during live streams on Twitch, then compiled into this repository and a 7-hour YouTube video.
It was created during live streams on Twitch, then compiled into this repository and a 7-hour YouTube video.Does the course cover connecting SQL to actual code?Yes, there's a lesson on connecting from code using connectors, including a Python example and a note on SQL injection.
Yes, there's a lesson on connecting from code using connectors, including a Python example and a note on SQL injection.Are there any advanced topics beyond basic CRUD?Yes — indexes, triggers, views, stored procedures, transactions, and cloud deployment are covered toward the end of the course.
Yes — indexes, triggers, views, stored procedures, transactions, and cloud deployment are covered toward the end of the course.Is there anything beyond the free repo content?The author offers a paid platform (mouredev.pro) with the course split into individual lessons, exercises, tests, and a completion certificate, but the repository itself is free.
The author offers a paid platform (mouredev.pro) with the course split into individual lessons, exercises, tests, and a completion certificate, but the repository itself is free.What are similar projects?html-css, Sigma-Web-Dev-Course, Python-100-Days, Python-Core-50-Courses, interview_python, Complete-Python-3-Bootcamp, Hello-Python, curriculum
html-css, Sigma-Web-Dev-Course, Python-100-Days, Python-Core-50-Courses, interview_python, Complete-Python-3-Bootcamp, Hello-Python, curriculumWhich topics is it in?sql-client, relational-database, students, course, mysql, sql, academic-research, video, beginner-friendly, postgresql, learning-resources, database
sql-client, relational-database, students, course, mysql, sql, academic-research, video, beginner-friendly, postgresql, learning-resources, database