Beginner Notes - Page 9

SQL Data Types Explained

Numeric, string, date and boolean types across the major dialects, and how to pick the type that stops bad data at the door.

HTML

HTML Comments: Notes That Ship With Your Code

Comments explain markup to the next developer, but they are downloaded by every visitor and readable by anyone. Learn the syntax, the nesting trap and...

SQL

SQL Syntax, Keywords, Identifiers and Comments

How a SQL statement is built: clause order, keywords versus identifiers, quoting rules, statement terminators and the two comment styles.

HTML

Elements, Tags and Attributes: The Vocabulary of HTML

Tag, element and attribute are three different things, and interviews test the difference constantly. Learn the anatomy, the void elements, boolean at...

SQL

The Relational Model: Tables, Rows, Columns and Schemas

Tables hold typed columns and unordered rows, schemas hold tables, and every value obeys the type its column declares.

HTML

HTML Document Structure: DOCTYPE, html, head and body

Every page is built from the same four parts. Learn what the doctype actually does, why html carries the lang attribute, and the rule that decides whe...

SQL

What is SQL: Databases, DBMS and RDBMS

SQL is the declarative language used to define and query relational data. Start here to see what a database, a DBMS and an RDBMS actually are.

HTML

What is HTML: The Structure Layer of Every Web Page

HTML is a markup language, not a programming language. It labels content so that browsers, search engines and assistive technology all agree on what e...