- 177
- 3 702 232
Q Visible
Ireland
Registrace 15. 03. 2012
I'm a lecturer at an Irish university. I make tutorials on many different subjects that I teach to help my students and a wider audience as a quick references. Some of the different topics that I focus on are
databases,
data science,
spreadsheets: excel and google sheets ,
audio and video media production,
internet of things,
digital marketing,
programming,
web design.
I often include download links in my descriptions to allow viewers to get the files and work alongside the video. My github is here: github.com/qVisible.
Go ahead and subscribe and press the alert button.
databases,
data science,
spreadsheets: excel and google sheets ,
audio and video media production,
internet of things,
digital marketing,
programming,
web design.
I often include download links in my descriptions to allow viewers to get the files and work alongside the video. My github is here: github.com/qVisible.
Go ahead and subscribe and press the alert button.
SQL JOIN Comprehensive Tutorial for Beginners
Conquer SQL Inner Joins with this concise and easy-to-follow tutorial! Learn how to combine and filter data from multiple tables using practical examples, step-by-step guidance, and expert advice. Ideal for SQL beginners and enthusiasts.
In this video, we'll cover:
The fundamentals of SQL Inner Joins
How to write and understand Inner Join syntax
Real-world examples for applying Inner Joins effectively
Tips for optimizing SQL queries with Inner Joins
Common pitfalls and best practices for using Inner Joins
Whether you're a beginner looking to learn SQL basics or a seasoned developer seeking to improve your database querying skills, this tutorial offers valuable insights for everyone. Master SQL Inner Joins today and elevate your data management capabilities! Don't forget to like, comment, and subscribe for more in-depth tutorials on SQL and database management.
In this video, we'll cover:
The fundamentals of SQL Inner Joins
How to write and understand Inner Join syntax
Real-world examples for applying Inner Joins effectively
Tips for optimizing SQL queries with Inner Joins
Common pitfalls and best practices for using Inner Joins
Whether you're a beginner looking to learn SQL basics or a seasoned developer seeking to improve your database querying skills, this tutorial offers valuable insights for everyone. Master SQL Inner Joins today and elevate your data management capabilities! Don't forget to like, comment, and subscribe for more in-depth tutorials on SQL and database management.
zhlédnutí: 2 372
Video
Master the HAVING Clause in SQL: Ultimate Guide to Grouped Data Filtering (LIKE WHERE for Groups)
zhlédnutí 944Před rokem
Unlock the power of SQL's HAVING Clause in this comprehensive tutorial! Dive into the secrets of filtering grouped data with this easy-to-follow guide. Discover how the HAVING clause works like a WHERE clause for groups in your SQL queries. Perfect for beginners and experienced users alike, this video covers everything you need to know about HAVING, including examples, tips, and best practices....
SQL GROUP BY Clause: Step-by-Step Tutorial for Students | Home Rentals Database Example
zhlédnutí 257Před rokem
🔥 Boost your SQL skills with this in-depth, easy-to-follow tutorial on the powerful GROUP BY clause! Perfect for anyone looking to up their SQL game. In this video, we use a real-world Home Rentals agency database as an example to help you understand the practical applications of the GROUP BY clause in SQL. ⚡ Learn how the GROUP BY clause is used to group rows in a query that have the same valu...
Master AVG & MAX Aggregate Functions in SQL: Essential Guide for Data Analysis & Business Students
zhlédnutí 639Před rokem
Welcome to Q-VISIBLE - your one-stop source for all things data! In this in-depth tutorial, we'll explore the power of AVG() and MAX() aggregate functions in SQL, key tools for data analysis, programming, and business courses. Perfect for university and college students of any discipline that uses SQL, including: 📊 Data Science 🖥️ Computer Science 📈 Business Analysis 📚 Information Systems 💼 Man...
AS keyword SQL - Renaming Column Headings in SQL with the 'AS' Keyword - A Beginner's Guide
zhlédnutí 800Před rokem
Are you tired of confusing column headings in your SQL query results? Look no further! In this tutorial, QVisible, a working lecturer in data analysis and programming, will show you how to use the 'AS' keyword in SQL to rename your column headings and make them more meaningful to your users. The 'AS' keyword allows you to rename a column heading to a more descriptive name, making it easier for ...
Mastering Aggregate Functions in SQL - Count and Sum Explained
zhlédnutí 1,3KPřed rokem
Are you struggling to analyze data in your SQL databases? Fear not! In this tutorial, we'll show you how to use aggregate functions in SQL to summarize and analyze your data like a pro. Aggregate functions like COUNT and SUM are powerful tools that allow you to calculate values based on sets of data. With these functions, you can quickly get an overview of your data and gain valuable insights i...
Wildcard characters in SQL WHERE clauses - Mastering SQL Wildcard Character for Data Filtering
zhlédnutí 995Před rokem
Are you tired of sifting through data one by one? Look no further! In this tutorial, we'll show you how to use the SQL wildcard character to filter your data like a pro. The wildcard character is a powerful tool that allows you to match and filter data based on patterns, rather than specific values. With the ability to match any number of characters, you can easily filter through large amounts ...
IN, NOT IN Keywords in SQL WHERE clauses - Exploring the Power of 'IN' and 'NOT IN' Keywords in SQL
zhlédnutí 875Před rokem
Hey there, in this tutorial, I'm going to show you how to take your data filtering skills to the next level with the powerful 'IN' and 'NOT IN' keywords in SQL. These keywords allow you to filter data based on sets of values, rather than having to repeat logical operators like 'OR' and 'AND' over and over again. By using sets, you can filter data with ease and get more accurate results. In this...
Understanding 'Between' and 'Not Between' Keywords as an Alternative to 'Or' and 'And' in SQL
zhlédnutí 1KPřed rokem
Description: SQL is a powerful language used to manage and manipulate data in relational databases. In this video, we'll explore an alternative to the commonly used "or" and "and" keywords in SQL - "between" and "not between" - that can help you filter data more efficiently. The "or" and "and" keywords are commonly used to filter data based on multiple conditions. However, this approach can som...
AND, OR in WHERE Clauses SQL - SQL Logical Compound Comparison Searches
zhlédnutí 1,5KPřed rokem
Are you ready to level up your SQL skills? In this comprehensive video tutorial, we demystify logical compound comparison filters in SQL, equipping you with the knowledge to optimize your queries and extract valuable insights from your data! Join us as m dive into the world of SQL filters, covering AND, OR, and NOT operators, along with their practical applications. Through real-world examples ...
Calculated Fields in SQL
zhlédnutí 4KPřed rokem
This step-by-step guide is designed to help you unlock the full potential of dynamic data manipulation using calculated fields in your SQL queries. If you're a beginner, don't worry - we've got you covered with clear explanations and practical examples to kickstart your learning journey. In this tutorial, you'll learn: 🔹 What calculated fields are and why they are essential for efficient data a...
PHP Random Colored Divs - For loops
zhlédnutí 726Před rokem
Learning about loops in programming opens up so many avenues to new programmers all of a sudden! It's hard to know where to begin to start to apply the new structure. Well here's one example. take a for loop to iterate through the generation of a number of div containers of random sizes, positions and background colors. In this tutorial I show you how to use the for loop, randomize the differen...
Learn Media Queries - Web Design Layout
zhlédnutí 264Před rokem
Media Queries allow web designers to have different CSS rules at different screen sizes. It's especially pertinent in responsive web design - as screen sizes changes designers often want to change the layout of different sections of the layout quite drastically. Media queries are generally placed at the bottom of a websites stylesheet and are exceptions to rules that have been placed higher up....
Validating Credit Card - PHP Applied Example
zhlédnutí 1,1KPřed rokem
Using and If Else structure in PHP along with the in built string function strlen() we can check to make sure the user has entered in a 16 digit credit card number. This tutorial is one of a series for programmers who are just starting out on their programming journey. At this stage it's all about applying what you are learning in different examples and practice.
While Loops Php Example - Lottery Slip
zhlédnutí 1,2KPřed rokem
Loops are such an important construct in programming - this example puts the while loop into practice in PHP and gives a more advanced and in-depth look at a while loop building a sophisticated form that can be submitted by a user. For a user who wants to play the lottery online, they can have an online lottery card showing all the numbers from which they can pick their selection. 00:50 part 1:...
SQL ORDER BY Keyword for Sorting Query Results
zhlédnutí 11KPřed 3 lety
SQL ORDER BY Keyword for Sorting Query Results
SELECT query in SQL - Retrieval of records from a table
zhlédnutí 54KPřed 3 lety
SELECT query in SQL - Retrieval of records from a table
Pie Charts - Creating & formatting - Mac Excel
zhlédnutí 40KPřed 3 lety
Pie Charts - Creating & formatting - Mac Excel
Database Constraints - What they are and How to use them
zhlédnutí 7KPřed 3 lety
Database Constraints - What they are and How to use them
Adding the Analysis Toolpak for Mac Excel
zhlédnutí 53KPřed 3 lety
Adding the Analysis Toolpak for Mac Excel
z-index in CSS - How to re-order layers in your HTML
zhlédnutí 14KPřed 3 lety
z-index in CSS - How to re-order layers in your HTML
Bookmark links in HTML - Navigation Tutorial
zhlédnutí 7KPřed 3 lety
Bookmark links in HTML - Navigation Tutorial
Central Limit Theorem - Explanation with Excel Download
zhlédnutí 11KPřed 3 lety
Central Limit Theorem - Explanation with Excel Download
How to Insert Chapters in YouTube Videos - A Step-by-Step Tutorial
zhlédnutí 93Před 3 lety
How to Insert Chapters in CZcams Videos - A Step-by-Step Tutorial
Facility Location - Simple Median Method
zhlédnutí 10KPřed 3 lety
Facility Location - Simple Median Method
Great video, thanks! Could you please giving me ideias on how to attach specific/variable pdf files for each name in the list. Also if is it possible to include a column in excel wit CC email addresses?
I don't know how to do these things. Anyone else?
8:00
why i cant click Alt+F9 key to toggle ~ please help!!!
are you on a Mac or PC? Laptop or desktop?
Thanks. It is easy to follow. It works perfectly.
Thanks.
Edit: It works, but on PC. Im getting warning for all the numbers i did not select. Warning: Undefined array key "box5" in C:\xampp\htdocs\checkbox\delete-multiple.php on line 9
Alignment function distribute horizontally doesn't work. and it didn't work in your video either
:nth-child (1,2,3,4) Or :not or :where is better
This is exactly what I was after. Thanks!
Thanks Wolfgang 😊
tnx bro you are the best
Is there any sound with this video?
No sound. it was just a class exercise.
THIIIIIIIS video was good! You explain things SIMPLY.
Nice🎉🎉🎉🎉
I can't thank you enough for this. you have an amazing way to explain things. Easy and Crisp to perfection.
Hey man, I don't know from where you are but you are a genius and you saved me a lot of time! Thanks a lot!
Thanks a mil! (from Ireland) 👍
You saved me from destroying my computer, so thanks for that!
Solid explanation thank you and love the accent!
Thanks for this!!
This was so helpful thank you!! For anyone who might still be having trouble, you have to use the link itself not a shortened link. My department has been putting off a project for months because we couldn’t figure out how to send out 300 emails with personalized links en mass.
My hero! Brilliant.
Thanks for saving my project! very clear tutorial and great voice too 🔥
I'm in this video after 10 yes of publication 🥴
From 2024
Thank u so much
This video is till spreading joy, thank you so much.
thank you, you made so clear for me.
Divs are epic and very powerful. This is exactly what I needed. Thanks!
🔥🔥
Thank you so much 🙏🏾😊
10 years ago and still the best video I've come across. Love it
Splendid video! A video put up way back in 2013 is so relevant and helpful even today. Great video!
Nice job . Small topic video very important for the beginners. All the best 👍
This video has saved me a lot of time! Thank you!!
THANK YOU!
This is great and I appreciate you sharing. However, once I saved the Word document and went back in, the links were now static. I found a different video that explains you have to do another step to add a bookmark. I don't understand how it all works, but adding that additional step kept the links dynamic. This additional step is found in this video (czcams.com/video/xEAIudoirTI/video.html) at ~ 1:50 mark.
Lol, explained that better than a professor. Good job!
you just saved my life
I stumbled upon your channel and damn I could listen to you talk for HOURS with that voice of yours
😁 You've made my day!!!
As you made mine for sure! can I get your socials? If you're down ofc
@@QVisible like you made mine for sure!! 🤭
Great video! the sound quality is superb. Thanks man
Thank you so much. As a beginner I learned a lot. I hope I can apply it
This is extremely helpful. Thank you.
Thank you for the explanation ❤️👍🏻
Thank you so much sir , here after 10 years and yes your method is still better than lot of our modern CZcams teachers
I am getting on me knees currently because this was crazy simple and cannot believe this was this hard for someone to explain. Thank you sir
this really helped!
Underrated
Thank you. I did not know you first need to select the Properties option on the ribbon on the upper right before right clicking the Table Design section.
Love from India 🎉
I love u too
Extremely clear and more helpful than the my in-person lectures. Thank you!
Can you make a video using restriction? I mean this was made using restriction free movement. I think imposing restrictions save a lot of time