Software Nuggets
Software Nuggets
  • 454
  • 635 806
PostgreSQL Script for Generating 1M Random Transaction Data
Other video title that didn't make the cut
1) PostgreSQL Script: Generating Fake Data for Transactions
2) PostgreSQL Script for Inserting Random Transaction Logs
3) PostgreSQL Script for Inserting 1 Million Transaction Records
4) PostgreSQL Script to Simulate Transactions for Testing
5) Building Random Transaction Data with PostgreSQL Script
Переглядів: 159

Відео

Find large folders & disk hogs with Excel VBA using FileSystemObject (FSO)
Переглядів 4116 годин тому
This Excel VBA tutorial shows how to use FileSystemObject (FSO) to find large files and disk hogs on your computer. The code demonstrates how to retrieve folder names and their corresponding sizes, and display them in an Excel worksheet. By leveraging VBA and the FileSystemObject, you can quickly gather folder sizes, identify large folders, and manage disk space more efficiently. Learn how to a...
Master PostgreSQL Window Functions: Learn RANK vs. DENSE_RANK with Simple Examples!
Переглядів 43Місяць тому
SQL window ranking functions PostgreSQL RANK PostgreSQL DENSE_RANK How to use PostgreSQL PARTITION BY How to use OVER clause PostgreSQL data ranking Each example straight forward and easy to understand. #softwarenuggets @softwareNuggets
Master the New JSON_TABLE Function in PostgreSQL 17, JSON to table.
Переглядів 236Місяць тому
PostgreSQL JSON to table PostgreSQL json_table function Working with JSON data in PostgreSQL JSONB tutorial PostgreSQL PostgreSQL JSON column to table PostgreSQL query JSON efficiently timestamp 0:00 intro software nuggets 0:03 introduce json_table function 0:17 download source from github 0:37 create table to store json 0:55 insert JSON into table 1:29 select * from table (see the json) 1:52 u...
PostgreSQL 17: New MERGE SQL Command for Combined INSERT, UPDATE, and DELETE Operations
Переглядів 140Місяць тому
Master PostgreSQL: Insert, Update, and Delete in One Command! MERGE SQL Command Postgresql MERGE SQL Command for Combined INSERT, UPDATE, and DELETE Learn how to efficiently manage your database with this powerful PostgreSQL technique. In this video, we'll show you how to perform insert, update, and delete operations all at once using a single SQL command. PostgreSQL 17 feature: MERGE command I...
HackerRank: Harry potter and wands, Ollivander's Inventory - SQL Server.
Переглядів 1062 місяці тому
Users will learn how to write a complex SQL query using Common Table Expressions (CTEs) to solve a problem involving filtering and sorting data from multiple tables. They'll understand how to use JOIN operations, aggregate functions, and ORDER BY clauses to extract specific information based on given criteria. Master the use of Common Table Expressions in SQL queries Understand how to join mult...
Rust: Learn Rust Traits with Practical Code Example
Переглядів 262 місяці тому
Learn Rust Traits with Practical Code Example We begin by creating a Shape trait, defining the area and display functions, which represent the core functionality of various shapes. Using Rust trait objects, we demonstrate how to implement the Shape trait for a Rectangle struct, encapsulating properties like width and height. What Rust traits are and how to define them How to use dynamic dispatc...
Learn Python TkInter: Build a World Flags Guessing Game Application step-by-step.
Переглядів 1612 місяці тому
Learn Python TkInter: Build a World Flags Guessing Game Application, step-by-step Embark on an exciting journey to learn Python and master TkInter, one of the most popular GUI frameworks for Python. In this comprehensive, step-by-step tutorial, you'll build an engaging World Flags Guessing Game Application from scratch. This project-based learning experience is perfect for beginners and interme...
ASM Language (L10), How to DEBUG an assembly language program using GDB
Переглядів 1963 місяці тому
How to DEBUG an assembly language program using GDB How to use the file .gdbInit How to write a command and save in .gdbInit How to use break points in gdb for debugging How to use the START command to begin running the debugger How to change the value of a register ⏱️ Timestamps: 00:00 Hey Team Intro 00:03 Quote by Edsger Dijkstra 00:24 Script to Assemble/Compile source code 00:55 4 ways to st...
Assembly x86-64 Tutorial: Swapping Array Elements in Intel Syntax on Ubuntu Linux (Lesson 9)
Переглядів 1123 місяці тому
Learn how to swap two elements in an array using x86-64 Assembly language with Intel syntax on Ubuntu Linux. This comprehensive tutorial (Lesson 9) covers: Calling external C functions (printf) Subroutine implementation and calling Stack management Accessing elements in a 64-bit array Using NASM assembler and GCC compiler how to find offset address in assembly language what is offset in assembl...
Rust HashMap Tutorial: Essential Techniques for Efficient Data Management
Переглядів 714 місяці тому
Master Rust HashMaps with this comprehensive tutorial from #SoftwareNuggets. Ideal for beginners and intermediate Rust programmers looking to enhance their data management skills. Create and initialize HashMaps Manage capacity and length Perform insert, get, and remove operations Implement custom traits Use pattern matching with HashMaps Optimize HashMap performance Table of Contents 00:00 Hey ...
Node.js PostgreSQL Tutorial: Calling Functions & Database Operations
Переглядів 2524 місяці тому
Node.js PostgreSQL Tutorial: Calling Functions & Database Operations Learn how to integrate Node.js with PostgreSQL using the pg package. Discover essential tips for establishing connections, executing SQL operations, and calling PostgreSQL functions from your Node.js applications. Perfect for programmers diving into database-driven web development!" Master essential Node.js database operations...
Master Number Base Addition: Decimal, Hexadecimal, Octal, Binary Using Carry Technique
Переглядів 864 місяці тому
Learn the universal carry technique for adding numbers in multiple bases with this comprehensive tutorial by #SoftwareNuggets. Perfect for computer science students, programmers, and math enthusiasts How to Subtract Binary ua-cam.com/video/KGXYzU1neVo/v-deo.html How to Subtract Hexadecimal ua-cam.com/video/X3Nozo41Rgg/v-deo.html How to Add Hexadecimal ua-cam.com/video/rF8eKBQNXDc/v-deo.html How...
HackerRank: Solution for Symmetric Pairs problem for SQL Server.
Переглядів 4455 місяців тому
HackerRank: Solution for Symmetric Pairs problem for SQL Server.
Command Line Calculator - A Calculator that converts Infix to Postfix using C# .Net 8
Переглядів 805 місяців тому
Command Line Calculator - A Calculator that converts Infix to Postfix using C# .Net 8
How-To Convert Infix to Postfix Notation. Learn with Three Examples
Переглядів 3295 місяців тому
How-To Convert Infix to Postfix Notation. Learn with Three Examples
Create A Tkinter Listbox In Python: Learn To Build A Reusable Component
Переглядів 6036 місяців тому
Create A Tkinter Listbox In Python: Learn To Build A Reusable Component
HackerRank: Solution for Interviews, a problem for SQL Server.
Переглядів 1346 місяців тому
HackerRank: Solution for Interviews, a problem for SQL Server.
PostgreSQL: Write a Dynamic Function using ALTER TABLE with JSON parameter!
Переглядів 1566 місяців тому
PostgreSQL: Write a Dynamic Function using ALTER TABLE with JSON parameter!
Learn Python,Tkinter and MongoDB to build a Movie Search App with Posters!
Переглядів 2477 місяців тому
Learn Python,Tkinter and MongoDB to build a Movie Search App with Posters!
Calling Extern Printf() In Assembly Code: Code up a Small app to learn the steps!
Переглядів 4547 місяців тому
Calling Extern Printf() In Assembly Code: Code up a Small app to learn the steps!
ASM Language: How to Sum the Digits from 8-bit Byte Array - Intel-Syntax Lesson 7. Assembly.
Переглядів 1047 місяців тому
ASM Language: How to Sum the Digits from 8-bit Byte Array - Intel-Syntax Lesson 7. Assembly.
HackerRank: How to Master SQL Joins and Grouping for Advanced Data Analysis. 🚀
Переглядів 768 місяців тому
HackerRank: How to Master SQL Joins and Grouping for Advanced Data Analysis. 🚀
PostgreSQL: How to write a Function to validate an Email Address using Regex.
Переглядів 2298 місяців тому
PostgreSQL: How to write a Function to validate an Email Address using Regex.
ASM Language: How to get input (sys_read) from the user in Assembly. Lesson 6. Intel-Syntax.
Переглядів 2508 місяців тому
ASM Language: How to get input (sys_read) from the user in Assembly. Lesson 6. Intel-Syntax.
HackerRank: How to Loop over Binary Tree Nodes in SQL Server.
Переглядів 1079 місяців тому
HackerRank: How to Loop over Binary Tree Nodes in SQL Server.
ASM Language: Learn the JUMP assembly language instructions. Lesson 5. Intel-Syntax.
Переглядів 3889 місяців тому
ASM Language: Learn the JUMP assembly language instructions. Lesson 5. Intel-Syntax.
PostgresSQL : How to Parse XML with Attributes. Insert into a Table.
Переглядів 4669 місяців тому
PostgresSQL : How to Parse XML with Attributes. Insert into a Table.
XML Parsing in PostgreSQL: Utilizing XPath for Variable Extraction for Table Insertion.
Переглядів 1,2 тис.9 місяців тому
XML Parsing in PostgreSQL: Utilizing XPath for Variable Extraction for Table Insertion.
Lesson 4 - Calculate area of rectangle in Assembly Language. Area = Width * Length. Using IMUL
Переглядів 3859 місяців тому
Lesson 4 - Calculate area of rectangle in Assembly Language. Area = Width * Length. Using IMUL

КОМЕНТАРІ

  • @SybylCampbell
    @SybylCampbell День тому

    视频内容非常精彩!我有一点困惑:有人给我转usdt,我有恢复短语。{pride}-{pole}-{obtain}-{together}-{second}-{when}-{future}-{mask}-{review}-{nature}-{potato}-{bulb} 我该如何提取它们呢?

    • @SoftwareNuggets
      @SoftwareNuggets День тому

      You wrote: The video content is very exciting! I'm a little confused: someone transferred me USDT and I have the recovery phrase. {pride}-{pole}-{obtain}-{together}-{second}-{when}-{future}-{mask}-{review}-{nature}-{potato}-{bulb} What should I do What about extracting them? Hey @SybylCampbell, are you asking me a crypto currency question, or, how to parse this: {pride}-{pole}-{obtain}-{together}-{second}-{when}-{future}-{mask}-{review}-{nature}-{potato}-{bulb}

  • @vorapobautomation9760
    @vorapobautomation9760 6 днів тому

    How to transfer the some data or all data from datagridview1 to datagridview2 in the same form with C# ? How to edit the data in datagridview1 or datagridview2 in any column and row and add the new row and remove the row too ?

    • @SoftwareNuggets
      @SoftwareNuggets 6 днів тому

      // Method 1: Transfer All Rows private void TransferAllRows() { // Clear destination DataGridView first dataGridView2.Rows.Clear(); // Copy all rows from dataGridView1 to dataGridView2 foreach (DataGridViewRow row in dataGridView1.Rows) { if (!row.IsNewRow) // Exclude the new row template { dataGridView2.Rows.Add(row.Cells.Cast<DataGridViewCell>() .Select(cell => cell.Value).ToArray()); } } } // Method 2: Transfer Selected Rows private void TransferSelectedRows() { foreach (DataGridViewRow row in dataGridView1.SelectedRows) { if (!row.IsNewRow) { dataGridView2.Rows.Add(row.Cells.Cast<DataGridViewCell>() .Select(cell => cell.Value).ToArray()); } } } // Method 3: Transfer Specific Rows by Condition private void TransferFilteredRows() { var rowsToTransfer = dataGridView1.Rows .Cast<DataGridViewRow>() .Where(row => SomeCondition(row)) // Define your condition .ToList(); foreach (var row in rowsToTransfer) { dataGridView2.Rows.Add(row.Cells.Cast<DataGridViewCell>() .Select(cell => cell.Value).ToArray()); } } Editing a Cell: Find the exact row and column you want to change Use dataGridView1.Rows[rowIndex].Cells[columnIndex].Value = newValue Replace rowIndex and columnIndex with actual numbers Replace newValue with the text or data you want to put in that cell Adding a New Row: Use dataGridView1.Rows.Add() method Put the values for each column in order Can add values directly or create a new row first, then add values Deleting a Row: Two main ways to delete: a) Delete by row number: dataGridView1.Rows.RemoveAt(rowIndex) b) Delete selected row: dataGridView1.Rows.Remove(dataGridView1.SelectedRows[0]) Always check if rows exist before trying to delete Tips: rowIndex starts at 0 (first row is 0, second is 1) Use dataGridView1.Rows.Count to know how many rows exist Hope this helps

  • @Amulya869
    @Amulya869 7 днів тому

    Please send this code

    • @SoftwareNuggets
      @SoftwareNuggets 7 днів тому

      --Here is the create table command and insert data github.com/softwareNuggets/VBA_for_Excel_resources/blob/main/sales_data.sql --Here is vba code for this video github.com/softwareNuggets/VBA_for_Excel_resources/blob/main/how_to_fetch_data_with_vba.bas

  • @balogunogooluwa6694
    @balogunogooluwa6694 10 днів тому

    Great video sir.

  • @michaelhernandez2075
    @michaelhernandez2075 10 днів тому

    many thanks

    • @SoftwareNuggets
      @SoftwareNuggets 10 днів тому

      Hope this video was helpful. Thanks for leaving a comment.

  • @ahmadjerjees428
    @ahmadjerjees428 13 днів тому

    thanks for the video man !

    • @SoftwareNuggets
      @SoftwareNuggets 13 днів тому

      I hope this video was useful. thanks for leaving a comment @ahmadjerjees428

  • @suigeneris1242
    @suigeneris1242 24 дні тому

    Good video.

  • @seangillespie4601
    @seangillespie4601 Місяць тому

    how is a 10 minute video 8 minutes too long...

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Hey @seangillespie4601, I agree! The video has been trimmed to remove unnecessary segments.

  • @nickeax
    @nickeax Місяць тому

    Thanks!

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Hey @nickeax, much appreciated. It means a lot to me that you took the time to support my content with a super thanks.

    • @nickeax
      @nickeax Місяць тому

      @@SoftwareNuggets thanks for the great content! Cheers

  • @Pretttttyyy
    @Pretttttyyy Місяць тому

    Hi, I'm first year of high school we learn in french but actually this is the only video that i understood from ,thank you so much 💓

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Hey @shayma_0e! That's awesome that you're learning hexadecimal in your first year of high school! 😊 I'm really glad this video helped you out. If you're interested, I have another video that shows how to subtract hexadecimal numbers: ua-cam.com/video/X3Nozo41Rgg/v-deo.html Keep up the great work - you're doing amazing! 👍

  • @chuckpietro
    @chuckpietro Місяць тому

    you briefly reference the function Build_PostgreSQL_ConnectionString, the most important part, but you fail to explain what it does. Another minute of video would have been helpful.

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Function Build_PostgreSQL_ConnectionString() as String dim connStr as String 'set up connection string connStr = "DSN=dvdRentalDSN;" Build_PostgreSQL_ConnectionString = connStr End Function Above, you can see DSN=dvdRentalDSN I'm using Windows 10/11 To create a Data Source Name (DSN) in Windows 10, which allows applications to connect to a database using the Open Database Connectivity (ODBC) standard, you can follow these steps: 1. Open ODBC Data Source Administrator Press Win + R to open the Run dialog. Type odbcad32 and press Enter. This opens the ODBC Data Source Administrator dialog. On 64-bit Windows, you'll see two versions: ODBC Data Source (64-bit) for 64-bit applications ODBC Data Source (32-bit) for 32-bit applications Choose the correct version based on your application's architecture. 2. Add a New DSN Go to either the User DSN (for individual user accounts) or System DSN (for all users) tab, depending on your requirements. Click Add... to create a new DSN. 3. Select a Driver In the list, choose the appropriate ODBC driver for the database you're connecting to (e.g., SQL Server, MySQL, Oracle). Click Finish. 4. Configure the Data Source A configuration dialog for the selected driver will appear. Fill in the necessary details: Data Source Name: Give your DSN a unique, descriptive name. Description: Optionally, add a description for the DSN. Server Name or Network Address: Specify the database server's name or IP address. Database Name: Enter the database name (if required by the driver). Authentication: Provide credentials, like username and password, if necessary. 5. Test the Connection (Optional) Most ODBC configuration dialogs have a Test Connection button. Click it to confirm that the DSN configuration is correct. 6. Save the DSN Once configured, click OK to save the DSN. After you create the DSN, we will use this connection to connect to PostgreSQL. Hope this helps Scott

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Please let me know if you were able to create the DSN, use the DSN, connect to The PostgreSQL database.

  • @Alacritous
    @Alacritous Місяць тому

    Wow. They've made JSON harder to work with.. Good job, guys!!

  • @cxxkie07
    @cxxkie07 Місяць тому

    I was looking for this kind of video.. Thank you. Explanation was very nice. It cleared my concept.

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Glad to hear this video was useful, in the video, command line calculator, I actually use this algorithm. It worth checking out.

  • @Phyreuben1
    @Phyreuben1 Місяць тому

    Thanks so much sir!! I was so confused when our prof tackled about this you just made it so easy <3

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Hey @Phyreuben1, glad to hear this video was useful. I appreciate you leaving a message. Wish you much success.

  • @blixstaa
    @blixstaa Місяць тому

    Can I use the pivot table to summarize data from multiple columns at the same time, or do I need to do each column one by one?

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Using a PIVOT table, just think, ROWS to COLUMNS. Create me an example, and share with me, how to use a PIVOT command.

  • @blixstaa
    @blixstaa Місяць тому

    Really helpful video on CASE expression. When using "Case", does it matter if I place it in the select or where clause? If so, how do I know which clause to put it in?

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      The CASE statement, can be used in the SELECT clause, the WHERE clause, the Order by clause, the GROUP BY clause, the HAVING Clause, and can also be used in JOIN conditions. As you can see, the CASE statement is very versatile. It's indispensable. This is one statement in SQL you must master! I recommend you write a SQL Expression, and try and use the CASE statement in all the elements I listed above. You'll need to practice this statement to become the master.

  • @blixstaa
    @blixstaa Місяць тому

    Can you explain when its better to use having instead of just adding conditions in the where clause?

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      a) the HAVING clause is primarily used with GROUP BY to perform a "WHERE filter" on the results of an aggregate function. b) HAVING does act similarly to WHERE, but on grouped data rather than individual rows. c) Aggregate functions such as MIN, MAX, SUM, AVG, and COUNT are used to perform calculations across multiple rows, effectively collapsing them into a single result. When data has been aggregated in this manner, typically in conjunction with a GROUP BY clause, the HAVING clause becomes an invaluable tool for filtering these aggregated results based on specific conditions.

  • @blixstaa
    @blixstaa Місяць тому

    Thank you for this breakdown of the select statement. When using select top 10, how could I retrieve the bottom 10 rows in a table?

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Change the direction of the data with order by field, top 10 will be those rows. Try this, let me know

    • @blixstaa
      @blixstaa Місяць тому

      @@SoftwareNuggets Thank you!

  • @stark1909
    @stark1909 Місяць тому

    And how to parse XML when you don't know the number and names of tags? That is, create a unique function XML -> Table. I try first XML -> JSON and only then to TABLE via temporary tables, but there is a performance problem due to recursion and duplicate column error

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Why won’t you know the tag names? You are just going to load random data into your database?

    • @stark1909
      @stark1909 Місяць тому

      @@SoftwareNuggets Because these are different xml state reference books and there are many of them and they all have different contents, and each such xml reference book needs to be saved as a separate table in the database

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      @stark1909 is it possible you send me several different files to: softwareNugget65@gmail.com

  • @kronykl
    @kronykl Місяць тому

    thank you very much for this!

  • @bleedingrx1079
    @bleedingrx1079 Місяць тому

    Why do i have error: self.button1 = tk.Button(self.root, text="Button 1", width=40, command=lambda: self.check_answer(0)) ^^^^^^^^^^^^^^^^^^^^ line 313, in check_answer if 0 <= self.correct_answer < self.num_answers: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ TypeError: '<=' not supported between instances of 'int' and 'NoneType' please, help me

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Hey @bleedingrx1079, what version of Python are you using? I am using 3.11.5 Check out my github account for a new version of this program. Look for the file called: flagsV2.py Here is a link to that file: github.com/softwareNuggets/Python_Shorts/blob/main/LearnCountryFlags/flagsV2.py Please let me know if this fixes your issue. Scott

    • @bleedingrx1079
      @bleedingrx1079 Місяць тому

      ​@@SoftwareNuggets Yessirr it works, turns out that was my fault(stupid), anyways, thanks for help!

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      @bleedingrx1079, Fixing errors builds your problem-solving muscles. Embrace these struggles - they're opportunities to grow. The expertise you're gaining now will serve you throughout your entire career. So, you got the app to work on your computer?

    • @bleedingrx1079
      @bleedingrx1079 14 днів тому

      @@SoftwareNuggets I'm sorry for late answering. I completely agree with u, without errors we couldn't gain any experience. And of course it works! Thanks for your worries

    • @SoftwareNuggets
      @SoftwareNuggets 14 днів тому

      @bleedingrx1079 so you got the app working? Did you add any features?

  • @BrecioCharlesFrancis
    @BrecioCharlesFrancis Місяць тому

    thanks for this, good luck to me for the exam!

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Hey @BrecioCharlesFrancis , Here is a short video to solve this Adding Hex problem. 9C84 25AC ------------- Please try and do by yourself, then use the video to get correct answer. ua-cam.com/users/shorts15aMoWsRl80 Good luck with your exam. Please let me know how you did!

  • @LibyaMicro
    @LibyaMicro Місяць тому

    Thanks from Africa

  • @LibyaMicro
    @LibyaMicro Місяць тому

    Excellent in Firebird databases there are also computed column that can fetch the value of a field from another table. such as bringing the department name from another table with the value of the field ID in the current table

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      I need to check out firebird. Thanks for the introduction!!

    • @LibyaMicro
      @LibyaMicro Місяць тому

      @@SoftwareNuggets However, this can only be done in PostgreSQL by calling a function. CREATE TABLE product ( product_id UUID price FLOAT available_location VARCHAR GENERATED ALWAYS AS fetch_product_location(product_id) )

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      @LibyaMicro that’s a great example. Thanks for the update.

  • @dexvt1862
    @dexvt1862 2 місяці тому

    Amazing lecture. Thanks Software Nuggets!

  • @AdamWatkins-m3c
    @AdamWatkins-m3c 2 місяці тому

    I love the calm, deliberate, clear way you speak and illustrate the answers. Can you come teach at my school?

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Thanks for the message. Appreciate you taking the time to reach out. Are you a CS student?

    • @AdamWatkins-m3c
      @AdamWatkins-m3c 2 місяці тому

      @@SoftwareNuggets I'm a Biomedical Tech student. We are following an Electronic Engineering Tech program which include Digital Logic I. The notes our instructor has given us does not explain how to add/subtract Hex numbers, but it is on the assignment he handed out.

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      @AdamWatkins-m3c, congratulations on pursuing Biomedical Technology! It's great to see you taking initiative to find additional resources for understanding hexadecimal addition and subtraction. Your instructor will likely be impressed by your proactive approach to learning. If you have any specific questions about hex operations or need further clarification, feel free to ask. Good luck with your studies!

  • @yuri-jd4co
    @yuri-jd4co 2 місяці тому

    stop speaking like that

  • @josh7635
    @josh7635 2 місяці тому

    For the prefix, you might want to consider using schemas. But glad you are thinking in a helpful fashion either way.

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Great observation! Using schemas can indeed help manage permissions and improve data access. It's a smart way to enhance organization within our databases.

  • @wordleSolver34734
    @wordleSolver34734 2 місяці тому

    Learn all the flags! great video, great learning app!

  • @JulianRiverplate14
    @JulianRiverplate14 2 місяці тому

    Amazing video!

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Thanks @JulianRiverplate14, appreciate the feedback.

  • @Clapped_Fortnites
    @Clapped_Fortnites 2 місяці тому

    good video!

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      thanks. did you get this app working on your box?

  • @blixstaa
    @blixstaa 2 місяці тому

    I know how to use computed columns now, thank you.

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: why would you need a computed column?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggetsYou would need a computed column to automatically calculate values from other columns with a formula so you wouldn’t have to do it by hand.

  • @blixstaa
    @blixstaa 2 місяці тому

    I understand this, I liked your scenario, it helped understand this much better.

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: How do you convert a RowVersion value to a Big Integer?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets You would use cast function

  • @blixstaa
    @blixstaa 2 місяці тому

    I understand that these are both the same now, thank you.

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      What one word could you say, so that I know you know why these datatypes are used?

  • @blixstaa
    @blixstaa 2 місяці тому

    This was pretty informative thank you for this

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: Does the Timestamp datatype have anything to do with the Date/Time?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets No, it has absolutely nothing to do with Date/Time

  • @blixstaa
    @blixstaa 2 місяці тому

    Thank you for this, I understand TimeStamp and now I also know cast statement

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      when you select a timestamp value, what format is that shown in?

  • @blixstaa
    @blixstaa 2 місяці тому

    I understand the difference between the two, thank you.

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: why would these data types be used?

  • @blixstaa
    @blixstaa 2 місяці тому

    Thank you, I understand this.

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      why would you use an UniqueIdentifier? How are they different from an Identity column?

  • @blixstaa
    @blixstaa 2 місяці тому

    Thank you for this, I know how to use BIT data type now.

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: So the Bit datatype has two states: what are they?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets 0; false and 1; true

  • @blixstaa
    @blixstaa 2 місяці тому

    Very informational, I can differentiate all of the date and time data types.

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      How would you convert a DateTime2 into a SmallDateTime?

  • @blixstaa
    @blixstaa 2 місяці тому

    Thank you, I understand SMALLINT data type

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: What is the largest number you can put into a SmallInt datatype?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets 32,767, the range is from -32,768 to 32767

  • @blixstaa
    @blixstaa 2 місяці тому

    I know how to efficiently use data type TINYINT now, thank you.

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      can you use identity(240,10) on a TINYINT datatype? Do you get an error if the identity value > max number allowed? what is the max number I can put into a TINYINT ?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets Yes you do receive an error if the identity value > max number, and you can use identity (240,10) for only 2 values before you receive an error so it isn’t ideal. The max number that can be used in TinyInt is 255

  • @blixstaa
    @blixstaa 2 місяці тому

    Thank you for teaching me how to reseed an identity column

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      What is the purpose and common use case of CHECKIDENT?

  • @blixstaa
    @blixstaa 2 місяці тому

    Thank you for showing how to use IDENTITY on a int data type

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Is this a legit command: counting backwards? create table t33 ( x int identity(10000,-10) not null, y varchar(10) ); insert into t33 values('aaa'); select * from t33;

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets yes this is a legit command

  • @blixstaa
    @blixstaa 2 місяці тому

    I know how to use data type INT, thank you for this video.

    • @SoftwareNuggets
      @SoftwareNuggets Місяць тому

      Great. Here are two questions: 1) what is the largest number you can assign an integer? 2) what happens when you add two int that exceed the datatype limit?

  • @blixstaa
    @blixstaa 2 місяці тому

    I understand how much space a NVARCHAR consumes

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      How much space and why?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets 2 bytes per character because it stores data in Unicode

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      @blixstaa you got it

  • @blixstaa
    @blixstaa 2 місяці тому

    thank you, i can see the comparison between varchar and nvarchar now

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      without executing this code: declare @c as nvarchar(10); set @c = 'blixstaa' select DATALENGTH(@c) what will the DATALENGTH(@c) equal? declare @c as nchar(10); set @c = 'blixstaa' select DATALENGTH(@c) what will the DATALENGTH(@c) equal?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets for nvarchar, it will equal 16 and for nchar it will equal 20

  • @blixstaa
    @blixstaa 2 місяці тому

    I understand VARCHAR vs CHAR now and how to use ASCII

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: what is the output of the following: (execute all four rows in one execution) declare @c as char(3); select @c ='A'; select len(@c) select DATALENGTH(@c) what will len(@c) print out? what will DATALENGTH(@c) print out?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets len(@c) will print 1 and datalength(@c) will print 3

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      @@blixstaa why does DATALENGTH(@c) print 3?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets because @c is declared as char(3)

  • @blixstaa
    @blixstaa 2 місяці тому

    Thank you for describing CHAR

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: can you put a unicode character like '₡' into a char(2) column?

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Question: what does the ascii function return?

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets No you cannot, you must use nchar

    • @blixstaa
      @blixstaa 2 місяці тому

      @@SoftwareNuggets the ascii value of the first character in a string

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      @@blixstaa an integer value between 0-255

  • @sa3a388
    @sa3a388 2 місяці тому

    Could you plz put the source program link? 😊

    • @SoftwareNuggets
      @SoftwareNuggets 2 місяці тому

      Hey @sa3a388, you can find the source to this video on my GitHub Account: github.com/softwareNuggets/VBA_for_Excel_resources/blob/main/ElapsedTime.bas