Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-12-02 13:58:11
30-Day Money-Back Guarantee

This course includes:

  • 10 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development SQL

The SQL and MySQL Master

MySQL database, SQL complete, best practices, Learn now!
Rating: 4.0 out of 54.0 (506 ratings)
25,127 students
Created by Pablo Tilotta, Cursea.me Online
Last updated 7/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • You’ll learn from the basics to the advanced level on DataBases.
  • You’ll acquire deep knowledge from scratch to advanced on the Structured Query Language (SQL).
  • You’ll do practical and real exercises to obtain information from a DataBase.
  • Everything on Stored Procedures to a high level.
  • You’ll learn about about VIEWS in MySQL.
  • You’ll learn how to program EVENTS in the MySQL engine.
  • You’ll learn about one of the most popular free DataBase engine: MySQL.
  • You’ll learn about one of the best client tools for the management of MySQL: HeidiSQL.
  • You’ll have personalized support for your real life, work related, or thesis exercises.
  • You’ll learn about TRIGGERS in MySQL.
  • You’ll learn about TRANSACTIONS in MySQL.

Course content

13 sections • 60 lectures • 10h 12m total length

  • Preview02:32

  • Preview01:42
  • What about Database Engines ?
    01:42
  • TABLE Concepts
    04:47
  • Preview09:16
  • INDEXES Concepts
    12:37

  • What is MySQL
    02:25
  • Installing MySQL on my PC
    04:18
  • Error while installing MySQL - Install XAMPP
    03:39
  • Installing HeidiSQL on my PC
    02:25
  • Connecting to the database server with HeidiSQL
    07:27
  • Preview02:26
  • Creating tables and fields
    48:18
  • Data types in MySQL and indexes
    38:01
  • Download Trained Database
    00:03
  • Importing data from an SQL file
    08:10
  • Additional tools in HeidiSQL
    15:54
  • Exporting data in HeidiSQL
    07:29
  • Query Builder
    04:50

  • The first normal form
    11:10
  • The second normal form
    02:27
  • The third normal form
    04:10
  • Best practice: More tables, less columns
    05:20
  • Best practice: More records, less columns
    12:38
  • Best practices: Using default values
    07:54
  • Best practices: Using status fields
    12:06
  • Best practices: Use indexes for each meaningful field
    13:29
  • Best practices: Summary tables
    16:54

  • Introduction to the database language
    01:42
  • Making queries (SELECT statement)
    05:08
  • WHERE operator
    15:33
  • Combining tables with WHERE
    18:32
  • ORDER BY clause
    06:00
  • Functions: SUM(), COUNT(), MAX(), AVG(), MIN()
    11:26
  • GROUP BY clause
    10:20
  • IN & NOT IN clause
    19:32
  • BETWEEN clause
    02:18
  • LIKE clause
    07:54
  • INNER JOIN clause (combining tables)
    08:49
  • LEFT, RIGHT, and FULL JOIN (combining tables)
    08:13
  • Basic functions in MySQL
    18:16
  • Preview10:30
  • UPDATE Statement
    11:20
  • DELETE Statement
    04:49

  • Only one table exercises
    13:38
  • Joining 2 or more tables
    15:06
  • Looking for strings
    17:14
  • Grouping, and addition joining many tables
    12:54

  • Exporting queries
    03:05
  • Saving SQL queries
    03:14
  • Foreign keys and table relationships
    10:15
  • Users management
    04:51

  • Basic concepts about stored procedures in MySQL
    21:54
  • Error managing
    16:07
  • Cursors and conditionals
    18:15

  • Triggers in MySQL
    19:45

  • Views in MySQL
    18:33

Requirements

  • no requisites

Description

+++++++++++++++++ Why should you buy this course?+++++++++++++++++++++

THIS IS THE ENGLISH VERSION, FOR THE SPANISH SUCCESS COURSE , LEADER IN DATABASES

With 2000 reviews, 4.51 stars, and over 14.000 students.

/curso-completo-de-bases-de-datos-de-0-a-avanzado/


Nowadays, database knowledge is essential for the student or the consolidated professional.
Every software tool, or business system uses databases to store information that is necessary to work, and to store sensible information, such as clients, products, sales, details of sales, suppliers, and many more.

Learning what you need to optimize and normalize your databases is essential. This is a course that should be taken not only by people who already know about databases, but also by any professional who desires to optimize his or her databases to the maximum.

In this course, the student will have access to this 9 sections:
Concepts on databases.
Database normalization.
Advanced normalization and best practices.
MySQL databases.
SQL language (complete)
SELECT statement exercises
Advanced use of MySQL and HeidiSQL.
Stored Procedures
EER diagrams in Workbench.

Who is this course for?
Every student and professional who wants to learn from 0 to advanced about databases.
Every student and professional who wants to learn about MySQL as a database engine.
MySQL users who want to know how to use HeidiSQL.
Anyone who wants to learn about databases with no previous knowledge.
Every student and professional who works with databases, but it’s interested in the SQL language (universal).

Who this course is for:

  • Everyone that want to learn about databases or MySQL

Instructors

Pablo Tilotta
Analista Programador Experto - 31 años de carrera
Pablo Tilotta
  • 4.4 Instructor Rating
  • 5,775 Reviews
  • 101,613 Students
  • 9 Courses

32 años de carrera como Analista Funcional - Analista de Sistemas - Project Leader - Administrador IT. Gerencia y Administración de Área de Sistemas. Consultoría y Management Sr. Implementación de ERP (4 años) en Prestigiosa Cadena de 80 sucursales.

Actualmente trabajando para una de las empresas de Software mas importantes de Argentina. (APER Argentina) como DBA Experto.

Experto Programador en COBOL  / Visual Basic 6.0.

Desde la experiencia en el Análisis de Sistemas, me he destacado en brindar soluciones a sectores complejos como Administración, Marketing, Tesorería, Logística y Distribución, Recursos Humanos con mas de 2000 soluciones y sistemas (no siempre la solución es un sistema o programa) a lo largo de 30 años ininterrumpidos.

Amplia experiencia como Administrador de Bases de Datos.

Metodologías Ágiles (Scrum Master), ISO 9001, Team Foundation Server, SVN, GIT.

Conocimientos en NODEJS, C++, Javascript, Lenguaje GO, y algunos conocimientos de JAVA.

Excelente predisposición, manejo de equipos, proyectos y objetivos. Perfil pragmático y simplificador, volver fácil lo difícil. 

Amplia experiencia en la documentación funcional y técnica de los Sistemas implementados, manual de usuarios.

Cursea.me Online
Profesor
Cursea.me Online
  • 4.0 Instructor Rating
  • 1,008 Reviews
  • 42,774 Students
  • 5 Courses

Computer teacher with more than 15 years of experience. With me you will learn Linux from scratch to be an expert. I have experience as a Debian system administrator and in preparation of students for LPI certifications. Also on local virtual servers and in the cloud using Docker and AWS.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.