Learn SQL / MySQL database basics FOR FREE

Learn SQL / MySQL database basics FOR FREE, available at Free, has an average rating of 4.33, with 23 lectures, based on 1358 reviews, and has 34136 subscribers.

You will learn about 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. This course is ideal for individuals who are This course is for people who want to learn SQL , and study databases It is particularly useful for This course is for people who want to learn SQL , and study databases.

Enroll now: Learn SQL / MySQL database basics FOR FREE

Summary

Title: Learn SQL / MySQL database basics FOR FREE

Price: Free

Average Rating: 4.33

Number of Lectures: 23

Number of Published Lectures: 23

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Original Price: Free

Quality Status: approved

Status: Live

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

Who Should Attend

This course is for people who want to learn SQL , and study databases

Target Audiences

This course is for people who want to learn SQL , and study databases

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!

Course Curriculum

Chapter 1: Course Presentation

Lecture 1: What is SQL?

Lecture 2: What is a database?

Lecture 3: What is a table?

Chapter 2: Installing the necessary software

Lecture 1: Installing MySql Server & MySql Workbench

Chapter 3: Data types

Lecture 1: What data types can we work with?

Chapter 4: How to create and alter a database

Lecture 1: CREATE DATABASE & CREATE TABLE – theory

Lecture 2: CREATE DATABASE & CREATE TABLE – practice

Lecture 3: ALTER TABLE – modify a table structure – theory

Lecture 4: ALTER TABLE – modify a table structure – practice

Lecture 5: Unique identifiers

Lecture 6: AUTO_INCREMENT

Chapter 5: Inserting data

Lecture 1: INSERT : inserting data in our tables – theory

Lecture 2: INSERT : inserting data in our tables – practice

Chapter 6: Reading data

Lecture 1: SELECT- reading data from our tables – theory

Lecture 2: SELECT- reading data from our tables – practice

Chapter 7: Filtering data

Lecture 1: WHERE – theory

Lecture 2: WHERE – practice

Chapter 8: Modifying data

Lecture 1: UPDATE- updating data in our tables – theory

Lecture 2: Settings

Lecture 3: UPDATE- updating data in our tables – practice

Chapter 9: Deleting data

Lecture 1: DELETE – deleting our table data – theory

Lecture 2: DELETE – deleting our table data – practice

Chapter 10: Become a Software Developer!

Lecture 1: Employment Program + Gift

Instructors

CodePlay Academy
IT School

Rating Distribution

1 stars: 14 votes
2 stars: 33 votes
3 stars: 173 votes
4 stars: 528 votes
5 stars: 610 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