A beginner’s guide to SQL and databases

1
49

In this course, Mike Dane will teach you database management basics and SQL.

The course starts off with Mike helping you install MySQL on Windows or Mac. Then he explores topics like schema design, Create-Read-Update-Delete operations (CRUD), and other database fundamentals.

If you’ve never studied databases or SQL before, this is a great starting point. It will cover:

  • What a database is
  • Tables and Keys
  • SQL Basics
  • MySQL Windows/Mac Installation
  • Creating Tables
  • Inserting Data
  • Constraints
  • Update & Delete
  • Basic Queries
  • Company Database Intro
  • Creating Company Database
  • More Basic Queries
  • Functions
  • Wildcards
  • Unions
  • Joins
  • Nested Queries
  • On Delete
  • Triggers
  • ER Diagrams

1 KOMMENTAR

Gör din röst hörd

Skriv din kommentar
Skriv ditt namn här