MySQL Training

by gsguma

HTML

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
<!doctype html>
<html lang="en">
  <header>
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <link href="bootstrap.min.css" rel="stylesheet" integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
  </header>

  <body>
    <div class="container-fluid">
      <h2>Treinamento Básico de Banco de Dados Relacional (MySQL)</h2>
      <br />

      <div class="alert alert-warning" role="alert">
        <i>
          *Copie e cole as consultas abaixo no editor online "<a href="https://www.w3schools.com/mysql/trymysql.asp?filename=trysql_editor">W3Schools: MySQL Tryit Editor</a>" para enternder melhor os comandos SQL.
        </i>
      </div>

      <br />

      <h3>
        Criação de banco de dados
        <a href="https://dev.mysql.com/doc/refman/8.0/en/creating-database.html">more info...</a>
      </h3>
      <div class="card">
        <div class="card-body">
          <h6 class="card-title">Sintaxe de criação e seleção do bando de dados:</h6>
          <p class="card-text">
            <pre>
            CREATE DATABASE new_database;
            USE new_database;</pre>
          </p>
        </div>
      </div>

      <br />
      <br />
      <h3>
        Criação de tabelas
        <a href="https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html">more info...</a>
      </h3>

      <div class="card">
        <div class="card-body">
          <h6 class="card-title">Como visualizar a sintaxe de criação de uma tabela já criada:</h6>
          <p class="card-text">
            <pre>
            SHOW CREATE TABLE Customers;</pre>
          </p>

          <h6 class="card-title">Exemplo 1:</h6>
          <p class="card-text">
            <pre>
            CREATE TABLE `Customers` (
              `CustomerID` int(11) NOT NULL AUTO_INCREMENT,
              `CustomerName` varchar(255)...

CSS

body {
   margin: 30px;
   background-color: #dbdbdb;
 }

 h3 > a {
   font-size: 60%;
   font-style: italic;
   margin-left: 5px;
 }

 pre {
   background-color: #f1efef;
   border: 1px solid #999;
   margin: 0;
   padding: 5px;
   border-radius: 0.375rem;
   ;
 }

 .card {
   background-color: #9cbcc373;
 }