Rx Note

Introduction In today's digital world, we constantly generate information, from swiping credit cards to browsing the web. This abundance necessitates the ability to analyze and interpret it into actionable insights. Data: The Foundation “Data! Data! Data!... I can't make bricks without clay!"—— Sherlock Holmes via Sir Arthur Conan Doyle Now, data science, the discipline of making data useful, is an umbrella term that encompasses 3 disciplines. Statistics Helps make informed decisions with some uncertainty Machine learning Automates decision-making for large datasets with inherent uncertainties Analytics Explores data to uncover potential insights that can guide decision-making Essentially, data is a collection of facts and information. Only with data, conclusions can be drawn for the best way forward (data-driven decicion). In everyday life, an allergic reaction prompts us to avoid the allergen in the future. In businesses, companies use data analytics to improve processes...

Introduction Structured Query Language (SQL) empowers data analysts to communicate with their databases. While spreadsheets (e.g. Microsoft Excel and Google Sheets) offer data storage and management, databases excel at handling larger and more complex datasets. Popular SQL programs include MySQL , Microsoft SQL Server and BigQuery . SQL Statements Database actions are primarily performed using SQL statements, which consist of easy-to-understand keywords like: Database CREATE DATABASE - Creates a new database. BACKUP DATABASE - Creates a backup of an existing database DROP DATABASE - Deletes an existing database. Table CREATE TABLE - Creates a new table within a database. ALTER TABLE - Modifies an existing table. DROP TABLE - Deletes a table from a database. TRUNCATE TABLE - Delete the data inside a table, but not the table itself. Data SELECT - Extracts data from a database SELECT DISTINCT - Returns only distinct (different) values UPDATE - Updates existing data in a databa...