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?
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 !
Before you begin your journey with the 12 essential MySQL topics, there are a few things you should know.
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.
Use this course only if you are a Windows user.
Use this course only if you are a Windows user or you have installed MySQL on your Windows PC or laptop.
Use this course only if you are a Mac user or you have installed MySQL on your Mac computer or laptop.
You will learn what is the main difference between a database and spreadsheet
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.
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.
In this lesson, you will learn what are the most commonly used acronyms among database administrators and what are their correlated meanings.
In this course, you will learn how to create and drop a MySQL database. Also, why you have to be careful with these commands.
In this lesson, you will get an understanding MySQL Terminology that will cover Database, Table, Row, Column, And Field.
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
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.
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.