Overview
Are you looking to enhance your SQL development proficiency to help boost your career prospects? Building a satisfying career can be a lifelong process but if you want to gain a competitive edge in your job search, look no further!
With this SQL for Data Analytics course, you will build the solid foundation you need to kickstart a successful career in the SQL development industry.
The course covers the essential things you need to know to boost your career within the SQL development. It provides you with the ability to improve your earning potential.
Covering everything you need to know to boost your career within SQL development, this industry recognised certification includes 85 comprehensive bite-sized modules that you can learn in your own time, pace and environment. Complete your course and earn your qualification in just 5 hours 55 minutes with dedicated online support you can trust and rely on.
Why Learn With Queen Mary Academy?
- 50,000+ students worldwide
- Start a new career or advance your current one & land your dream job
- Most in-demand skills for today’s job market
- Award-winning Customer Support
- Partnered with biggest accreditors in the world
Benefits You Will Gain
- No hidden fees.
- 24/7 access to the Learning Portal.
- Receive the UK and globally recognised certificate on completion of the course.
- Qualified tutor support and exceptional customer service.
- Access the Learning Portal whenever you want
- Learn from industry-leading experts.
Who is this course for?
Whether you are looking to enhance your employment prospects, boost your CV with essential skills or climb the career ladder to a higher position, this SQL for Data Analytics course will work as an initial step towards earning an internationally-recognised qualification that could prove invaluable for your career.
This SQL for Data Analytics course has been designed for learners who are looking to gain the skills and credentials to fast track a fulfilling career in SQL development.
Entry Requirement
The SQL for Data Analytics course is for learners of all levels, with no specific enrolment requirements; all you need is the commitment to learn, knowledge of the English language, and basic numeracy and IT skills. Students must be over the age of 16.
Certification
Once you have successfully completed the SQL for Data Analytics course, you will receive an accredited certificate from Queen Mary Academy as validation of your new skills. Certification is available in PDF format, at the cost of £12, or a hard copy can be sent via post at the cost of £27.
Career path
On successful completion of the SQL for Data Analytics course, learners will have the knowledge, skills and credentials to enter the relevant job market, with the confidence to explore a wide range of industry-related professions. Students will be able to add this qualification to their CV/resume, giving them a head start in their chosen field.
Course Curriculum
Introduction | |||
Case Study Part 1 | 00:04:00 | ||
CREATE | 00:11:00 | ||
Exercise 1: Create DB and Table | 00:01:00 | ||
Installation and getting started | |||
INSERT | 00:09:00 | ||
Import data from File | 00:05:00 | ||
Exercise 2: Inserting and Importing | 00:01:00 | ||
Case Study : Demo | |||
SELECT statement | 00:03:00 | ||
SELECT DISTINCT | 00:06:00 | ||
WHERE | 00:04:00 | ||
Logical Operators22 | 00:06:00 | ||
Exercise 3: SELECT & WHERE | 00:01:00 | ||
Fundamental SQL statements | |||
UPDATE | 00:05:00 | ||
DELETE | 00:04:00 | ||
ALTER | 00:17:00 | ||
Exercise 4: Updating Table | 00:01:00 | ||
Restore and Back-up | |||
Restore and Back-up | 00:07:00 | ||
Exercise 5: Restore and Back-up | 00:01:00 | ||
Selection commands: Filtering | |||
IN222 | 00:04:00 | ||
BETWEEN | 00:05:00 | ||
LIKE | 00:09:00 | ||
Exercise 6: In, Like & Between | 00:01:00 | ||
Selection commands: Ordering | |||
Side Lecture: Commenting in SQL | 00:01:00 | ||
ORDER BY | 00:07:00 | ||
LIMIT | 00:03:00 | ||
Exercise 7: Sorting | 00:01:00 | ||
Aggregate Commands | |||
AS | 00:03:00 | ||
COUNT | 00:05:00 | ||
SUM | 00:03:00 | ||
AVERAGE | 00:03:00 | ||
MIN & MAX | 00:04:00 | ||
Exercise 8: Aggregate functions | 00:01:00 | ||
Group By Commands | |||
GROUP BY | 00:12:00 | ||
HAVING | 00:05:00 | ||
Exercise 9: Group By | 00:01:00 | ||
Conditional Statement | |||
CASE WHEN | 00:05:00 | ||
JOINS | |||
Introduction to Joins | 00:02:00 | ||
Inner Join | 00:08:00 | ||
Left Join | 00:07:00 | ||
Right Join | 00:06:00 | ||
Full Outer Join | 00:05:00 | ||
Cross Join | 00:04:00 | ||
Except | 00:03:00 | ||
Union | 00:03:00 | ||
Exercise 10: Joins | 00:01:00 | ||
Subscribes | |||
Exercise 11: Subqueries | 00:01:00 | ||
Views and Indexes | |||
VIEWS | 00:07:00 | ||
Exercise 12: Views | 00:01:00 | ||
String Functions | |||
LENGTH | 00:03:00 | ||
UPPER LOWER | 00:02:00 | ||
REPLACE | 00:04:00 | ||
TRIM, LTRIM, RTRIM | 00:07:00 | ||
CONCATENATION | 00:03:00 | ||
SUBSTRING | 00:06:00 | ||
LIST AGGREGATION | 00:05:00 | ||
Exercise 13: String Functions | 00:02:00 | ||
Mathematical Functions | |||
CEIL & FLOOR | 00:03:00 | ||
RANDOM | 00:05:00 | ||
SETSEED | 00:04:00 | ||
ROUND | 00:02:00 | ||
POWER | 00:02:00 | ||
Exercise 14: Mathematical Functions | 00:01:00 | ||
Date-Time Functions | |||
CURRENT DATE & TIME | 00:04:00 | ||
AGE | 00:03:00 | ||
EXTRACT | 00:08:00 | ||
Exercise 15: Date-time functions | 00:01:00 | ||
PATTERN (STRING) MATCHING | |||
PATTERN MATCHING BASICS | 00:07:00 | ||
Exercise 16: Pattern Matching | 00:01:00 | ||
Data Type conversion functions | |||
Converting Numbers/ Date to String | 00:11:00 | ||
Converting String to Numbers/ Date | 00:06:00 | ||
User Access Control Functions | |||
User Access Control | 00:13:00 | ||
Bonus Section: Nail that Interview! | |||
Tablespace | 00:05:00 | ||
PRIMARY KEY & FOREIGN KEY | 00:05:00 | ||
ACID compliance | 00:06:00 | ||
Truncate | 00:04:00 | ||
Performance tuning tips | |||
TIP 2 | 00:01:00 | ||
TIP 3 | 00:02:00 | ||
TIP 4 (VACCUM) | 00:01:00 | ||
TIP 5 | 00:02:00 | ||
TIP 6 (STRING FUNCTIONS) | 00:02:00 | ||
TIP 7 (JOINS) | 00:02:00 | ||
TIP 8 (SCHEMAS) | 00:04:00 | ||
Bonus Section : Database Basics | |||
What is SQL | 00:02:00 | ||
Tables and DBMS | 00:03:00 | ||
Types of SQL commands | 00:04:00 | ||
PostgreSQL | 00:02:00 | ||
Order Your Certificate Now | |||
Order Your Certificate | 00:00:00 |
Course Reviews
No Reviews found for this course.