Skip to content

This is my first SQL project. I used clinical trial dataset. Here I have started from the start by learning: Designing a database, Creating table, Adding data to the table, Updating the column name, Altering the data in the table, Defining the questions that is needed to answer, Cleaning the dataset and Performing Exploratory Data Analysis.

Notifications You must be signed in to change notification settings

trinath-panda/Clinical-Trial-SQL-Project-1

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 

Repository files navigation

Clinical-Trial-SQL-Project-1

Welcome to our comprehensive project designed to guide you through the exciting world of SQL learning! Whether you're a beginner eager to explore the foundations of querying databases or a data enthusiast seeking to refine your data analysis skills, this project is your ultimate resource.

In this project, we've curated a wealth of resources and learning paths that cater to various learning styles and skill levels. Our goal is to empower you with the knowledge and techniques required to effectively use SQL for data analysis.

This is my first SQL project. I used a clinical trial dataset. Here I have started by learning: To design a database, Create a table, Add data to the table, Update the column name, Alter the data in the table, Define the questions that need to be answered, Clean the dataset, and Perform Exploratory Data analysis

Tutorial

For a step-by-step tutorial, you can see my YouTube playlist: https://youtube.com/playlist?list=PLWcqrtRKXifUaCVQoUBp-ypMK2d5ZiJBk

This project is for study purposes, and all the data shown and used is . You can also use this for practice and educational purposes.

Read Article

This article shows the results and complete project outcome:

  1. Portfolio: https://trinathp.wixsite.com/trinath-p/portfolio-collections/sql-portfolio/clinical-trial-sql-project
  2. Article: https://trinathp.wixsite.com/trinath-p/post/clinical-trial-data-sql-eda-project

Tool Used

  1. Microsoft SQL server
  2. SQL Server Management Studio (SSMS)

** You can use any SQL platform to perform your project; this is a personal preference.

Social Handle

  1. YouTube Channel: https://www.youtube.com/@trinath_panda_24
  2. Instagram: https://www.instagram.com/trinath_4/
  3. LinkedIn: https://www.linkedin.com/in/trinathpanda24/
  4. Website: https://trinathp.wixsite.com/trinath-p
  5. Git: https://github.com/trinathpanda04/Clinical-Trial-SQL-Project-1

About

This is my first SQL project. I used clinical trial dataset. Here I have started from the start by learning: Designing a database, Creating table, Adding data to the table, Updating the column name, Altering the data in the table, Defining the questions that is needed to answer, Cleaning the dataset and Performing Exploratory Data Analysis.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published