Learn SQL / MySQL for FREE. Database basics
Free tutorial
Rating: 4.4 out of 54.4 (615 ratings)
13,769 students
1hr 48min of on-demand video
Created by Academia Programatorilor
English
English [Auto]
Current priceFree
What you’ll learn
- You will learn how to query a database in SQL
- You will have detailed knowledge and understanding of using MySQL, one of the most used databases in the world.
- You will program SQL to solve a variety of database problems, with applicability in IT industry projects
- You will gain knowledge of SQL and MySQL, which will allow you to apply for jobs in the IT sector.
Requirements
- A PC or laptop with Windows or MAC operating system
- No prior knowledge of databases, SQL or MySQL is required.
Description
Hello,
Getting here means you want to learn database programming. You’ve come to the right place!
Why programming?
Because you earn well, the employment rate in the field is almost 100%, or maybe just for fun.
We want to help you build a real experience in the field, not just learn a programming language.
When you are just starting out in IT and want to get a job, the most important thing is to prove to your employer that you are capable of producing for him.
If you bring added value to the employer, everything is fine, and our complete beginner course can help you do just that. You will learn how to read and write complex queries in a database using one of the most sought after skills. – MySQL.
Learning SQL is one of the fastest ways to improve your career prospects, as it is one of the most sought-after technological skills! In this course you will learn quickly and you will receive challenges along the way to improve your understanding!
In this course you will learn the basics of SQL without the need for prior knowledge of databases.
You will learn the basics of SQL syntax.
You will learn what databases are, tables, and how to use them.
You will learn how to create databases and tables.
You will learn to modify existing tables.
You will learn to enter data in tables.
You will learn to read data from tables.
You will learn to modify existing data in tables.
You will learn how to delete data from tables.
Upon completion of this course, you will have the skills to be able to use SQL with confidence, to have a solid understanding of MySQL and to be skilled in designing databases.
Success!
Who this course is for:
- This course is for people who want to learn SQL , and study databases
Show less
Course content
10 sections • 24 lectures • 1h 49m total lengthCollapse all sections
Course Presentation3 lectures • 6min
- What is SQL?02:58
- What is a database?02:00
- What is a table?01:04
Installing the necessary software1 lecture • 3min
- Installing MySql Server & MySql Workbench02:50
Data types1 lecture • 4min
- What data types can we work with?03:30
How to create and alter a database6 lectures • 32min
- CREATE DATABASE & CREATE TABLE – theory10:21
- CREATE DATABASE & CREATE TABLE – practice06:05
- ALTER TABLE – modify a table structure – theory05:55
- ALTER TABLE – modify a table structure – practice08:53
- Unique identifiers00:12
- AUTO_INCREMENT00:11
Inserting data2 lectures • 15min
- INSERT : inserting data in our tables – theory06:39
- INSERT : inserting data in our tables – practice08:41
Reading data2 lectures • 10min
- SELECT- reading data from our tables – theory03:03
- SELECT- reading data from our tables – practice07:12
Filtering data3 lectures • 12min
- WHERE – theory03:48
- WHERE – practice08:16
- Feedback00:06
Modifying data3 lectures • 14min
- UPDATE- updating data in our tables – theory05:00
- Settings00:14
- UPDATE- updating data in our tables – practice08:47
Deleting data2 lectures • 13min
- DELETE – deleting our table data – theory05:35
- DELETE – deleting our table data – practice07:10
What’s next?1 lecture • 1min
- What’s next00:39