Complete SQL Guide

Simpliv

Course

Online

£ 150 VAT inc.

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Learn SQL from Scratch. How to download it on your device to how to customize a database. Learn everything from one video.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

There are several exercises on this course. We will do that from time to time. Like how to make a database, how to create functions, how to create view, how to join multiple tables from one database or different databases etc

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

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 4 years

Subjects

  • SQL Database
  • Installation
  • Database training
  • SQL
  • Database
  • Database Management
  • MySQL

Course programme

Initial Steps 4 lectures 17:34 SQL Installation Getting Familier with SQL Database Management Introduction MYSQL workbench vs MYSQL command Line Initial Steps 4 lectures 17:34 SQL Installation Getting Familier with SQL Database Management Introduction MYSQL workbench vs MYSQL command Line SQL Installation SQL Installation SQL Installation SQL Installation Getting Familier with SQL Getting Familier with SQL Getting Familier with SQL Getting Familier with SQL Database Management Introduction Database Management Introduction Database Management Introduction Database Management Introduction MYSQL workbench vs MYSQL command Line MYSQL workbench vs MYSQL command Line MYSQL workbench vs MYSQL command Line MYSQL workbench vs MYSQL command Line Starting with My SQL 14 lectures 01:06:49 Creating and Deleting New Tables Resources INSERT data in SQL Constraints UPDATE & DELETE data from TABLE Fetching Data's using Diff Types of Queries AS operator DISTINCT keyword IN keyword BETWEEN operator First Exercise Sollution of Exercise 1 LIKE operator Exercise 2 with Sollution Starting with My SQL 14 lectures 01:06:49 Creating and Deleting New Tables Resources INSERT data in SQL Constraints UPDATE & DELETE data from TABLE Fetching Data's using Diff Types of Queries AS operator DISTINCT keyword IN keyword BETWEEN operator First Exercise Sollution of Exercise 1 LIKE operator Exercise 2 with Sollution Creating and Deleting New Tables Creating and Deleting New Tables Creating and Deleting New Tables Creating and Deleting New Tables Resources Resources Resources Resources INSERT data in SQL INSERT data in SQL INSERT data in SQL INSERT data in SQL Constraints Constraints Constraints Constraints UPDATE & DELETE data from TABLE UPDATE & DELETE data from TABLE UPDATE & DELETE data from TABLE UPDATE & DELETE data from TABLE Fetching Data's using Diff Types of Queries Fetching Data's using Diff Types of Queries Fetching Data's using Diff Types of Queries Fetching Data's using Diff Types of Queries AS operator AS operator AS operator AS operator DISTINCT keyword DISTINCT keyword DISTINCT keyword DISTINCT keyword IN keyword IN keyword IN keyword IN keyword BETWEEN operator BETWEEN operator BETWEEN operator BETWEEN operator First Exercise First Exercise First Exercise First Exercise Sollution of Exercise 1 Sollution of Exercise 1 Sollution of Exercise 1 Sollution of Exercise 1 LIKE operator LIKE operator LIKE operator LIKE operator Exercise 2 with Sollution Exercise 2 with Sollution Exercise 2 with Sollution Exercise 2 with Sollution Advanced SQL 16 lectures 54:18 Regular Expression or REGEXP operator IS and IS NOT operator INNER JOIN with ALIAS Exercise 3 with Sollution Joining Tables accross Different Databases SELF JOIN Exercise 4 with sollution Implicit JOIN OUTER JOIN OUTER JOIN with multiple Tables Self OUTER JOIN USING keyword NATURAL JOIN CROSS JOIN UNION operator Exercise 5 with sollution Advanced SQL

Additional information

No prerequisites. If you wanna learn any database management language, join this course

See related categories

Complete SQL Guide

£ 150 VAT inc.

The best Other Education courses

See all

See all