
Fueling your journey to inspire, overcome, and motivate towards a brighter future. Join us today
Log In
Sign Up
Don’t have an account yet? Sign Up
Already have an account? Sign In
By signing up, I accept IOMH (Terms & Conditions)
Want to master SQL for data science? Learn SQL for Data Science Data Analytics and Data Visualisation skills & advanced techniques here!
Enrolled Students: 36
Join our SQL for Data Science, Data Analytics and Data Visualisation course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The SQL for Data Science, Data Analytics and Data Visualisation course has everything you need to get a great start in this sector.
Improving and moving forward is key to getting ahead personally. The SQL for Data Science, Data Analytics and Data Visualisation course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now!
This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this SQL for Data Science, Data Analytics and Data Visualisation. Enrol today and complete the course to achieve a certificate that can change your career forever.
After studying the SQL for Data Science, Data Analytics and Data Visualisation course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate.
Upon successfully completing the final assessment, you’ll unlock a CPD-accredited Certificate of Achievement—a valuable credential that demonstrates your commitment to professional development. The PDF Certificate is priced at £8.99 and will be emailed to you immediately. Also, A printed Hard copy Certificate can be purchased for £15.99 and will be sent to your address by post.
This SQL for Data Science, Data Analytics and Data Visualisation is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.
On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.
This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education.
You don’t need any educational qualifications or experience to enrol in the SQL for Data Science, Data Analytics and Data Visualisation course.
Do note: You must be at least 16 years old to enrol.
Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course.
The certification and skills you get from this SQL for Data Science, Data Analytics and Data Visualisation Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.
1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website.
2. Click on Take This Course button, and you will be directed to the Cart page.
3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details.
4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal.
After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn’t receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase.
You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK.
For International Delivery, it will take 20-25 days.
If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly.
You can make the payment using PayPal or you can Bank Transfer the amount.
For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice.
After that, you will receive an email with the invoice and bank details and you can make the payment accordingly.
We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device.
To resolve this issue, please log out of your account and then log back in.
| Section 01: Getting Started | |||
| Introduction | 00:03:00 | ||
| How to get course requirements | 00:03:00 | ||
| Getting started on Windows, Linux or Docker | 00:01:00 | ||
| How to ask great questions | 00:01:00 | ||
| FAQ’s | 00:01:00 | ||
| Section 02: SQL Server Setting Up | |||
| Section Introduction | 00:02:00 | ||
| Microsoft SQL Server Installation | 00:19:00 | ||
| SQL Server Management Studio (SSMS) Installation | 00:08:00 | ||
| How to connect MS SQL (Windows Authentication) | 00:04:00 | ||
| Download and Restore Sample Database | 00:07:00 | ||
| Section 03: SQL Azure Data Studio | |||
| What is Azure Data Studio | 00:06:00 | ||
| Azure Data Studio Installation steps | 00:07:00 | ||
| Azure Data Studio to Connect SQL Server | 00:09:00 | ||
| Create a Database | 00:07:00 | ||
| Create a Table | 00:09:00 | ||
| Insert Data rows | 00:07:00 | ||
| View the Data returned by Query | 00:03:00 | ||
| Section 04: SQL Database Basic SSMS | |||
| Section Introduction | 00:01:00 | ||
| Overview of Databases | 00:11:00 | ||
| Creating Database | 00:05:00 | ||
| SQL Data Types | 00:03:00 | ||
| Column Data Types on SSMS | 00:04:00 | ||
| Creating Table | 00:09:00 | ||
| Overview of Primary Key and Foreign Key | 00:04:00 | ||
| Primary Key | 00:04:00 | ||
| Foreign Key | 00:07:00 | ||
| Creating Temporary tables | 00:06:00 | ||
| Section 05: SQL Statements For DATA | |||
| Section Introduction | 00:01:00 | ||
| Insert statement | 00:08:00 | ||
| Update statement | 00:05:00 | ||
| Delete statement | 00:03:00 | ||
| Section 06: SQL Data Structure Statements | |||
| Section Introduction | 00:01:00 | ||
| CREATE table statement | 00:03:00 | ||
| DROP statement | 00:02:00 | ||
| ALTER statement | 00:05:00 | ||
| TRUNCATE statement | 00:04:00 | ||
| COMMENT in query | 00:01:00 | ||
| RENAME | 00:02:00 | ||
| Section 07: SQL User Management | |||
| Create Database user | 00:04:00 | ||
| GRANT permissions | 00:06:00 | ||
| REVOKE permissions | 00:04:00 | ||
| Section 08: SQL Statement Basic | |||
| Section Introduction | 00:01:00 | ||
| SQL Statement basic | 00:03:00 | ||
| SELECT Statement | 00:07:00 | ||
| SELECT DISTINCT | 00:03:00 | ||
| SELECT with column headings | 00:03:00 | ||
| Column AS statement | 00:02:00 | ||
| Section 09: Filtering Data Rows | |||
| SELECT WHERE Clause – theory | 00:04:00 | ||
| SELECT WHERE Clause – practical | 00:07:00 | ||
| Section 10: Aggregate Functions | |||
| Sum() | 00:08:00 | ||
| Min()-Max() | 00:07:00 | ||
| Section 11: SQL Query Statements | |||
| Order By statement | 00:05:00 | ||
| SELECT TOP clause in SQL | 00:04:00 | ||
| BETWEEN command | 00:08:00 | ||
| IN operator | 00:04:00 | ||
| Wildcard Characters and LIKE | 00:05:00 | ||
| Section 12: SQL Group By Statement | |||
| Section Introduction | 00:01:00 | ||
| Group by – theory | 00:03:00 | ||
| Group by – practical | 00:05:00 | ||
| HAVING statement | 00:04:00 | ||
| Section 13: JOINS For Multiple Table Data Analysis | |||
| Overview of Joins | 00:02:00 | ||
| What are Joins | 00:02:00 | ||
| Inner join | 00:08:00 | ||
| Left outer join | 00:03:00 | ||
| Right outer join | 00:02:00 | ||
| Full outer join | 00:01:00 | ||
| Union | 00:03:00 | ||
| Cartesian Product with the Cross Join | 00:03:00 | ||
| Query Exercise | 00:01:00 | ||
| Solution for Query Exercise | 00:01:00 | ||
| Section 14: SQL Constraints | |||
| Section introduction | 00:01:00 | ||
| Check constraint | 00:07:00 | ||
| NOT NULL constraint | 00:08:00 | ||
| UNIQUE constraint | 00:05:00 | ||
| Section 15: Views | |||
| Creating Views | 00:04:00 | ||
| Reporting with multiple tables | 00:03:00 | ||
| Section 16: Advanced SQL Commands | |||
| Section Introduction | 00:01:00 | ||
| Timestamp | 00:04:00 | ||
| Extract from timestamp | 00:03:00 | ||
| Mathematical scalar functions | 00:04:00 | ||
| String functions | 00:05:00 | ||
| Sub Query | 00:03:00 | ||
| SELECT with calculations | 00:00:00 | ||
| Section 17: SQL Stored Procedures | |||
| Create stored procedure | 00:05:00 | ||
| Stored procedure with parameter | 00:04:00 | ||
| Section 18: Azure Data Studio Visualization | |||
| Installing SandDance Extension | 00:03:00 | ||
| Visualization Charts | 00:05:00 | ||
| Multiple Table Data Charts | 00:06:00 | ||
| Section 19: Azure Studio SQL For Data Analysis | |||
| Type Decision for Data Analysis | 00:13:00 | ||
| Data Analysis with Case Statement and String Text | 00:09:00 | ||
| Section 20: Import & Export Data | |||
| Section Introduction | 00:01:00 | ||
| Import Flat File | 00:05:00 | ||
| Import .csv or excel file | 00:03:00 | ||
| Export Data to Excel or any format | 00:06:00 | ||
| Section 21: Backup And Restore Database | |||
| Section Introduction | 00:01:00 | ||
| Creating Database backup | 00:04:00 | ||
| Restoring Database backup | 00:04:00 | ||
Save Up To 95% -
This course includes:
4.7 (8 reviews)
365 days
27 Students
4.7 (8 reviews)
365 days
28 Students
COPYRIGHT © 2021 Institute of Mental Health