Learn SQL(course for beginners)

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.

Company Database Code: https://www.giraffeacademy.com/databa...

Contents

(0:00) Introduction

(2:36) What is a Database?

(23:10) Tables & Keys

(43:31) SQL Basics

(52:26) MySQL Windows Installation

(1:01:59) MySQL Mac Installation

(1:15:49) Creating Tables

(1:31:05) Inserting Data

(1:38:17) Constraints

(1:48:11) Update & Delete

(1:56:11) Basic Queries

(2:08:37) Company Database Intro

(2:14:05) Creating Company Database

(2:30:27 ) More Basic Queries

(2:26:24) Functions

(2:45:13) Wildcards

(2:53:53) Union

(3:01:36) Joins

(3:11:49) Nested Queries

(3:21:52) On Delete

(3:30:05) Triggers

(3:42:12) ER Diagrams Intro

(3:55:53) Designing an ER Diagram

(4:08:34) Converting ER Diagrams to Schemas

Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmI...

Follow Mike on Twitter: https://twitter.com/GiraffeAcademy

The Giraffe Academy website: http://www.giraffeacademy.com/

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org

And subscribe for new videos on technology every day: https://youtube.com/subscription_cent...

freeCodeCamp.org

Buxone Technology September 11, 2018