Skip to main content

This Week's Best Picks from Amazon

Please see more curated items that we picked from Amazon here .

Importing .csv files to SQL server

In this I post I will try to demonstrate how we import a .csv file which we downloaded from online to SQL Server.We use the table which we import to do some other SQL practices in the next topics.
We start by creating a database called 'Nobel_Laureates'. Open SQL Server Management Studio and create a new query window by clicking on 'New Query' menu or by hitting 'Ctrl + N' on your keyboard.
Lets create a database called 'Nobel_Laureates' using the following code.

CREATE DATABASE Nobel_Laureates
USE Nobel_Laureates

Now lets download the list of all the Nobel Laureates from online using this link, or by copying and pasting 'https://www.aggdata.com/download_sample.php?file=nobel.csv' on your browser.
The link downloads a .csv file with a name 'nobel.csv' on your default downloads folder.
Once the nobel.csv file is downloaded, We import it to our Database as follows. Right click on the 'Nobel_Laureates' database.



 And go to 'task' and then click on  'import data'.The 'SQL Server Import and Export Wizard' dialogue box pops up.
Read the content and Click Next.


From the Data Source list Select Flat File Sources,click Browse button to select the nobel.csv file from your downloads folder. Leave everything else as it is and click Next.


Leave everything as it is and click Next.

 Leave everything as it is and click Next.

Leave everything as it is and click Finish.



Now You have the 'nobel' table in your database.





Popular posts from this blog

The Curse of Dimensionality: Why More Data Isn’t Always Better in Data Science

In data science, the phrase "more data leads to better models" is often heard. However, when "more data" means adding dimensions or features, it can lead to unexpected challenges. This phenomenon is known as the Curse of Dimensionality , a fundamental concept that explains the pitfalls of working with high-dimensional datasets. Let’s explore the mathematics behind it and practical techniques to overcome it. What is the Curse of Dimensionality? 1. Volume Growth in High Dimensions The volume of a space increases exponentially as the number of dimensions grows. For example, consider a unit hypercube with side length \(r = 1\). Its volume in \(d\)-dimensions is: \[ V = r^d = 1^d = 1 \] However, if the length of the side is slightly reduced, say \(r = 0.9\), the volume decreases drastically with increasing \(d\): \[ V = 0.9^d \] For \(d = 2\), \(V = 0.81\); for \(d = 10\), \(V = 0.35\); and for \(d = 100\), \(V = 0.00003\). This shows how...
Read more

Intelligent Agents and Their Application to Businesses

Intelligent agents, as a key technology in artificial intelligence (AI), have become central to a wide range of applications in both scientific research and business operations. These autonomous entities, designed to perceive their environment and adapt their behavior to achieve specific goals, are reshaping industries and driving innovation. This post provides a detailed analysis of the current state of intelligent agents, including definitions, theoretical and practical perspectives, technical characteristics, examples of business applications, and future prospects. Definitions and Terminology Intelligent agents are broadly defined as autonomous systems that can perceive and interact with their environments using sensors and actuators. Their autonomy enables them to make decisions and execute actions without constant human intervention. They operate with a specific goal or objective, which guides their decision-making processes. These entities may exi...
Read more

Role of Fourier Transform in Speech Recognition

Speech recognition has become an integral part of modern technology, from voice assistants to transcription services. A key mathematical tool enabling these advancements is the Fourier Transform (FT), particularly its variant, the Short-Time Fourier Transform (STFT). The Fourier Transform provides a way to convert speech signals from the time domain to the frequency domain, allowing us to extract meaningful features for analysis and recognition. Why Use Fourier Transform in Speech Recognition? Speech signals are inherently time-domain signals, with varying amplitude over time. However, speech carries crucial information in its frequency content, such as phonemes, tones, and pitch. The Fourier Transform enables us to analyze these characteristics by breaking the signal into its constituent frequencies. The Fourier Transform is widely used in speech recognition for: Spectrogram Generation: Converting speech signals into visual representations of frequency over time. Fea...
Read more