Photography Course Online
Online Adobe Lightroom Course
Mobile Photography Course Online
Online Outdoor Photography Course
Food Photography Course Online
Online Photography Course for Beginners
Video Production Online Course with Editing
Online Weddeing Photography Course
Adobe Photoshop Certification Course
Video Editing Course Online
Pinterest Marketing & Advertising Course Online
Social Media Marketing Course Online
Online Digital Marketing Course
Creative Writing Certification Online
SEO Certification Course Online
Social Media Viral Marketing Course
Adobe Illustrator Training Course
Online Graphic Design Course
Fashion Design Course Online
Online Interior Design Diploma
Online CAD Designer Training Course
Safeguarding Small Businesses Course Online
Bookkeeping & Accounting
Start a Web Design Business
Leadership and Management Training Course Online
Project Management Training Certification
Bookkeeping & Accounting Course Online
Online Sales Training Course
Online Psychology Training Course
Business Statistics and Analysis Course Online
Nail Technician Course Online
Online Acne Treatments and Beauty Care Training
Brow Lift & Lamination Training
Hair Styling Training For Girls
Acrylic Nail Extension Course
Bridal and Occasional Makeup
Beauty Therapy Certification Course
Makeup & Nail Course Online
Healthy Eating for Physical & Mental Health Online Course
Natural Nutrition: Naturopathy Course
Marketing for Fitness Business
Online Nutrition Certification Course
Online Sports Nutrition Course
Meditation and Mindfullness Course Online
Online Holistic Therapy Course
Online Life Coaching & Counselling Course
Water Colour Painting Level-3
Online Baking Course
Financial Analysis : Finance Reports
Trading & Investment analysis online course
Stock Trading Online Course
Real Estate Agent Certification Course Online
Cryptocurrency Trading Course Online
Online Financial Planning Course
Online Diploma in Economics
Online English Training
IELTS Course Online
Building a TodoMVC Application in Vue, React and Angular
Online Game Development Course
Online Database Development Course
Android App Development Course
No products in the basket.
Twitter profile link
Facebook profile link
SQL is a standard language for storing, manipulating, and retrieving data in databases. SQL is short for Structured Query Language.
My SQL Server is a relational database management system or RDBMS. A DBMS is a program that enables its users to access databases, manipulate data, reports, or representation of data. This module looks at what is data, a database, a table, relationships, and foreign keys.
A video walkthrough to download and install MySQL Server and Workbench.
This video looks at connecting to a database using SQL commands for the MySQL Server and creating your first database.
This video guides you with dropping or removing a database by using an SQL command script.
This video covers quite a few concepts, namely creating tables using SQL scripts, and the fact that we can have multiple commands in one file, and how we can execute them all vs executing them in parts.
In this lesson, we will look at inserting records into our tables. To begin this exercise, we will use a script and we will look at the syntax to insert records into our student table.
In this video, we will look at using the MySQL Workbench interface to insert records into our data tables. The MySQL Workbench allows you to insert records directly without having to write any SQL code.
In this lesson, we will discuss how we go about selecting or viewing records (using SQL statements) in our database tables.
In this video, we will learn how the Workbench generates records and about more advanced queries in terms of custom columns and filters.
In this lesson, we will look at how we can go about updating data that is already in our database with SQL statements.
In this tutorial, we will learn how to remove records from our database.
This video covers how we can go about reverse engineering our newly created database into a database model. This is a graphical representation of our database.
Learn how to forward engineer a data model into a database. This time, instead of writing scripts or going into the user interface and creating the database upfront, we want to take it from the modelling perspective. This is for people who are visual first.
Study relational database design as it relates to relationships, foreign keys and normalization.
In this video, we will learn how to start modifying our databases so we can prepare them to have relationships and foreign keys.
Working with our school database, we will modify the table to support foreign keys. We will be adding more tables to this database using Workbench.
We will be adding data to the new class and enrolment tables. The challenge with the relational database is once we start introducing relationships to the table, as you will learn.
This video covers running queries from multiple tables that are related or Inner Joins.
Understand how Left, Right and Cross-Joins work with this video tutorial.
Learn about the group-by statements available to us in MySQL. Group-bys allow us to eliminate repeating data and select distinct records from a table, as well as to conduct mathematical operations.
In this video, we will look at aggregate functions starting with the average function.
We will look at two scenarios where the number of students per class or course will help us to accomplish the “count” function.
In this scenario, we want to see the highest and lowest grades by course using the “Min” & “Max” functions.
For this scenario, we want to look at the total number of credits that each student is studying using the “Sum” function.
You are faced with a scenario where you want to see only students with a certain number of credits. This tutorial shows you how to sum up conditionally with the “having” clause.
Get accredited certificates
Add skills to your CV
Test your skills
for any questions
Start for free
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.