MySQL: A beginner's guide to MySQL

MySQL: A beginner's guide to MySQL, available at $54.99, has an average rating of 4.55, with 42 lectures, based on 12 reviews, and has 107 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful for 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.

Enroll now: MySQL: A beginner's guide to MySQL

Summary

Title: MySQL: A beginner's guide to MySQL

Price: $54.99

Average Rating: 4.55

Number of Lectures: 42

Number of Published Lectures: 42

Number of Curriculum Items: 42

Number of Published Curriculum Objects: 42

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

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!

Course Curriculum

Chapter 1: Database Basics

Lecture 1: What is a Database

Lecture 2: Rows and Database Keys

Lecture 3: Installing your Database System

Chapter 2: The Structured Query Language

Lecture 1: What is SQL?

Lecture 2: Using the SQL Command Line

Lecture 3: SQL Data Types

Lecture 4: How to Create a Table

Lecture 5: CRUD – Part 1a

Lecture 6: CRUD – Part 1b

Lecture 7: CRUD – Part 2

Chapter 3: Database Relationships

Lecture 1: Relationships

Lecture 2: Normalization – Part 1

Lecture 3: Normalization – Part 2

Lecture 4: One to Many Relationship

Lecture 5: One to One Relationship

Lecture 6: Many to Many Relationship

Lecture 7: Database Tools

Lecture 8: Database Joins – Part 1

Lecture 9: Database Joins – Part 2

Lecture 10: Database Joins – Part 3

Chapter 4: Advanced Queries

Lecture 1: Grouping – Part 1

Lecture 2: Grouping – Part 2

Lecture 3: Aggregate Functions

Lecture 4: Having Keyword – Part 1

Lecture 5: Having Keyword – Part 2

Lecture 6: Ordering

Lecture 7: Select Into – Part 1

Lecture 8: Select Into – Part 2

Lecture 9: Alter Tables

Lecture 10: Views

Lecture 11: Subqueries – Part 1

Lecture 12: Subqueries – Part 2

Chapter 5: Bonus Videos

Lecture 1: Indexes – Part 1

Lecture 2: Indexes – Part 3

Lecture 3: Indexes – Part 2

Lecture 4: Backups – Part 1

Lecture 5: Backups – Part 2

Lecture 6: Stored Procedures and Functions – Part 1

Lecture 7: Stored Procedures and Functions – Part 2

Lecture 8: Stored Procedures and Functions – Part 3

Lecture 9: Stored Procedures and Functions – Part 4

Lecture 10: How to Read MySQL Documentation

Instructors

Trevor Page
Senior Software Engineer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 4 votes
5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu