Booking options
£11.99
Course Images
SQL
- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
3 hours 52 minutes
Intermediate level
Description
Overview
This SQL course will unlock your full potential and will show you how to excel in a career in SQL. So upskill now and reach your full potential. Everything you need to get started in SQL is available in this course.
Learning and progressing are the hallmarks of personal development. This SQL will quickly teach you the must-have skills needed to start in the relevant industry.
In This Mental Health Course, You Will:
Learn strategies to boost your workplace efficiency.
Hone your SQL skills to help you advance your career.
Acquire a comprehensive understanding of various SQL topics and tips from industry experts.
Learn in-demand SQL skills that are in high demand among UK employers, which will help you to kickstart your career.
This SQL course covers everything you must know to stand against the tough competition in the SQL field.
The future is truly yours to seize with this SQL. Enrol today and complete the course to achieve a SQL certificate that can change your professional career forever.
Additional Perks of Buying a Course From Institute of Mental Health
Study online - whenever and wherever you want.
One-to-one support from a dedicated tutor throughout your course.
Certificate immediately upon course completion
100% Money back guarantee
Exclusive discounts on your next course purchase from Institute of Mental Health
Enrolling in the SQL course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.
Process of Evaluation
After studying the SQL course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.
Certificate of Achievement
Upon successfully completing the SQL course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.
Who Is This Course for?
This SQL is suitable for anyone aspiring to start a career in SQL; even if you are new to this and have no prior knowledge on SQL, this course is going to be very easy for you to understand.
And if you are already working in the SQL field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.
Taking this SQL course is a win-win for you in all aspects.
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.
Requirements
This SQL course has no prerequisite.
You don't need any educational qualification or experience to enrol in the SQL 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 SQL course.
Course Curriculum
Unit 01: Course and Instructor Introduction | |||
Course and Instructor Introduction | 00:05:00 | ||
Unit 02: Laying out the foundation - Overview & Installation | |||
Pre-requisites & Different Editions of SQL Server | 00:06:00 | ||
Downloading Express Edition & sample database | 00:03:00 | ||
Installing the downloads & Configuration | 00:19:00 | ||
The sa Login | 00:04:00 | ||
Wrap up - what we went over! | 00:01:00 | ||
Unit 03: Core concepts - Taming the RDBMS beast! | |||
What is RDBMS? | 00:12:00 | ||
Where does SQL Server fit in? | 00:02:00 | ||
Basic database objects | 00:16:00 | ||
Different Files that got installed - MDF & LDF | 00:03:00 | ||
Wrap up - what we went over! | 00:01:00 | ||
Unit 04: Tool of the trade - SQL Server Management Studio | |||
Getting started with SSMS | 00:07:00 | ||
Getting around Object Explorer | 00:05:00 | ||
Query Window | 00:06:00 | ||
Pre-built DB - system database | 00:04:00 | ||
Wrap up - what we went over! | 00:01:00 | ||
Unit 05: Simple SELECT | |||
Bare Minimum: SELECTING a literal | 00:05:00 | ||
Retrieving / querying data from a table - using FROM clause | 00:06:00 | ||
Playing with Column Names | 00:03:00 | ||
Rearranging columns to your liking | 00:01:00 | ||
Wrap up - what we went over! | 00:01:00 | ||
Unit 06: Filtering out unwanted data | |||
Narrowing down and ordering result set - WHERE and ORDER clause | 00:17:00 | ||
Narrowing down result set - BETWEEN / NOT BETWEEN | 00:09:00 | ||
Narrowing down result set - IN and NOT IN operator | 00:05:00 | ||
Narrowing down result set - Pattern Matching: LIKE and Wildcards | 00:11:00 | ||
Wrap up - what we went over! | 00:01:00 | ||
Unit 07: Expressions and Functions | |||
Dealing with nothing: NULL | 00:06:00 | ||
Working with strings: Concatenation and other string functions | 00:15:00 | ||
Working with dates: Date Functions | 00:07:00 | ||
Some System Functions | 00:05:00 | ||
Wrap up - what we went over! | 00:02:00 | ||
Unit 08: Getting data out of multiple tables | |||
Joining multiple tables - INNER JOIN | 00:09:00 | ||
Join types - OUTER JOIN - LEFT / RIGHT / FULL | 00:08:00 | ||
Join types - CROSS JOIN | 00:02:00 | ||
Holy UNION! | 00:03:00 | ||
Subqueries | 00:04:00 | ||
Wrap up - what we went over! | 00:02:00 | ||
Unit 09: Summarizing and Grouping data | |||
DISTINCT and ALL Predicates | 00:02:00 | ||
Aggregate Functions | 00:03:00 | ||
GROUP BY clause / HAVING clause | 00:04:00 | ||
WHERE and ORDER BY in aggregate queries | 00:04:00 | ||
Wrap up - what we went over! | 00:01:00 | ||
Unit 10: Bonus | |||
Bonus_Section | 00:01:00 |
