Informática y software
Otros
SQL
Introduction to SQL and MySQL
4,3 (623 valoraciones)
Las valoraciones de los cursos se calculan a partir de las valoraciones individuales de los estudiantes y de muchos otros factores, como la antigüedad de la valoración y la fiabilidad, para asegurar que reflejen la calidad del curso de manera justa y precisa.
10.274 estudiantes inscritos

Introduction to SQL and MySQL

Learn the basics of the most popular programming language designed for managing data
4,3 (623 valoraciones)
Las valoraciones de los cursos se calculan a partir de las valoraciones individuales de los estudiantes y de muchos otros factores, como la antigüedad de la valoración y la fiabilidad, para asegurar que reflejen la calidad del curso de manera justa y precisa.
10.274 estudiantes inscritos
Creado por Holczer Balazs
Fecha de la última actualización: 4/2019
Inglés
Inglés [automático]
Vista previa de este curso
Introduction to SQL and MySQL
Precio actual: 13,99 € Precio original: 19,99 € Descuento: 30 % de descuento
¡Esta oferta termina en 5 horas!
Comprar ahora
Garantía de reembolso de 30 días
Este curso incluye
  • 3,5 horas de vídeo bajo demanda
  • 8 artículos
  • 7 recursos descargables
  • Acceso de por vida completo
  • Acceso en dispositivos móviles y TV
  • Certificado de finalización
Training 5 or more people?

Dale a tu equipo acceso a más de 4.000 de los mejores cursos de Udemy en cualquier momento y lugar.

Prueba Udemy for Business
Lo que aprenderás
  • Understand the basic concepts of databases
  • Get a good grasp of SQL queries
Requisitos
  • We will perform the queries with the help of an online platform, so no previous software installations are required
Descripción

Learn the basic concepts and functions that you will need to make queries with the most popular data manipulating programming language, SQL. This course is about SQL commands in the main. You will learn the basics of queries. This is a fundamental part of databases so it is definitly worth learning.

Section 1:

  • setting up the environment

  • installing MySQL

  • relational databases theory

Section 2:

  • SQL and MySQL basics

  • creating databases and database tables

  • updating tables

  • dropping tables

Section 3:

  • basic SQL and MySQL commands

  • select, where and wildcards

  • ORDER BY and GROUP BY commands

Section 4:

  • joining multiple database tables

Section 5:

  • advanced SQL and MySQL

  • subqueries

  • transactions (ACID principles)

  • views

  • indexes and constraints

Learning the fundamentals of SQL is a good choice and puts a powerful tool at your fingertips. SQL is easy to learn as well as it has excellent documentations.

The most important fact about SQL that it is used in almost every speciality from software engineering to financial analysis, so understanding the concepts and basic language features can prove to be very marketable.

Thanks for joining the course, let's get started!

¿Para quién es este curso?
  • This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge
Contenido del curso
Ampliar todo 70 clases 03:40:36
+ – Table Manipulation
8 clases 29:37
Data types
Vista previa 05:43
Creating a table
Vista previa 07:45
Inserting into a table
Vista previa 03:05
Delete row from a table
04:52
Updating a row
02:46
Changing table structure
03:14
Drop tables
02:09
Chapter summary & source code
00:03
+ – Basic SQL
14 clases 43:10
SQL dump - the city and country tables
03:30
SELECT
02:41
WHERE
02:28
IN
02:12
BETWEEN
03:28
NOT - negation in SQL
02:07
Logical operators
04:03
Wildcards
03:27
Functions
05:51
ORDER BY
04:40
GROUP BY example I
03:05
GROUP BY example II
02:33
HAVING
03:02
Chapter summary & source code
00:03
+ – Joining Multiple Tables
14 clases 37:57
Configuring the database tables - PERSON and UNIVERSITY
02:55
Inner join introduction
04:46
Inner join example
03:55
Left join introduction
03:05
Left join example
02:15
Right join introduction
01:36
Right join example
01:28
JOIN example - number of cities
05:12
JOIN example - total population by continent
03:23
Online SQL console
01:03
JOIN example - customers and orders
02:53
JOIN example - number of orders by customers
03:18
JOIN example - number of orders by country
02:05
Chapter summary & source code
00:03
+ – Advanced SQL - Subqueries
7 clases 19:15
Subqueries introduction
06:36
Non-correlated scalar subquery
02:05
Non-correlated multiple-row subquery
02:45
Correlated subquery
02:50
Subqueries and joins
01:52
Transforming subquery into join
03:04
Chapter summary & source code
00:03
+ – Advanced SQL - Transactions
7 clases 29:14
Transactions introduction - locking
09:25
Transactions introduction - transactions
03:37
ACID principles
03:39
Transaction example - COMMIT
04:28
Transaction example - ROLLBACK
02:32
Transaction example - SAVEPOINT
05:30
Chapter summary & source code
00:03
+ – Advanced SQL - Views
6 clases 14:28
Views introduction
04:54
Views example - initialize database
01:38
Views example - create views
03:57
Views example - update views
02:59
Views example - dropping views
00:57
Chapter summary & source code
00:03
+ – Advanced SQL - Indexes And Constraints
5 clases 18:35
Indexes introduction
06:32
Indexes example
04:37
Constraints introduction
01:23
Primary keys
03:08
Unique constraints
02:55