Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MySQL Database Bootcamp: Go from SQL Beginner to Expert
Rating: 4.1 out of 5(28 ratings)
84 students

MySQL Database Bootcamp: Go from SQL Beginner to Expert

Master yourself in SQL, do practical projects with MySQL.
Created byNiharika Jain, Lavnya upadhyay
Last updated 5/2019
English

What you'll learn

  • Create your own database or insert values in existing databases
  • Write Advance SQL queries
  • Become a proficient MySQL Workbench user(Create, import, export and query databases)
  • Handle complex SQL joins(inner,Outer,Cross & Self)
  • Student will be able to Create & modify tables with setting constraints to columns.
  • Learn some of the most useful built-in functions in SQL.

Course content

10 sections • 30 lectures • 2h 52m total length

  • Introduction to Course4:29
  • Introduction to Database2:56
  • Installation/Environment Setup on Windows Machine5:08

    You can download MySql installer from this link :

    https://dev.mysql.com/downloads/installer/

  • Installation/Environment Setup on Mac Machine5:04

    Download mysql server from below link:

    https://dev.mysql.com/downloads/mysql/

    Download mysql workbench from below link:

    https://dev.mysql.com/downloads/workbench/

  • Import/Restore Existing Database in MySQL Workbench1:50

    In our complete course we are using eshop database and for assignments we are using assignment database.

Requirements

  • No prior SQL or technical experience is required.
  • No software License is required. We will install MySQL and workbench which is freely available on site.
  • A Windows or Mac machine where we will install the database and practice our queries
  • Basic computer knowledge is required to learn from this course.

Description

This course will help you in reading and writing complex SQL queries using one of the most demanding database in industry which is mysql. These skills are also applicable to any other major SQL database like Microsoft SQL Server,Oracle, and much more.

This course is designed for Students as well Software professionals who are willing to learn, understand the technique to create  databases, tables or how  to query that database.This course includes Creating database, different ways to insert values in the database as well as selecting queries and different types of joins.

Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

If you are already a SQL programmer and looking for a reference course then this course is not for you.

Who this course is for:

  • Any student who is interested in learning SQL queries and Database technologies
  • Anyone interested in getting a job in Database
  • Product owners, people in marketing roles who are interested in understanding company or product data better.

Report abuse