- Видео 105
- Просмотров 63 024
nikkiinit
Канада
Добавлен 23 янв 2022
SQL GROUPING DATA | Data Aggregation #sqltutorial #database #oraclesql #dataanalytics
In this tutorial, we'll break down the GROUP BY clause step-by-step, showing you how to:
Group data into meaningful categories: Learn how to segment your data based on specific columns, like product category, customer region, or order date.
Calculate aggregate functions: Discover how to use functions like COUNT, SUM, AVG, MIN, and MAX to get insights from each group. We'll show you real-world examples!
Combine GROUP BY with WHERE: Filter your data before grouping to focus on the most relevant information.
Use HAVING to filter groups: Learn the crucial difference between WHERE and HAVING, and how to filter groups after aggregation.
#SQL #GroupBy #Database #DataAnalysis #SQLTutorial #Coding #Pro...
Group data into meaningful categories: Learn how to segment your data based on specific columns, like product category, customer region, or order date.
Calculate aggregate functions: Discover how to use functions like COUNT, SUM, AVG, MIN, and MAX to get insights from each group. We'll show you real-world examples!
Combine GROUP BY with WHERE: Filter your data before grouping to focus on the most relevant information.
Use HAVING to filter groups: Learn the crucial difference between WHERE and HAVING, and how to filter groups after aggregation.
#SQL #GroupBy #Database #DataAnalysis #SQLTutorial #Coding #Pro...
Просмотров: 18
Видео
Handling SQL Nulls: Essential Techniques for Data Professionals | #sql #oracle #postres
Просмотров 4414 дней назад
This video provides a comprehensive guide to effectively handling null values in SQL. We explore the nuances of nulls, their impact on query results, and demonstrate practical techniques to: Identify and locate null values: Learn to effectively pinpoint and isolate nulls within your datasets. Implement robust null handling strategies: Master techniques such as: IS NULL and IS NOT NULL: Utilize ...
10 Essential Linux Commands You NEED to Know #systemadministrator #systemadmin
Просмотров 226Месяц назад
This video dives deep into 10 crucial Linux commands that will significantly boost your productivity and efficiency when working with the Linux operating system. Whether you're a beginner or an intermediate user, these commands will empower you to navigate the command line with confidence and streamline your workflows. By mastering these commands, you'll gain a solid foundation in the Linux com...
Softwear Development On Linux | Automate Your Build Process With Makefiles
Просмотров 8292 месяца назад
In this video, you'll learn: What Makefiles are and why you should use them Basic Makefile syntax and structure How to define targets and dependencies Using variables and functions to create flexible Makefiles Best practices for writing clean and efficient Makefiles Whether you're a beginner or an experienced developer, this tutorial will help you master the art of Makefiles and take your build...
C++ STL Tutorial | Master the Standard Template Library #cppprogramming
Просмотров 2962 месяца назад
Learn C STL from the ground up! This comprehensive tutorial will guide you through the essential components of the C Standard Template Library (STL). From containers like vectors, lists, and maps to algorithms like sorting, searching, and transforming, you'll gain a solid understanding of how to leverage the power of the STL to write efficient and elegant C code. #C #stlcards #tutorial #program...
Softwear Development On Linux Using GCC And G++
Просмотров 7412 месяца назад
Learn how to compile and link C and C code on Linux using the powerful GCC and G compilers. From basic usage to advanced optimization techniques, this video has you covered! #GCC #G #Linux #C #C #compiler #programming #tutorial #beginner #advanced #optimization #debugging
How To Write And Structure An ATS Friendly Tech Resume #techjobs
Просмотров 1225 месяцев назад
This video shows how to write a resume for IT roles. By the end of this video, you should know how to write and structure a resume that will pass any ATS system.
Safe Empty State in Computer Programming | Software Design Principles
Просмотров 395 месяцев назад
We can validate the incoming data before storing it in an object also, we can reject invalid data and store default data. Why do that? An empty state in C refers to the initial condition of an object or data structure before it's populated with meaningful data. It's essentially a placeholder or starting point. Key Points: - No strict definition: The concept of an empty state is more conceptual ...
How to archive files in linux | Linux tar command | #linux #linuxterminal #linuxcommandline
Просмотров 1266 месяцев назад
The tar command in Linux is a versatile tool for working with archive files, often called tarballs. Here's a quick rundown of its capabilities: Creating Archives: You can use tar to bundle multiple files and directories into a single archive for easy storage or transfer. Extraction: Likewise, tar can extract the contents of an archive, recreating the original files and directory structure on yo...
C++ Pass-by-value vs pass-by-reference | #softwaredeveloper #cprogrmming #coding
Просмотров 367 месяцев назад
C Pass-by-value vs pass-by-reference | #softwaredeveloper #cprogrmming #coding
Mastering C/C++ Functions for Beginners | #softwaredeveloper #softwaredevelopment
Просмотров 1047 месяцев назад
Mastering C/C Functions for Beginners | #softwaredeveloper #softwaredevelopment
Should you Learn Ai? | The Greatness Of Technology | WWDC24
Просмотров 747 месяцев назад
Should you Learn Ai? | The Greatness Of Technology | WWDC24
C++ Class | Create Software While You Learn | Programming Journey | Coding Advice #codingtutorial
Просмотров 1997 месяцев назад
C Class | Create Software While You Learn | Programming Journey | Coding Advice #codingtutorial
C++ Tutorial | ATM Software Update Add loops | C++ Tutorial for beginners | #softwaredeveloper
Просмотров 2858 месяцев назад
C Tutorial | ATM Software Update Add loops | C Tutorial for beginners | #softwaredeveloper
C++ Tutorial | Create software while learning C++ | C++ Tutorial for beginners | Introduction to C++
Просмотров 9308 месяцев назад
C Tutorial | Create software while learning C | C Tutorial for beginners | Introduction to C
Linux tput Command | Design your Program with tput | #bash #linux #shellscripting #bashscripting
Просмотров 7228 месяцев назад
Linux tput Command | Design your Program with tput | #bash #linux #shellscripting #bashscripting
How to get a job as a software developer with no experience | New to Tech | Job Search Tips
Просмотров 1499 месяцев назад
How to get a job as a software developer with no experience | New to Tech | Job Search Tips
Concept of Database Creation | Database Design #databasedesign #database #sqldeveloper
Просмотров 12810 месяцев назад
Concept of Database Creation | Database Design #databasedesign #database #sqldeveloper
Awk Scripting PART 1 | introduction to awk scripting language | #linux #shellscripting #bash
Просмотров 35710 месяцев назад
Awk Scripting PART 1 | introduction to awk scripting language | #linux #shellscripting #bash
Best Operating System And Computer for Software Development And Data Science #datascience
Просмотров 12711 месяцев назад
Best Operating System And Computer for Software Development And Data Science #datascience
MySQL DBA Tutorial | Install | Grant And Revoke Privileges | Create Users | LOAD DATA
Просмотров 276Год назад
MySQL DBA Tutorial | Install | Grant And Revoke Privileges | Create Users | LOAD DATA
Linux Pipe | Fifo #bashscripting #linux #shellscripting #linuxforbeginners #devops
Просмотров 602Год назад
Linux Pipe | Fifo #bashscripting #linux #shellscripting #linuxforbeginners #devops
Data Analytics Using Python | #dataanalytics #dataanalysis #pythonforbeginners #python
Просмотров 104Год назад
Data Analytics Using Python | #dataanalytics #dataanalysis #pythonforbeginners #python
Data Analytics Using Python | Introduction #dataanalytics #dataanalysis #pythonforbeginners #python
Просмотров 214Год назад
Data Analytics Using Python | Introduction #dataanalytics #dataanalysis #pythonforbeginners #python
Vi Text Editor Tutorial #linux #vi #bashscripting #shellscripting
Просмотров 321Год назад
Vi Text Editor Tutorial #linux #vi #bashscripting #shellscripting
PostgreSQL Database Tutorial #postgresql #pgadmin #dataanalytics #datascience
Просмотров 85Год назад
PostgreSQL Database Tutorial #postgresql #pgadmin #dataanalytics #datascience
Tableau For Data Analytics and Data Visualization
Просмотров 175Год назад
Tableau For Data Analytics and Data Visualization
You have a talent for technical communication. Always very clear and easy to follow. Cheers!
Thank you! I appreciate your support 💕
great video
Brilliant! Just brilliant. Merci beaucoup :)
You don't need to use touch to create the file first. You can type vim _filename_ vim will create and open the filename.
You can also use .hxx and .cxx
Instead of top, you can use htop for better output display
How does a fresher/No experience, structure his or hers?
You have to prioritize you projects on GitHub! If you have no experience the hiring manager will definitely look at your GitHub profile.
great video but i was "googeling" about cd command in shell scripts - and i got this video today from you - :° ) nikki - ls -al is no problem, but cd is not easy to understand how it works with subshells and why it does not work in shell scripts - There is so weak information about this topic. If you know something - maybe you can make a video sometimes, it would really help people out -(i searched for a better way to first cd and than ls by taking a argument from a read array) -your channel is growing - great - thanks for your work and greetings - nikki ✴
You've done an excellent job. But you're not using Vi very well.
Vi Text Editor Tutorial #linux #vi #bashscripting #shellscripting ruclips.net/video/MjncAIo91bU/видео.html
Another delicious bowl of Linux cookies for us. Thank you
We are baking up some delicious Linux knowledge today! 👩🍳 🍪 😂 hope you enjoy it 💕
🙏🏼
Great video, I'm subscribing to your channel. Thank you
Welcome! Glad you enjoyed the video.
I see where you're coming from, but there’s a misunderstanding here. gcc and g++ are compilers used to translate C/C++ source code into machine code. They are not limited to smaller programs; they can handle both small and large projects. The size of the program doesn't determine whether you use gcc or g++. These compilers are fundamental to the build process, regardless of the project's size. make and CMake, on the other hand, are build tools or build system generators. They don't compile the code directly; instead, they help manage the build process by defining how files should be compiled and linked. For larger projects with multiple files and dependencies, tools like make or CMake make it easier to automate and organize the build process, but they are not the reason the program is considered large or small. They simply help manage complexity, which is common in larger projects. So, whether the program is small or large, you’ll always use a compiler (like gcc or g++) to generate the final executable, and make or CMake just simplifies the process when there are many files and dependencies.
I never claimed that make and Makefile are compilers. Similarly, I didn't suggest that gcc and g++ are incapable of compiling larger programs. I used the term "suitable". While gcc and g++ can handle large projects, using them directly for every compilation step might not be the most efficient approach. This is because gcc typically compiles single files. If you modify a file and use gcc to recompile, you'll need to recompile the entire project. In contrast, make is a build automation tool that can significantly streamline the compilation process. It analyzes dependencies between files and only recompiles those that have changed or whose dependencies have been modified. This can save time and effort, especially for large projects with numerous source files.
vi: There will be no escape! 😈
Do you have LinkedLn account?
Yes I do, here is the link: linkedin.com/in/nekeisha-pope 💕
I really appreciate your teaching style. This is extremely helpful information. thank you.
Thank you 💕
Girl you amazing thank you
Thank you Abdul 💕
It’s honestly an amazing tutorial, voice is clear and example is great.Maybe u can try to use C to explain it by the way
Super video, Great content! Cheers from norway!
Thank you 🙏🏾 💕
Great awesome explanation
Thank you 🙏🏾 💕
Cannot find this video in your playlist
Dear thank you for these helpful tips. Could publish a a series of C++ and Linux
Very well explained, thank you!
Hi sis thank you very much could you please upload more videos. Am really grateful for you
Oh my goodness this is the best tutorial I have ever seen!! Thanks so much now I am not afraid to try it!!
so, ETL is basically importing data to usable database for queries?
ETL is importing data from multiple destination to a data warehouse. But there is a process (Extract, Transform, Load)
Awesome tutorial. I would like to ask for assistance. How to read, i mean extract data in a table from the web, in html format, given the link. Thank you
You can do it several ways. Which program languages are you using? Python will be the best for that.
有来当听力练的踢我🎉
Muchas gracias Nikki, sus aportes son muy instructivos. Siempre se aprende algo nuevo y eso es gracias a personas como ud. que dedican tiempo y conocimiento a enseñar. Un saludo.
Thanks sis
You’re welcome
Ive always used .tar.gz or .tgz when denoting that a file is both tarred and compressed with gzip. This is the way i was taught >25 years ago. There are, if course other options you can use besides gzip for compression of a tar file.
Thank you Nikki. I find this video very helpful.
You’re welcome 💕
Very instructive 🤙
Thank you.
When using tar command I never used the -p option. I have learn something. Thank you.
you love it , this is why you are a great teacher , people see this ... Thanks 👍and greetings
Thank you! And beautiful subscribers like you who push me to love it more! Thank you for your support 💕
Muchas gracias Nikki, interesante aporte. Un saludo
Make more videos
Thank you, you beautifully explained the shell!
thank you, good content,
Thank you so much, Nikki! Looking forward to your next c++ tutorials. these are very helpful! <3
You’re welcome 💕
Thank you this is a very great tutorial, I learned a lot with it! <3
You’re welcome 💕
I'm just here for the joke of linux being sad and awkward
😂🤣🤣😂 I love this one! Sad (sed) and awkward (awk) 😂
Fantastic tutorial Nikki!!! A for-loop is great when we know the exact number of times that we want the loop to run. However, we often want the loop to continue for an undetermined number of iterations until a specific condition is met. That's when the while-loop is super useful. Great breakdown! 👌🏽 Wish we could get rid of those taxes tho! 🤣
Thank you! 🙏🏾 I think I will leave the tax 🤣😂 I want everyone to have money in their savings! It will motivate them to save! 😇
Great tutorials!! I'm studying for my linux course exam at uni and your videos are really helping me. Thank you!
Thank dear! Glad the videos are helping you. 😇
🔥🔥🔥 I love the project-based tutorials! I haven't worked with C++ in a while, so this was a great refresher! Amazing video. I'm looking forward to the next one!
C++ is one of my favourite! You should get back! Let’s build some great things together!
Fun, thank you. I just started goofing around with GTK in C. I suppose the next logical step would be C++
You’re welcome! Yes, make the step! C++ is more fun! 🤞
Ahora si se activaron los subtítulos..!! Muchas gracias..
Hola Nikki, tu video no tiene subtítulos para español, me lo perderé, que pena. Un saludo.
You are just awesome, your explanation is so good. Greetings from India ❤
Thank you! 😊 I appreciate your feedback! ❤️
@@nikkiinit if possible please make videos on some real time shell scripting examples codes. Thank you ❤️
Fantastic,i learned something new today
Thank you 🙏🏾
Great stuff, very insighful content🎉
Thank you very much! 💕✨