Tag database

Data, Development

Restoring a Backup in SQL Server Management Studio

Before I write tutorials on SQL, the first step is showing how to restore a backup file in SQL Server Management Studio so we can dig into SQL queries and business/data analytics.

Teylor Feliz
December 5, 2023

Data, Development

A Style Guide for SQL Development and Data Analysis

A lot of people without technical backgrounds are learning SQL for data analysis or retrieving data from databases.

Teylor Feliz
August 23, 2023

Business, Data

Where to Start in Data Science, Data Analysis, and Business Intelligence

Believe it or not, a lot of data analysis can be done with Excel without having to jump into Python or R. Most of the time, a pivot table in Excel can answer the business questions needed by management to make timely decisions.

Teylor Feliz
September 16, 2021

Data, Development

What Is the Difference Between Database, Database Management System, and Database System?

The importance of the distinction depends on the context. For example, normally this is not very important and most people use database systems, interchangeably with database and DBMS.

Teylor Feliz
August 15, 2021

General

More Than Just Web Development and Web Design

One of my first jobs in the IT field doing queries into a large database for a telephone company. Something that could be called Big Data and my job was to get insights out of it like a data engineer, data scientist, or data analyst.

Teylor Feliz
August 11, 2021