SQL Pro
SQL Pro
  • Видео 18
  • Просмотров 74 252
How to use MERGE in SQL Server to Upsert Data
Learn how to upsert data in SQL Server using a MERGE statement. Keep your database up to date and running smoothly.
Take the Advanced SQL Server for Business Intelligence Analysts course: codecrewcareers.com/course/advanced-sql-server-for-business-intelligence-analysts/
Просмотров: 63

Видео

Import CSV Files into SQL Server using Azure Data Studio
Просмотров 1 тыс.4 месяца назад
Quickly import a CSV file into SQL Server using Azure Data Studio's flat file import wizard. Check out our Advanced SQL Server for Business Intelligence Analyst Course: codecrewcareers.com/course/advanced-sql-server-for-business-intelligence-analysts/
How to Install Mongosh on Windows
Просмотров 778Год назад
Quick walkthrough for installing Mongosh How to Install MongoDB Server on Windows ruclips.net/video/8QzDi-cgc44/видео.html 00:04 - Before Starting 00:18 - Navigate to Download Page 00:30 = Find Tools Page 00:55 - Versions of Mongosh 01:00 - Select Windows Platform 01:07 - Select MSI Package 01:45 - Choose Install Location 02:17 - User Install or Computer Install Options 02:50 - Connecting Mongo...
How to Install MongoDB Compass on Windows
Просмотров 359Год назад
Quick walkthrough for installing MongoDB Compass. How to Install MongoDB Server on Windows ruclips.net/video/8QzDi-cgc44/видео.html 00:16 - Why you might want to skip this video 00:58 - Different Editions of MongoDB Compass 01:42 - Other Tools to Consider Downloading 02:12 - Downloading the Microsoft Installer 03:45 - First look at MongoDB Compass Interface
How to Install MongoDB Server on Windows
Просмотров 100Год назад
Full walkthrough of MongoDB Server Install. 00:39 - Downloading the Microsoft MSI 01:26 - Beginning the Install 01:44 - Complete vs Custom Installs 02:23 - Configuring MongoDB as a Microsoft Service 02:57 - Configuring Users 03:52 - Optional MongoDB Compass Install 05:16 - Connecting to MongoDB Server through MongoDB Compass
How to use the json_normalize Function in Pandas
Просмотров 8 тыс.2 года назад
Learn how to flatten JSON files using the pandas json_normalize() function! Link to Jupyter Notebook: github.com/Data-Craftsman-Learn/Pandas-Functions Key Moments: - How to Open JSON Files - 00:55 - Convert JSON Files to Python Dictionary - 01:51 - Hierarchical JSON Structures - 03:26 - Navigating JSON Levels - 04:05 - Flattening JSON Files with json_normalize() - 07:20 - Creating a DataFrame f...
How to Use the read_csv Function in Pandas
Просмотров 2932 года назад
Learn how to use all parameters in the Pandas read_csv() Function! We walk through examples for each parameter. Comprehensive Guide: github.com/Data-Craftsmans-Guild/pandas-deep-dive/blob/main/read_csv()/read_csv.md Key Moments - Basics of read_csv() - 00:47 - Opening Tab Separated Files - 02:09 - Opening Space Separated Files - 03:26 - Defining Column Headers - 04:27 - Defining Multiple Column...
How to Install Git on Windows 10
Просмотров 3,1 тыс.2 года назад
Install the industry standard version control system, git! Learn how to clone a remote repository: ruclips.net/video/IcoRmuDAGQ4/видео.html
How To Create Users and Logins in SQL Server 2019
Просмотров 2,2 тыс.3 года назад
Data Security is extremely important, but for companies to capture data driven insights, they need to grant data access to certain people in the organization. Learn how to manage database users and logins in SQL Server 2019 so that data analysts have appropriate access to data.
How to Create Schemas in SQL Server 2019
Просмотров 2,6 тыс.3 года назад
Organize your databases with Schemas
How to Extract Phone Numbers Using Regular Expressions in Python
Просмотров 6 тыс.3 года назад
Learn how to search through a text file and pull out phone numbers in a structured data format! Subscribe for more tips and how to videos here: ruclips.net/channel/UCbfcR3OcQwgHvUT9skblhSA
How to Open JSON Files Into Python
Просмотров 1,7 тыс.3 года назад
Data Engineers are primarily responsible for data flows. Python makes this task a bit more manageable with its various libraries for extracting and manipulating data. In this video, we discuss how the Pandas library can be used to extract data and transform data.
Machine Learning Workflow
Просмотров 1,5 тыс.3 года назад
Realizing data driven opportunities starts with a solid understanding of how the process works. In this video, we discuss the steps to creating and implementing a Machine Learning Solution. What is the role of a data scientist? What is the role of a Data Engineer?
Sqlite Studio Features
Просмотров 6 тыс.3 года назад
Learn about the Features of SQLite Studio and how you can manage your databases using this GUI. Subscribe for more tips and how to videos here: ruclips.net/channel/UCbfcR3OcQwgHvUT9skblhSA
How to Connect SQLite to Your Web Application
Просмотров 14 тыс.3 года назад
Learn how to support your web applications with SQLite Subscribe for more tips and how to videos here: ruclips.net/channel/UCbfcR3OcQwgHvUT9skblhSA
How to Import SQLite Databases from SQL Scripts
Просмотров 10 тыс.3 года назад
How to Import SQLite Databases from SQL Scripts
How to Install SQLite Studio on Windows 10
Просмотров 16 тыс.3 года назад
How to Install SQLite Studio on Windows 10
How to Install SQLite on Windows 10
Просмотров 1,2 тыс.3 года назад
How to Install SQLite on Windows 10

Комментарии

  • @Sara-o6h7t
    @Sara-o6h7t Месяц назад

    what would you need to do to be able to deploy this app so that is still updates the database file but it can be accessed from any device with a url? i'm a student working on a very similar project with SQLite, python and Html and it works great when i test it locally but i need to be able to access it from multiple devices and when i deploy it on free hosting platform like Render, none of my changes actually update in the database... i'm assuming that is because i am using free instances that spin down with inactivity and therefore loose all the data generated during that instance but would there be a way to connect the database to a cloud and save changes that way without having to pay anything extra?

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

      There are very few free deployment options out there. My recommendation would be to try out Heroku. Instead of using SQLite, you will probably have to switch to a Postgres or MySQL Database. But these are hosted by Heroku which will prevent data loss. You may still need to pay for Heroku, but it will likely be on the cheaper side and it works really well for flask and Django applications. On that note, SQLite is best for local applications and testing.

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

    i am doing this on ubuntu and when i right click i just get first 4 options, i dont see any other options including import wizard and other stuff

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

    Thankyou sir

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

    Hi, is there any chance you could share the code with me? Working on a project similar to this.

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

      Hey! It’s been a while since this video was recorded. I’ve since deleted the code. Would have probably been a good idea to keep it 😅

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

      @@SQLPro1 Aww no bother, thanks anyway.

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

    hi there , how the json flatten file is created ? or when can I download that file ?

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

    Thanks for the quick and very informative video!

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

    Excellent! could you please share the github link with this repo? The one in the description is down. :(

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

      Thank you for bringing this to my attention! I've fixed the link to the repo. I'll post the link here as well. The dataset for this video is large so you will have to download that directly from the source. The link should be on the readme. Thank you! github.com/Data-Craftsman-Learn/Pandas-Functions

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

    Hello thx for this video !!! But how can I parse all the records for each rows ? and then the result will be in one table I would like to have it in one DataFrame instead many different data frames =) I mean will have all levels values in one table, like matrix u know... if I have so many levels (~10+) data.key data.doc_count data.1.buckets data.2.values.50.0 0 name1 1992 [{'key_as_string': '2024-01-19T00:00:00.000+02... 98.268412 1 name2 2209 [{'key_as_string': '2024-01-19T00:00:00.000+02... 99.674954 2 name3 2282 [{'key_as_string': '2024-01-19T00:00:00.000+02... 99.909242 3 name4 2294 [{'key_as_string': '2024-01-19T00:00:00.000+02... 100.000000

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

    11 minutes in, great video brother

  • @Brandy-lm5yb
    @Brandy-lm5yb 9 месяцев назад

    This video was incredibly helpful thank you.

  • @ErikS-
    @ErikS- 10 месяцев назад

    skip to 6:55...

  • @brucestuff
    @brucestuff 11 месяцев назад

    This is pairing nicely with my coursera : python for datascience course.

  • @ADITYACHAUDHARY-gs4pk
    @ADITYACHAUDHARY-gs4pk Год назад

    Bro a beginner won't be able to understand anything

    • @SQLPro1
      @SQLPro1 Год назад

      Hi Aditya, thank you for taking the time to comment on the video. It is a little bit more of an advanced concept. I personally could have made the video simpler, but if anyone at the beginner level has questions, I’m happy to answer.

    • @ADITYACHAUDHARY-gs4pk
      @ADITYACHAUDHARY-gs4pk Год назад

      @@SQLPro1 I understand your point completely , not an issue ...

  • @ianslabel9766
    @ianslabel9766 Год назад

    I have a tab separated csv file. When I import it to pandas, the column headers are off by one. The first column headers is empty, and the second column has the first co header name, the 3rd col has the second col header name. What should I do about that?

    • @SQLPro1
      @SQLPro1 Год назад

      Hard to know the exact issue without seeing what the file looks like, but it sounds like there is an extra comma on the first line of the csv. For example: ,col1,col2 Removing the comma should fix the issue in this case.

  • @jesieniar
    @jesieniar Год назад

    We could really use a bigger font Other than that, a great video

  • @BigDataSport
    @BigDataSport Год назад

    Very good content

  • @adriansmith8557
    @adriansmith8557 Год назад

    Is this video available i better than 360p?

    • @SQLPro1
      @SQLPro1 Год назад

      Hi Adrian, there should be options in the video settings for up to 1080p.

  • @kanchanvyas5490
    @kanchanvyas5490 Год назад

    Thank you so much, I have been trying to load my json file for long and failed . This is a very easy and crisp video. Thank you so much.

    • @SQLPro1
      @SQLPro1 Год назад

      Glad to help! Thank you for watching!

  • @aminssssi
    @aminssssi Год назад

    Amazing and simple Thank you

  • @bajanbryan4908
    @bajanbryan4908 2 года назад

    Thank you!

  • @ristoventsel7467
    @ristoventsel7467 2 года назад

    how do u get the answer without the brackets?

    • @ristoventsel7467
      @ristoventsel7467 2 года назад

      and without the "

    • @SQLPro1
      @SQLPro1 2 года назад

      The Regex function returns a list of strings from the larger body of text. To return it without brackets you would just put the position of the phone number you want to return. For example, if you type phone_numbers[0], it would return the first phone number as a string.

    • @4T_JIN
      @4T_JIN Год назад

      What the hell u r doing man😂

  • @jonlbs7
    @jonlbs7 2 года назад

    What is the website you are referring to? :)

    • @jonlbs7
      @jonlbs7 2 года назад

      I found it .. :)

  • @tonyy553
    @tonyy553 2 года назад

    Great explanation! THANK YOU! I'm not searching the installation guide for a screen recording telling me "Just use the default setting" and explaining nothing.

  • @shakojohnny
    @shakojohnny 2 года назад

    Thanks for the tutorial.

    • @shakojohnny
      @shakojohnny 2 года назад

      Do you have a link for the source code?

  • @folaranmi05
    @folaranmi05 2 года назад

    Thank you!

  • @flirk7778
    @flirk7778 2 года назад

    Thank you,❤️

  • @syedadil7256
    @syedadil7256 2 года назад

    Thank you

  • @andrewschroeder3852
    @andrewschroeder3852 2 года назад

    Do I need to download SQLite 3 before SQLite Studio?

  • @clemencetan9274
    @clemencetan9274 2 года назад

    Thank you very much, my dev teacher sent me your link, and what you explained is so helpful.

    • @SQLPro1
      @SQLPro1 2 года назад

      Glad to help!

  • @orderla8877
    @orderla8877 2 года назад

    Thank you. Btw, does sqlite studio have formatting option? Cause in sqlite browser doesn't allow formatting table cell window (above the table, y'know) even though formatting feature exists there overall. Sucks.

    • @SQLPro1
      @SQLPro1 2 года назад

      Hi there, just looking to clarify. What do you mean by formatting?

  • @orderla8877
    @orderla8877 2 года назад

    At last, some American explaining their own stuff)

  • @pondokkoding5023
    @pondokkoding5023 2 года назад

    how about the opposite of that?

  • @Emil8888_P
    @Emil8888_P 2 года назад

    Thank you very much!

  • @heinthantaung8251
    @heinthantaung8251 2 года назад

    Thanks. Very helpful.

  • @ARCSTA
    @ARCSTA 3 года назад

    Can u send me the link to the database copy and paste please

  • @day2daylogic802
    @day2daylogic802 3 года назад

    I finally figured all of this out and I greatly appreciate it. Is there a way to run this data base on Azure Data Studio?

  • @day2daylogic802
    @day2daylogic802 3 года назад

    Nope. I'm getting "sqlite3" is not a recognized as an internal or external command, operable program or batch file

    • @erlkonig7347
      @erlkonig7347 Год назад

      me too, if someone knows the solution, an answer is appreciated. Edit : After setting Environment Variables, you need to restart your PC.

    • @StefanoVerugi
      @StefanoVerugi Год назад

      @@erlkonig7347 did you run sqlite3 from its folder? otherwise you need to set it up in Environment variables (Windows) 3:00

    • @erlkonig7347
      @erlkonig7347 Год назад

      @@StefanoVerugi Thanks for your answer :) It worked after I restarted my computer. I had to edit my comment.

  • @nrzero515
    @nrzero515 3 года назад

    Great! Sir

  • @cesarl.c.847
    @cesarl.c.847 3 года назад

    Great video. To review LoaderDataPlus tool. This tool import flat files and export to SQLITE syntax and other DMBS. Download this tool from tutorial videos on RUclips.