MySQL Database Bootcamp: Go from SQL Beginner to Expert

Simpliv

Course

Online

£ 10 VAT inc.

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Mac
  • Import
  • Installation
  • Database training
  • SQL
  • Database
  • Email
  • MySQL
  • Windows

Course programme

Introduction & Environment Setup 4 lectures 16:33 Introduction to Course Installation/Environment Setup on Windows Machine Installation/Environment Setup on Mac Machine Import Database in MySQL Workbench Introduction & Environment Setup 4 lectures 16:33 Introduction to Course Installation/Environment Setup on Windows Machine Installation/Environment Setup on Mac Machine Import Database in MySQL Workbench Introduction to Course Introduction to Course Introduction to Course Introduction to Course Installation/Environment Setup on Windows Machine Installation/Environment Setup on Windows Machine Installation/Environment Setup on Windows Machine Installation/Environment Setup on Windows Machine Installation/Environment Setup on Mac Machine Installation/Environment Setup on Mac Machine Installation/Environment Setup on Mac Machine Installation/Environment Setup on Mac Machine Import Database in MySQL Workbench Import Database in MySQL Workbench Import Database in MySQL Workbench Import Database in MySQL Workbench Setup your Database and Table 2 lectures 15:27 Create Your Data Base and Table Database and Table Creation Quiz Insert value in your DataBase Insertion Quiz Setup your Database and Table 2 lectures 15:27 Create Your Data Base and Table Database and Table Creation Quiz Insert value in your DataBase Insertion Quiz Create Your Data Base and Table Create Your Data Base and Table Create Your Data Base and Table Create Your Data Base and Table Database and Table Creation Quiz Database and Table Creation Quiz Database and Table Creation Quiz Database and Table Creation Quiz Insert value in your DataBase Insert value in your DataBase Insert value in your DataBase Insert value in your DataBase Insertion Quiz Insertion Quiz Insertion Quiz Insertion Quiz Querying the Data 6 lectures 18:16 SELECT - Retrieve data and Filtering Assignment of SELECT - Retrieve data and Filtering Chapter In this Assignment, you will practice SELECT and WHERE Statements which we have learned in the previous chapter.For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Write an SQL Query to fetch all records from Customers Table.
  • Write an SQL Query to fetch only Customer ID, Name, Gender from Customers Table.
  • Write an SQL Query to fetch all the customers whose country is 'United State'.
  • Write an SQL Query to fetch all Indian Name, Email, PhoneNo and DOB.
  • Write an SQL Query to fetch records of all Female Employee.
  • Write an SQL Query to fetch records of all country except China.
  • Write an SQL Query to fetch all customers whose age is greater than 35.
  • Write an SQL Query to fetch customer Id, name and DOB whose DOB is less than 1990-12-31.
  • Write an SQL Query to fetch all customer details whose age is less than and equal to 30.
  • Write an SQL Query to fetch all Customer Name, email and country except whose age is 60.
    • SELECT - Logical Operators Assignment of SELECT - Logical Operators Chapter In this Assignment, you will practice WHERE Statement with Logical operators which we have learned in the previous chapter. For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Get the all males customers detail who are from France.
  • Fetch all Customers detail whose DOB is 8th Feb 1981 or who name is Myrna.
  • Get the Customer Name, Country and Age of customers whose name is Jane and DOB is greater than 31st Dec 1990.
  • Get the name of whose Customer whose Age is less than and equal to 30 or Country is 'United State' or Gender is Male.
  • Fetch only those customers name who are not from South Korea.
  • Fetch all Customer details whose country is Japan and age is greater than 30.
  • Get the Name, Age and Country of male customers whose country is India or United States
  • Fetch all customers whose age is between 40 to 50 and Country is France and China.
    • SELECT - Patterns & Sorting Assignment of SELECT - Patterns & Sorting Chapter Question 1 to Question 5 : Related to 'Pattern and Sorting' chapter Question 6 to Question 8 : Related to all previous chapters. For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Fetch all details of those customers whose Email contain .gov.
  • Fetch all details of those customers whose country start with south.
  • Get all details of those customers whose phone no start and end with any character but 2nd and 4th position contain 1 and 4.
  • List those customers whose name second character is e and name end with ta ordered by country in descending order.
  • Sort the customers country in descending order then by age in ascending order and last sort date of birth in descending order.
  • Select those customers whose email contain .com and country is India or united states.
  • Sort the above query result by country in descending order.
  • Get the list of those customers whose age between 30 to 50 and country last two characters are ia.
    • Querying the Data. 6 lectures 18:16 SELECT - Retrieve data and Filtering Assignment of SELECT - Retrieve data and Filtering Chapter In this Assignment, you will practice SELECT and WHERE Statements which we have learned in the previous chapter.For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Write an SQL Query to fetch all records from Customers Table.
  • Write an SQL Query to fetch only Customer ID, Name, Gender from Customers Table.
  • Write an SQL Query to fetch all the customers whose country is 'United State'.
  • Write an SQL Query to fetch all Indian Name, Email, PhoneNo and DOB.
  • Write an SQL Query to fetch records of all Female Employee.
  • Write an SQL Query to fetch records of all country except China.
  • Write an SQL Query to fetch all customers whose age is greater than 35.
  • Write an SQL Query to fetch customer Id, name and DOB whose DOB is less than 1990-12-31.
  • Write an SQL Query to fetch all customer details whose age is less than and equal to 30.
  • Write an SQL Query to fetch all Customer Name, email and country except whose age is 60.
    • SELECT - Logical Operators Assignment of SELECT - Logical Operators Chapter In this Assignment, you will practice WHERE Statement with Logical operators which we have learned in the previous chapter. For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Get the all males customers detail who are from France.
  • Fetch all Customers detail whose DOB is 8th Feb 1981 or who name is Myrna.
  • Get the Customer Name, Country and Age of customers whose name is Jane and DOB is greater than 31st Dec 1990.
  • Get the name of whose Customer whose Age is less than and equal to 30 or Country is 'United State' or Gender is Male.
  • Fetch only those customers name who are not from South Korea.
  • Fetch all Customer details whose country is Japan and age is greater than 30.
  • Get the Name, Age and Country of male customers whose country is India or United States
  • Fetch all customers whose age is between 40 to 50 and Country is France and China.
    • SELECT - Patterns & Sorting Assignment of SELECT - Patterns & Sorting Chapter Question 1 to Question 5 : Related to 'Pattern and Sorting' chapter Question 6 to Question 8 : Related to all previous chapters. For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Fetch all details of those customers whose Email contain .gov.
  • Fetch all details of those customers whose country start with south.
  • Get all details of those customers whose phone no start and end with any character but 2nd and 4th position contain 1 and 4.
  • List those customers whose name second character is e and name end with ta ordered by country in descending order.
  • Sort the customers country in descending order then by age in ascending order and last sort date of birth in descending order.
  • Select those customers whose email contain .com and country is India or united states.
  • Sort the above query result by country in descending order.
  • Get the list of those customers whose age between 30 to 50 and country last two characters are ia.
    • SELECT - Retrieve data and Filtering SELECT - Retrieve data and Filtering SELECT - Retrieve data and Filtering SELECT - Retrieve data and Filtering Assignment of SELECT - Retrieve data and Filtering Chapter In this Assignment, you will practice SELECT and WHERE Statements which we have learned in the previous chapter.For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Write an SQL Query to fetch all records from Customers Table.
  • Write an SQL Query to fetch only Customer ID, Name, Gender from Customers Table.
  • Write an SQL Query to fetch all the customers whose country is 'United State'.
  • Write an SQL Query to fetch all Indian Name, Email, PhoneNo and DOB.
  • Write an SQL Query to fetch records of all Female Employee.
  • Write an SQL Query to fetch records of all country except China.
  • Write an SQL Query to fetch all customers whose age is greater than 35.
  • Write an SQL Query to fetch customer Id, name and DOB whose DOB is less than 1990-12-31.
  • Write an SQL Query to fetch all customer details whose age is less than and equal to 30.
  • Write an SQL Query to fetch all Customer Name, email and country except whose age is 60.
    • Assignment of SELECT - Retrieve data and Filtering Chapter In this Assignment, you will practice SELECT and WHERE Statements which we have learned in the previous chapter.For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Write an SQL Query to fetch all records from Customers Table.
  • Write an SQL Query to fetch only Customer ID, Name, Gender from Customers Table.
  • Write an SQL Query to fetch all the customers whose country is 'United State'.
  • Write an SQL Query to fetch all Indian Name, Email, PhoneNo and DOB.
  • Write an SQL Query to fetch records of all Female Employee.
  • Write an SQL Query to fetch records of all country except China.
  • Write an SQL Query to fetch all customers whose age is greater than 35.
  • Write an SQL Query to fetch customer Id, name and DOB whose DOB is less than 1990-12-31.
  • Write an SQL Query to fetch all customer details whose age is less than and equal to 30.
  • Write an SQL Query to fetch all Customer Name, email and country except whose age is 60.
    • Assignment of SELECT - Retrieve data and Filtering Chapter In this Assignment, you will practice SELECT and WHERE Statements which we have learned in the previous chapter.For your reference you can Download the attached txt file which have all the answers.Questions for this assignment
  • Write an SQL Query to fetch all records from Customers Table.
  • Write an SQL Query to fetch only Customer ID, Name, Gender from Customers Table.
  • Write an SQL Query to fetch all the customers whose country is 'United State'.
  • Write an SQL Query to fetch all Indian Name, Email, PhoneNo and DOB.
  • Write an SQL Query to fetch records of all Female Employee.
  • Write an SQL Query to fetch records of all country except China.
  • Write an SQL Query to fetch all customers whose age is greater than 35.
  • Write an SQL Query to fetch customer Id, name and DOB whose DOB is less than 1990-12-31.
  • Write an SQL Query to fetch all customer details whose age is less than and equal to 30 SELECT - Patterns & Sorting...

    • Additional information

    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

    See related categories

    MySQL Database Bootcamp: Go from SQL Beginner to Expert

    £ 10 VAT inc.

    The best Other Education courses

    See all

    See all