
In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of “SQL For Data Analytics & Database Development”. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL’s profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative.
It isn’t simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn’t merely technical; it’s the spine of transformative decisions in today’s leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories.
Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future.
Learning Outcomes:
This SQL For Data Analytics & Database Development was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.
Course Introduction | |||
Introduction | 00:04:00 | ||
Course Curriculum Overview | 00:05:00 | ||
Overview of Databases | 00:10:00 | ||
SQL Environment Setup | |||
MySQL Installation | 00:16:00 | ||
MySQL Workbench Installation | 00:09:00 | ||
Connecting to MySQL using Console | 00:09:00 | ||
SQL Statement Basics | |||
Overview of Challenges | 00:04:00 | ||
SQL Statement Basic | 00:16:00 | ||
SELECT Statement | 00:09:00 | ||
SELECT DISTINCT | 00:05:00 | ||
Column AS Statement | 00:12:00 | ||
COUNT built-in Method usage | 00:11:00 | ||
SELECT WHERE Clause – Part One | 00:05:00 | ||
SELECT WHERE Clause – Part Two | 00:11:00 | ||
SQL Statement Basic | 00:16:00 | ||
SQL Limit Clause Statement | 00:09:00 | ||
SQL Using BETWEEN with Same Column Data | 00:11:00 | ||
How to Apply IN Operator | 00:11:00 | ||
Wildcard Characters with LIKE and ILIKE | 00:11:00 | ||
GROUP BY Statements | |||
Overview of GROUP BY | 00:06:00 | ||
Aggregation function SUM() | 00:09:00 | ||
Aggregation MIN() and MAX() | 00:05:00 | ||
GROUP BY – One | 00:09:00 | ||
GROUP BY – Two | 00:12:00 | ||
HAVING Clause | 00:05:00 | ||
JOINS | |||
Overview of JOINS | 00:04:00 | ||
Introduction to JOINS | 00:04:00 | ||
AS Statement table | 00:03:00 | ||
INNER Joins | 00:14:00 | ||
FULL Outer Join | 00:11:00 | ||
LEFT Outer JOIN | 00:08:00 | ||
RIGHT JOIN | 00:08:00 | ||
Union | 00:07:00 | ||
Advanced SQL Commands / Statements | |||
Timestamps | 00:12:00 | ||
EXTRACT from timestamp | 00:10:00 | ||
Mathematical Functions | 00:12:00 | ||
String Functions | 00:22:00 | ||
SUBQUERY | 00:13:00 | ||
Creating Database and Tables | |||
Basic of Database and Tables | 00:06:00 | ||
DataTypes | 00:10:00 | ||
Primarykey and Foreignkey | 00:06:00 | ||
Create Table in SQL Script | 00:13:00 | ||
Insert | 00:11:00 | ||
Update | 00:07:00 | ||
Delete | 00:04:00 | ||
Alter Table | 00:09:00 | ||
Drop Table | 00:05:00 | ||
NOT NULL Constraint | 00:08:00 | ||
UNIQUE Constraint | 00:09:00 | ||
Databases and Tables | |||
Creating a Database backup | 00:12:00 | ||
10a Overview of Databases and Tables | 00:05:00 | ||
10c Restoring a Database | 00:07:00 | ||
Order your Certificate | 00:00:00 |
Take control of your email management and organization like never before with The Complete Microsoft Outlook Masterclass. This comprehensive course …
1
Streamline your email management with powerful strategies that make Outlook work for you! In the Outlook Tips and Tricks course, …
1
Unlock the essentials of Microsoft Access for Beginners and discover how to efficiently manage data in a structured database environment. …
1
$427.70 Original price was: $427.70.$27.30Current price is: $27.30. ex Vat