SQL - MySQL for data manipulation

Focused View

Nico @softcademy

3:01:07

115 View

1. Introduction

1. SQL.mp4

03:05

2. Introduction.html

2. MySQL

1. Installation.mp4

11:04

2. Starting with MySQL.mp4

06:45

3. Create database.mp4

06:53

4. Schema - what we will build together.mp4

02:42

5. Create & describe table.mp4

09:02

6. Create other tables.mp4

09:42

7. Foreign key.mp4

10:15

8. Insert data.mp4

11:04

9. Alter table.mp4

13:00

10. Select from more tables with joins.mp4

04:48

11. Joins overview.mp4

02:55

12. Where clause, order by, & alias.mp4

07:32

13. Aggregate functions.mp4

04:23

14. Limit & offset.mp4

05:33

15. Useful operations.mp4

08:34

16. Working with dates - datediff.mp4

04:32

17. Working with dates - interval.mp4

03:14

18. Subquery & Group by.mp4

08:07

19. Wildcards.mp4

10:47

20. In & not in.mp4

03:22

21. Select from more tables.mp4

09:54

22. Select total.mp4

04:56

23. Delete.mp4

03:00

24. Delete with subquery.mp4

04:55

25. Update.mp4

06:25

26. Drop Delete table.mp4

04:38

Description

Understand SQL - Learn Database Design and Data analysis

What You'll Learn?

Create own database
Use / interact with existing databases
Write complexe SQL queries
Joins multiple tables
Extract information & apply logic to generate different set of data
Organize data
Create, React, Update, & Delete
Clauses & Wildcards
Subqueries & Group by
Working with dates

Who is this for?

Administrators

Database administrators

Data analyzers

What You Need to Know?

No preview knowledge required

More details

Description
In this course, you will be able to learn how to use MySQL to create any database project that you would like to. Also you will be able to interact with existing database, manipulate data, and use the most used queries either to display data (select) or to perform any kind of analysis. The course covers basics and advanced SQL queries such as select / display, update, delete, and so many useful functions. A hotel reservation system is created for the purpose of an example so that you can create your own project after you take this course.
You will learnÂ best MySQL queries such as: (CRUD (Create, Read, Update, Delete), wildcards, subqueries, connecting more tables together, working with dates, and many more operations for data manipulation in any database) that will help you creating big real-world applications.
Key concepts:
SQL (Structured Query Language - in-demand technology)
SQL syntax
Understand SQL Joins
MySQL (one of the most popular and widely used databases)
Use MySQL logical operators and other functions
Database Design & Development
Data Analysis
Differences
Of course CRUD
Subqueries
Displaying data from many tables
Displaying data that do not have to be on your table, but you perform operations to get them as result
Take your time, practice, and get ready for more. Avoid having too much information on too many technologies, they are all very nice and useful things to learn and build great apps.
All the best with learning!
Who this course is for:
Administrators
Database administrators
Data analyzers

User Reviews

Rating

average 0

Total votes0

Focused display

Experienced Web Development Specialist with a demonstrated history of working in the information technology and services industry. Skilled in PHP, Python, Java, MySQL, Android studio, JavaScript, jQuery, and full-stack web development. Strong arts and design professional with a Master of Information Technology focused in Information Technology.From own experiences, we found out that learning from video tutorials is a very effective way of learning. Someone helped us with their video tutorials during our studies, now our video tutorials are made to help - The main reason you will find them at very low price.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.