Mysql: A Beginner'S Guide To Mysql

MySQL is a complete beginners guide to learning MySQL in plain English.

What you'll learn
You'll learn how to install a database server on your own computer
You'll learn how to create and manage multiple databases
You'll be able to create, read, update and delete data from your databases
You'll learn how to write advanced queries on your data that can be used in real reports
You will be able to create stored functions and stored procedures
You'll be able to know what kind of database indexes to use depeding on your specific environment
Requirements
You will need to have basic Windows / Mac skills, as installation of software will be required
You will need to install one piece of free software called TOAD for MySQL (We'll show you the exact steps in the course)
Knowledge of programming is a "nice-to-have"
Description
Land Your Dream Programming Job! Learning about Databases and SQL is a skill that not only benefits Database Administrators, but also programmers too. This course is designed to give programmers a "leg-up" on the competition when it comes to landing a great job in the programming field. SQL in Plain English This course is taught by former senior software engineer and teaching expert Trevor Page. His "plain English" teaching style has students around the world jumping for joy as they pick up new and valuable skills with relative ease. You can learn the mysteries of Databases, how to "talk" to them and what a good Database design looks like. It may seem like voodoo, but with Trevor's help you'll be bragging to all your friends about how you created a relational database with a full spread of tables in third normal form. Full Walkthroughs (including how to install tools) Most courses just assume that you will know what tools to use and even how to install them. Not in this course!Trevor not only teaches you the core course material, but he also takes you step by step through the (sometimes) challenging process of installing a database server on your computer and the tools you’ll need to administer your new databases. It’s all laid out for you in beautiful HD video and audio! Security and Automated Backups One aspect of Databases that always scares newcomers to the SQL party is how to make sure your databases are secure and backed up. No worries, you’ll learn exactly how to keep your data secure and backed up (automatically) so you’ll always hit the sack with a smile on your face knowing your data is safe!

Overview

Section 1: Database Basics

Lecture 1 What is a Database

Lecture 2 Rows and Database Keys

Lecture 3 Installing your Database System

Section 2: The Structured Query Language

Lecture 4 What is SQL?

Lecture 5 Using the SQL Command Line

Lecture 6 SQL Data Types

Lecture 7 How to Create a Table

Lecture 8 CRUD - Part 1a

Lecture 9 CRUD - Part 1b

Lecture 10 CRUD - Part 2

Section 3: Database Relationships

Lecture 11 Relationships

Lecture 12 Normalization - Part 1

Lecture 13 Normalization - Part 2

Lecture 14 One to Many Relationship

Lecture 15 One to One Relationship

Lecture 16 Many to Many Relationship

Lecture 17 Database Tools

Lecture 18 Database Joins - Part 1

Lecture 19 Database Joins - Part 2

Lecture 20 Database Joins - Part 3

Section 4: Advanced Queries

Lecture 21 Grouping - Part 1

Lecture 22 Grouping - Part 2

Lecture 23 Aggregate Functions

Lecture 24 Having Keyword - Part 1

Lecture 25 Having Keyword - Part 2

Lecture 26 Ordering

Lecture 27 Select Into - Part 1

Lecture 28 Select Into - Part 2

Lecture 29 Alter Tables

Lecture 30 Views

Lecture 31 Subqueries - Part 1

Lecture 32 Subqueries - Part 2

Section 5: Bonus Videos

Lecture 33 Indexes - Part 1

Lecture 34 Indexes - Part 3

Lecture 35 Indexes - Part 2

Lecture 36 Backups - Part 1

Lecture 37 Backups - Part 2

Lecture 38 Stored Procedures and Functions - Part 1

Lecture 39 Stored Procedures and Functions - Part 2

Lecture 40 Stored Procedures and Functions - Part 3

Lecture 41 Stored Procedures and Functions - Part 4

Lecture 42 How to Read MySQL Documentation

This Databases and SQL course is meant for beginners who have either no prior experience with Databases, or very limited experience. This course isn't meant for those who already have a solid foundation of knowledge in SQL.