nikkiinit
nikkiinit
  • Видео 105
  • Просмотров 63 024
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...
Просмотров: 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 ...
C++ Inheritance | Write better code
Просмотров 606 месяцев назад
C Inheritance | Write better code
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...
Start making money with your skills
Просмотров 1457 месяцев назад
Start making money with your skills
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
Best Programming Languages To Learn
Просмотров 408Год назад
Best Programming Languages To Learn
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

Комментарии

  • @parentteachernight
    @parentteachernight 15 дней назад

    You have a talent for technical communication. Always very clear and easy to follow. Cheers!

    • @nikkiinit
      @nikkiinit 14 дней назад

      Thank you! I appreciate your support 💕

  • @babafunmiseadebowale7746
    @babafunmiseadebowale7746 26 дней назад

    great video

  • @faraitanekha2642
    @faraitanekha2642 29 дней назад

    Brilliant! Just brilliant. Merci beaucoup :)

  • @DV-ml4fm
    @DV-ml4fm Месяц назад

    You don't need to use touch to create the file first. You can type vim _filename_ vim will create and open the filename.

  • @jamestakac8951
    @jamestakac8951 Месяц назад

    You can also use .hxx and .cxx

  • @NuncNuncNuncNunc
    @NuncNuncNuncNunc Месяц назад

    Instead of top, you can use htop for better output display

  • @victorbenedict8743
    @victorbenedict8743 Месяц назад

    How does a fresher/No experience, structure his or hers?

    • @nikkiinit
      @nikkiinit Месяц назад

      You have to prioritize you projects on GitHub! If you have no experience the hiring manager will definitely look at your GitHub profile.

  • @smilingcatonlinux5998
    @smilingcatonlinux5998 Месяц назад

    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 ✴

  • @anatolehagbe7301
    @anatolehagbe7301 2 месяца назад

    You've done an excellent job. But you're not using Vi very well.

    • @nikkiinit
      @nikkiinit 2 месяца назад

      Vi Text Editor Tutorial #linux #vi #bashscripting #shellscripting ruclips.net/video/MjncAIo91bU/видео.html

  • @stalinengoma7680
    @stalinengoma7680 2 месяца назад

    Another delicious bowl of Linux cookies for us. Thank you

    • @nikkiinit
      @nikkiinit 2 месяца назад

      We are baking up some delicious Linux knowledge today! 👩‍🍳 🍪 😂 hope you enjoy it 💕

  • @REBELATIONSPODCAST
    @REBELATIONSPODCAST 2 месяца назад

    🙏🏼

  • @daemon_zero
    @daemon_zero 2 месяца назад

    Great video, I'm subscribing to your channel. Thank you

    • @nikkiinit
      @nikkiinit 2 месяца назад

      Welcome! Glad you enjoyed the video.

  • @nilimdaimari
    @nilimdaimari 2 месяца назад

    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.

    • @nikkiinit
      @nikkiinit 2 месяца назад

      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.

  • @leonidas14775
    @leonidas14775 2 месяца назад

    vi: There will be no escape! 😈

  • @AaneiMarco
    @AaneiMarco 2 месяца назад

    Do you have LinkedLn account?

    • @nikkiinit
      @nikkiinit 2 месяца назад

      Yes I do, here is the link: linkedin.com/in/nekeisha-pope 💕

  • @lisacondon8081
    @lisacondon8081 3 месяца назад

    I really appreciate your teaching style. This is extremely helpful information. thank you.

    • @nikkiinit
      @nikkiinit 2 месяца назад

      Thank you 💕

  • @abdullahabdi9093
    @abdullahabdi9093 3 месяца назад

    Girl you amazing thank you

    • @nikkiinit
      @nikkiinit 2 месяца назад

      Thank you Abdul 💕

  • @maybeeric-qv9mo
    @maybeeric-qv9mo 3 месяца назад

    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

  • @Fullflexno
    @Fullflexno 3 месяца назад

    Super video, Great content! Cheers from norway!

    • @nikkiinit
      @nikkiinit 3 месяца назад

      Thank you 🙏🏾 💕

  • @eldarmammadov9917
    @eldarmammadov9917 4 месяца назад

    Great awesome explanation

    • @nikkiinit
      @nikkiinit 3 месяца назад

      Thank you 🙏🏾 💕

  • @antsangeo
    @antsangeo 4 месяца назад

    Cannot find this video in your playlist

  • @otaibabahar7521
    @otaibabahar7521 5 месяцев назад

    Dear thank you for these helpful tips. Could publish a a series of C++ and Linux

  • @JavierPortillo1
    @JavierPortillo1 5 месяцев назад

    Very well explained, thank you!

  • @otaibabahar7521
    @otaibabahar7521 5 месяцев назад

    Hi sis thank you very much could you please upload more videos. Am really grateful for you

  • @sherrilltechnology
    @sherrilltechnology 5 месяцев назад

    Oh my goodness this is the best tutorial I have ever seen!! Thanks so much now I am not afraid to try it!!

  • @puko365
    @puko365 5 месяцев назад

    so, ETL is basically importing data to usable database for queries?

    • @nikkiinit
      @nikkiinit 5 месяцев назад

      ETL is importing data from multiple destination to a data warehouse. But there is a process (Extract, Transform, Load)

  • @osoriomatucurane9511
    @osoriomatucurane9511 6 месяцев назад

    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

    • @nikkiinit
      @nikkiinit 5 месяцев назад

      You can do it several ways. Which program languages are you using? Python will be the best for that.

  • @ziyao2461
    @ziyao2461 6 месяцев назад

    有来当听力练的踢我🎉

  • @jorgel.2222
    @jorgel.2222 6 месяцев назад

    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.

  • @abdullahabdi9093
    @abdullahabdi9093 6 месяцев назад

    Thanks sis

    • @nikkiinit
      @nikkiinit 6 месяцев назад

      You’re welcome

  • @Practical-IT
    @Practical-IT 6 месяцев назад

    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.

  • @mizo80-t2j
    @mizo80-t2j 7 месяцев назад

    Thank you Nikki. I find this video very helpful.

    • @nikkiinit
      @nikkiinit 7 месяцев назад

      You’re welcome 💕

  • @kenkkash
    @kenkkash 7 месяцев назад

    Very instructive 🤙

    • @nikkiinit
      @nikkiinit 7 месяцев назад

      Thank you.

    • @kenkkash
      @kenkkash 7 месяцев назад

      When using tar command I never used the -p option. I have learn something. Thank you.

  • @smilingcatonlinux5998
    @smilingcatonlinux5998 7 месяцев назад

    you love it , this is why you are a great teacher , people see this ... Thanks 👍and greetings

    • @nikkiinit
      @nikkiinit 7 месяцев назад

      Thank you! And beautiful subscribers like you who push me to love it more! Thank you for your support 💕

  • @jorgel.2222
    @jorgel.2222 7 месяцев назад

    Muchas gracias Nikki, interesante aporte. Un saludo

  • @yuvarajcena26
    @yuvarajcena26 7 месяцев назад

    Make more videos

  • @pawanj1
    @pawanj1 8 месяцев назад

    Thank you, you beautifully explained the shell!

  • @abhishekjohri498
    @abhishekjohri498 8 месяцев назад

    thank you, good content,

  • @yurenashy
    @yurenashy 8 месяцев назад

    Thank you so much, Nikki! Looking forward to your next c++ tutorials. these are very helpful! <3

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      You’re welcome 💕

  • @sasukehyuuga4044
    @sasukehyuuga4044 8 месяцев назад

    Thank you this is a very great tutorial, I learned a lot with it! <3

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      You’re welcome 💕

  • @procrasti86
    @procrasti86 8 месяцев назад

    I'm just here for the joke of linux being sad and awkward

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      😂🤣🤣😂 I love this one! Sad (sed) and awkward (awk) 😂

  • @SaintReaux
    @SaintReaux 8 месяцев назад

    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! 🤣

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      Thank you! 🙏🏾 I think I will leave the tax 🤣😂 I want everyone to have money in their savings! It will motivate them to save! 😇

  • @petraahnell8557
    @petraahnell8557 8 месяцев назад

    Great tutorials!! I'm studying for my linux course exam at uni and your videos are really helping me. Thank you!

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      Thank dear! Glad the videos are helping you. 😇

  • @SaintReaux
    @SaintReaux 8 месяцев назад

    🔥🔥🔥 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!

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      C++ is one of my favourite! You should get back! Let’s build some great things together!

  • @MrBean0829
    @MrBean0829 8 месяцев назад

    Fun, thank you. I just started goofing around with GTK in C. I suppose the next logical step would be C++

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      You’re welcome! Yes, make the step! C++ is more fun! 🤞

  • @jorgel.2222
    @jorgel.2222 8 месяцев назад

    Ahora si se activaron los subtítulos..!! Muchas gracias..

  • @jorgel.2222
    @jorgel.2222 8 месяцев назад

    Hola Nikki, tu video no tiene subtítulos para español, me lo perderé, que pena. Un saludo.

  • @abhishekpulicheri6075
    @abhishekpulicheri6075 8 месяцев назад

    You are just awesome, your explanation is so good. Greetings from India ❤

    • @nikkiinit
      @nikkiinit 8 месяцев назад

      Thank you! 😊 I appreciate your feedback! ❤️

    • @abhishekpulicheri6075
      @abhishekpulicheri6075 8 месяцев назад

      @@nikkiinit if possible please make videos on some real time shell scripting examples codes. Thank you ❤️

  • @puneetchauhan5495
    @puneetchauhan5495 9 месяцев назад

    Fantastic,i learned something new today

    • @nikkiinit
      @nikkiinit 9 месяцев назад

      Thank you 🙏🏾

  • @bawinja7213
    @bawinja7213 9 месяцев назад

    Great stuff, very insighful content🎉

    • @nikkiinit
      @nikkiinit 9 месяцев назад

      Thank you very much! 💕✨