Exclusive Deal! 94% Off, Today Only!
Buy 1 or more contact sale
Mastering SQL Programming provides an excellent opportunity to gain the skills and knowledge you’ll need to advance in your career. Take this course anywhere and at any time. Don’t let your lifestyle limit your learning or your potential.
Mastering SQL Programming will provide you with the right CPD Accredited qualifications that you’ll need to succeed.Gain experience online and interact with experts. This can prove to be the perfect way to get notice by a prospective employer and stand out from the crowd.
Mastering SQL Programming has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to.
The only thing you need to take Mastering SQL Programming is Wi-Fi and a screen. You’ll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes..
Upon passing the course, you will receive proper certification that is accredited by CPD and universally accepted. You can order your certificate at a cost of £10 for PDF and £29 for hardcopy certificate or both for £39.
The Mastering SQL Programming has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Mastering SQL Programming.
Enrol on the Mastering SQL Programming and learn a new professional skill from anywhere, at any time!
Enrol on the Mastering SQL Programming with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Mastering SQL Programming without any delay.
We only ask that all students have a passion for learning and literacy, and be over the age of 16.
Complete the Mastering SQL Programming online from your computer, tablet, or smartphone, and learn in a way that suits you.
Course Introduction | |||
Introduction | 00:04:00 | ||
Course Curriculum Overview | 00:05:00 | ||
Overview of Databases | 00:10:00 | ||
SQL Environment Setup | |||
MySQL Installation | 00:16:00 | ||
MySQL Workbench Installation | 00:09:00 | ||
Connecting to MySQL using Console | 00:09:00 | ||
SQL Statement Basics | |||
Overview of Challenges | 00:04:00 | ||
SQL Statement Basic | 00:16:00 | ||
SELECT Statement | 00:09:00 | ||
SELECT DISTINCT | 00:05:00 | ||
Column AS Statement | 00:12:00 | ||
COUNT built-in Method usage | 00:11:00 | ||
SELECT WHERE Clause – Part One | 00:05:00 | ||
SELECT WHERE Clause – Part Two | 00:11:00 | ||
SQL Statement Basic | 00:16:00 | ||
SQL Limit Clause Statement | 00:09:00 | ||
SQL Using BETWEEN with Same Column Data | 00:11:00 | ||
How to Apply IN Operator | 00:11:00 | ||
Wildcard Characters with LIKE and ILIKE | 00:11:00 | ||
GROUP BY Statements | |||
Overview of GROUP BY | 00:06:00 | ||
Aggregation function SUM() | 00:09:00 | ||
Aggregation MIN() and MAX() | 00:05:00 | ||
GROUP BY – One | 00:09:00 | ||
GROUP BY – Two | 00:12:00 | ||
HAVING Clause | 00:05:00 | ||
JOINS | |||
Overview of JOINS | 00:04:00 | ||
Introduction to JOINS | 00:04:00 | ||
AS Statement table | 00:03:00 | ||
INNER Joins | 00:14:00 | ||
FULL Outer Join | 00:11:00 | ||
LEFT Outer JOIN | 00:08:00 | ||
RIGHT JOIN | 00:08:00 | ||
Union | 00:07:00 | ||
Advanced SQL Commands / Statements | |||
Timestamps | 00:12:00 | ||
EXTRACT from timestamp | 00:10:00 | ||
Mathematical Functions | 00:12:00 | ||
String Functions | 00:22:00 | ||
SUBQUERY | 00:13:00 | ||
Creating Database and Tables | |||
Basic of Database and Tables | 00:06:00 | ||
DataTypes | 00:10:00 | ||
Primarykey and Foreignkey | 00:06:00 | ||
Create Table in SQL Script | 00:13:00 | ||
Insert | 00:11:00 | ||
Update | 00:07:00 | ||
Delete | 00:04:00 | ||
Alter Table | 00:09:00 | ||
Drop Table | 00:05:00 | ||
NOT NULL Constraint | 00:08:00 | ||
UNIQUE Constraint | 00:09:00 | ||
Databases and Tables | |||
Creating a Database backup | 00:12:00 | ||
10a Overview of Databases and Tables | 00:05:00 | ||
10c Restoring a Database | 00:07:00 | ||
Certificate | |||
Order Your Certificate | 00:00:00 |