The 12 Essential MySQL Topics for Newbies
3.6 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,830 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The 12 Essential MySQL Topics for Newbies to your Wishlist.

Add to Wishlist

The 12 Essential MySQL Topics for Newbies

This course covers the best 12 essential MySQL topics for Newbies!
3.6 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,830 students enrolled
Created by Sia Liolios
Last updated 1/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn MySQL basics from a professional trainer
  • Information packed practical training for people that need to get an understanding of MySQL.
  • Best suitable for beginners level users and who learn faster when demonstrated.
  • Course content designed by considering current the latest release of MySQL and the job market.
  • Practical learning experience with examples.
  • Get personal answers to your questions
  • Free Bonus: MySQL Acronyms- Quick Reference Table & MySQL- Data Types - Quick Reference Table
View Curriculum
Requirements
  • Internet, Windows/MAC
  • Be prepared for an awesome course!
Description

Welcome to "The 12 Essential MySQL Topics for Newbies". MySQL is the world's most popular open source database that powers many different types of applications, from a tiny blog to internet giants like Facebook, Twitter and Wikipedia.

In this course, we'll take a look at some general topics like why databases are better than spreadsheets and then we'll install MySQL on Windows and also on Mac. We'll take a look at creating and dropping a database.

We'll look at MySQL terms and data types that you're likely to come across and, how to interact with MySQL console, this course focuses on working with databases at the command line, and not database server administration.

What else will you get?

  • A friendly, personal answers to you for all questions guarantee
  • Personal contact with me, the course tutor
  • Bonus cheatsheets
  • Lifetime access to course materials

More than 3000 students!

"I really enjoy to learn this course and the content is very relevant for the time I saw the videos. The most important part for me was the normalization. Also Sia is a great teacher!! Thanks a lot!

Raj S. ( 5 stars) "

Now, let's get started !


Who is the target audience?
  • Anyone interested in learning MySQL and Database techonologies
  • Anyone interested in making a career change to Tech industry
  • This course is for people who are new Databases or SQL
  • Project managers that need to have a database knowledge
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
What you will learn in this course
1 Lecture 00:48

In this lesson, I will show you what you will learn in this course

Preview 00:48
+
Before watching this course
2 Lectures 02:34

Before you begin your journey with the 12 essential MySQL topics, there are a few things you should know.

Preview 00:46

For this course you will need access to a running instance of MySQL. that's why it is important to start with the installation of MySQL courses depending of your operating system either Windows or Mac.

Easy ways to play with MySQL
01:48
+
How to Install - Interact With MySQL
4 Lectures 07:58

Use this course only if you are a Windows user.

Installing MySQL on your Windows
01:28

Use this course only if you are a Windows user or you have installed MySQL on your Windows PC or laptop.

Interaction with MySQL console on your Windows
01:28

Use this course only if you are a Mac user.

Preview 02:31

Use this course only if you are a Mac user or you have installed MySQL on your Mac computer or laptop.

Interaction with MySQL console on your MAC
02:31
+
Understand Database basics
5 Lectures 26:31

You will learn what is the main difference between a database and spreadsheet

Databases Vs. Spreadsheets
04:53

There are definitely some similarities between flat files and relational databases. Both can be manipulated to show information in a new form without changing the original data. Both allow you to extract data out of certain fields. In this course, you will learn why relational database is the most efficient way to manage your data.

Relational databases vs. flat files
03:14

There are three main reasons to normalize a database.  The first is to minimize duplicate data, the second is to minimize or avoid data modification issues, and the third is to simplify queries. In this course, you will learn how to normalize your data.

Normalizing databases
07:08

In this lesson, you will learn what are the most commonly used acronyms among database administrators and what are their correlated meanings.

Common database acronyms
05:36

In this course, you will learn how to create and drop a MySQL database. Also, why you have to be careful with these commands.

Preview 05:40

Test your database basic knowledge
4 questions
+
Exploring MySQL Basics
3 Lectures 15:45

In this lesson, you will get an understanding MySQL Terminology that will cover Database, Table, Row, Column, And Field.

Preview 02:38

SQL is a Declarative Language, which is very much a different from a procedural language. You are most likely much more familiar with procedural approaches in computing. This is why in this lesson, we’ll take a closer look at what it means to be a Declarative Language, and how we will need to adjust our thinking to best make use of it

Understanding Declarative Structure Language
03:36

Properly defining the fields in a table is important to the overall optimization of your database. That's why in this lesson, we will show you how to use the different data type in the most efficient way.

Exploring MySQL Data Types
09:31

Test your MySQL basic knowledge
3 questions
+
What you have learned
1 Lecture 00:16
Conclusion
00:16
+
Bonus for you
3 Lectures 00:12
MySQL- Data Types - Quick Reference Table - Free
00:05

MySQL Acronyms- Quick Reference Table - Free
00:04

For Mac user only - Alias
00:03
About the Instructor
Sia Liolios
3.6 Average rating
23 Reviews
2,830 Students
1 Course
TOP PROFESSIONAL CONSULTANT, ONLINE INSTRUCTOR, COACH

TOP professional consultant and trainer who helps build positive corporate cultures since 22 years. Sia offers consulting and training in the areas of IT skills.

Also written articles for a wide variety of industry training compagnies, covering Databases, Microsoft Office, safety, personal development, employee assistance, and more.

I believe this course is the best on the market and if you don't agree, I'll happily refund your money.

Sign up to my courses and join me in this amazing adventure today.