• LOGIN
  • No products in the cart.

SQL for Data Analytics

4.7( 7 REVIEWS )
3 STUDENTS

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

4.7

4.7
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

SQL for Data Analytics
TAKE THIS COURSE

Instructors

3 STUDENTS ENROLLED

14 Days Money Back Guarantee

© Queenmary Academy. All rights reserved.