sqlteaching/index.html at master · rhc2104/sqlteaching · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
<!DOCTYPE html>
<html data-theme="dark">
  <head>
    <title>SQL Teaching - The easiest tutorial to learn SQL</title>
    <script src="sql.js?1"></script>
    <script src="jquery-2.1.3.min.js"></script>
    <link rel="stylesheet" href="pico.css?1">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

    <link rel="icon" href="./favicon.ico" type="image/x-icon">

    <meta property='og:site_name' content='SQL Teaching' />
    <meta property='og:title' content='SQL Teaching' />
    <meta property='og:url' content='http://www.sqlteaching.com' />
    <meta property='og:description' content='The easiest way to learn SQL' />
    <meta property='og:image' content='http://www.sqlteaching.com/database.png' />
    <meta http-equiv="Cache-Control" content="no-cache, no-store, must-revalidate" />
    <meta http-equiv="Pragma" content="no-cache" />
    <meta http-equiv="Expires" content="0" />

    <meta name="viewport" content="width=640" />
  </head>
  <body class="container">
    <div class="header">
      <h1 id='title-header' >
        SQL Teaching
      </h1>
    </div>
    <div class="main grid">
      <aside >
        <nav class="sidebar">
        </nav>
      </aside>
      <details class="mobile-sidebar">
        <summary>Lessons</summary>
        <div class="mobile-sidebar-links">

        </div>
      </details>
      <article class="content">
        <!-- <div class='menu menu-hidden-for-mobile'>
        </div> -->
        <div class='not-menu-container'>
          <h3 id='lesson-name'>
          </h3>
          <div class='layout-row'>
            <div id='prompt'>
            </div>
          </div>
          <div class='layout-row'>
            <div class='sql-input-container'>
              <h4 id="sql">SQL</h4>
              <textarea id='sql-input' rows=8  tabindex='1' placeholder="Write your SQL here"></textarea>
              <a id='sql-link' href='#' class='btn btn-default' tabindex='2' role="button">Run SQL</a>
            </div>
            <br/>
            <div class='results-container'>
              <div class='layout-row'>
                <article id='answer-correct' class='alert success'>
                </article>
                <article id='answer-wrong' class='alert danger'>
                </article>
              </div>
              <strong>Result:</strong>
              <div id='results'>
              </div>
            </div>
            <div class='expected-results-container'>
              <strong>Expected Result:</strong>
              <div id='expected-results'></div>
            </div>
          </div>
          <div class='layout-row'>
            <div class='current-tables-container'>
              <strong>Current tables:</strong>
              <div id='current-tables'></div>
            </div>
            <br/>
          </div>
          <div id='links-subheader'>
            <div class="grid link-buttons">
              <a id='previous-link' class='pagination-link secondary' role='button'>Previous</a>
              <a id='next-link' class='pagination-link' role="button">Next</a>
            </div>
          </div>
        </div>

      </div>
      <div class="footer container">
        <div class='email-info'>
          Stuck? <a href="mailto:sqlteaching@gmail.com" target="_top">Email us at sqlteaching@gmail.com</a> for help or feedback. <a href="https://github.com/rhc2104/sqlteaching" target="_blank">View on GitHub</a>
        </div>
        <div class="re-design">
          Redesigned by <a href="https://github.com/JackGraymer/sqlteaching-redesigned/tree/master" target="_blank">Alvaro Cervan <i class="fa fa-github"></i> </a> 2023
        </div>
      </div>
    </div>
    <button onclick="changeTheme()" id="theme">
      <i class="fa fa-adjust" aria-hidden="true"></i>
    </button>

    <script src="sqlteaching.js?1"></script>
  </body>
</html>