A web application for the Andela bootcamp Cohort-XIII

basic sql queries 🏬

Learning SQL basics, intermediate and advance with hands on experience with t-sql version.

A repository with SQL examples.

A collection of simple SQL queries.

Few more basic additional MS-SQL queries in addition to my previous repository to help beginners understand the concepts more deeply.Here we make use of readily available database 'WideWorldImportersDW-Full.bak' to perform our SQL queries.

Exercise in writing SQL queries to extract data results from joined tables.

Modéliser, créer et requêter une base de données avec SQL

This module covers performing descriptive analytics on time series data, geospatial data, complex data types (arrays, JSON, and JSONB), and text.

The course will help you uncover insights in a sample dataset using a case study approach. You will use all SQL queries to understand the cause for the dip in the pre-sales.

This module covers how to assemble multiple tables into a dataset using SQL queries. It also introduces how to transform and clean data using SQL functions.

In this project, we use MySQL Workbench to design the UML diagram, build the database (tables of customers, deliverers, dishes, orders and order quantities) and finally make SQL queries on the client and server side.

Data Normalization and SQL Queries on Healthcare Data

Relational Database

Developed an SQL engine that will run a subset of SQL queries using command-line interface

Data analysis for the Sakila Database which is a nicely normalised schema modelling a DVD rental store, featuring things like films, actors, film-actor relationships, and a central inventory table that connects films, stores, and rentals using tools like Excel used to view the data and create insert queries for all the tables and then by using SQL

It contains all the higher level programming projects that I have worked on during my 12 months SE training at ALX-Africa. Mostly it is Python.

Explore a comprehensive HR Analytics portfolio showcasing data analysis and visualization skills. Featuring dashboards in Power BI, Excel, and Tableau, along with SQL queries for deeper insights. A holistic view of expertise in HR analytics, data visualization, and database management. Let's dive into the game of data insights!

This project acted as practice for basics of creating queries using SQLite syntax

Relational Schema and Queries on car rental company data