Skills

Basic SYNTAX

DROP

CREATE

The DROP statement in SQL is used to delete an existing database, table, or index. It permanently removes the specified object from the database.

{ DROP TABLE table_name; }

CREATE

The CREATE statement is used to create a new database, table, or index in the database. It defines the structure and properties of the object being created.

{ CREATE TABLE table_name ( column1 datatype, column2 datatype); }

DELETE

CREATE

INSERT INTO

The DELETE statement is used to delete specific rows from a table based on a specified condition. It removes data from the table but does not delete the table structure.

{ DELETE FROM table_name

WHERE condition; }

INSERT INTO

The INSERT INTO statement is used to insert new rows into an existing table. It adds data to the specified columns or all columns of the table.

{ INSERT INTO table_name (column1, column2, ...)

VALUES (value1, value2, ...); }

SELECT

INSERT INTO

SELECT

The SELECT statement is one of the most fundamental and widely used SQL statements. It is used to retrieve data from one or more tables in the database.

{ SELECT * FROM table_name; }

JOIN

INSERT INTO

SELECT

The JOIN clause is used to combine rows from two or more tables based on a related column between them. It allows you to fetch data from multiple tables simultaneously.

{ SELECT column_name(s)

FROM table1

JOIN table2 ON table1.column_name = table2.column_name; }

SQL vs. MYSQL

ML with Thomas - GUIDE TO SQL and MYSQL (ChatGPT assisted)

SQL (Structured Query Language) is a programming language designed for managing and querying relational databases. It serves as the foundation for various database management systems (DBMS), including MySQL.

MySQL is a specific implementation of a relational database management system based on the SQL language. Here are the main differences between MySQL and SQL:

SQL (Standard): SQL is a standardized language for managing relational databases, and it provides a consistent syntax across different database systems. It defines the general concepts and commands used to interact with relational databases.
MySQL (Specific Implementation): MySQL, on the other hand, is a particular relational database management system that utilizes SQL as its query language. It is developed by Oracle Corporation and is widely used in various applications due to its open-source nature, ease of use, and performance.
Portability: SQL queries written following the standard can be executed in any relational database system that complies with the SQL standard. This portability allows you to migrate from one SQL-compliant database system to another with minimal changes to your queries. However, each database system may have its own extensions and optimizations, so complete portability is not always guaranteed.
Functionality: While SQL defines the core functionalities and commands for interacting with databases, each database system, including MySQL, may offer additional features and functions that are specific to that system. These proprietary extensions can vary, making some features available in one system but not in others.
Applicability: SQL, being a standard language, is widely used in various database systems, not just MySQL. It is suitable for any application that involves relational databases, such as web development, data analysis, and enterprise applications.
Popularity: MySQL is one of the most popular relational database management systems worldwide due to its robust performance, scalability, and open-source nature. It has a large user and developer community, which contributes to its ongoing development and support.

In summary, SQL is the standard language for interacting with relational databases, while MySQL is a specific implementation of a relational database management system that uses SQL as its query language. SQL knowledge is transferable to other database systems, but specific features and optimizations may vary between different implementations like MySQL.

Tableau Basics

ML with Thomas - GUIDE TO Tableau (ChatGPT assisted)

Tableau is a powerful data visualization and business intelligence tool that helps individuals and organizations analyze, visualize, and understand their data. It allows users to connect to various data sources, transform raw data into interactive and meaningful visualizations, and share insights with others. Tableau is designed to be user-friendly, enabling both technical and non-technical users to create insightful dashboards and reports without requiring extensive coding or database expertise.

Uses of Tableau

Data Visualization: Tableau excels at creating visually appealing charts, graphs, maps, and other data visualizations that help users explore trends, patterns, and correlations in their data.
Business Intelligence: Tableau is widely used for business intelligence purposes, providing decision-makers with actionable insights by presenting complex data in an easily understandable format.
Interactive Dashboards: With Tableau, users can design interactive dashboards that allow for dynamic exploration of data. Dashboards can display multiple visualizations on a single canvas, providing a comprehensive view of information.
Ad Hoc Analysis: Tableau's drag-and-drop interface enables users to quickly perform ad hoc analysis by creating visualizations on-the-fly, without the need for predefined reports or queries.
Data Blending: Tableau can connect to and blend data from various sources, such as databases, spreadsheets, cloud services, and more. This enables users to analyze data from different systems in a unified view.
Predictive Analysis: While not as advanced as dedicated predictive analysis tools, Tableau offers basic predictive modeling and forecasting features to help users anticipate future trends based on historical data.

Basics of Tableau Concepts

Tableau is primarily a visual tool, meaning that users create visualizations by dragging and dropping elements onto a canvas. However, there are some key concepts and terminology you should be familiar with:

Data Source: This is the dataset you want to visualize. It can be an Excel spreadsheet, a database table, a web data connector, or another data file.
Dimensions: These are categorical data fields that provide context for your visualizations. Examples include product names, dates, and regions.
Measures: Measures are numerical data fields that you can perform calculations on. Examples include sales revenue, profit, and quantities.
Visualizations: These are the charts, graphs, and maps you create to represent your data. Tableau supports various types of visualizations, such as bar charts, line charts, scatter plots, and more.
Filters: Filters allow you to focus on specific subsets of your data, enabling you to explore different scenarios and trends.
Dashboard: A dashboard is a collection of visualizations, filters, and other elements arranged on a single page. It provides an overview of data insights and allows users to interact with the data.
Calculation Field: Tableau allows you to create custom calculated fields using formulas. These fields can be used for complex calculations or to create new dimensions and measures.
Parameters: Parameters are dynamic values that users can modify to influence the behavior of a visualization. They provide a way to add interactivity to your dashboards.

SKILLS

BASICS OF MYSQL (SQL SYNTAX)

Basic SYNTAX

DROP

CREATE

CREATE

CREATE

CREATE

CREATE

DELETE

CREATE

INSERT INTO

INSERT INTO

INSERT INTO

INSERT INTO

SELECT

INSERT INTO

SELECT

JOIN

INSERT INTO

SELECT

SQL vs. MYSQL

ML with Thomas - GUIDE TO SQL and MYSQL (ChatGPT assisted)

Basics of Tableau

Tableau Basics

ML with Thomas - GUIDE TO Tableau (ChatGPT assisted)

Uses of Tableau

Basics of Tableau Concepts

SKILLS

BASICS OF MYSQL (SQL SYNTAX)

Basic SYNTAX

DROP

CREATE

CREATE

CREATE

CREATE

CREATE

DELETE

CREATE

INSERT INTO

INSERT INTO

INSERT INTO

INSERT INTO

SELECT

INSERT INTO

SELECT

JOIN

INSERT INTO

SELECT

SQL vs. MYSQL

ML with Thomas - GUIDE TO SQL and MYSQL (ChatGPT assisted)

Basics of Tableau

Tableau Basics

ML with Thomas - GUIDE TO Tableau (ChatGPT assisted)

Uses of Tableau

Basics of Tableau Concepts

This website uses cookies.