How to Set Up a Github Repository for SQL Files

Learn how to set up a Github repository and add SQL files to it in this video.

If you've worked with software development teams before, you're probably familiar with Github. It's commonly used for application code, but it can also be used for database and SQL code.

In this video, you'll learn how to create an account on Github, how to create a Personal Access Token to access Github from the command line and other tools, how to use a few basic Github commands to access your repository, and how to add a file.

Timestamps:
00:00 Why Github?
00:43 Step 1 - sign up to Github
01:34 Step 2 - create a Personal Access Token
03:03 Step 3 - create a repository
05:00 Step 4 - add the repository to your computer with git clone
07:31 Step 5 - create a new SQL file
08:54 Step 6 - add the file to the repository with git add
11:09 Commit the file using git commit
11:45 Upload changes using git push
12:55 See the new file on Github
14:11 Visual summary of what we did

[TheChillBison]

This is the most peaceful tech tutorial I've ever heard. Love it!

[selsoft]

Very simple and useful. No need more detail as a SQL Server Developer. Thank you it is good for me to started github.

[estevanprado]

One of the clearest tutorials on how to get started with github, cleared up a lot, thanks!

[cybrpunk_eth]

I don't know what it is, but your video made Git and Github all "click" for me. Thank you!

[luisadriangonzalezontibero]

Great video, great quality. Answers a lot of my questions as I'm thinking of them and does a great job of predicting some of the pitfalls we may encounter. The update about the personal access tokens was great! Also you did a great job of pointing out the basic CLI commands we need! Great tutorial for a beginner like me with not a whole lot of experience with git and with only limited experience using CLI. Once I learned how to use MySQL workbench on a different video, I was able to keep track of all the queries I created using Git/GitHub.

[PS-vcef]

Absolutely the best video! Thank you!

[kaushikdesai]

Thank you sir, it cleared my confusions on git. Now I will start to implement it my work

[andrejusjaroslavcevas]

Question: is it possible to commit and push my code directly from MySQL Workbench query to GitHub?

[rikyriky]

Thanks for continuing making these valuable videos and sharing with us!

[calebeldredge]

Dude, this video is perfect. Thank you man

[simonnavon]

Question, would you recommend this method for establishing a test server for an existing production server?

[vishalnadekar]

Can we upload the sql code in markdown readme page as well?
Can i download a sql code file from mysql workbench and upload it on GitHub as a pure sql code file with some data sources gile?

[ALLInOne-nnny]

Hi, could you create a video to setup github workflow to deploy the sql db to azure. Or share link for reference please ❤

[tomriddle]

Hi,
How do we manage SQL code( DDL, Stored procedures), SSIS packages and Power Bi reports on Github?

[lipsapatro]

i cant understand from 7.02 mins, i did not get redirected to login page & i am confused where will i add that token

[parthtiwari]

Hey after cloning the repo using ht git clone I did not receive a prompt to sign in to git hub. Why is that?

[svetlana]

Great video, thank you! A quick question: if I make changes to my SQL file, is there a way these changes to be automatically uploaded to GitHub or I have to upload a new file with changes via Command Prompt?

[daveshivani]

Thanks for the video. After cloning process done, not getting command for password and username. also facing error while using "ls". I am using window not Mac. Can anyone help me here ?

[tomriddle]

After git clone command where is prompt for username and password

[Amstrongchuks]

How do you open a command line on a windows