- Full Price
- 1538 QR
- You Save
- 1493 QR
Fine Print
- Valid from 6 Aug – 6 Oct 2024
- Redemption period: 2 months from the deal’s start date
- Lifetime access to course content & materials
- ONE voucher per person; may purchase multiple vouchers as gifts
- Vouchers not redeemed by 6 Oct 2024 will NOT be refunded
- No mandatory completion deadline; learners can take & finish it anytime they want
- After successfully passing the test you will be able to claim the pdf certificate for £5.99 Original Hard Copy certificates need to be ordered at an additional cost of £9.60
- In order to be eligible for the certificate you need to successfully complete the course and pass each course module
- For more information visit: SQL For Data Analytics & Database Development Online Course or write to [email protected]
- Internet access and audio required
- You’ll get access to detailed video tutorials, practical examples, and useful tips
- Not valid with other offers
- No cash value/No cash back/No refunds
How to Redeem:
To activate your voucher and assign your course:
- Please visit the Redeem Voucher Page of Study Hub
- Fill up the necessary information
- Enter the voucher code
- Click the submit button
- The course will be assigned to you within 48 hours
Please see the terms for all deals here
Highlights
SQL For Data Analytics & Database Development Online Course
Pay QR45 instead of QR1538
- Through this course, you will deepen your knowledge in coding, SQL, and machine learning, mastering SQL’s most popular string, mathematical, and date-time functions
- You will learn how to enhance the performance of databases & use sorting and filtering commands in SQL, equipping you with the skills to kickstart your career
- Improve your job prospects in data analytics, database development, & database administration with the complete SQL For Data Analytics & Database Development course
- Master SQL for data analysis by learning from the experts and enroll in this step-by-step training course today!
- No formal qualifications are required! This course is perfect for people who want to learn new skills, start a new career, or enhance their knowledge about their chosen field
- Lifetime access to course materials
See below for the full course outline!
Pursue a career in tech!
Course Outline:
Course Introduction
- Introduction
- Course Curriculum Overview
- Overview of Databases
SQL Environment Setup
- MySQL Installation
- MySQL Workbench Installation
- Connecting to MySQL using Console
SQL Statement Basics
- Overview of Challenges
- SQL Statement Basic
- SELECT Statement
- SELECT DISTINCT
- Column AS Statement
- COUNT built-in Method usage
- SELECT WHERE Clause – Part One
- SELECT WHERE Clause – Part Two
- SQL Statement Basic
- SQL Limit Clause Statement
- SQL Using BETWEEN with Same Column Data
- How to Apply IN Operator
- Wildcard Characters with LIKE and ILIKE
GROUP BY Statements
- Overview of GROUP BY
- Aggregation function SUM()
- Aggregation MIN
- GROUP BY – One
- GROUP BY – Two
- HAVING Clause
JOINS
- Overview of JOINS
- Introduction to JOINS
- AS Statement table
- INNER Joins
- FULL Outer Join
- LEFT Outer JOIN
- RIGHT JOIN
- Union
Advanced SQL Commands / Statements
- Timestamps
- EXTRACT from timestamp
- Mathematical Functions
- String Functions
- SUBQUERY
Creating Database and Tables
- Basic of Database and Tables
- DataTypes
- Primarykey and Foreignkey
- Create Table in SQL Script
- Insert
- Update
- Delete
- Alter Table
- Drop Table
- NOT NULL Constraint
- UNIQUE Constraint
Databases and Tables
- Creating a Database backup
- 10a Overview of Databases and Tables
- 10c Restoring a Database
Company Profile
Over the course of 15 years, Studyhub has witnessed a continuous evolution in culture. Throughout its history, Studyhub’s core principles have remained steadfast, playing a central role in shaping behavior, fostering a customer-centric approach, and influencing collaborative dynamics among team members, learners, and the wider community. The combination of these elements contributes to the creation of a positive and nurturing environment.
The current era offers an unprecedented array of options and opportunities, all conveniently accessible at one’s fingertips. The ability to acquire new skills and foster personal growth has never been easier, with the availability of online platforms. Through Studyhub, individuals can now partake in learning experiences facilitated by the most seasoned instructors from across the globe. Furthermore, the internet has enabled individuals to ignite revolutionary movements and bring about transformative change, all from the comfort of their homes.
