SQL SELECT Statement Tutorial

visibility 21 lượt xem schedule 1 năm trước timer 14:58
open_in_new Dailymotion
Learn the basics of the SQL SELECT statement in this quick tutorial! We'll cover retrieving data from tables using simple examples. No database installation required! Practice along using the mycompiler.io link below. Plus, see the SELECT statement in action using a real MySQL database. Perfect for beginners!<br />---<br />Code from the video: https://www.mycompiler.io/view/Jd9aaO6JUOx<br />Run SQL code online free: https://www.mycompiler.io/new/sql<br />---<br />Get my coloring book, Watson the Time-Travelling Dog 🐕🦖👇<br />https://watsoncoloringbooks.com/book1-locations/<br />---<br />Our website: https://watsontechworld.com<br />---<br />00:00 Intro and overview of tutorial<br />01:00 Teaching about SELECT statement in a document<br />02:20 Showing mycompiler.io with SQL next to spreadsheet<br />04:04 Creating the table and inserting data<br />04:50 Notes about SQL semicolons P1<br />05:15 Info about comments in SQL<br />05:57 Running first SELECT statement with *<br />06:35 More example SELECT commands P1<br />10:38 Notes about SQL semicolons P2<br />10:57 More example SELECT commands P2<br />12:07 SELECT commands in a MySQL database<br />14:22 Conclusion about SQL SELECT statement<br />---<br />#SQL #SQLTutorial #MySQL #SQLSelect #LearnSQL #SQLForBeginners #SQLBasics #DatabaseTutorial #BeginnerSQL #database