1. What is GitHub?

GitHub is a software source code hosting service, which is basically a “web disk” for files, but this “web disk” is made for developers to help them store and manage their code. There are now more than 50 million developers on the platform.

I wrote a free tutorial, Illustrated SQL Interview Questions, which I would like to put on GitHub as an ebook so that more people can see it.

If you’d like to use GitHub to create a digital tutorial, see the steps I’ve written below.

2. How to make an e-tutorial?

1) Install the plug-in in your browser

Github documents in Markdown, so we need to convert documents with public numbers to Markdown.

Markdown is a browser extension that converts web pages to Markdown language.

ksria.com/simpread/

2) Convert the article into a Markdown document

Copy the link to the official number of the article into the browser address bar to open, and then open jianyue according to the following operation, you can download the article into Markdown file.

3) Upload the downloaded Markdown file to Github

Log in to Github to establish the chapter.

github.com/

Click the Sign in button in the upper right corner and fill in your account password to log in. If you log in for the first time, you need to register an account first.

Once logged in, create a project and then click the project name to enter the project.

Click the “Add File” button and select “Create New File” to enter the “Create Document” page.

Enter the file name in the red box below. If you need to create a chapter of the ebook, add “/” after the entered name to automatically create the chapter. Github does not allow blank sections to be created, so you need to enter the file name after you create the section.

After filling in, click the red box below (submit modification) to complete the chapter and document creation. If the document is not needed, delete it later.

4) Upload the Markdown document

At this point, the chapter has been created. All we need to do is find the appropriate section and upload the Markdown file we downloaded.

Click the Add File button and select Upload File.

You can click Choose Your Files to upload the Markdown file you downloaded to GitHub.

Multiple documents can be uploaded at one time. After uploading successfully, click the place in the red box below to submit modification.

How do we check if our operation was successful?

Click the corresponding chapter name to check whether the document is displayed. If it is displayed, the upload is successful.

5) Manually modify the uploaded Markdown file

The Markdown file converted by the previous plug-in tool does not necessarily meet our needs, so we need to modify it manually. Click the Markdown file that you want to modify.

Click the Modify button (red box below)

After modification, you can click Preview Changes to check whether the desired effect is achieved.

You can record the changes in the gray area below (red box below). When the changes are complete, click Commit Changes.

6) Modify the contents of the book

The readme. md file on the front page of the project is the directory for the ebooks. Now we will update the uploaded document to the directory.

Click the Modify button for readme.md.

Replace the following code snippet with the name and relative address of the file you want to insert and place it under the corresponding section script location.

For example, ByteDance’s interview question: What’s your average salary?

Gitbub records changes and commits them by committing them, so after each change you need to click Commit Changes to complete the changes.

3. Add author information to the ebook

In the ebook catalogue, you can find ICONS and links related to the author, ebook, as shown below.

How do you add and modify this?

1) Change the order of ICONS

Suppose you want to move the Stars and author ICONS in the figure below to the end of the line where the arrow is

Click the Modify button at the top right of the readme. md file

Locate the script below at the beginning of the document, where a << span=””>a> code snippet represents an icon. Locate the Stars and author icon code (red box below) and move it to the << span=””> A > code indicated by the last arrow. Click Submit to complete the modification.

2) Modify the link corresponding to the icon

Find the href value in << span=””>a>, modify the content after the equal sign in the red box below to the desired link content, click Submit to complete the modification.

4. Final results

Click on the place in the red box below, the more people give the Star, the more people can see the work. My ebook achievement address:

Github.com/houzidata/G…

Recommended: Learn SQL from scratch?