Gain insights into SQL by exploring database creation, data manipulation, and advanced queries. Learn about practical applications and practice for SQL interviews to build confidence and readiness.

sql.tar.gz

The ability to work SQL is becoming an increasingly in-demand skill, both for software developers and people in less technical roles. If you’re interested in learning SQL and have no prior experience with it, then this course will be your light in a dark tunnel.

You’ll start by covering the basics of SQL such as how to create a database, how to insert, query, and update data. You’ll also learn fundamental concepts that developers and data scientists use everyday such as multi-table operations, nested queries, and how to set up views. 

Throughout, you’ll get to execute SQL queries in your browser and see results in real-time - you won’t need to worry about set-up.

At the end of this course, you’ll also get some hands-on practice with common SQL interview questions, so when the time comes, you’ll be ready and confident to answer any question that comes your way. Let’s get started!

An Introductory Guide to SQL


# MySQL history & architecture   
SQL stands for Structured Query Language but was initially conceptualized as SEQUEL Structured English Query Language. The name was changed from SEQUEL to SQL because another company already held the copyright to SEQUEL. SQL was originally developed by two IBM engineers to manipulate data stored in an IBM-developed database, which was somewhat based on the relational model for databases.


# SQL standard and implementations
  
SQL was accepted as a standard by ANSI in 1986 and ISO in 1987. It has been revised a number of times. Various companies have created implementations of this standard. The standard can be thought of as the blueprint that describes the behavior while the actual implementation consists of __MySQL__, __SQL Server__, __PostgreSQL__, etc.

The implementations by various vendors are similar because they all conform to the same standard. There are some differences in syntax though. Popular implementations include __Oracle RDBMS__, __IBM DB2__, __Microsoft SQL Server__, __Teradata__, and __MySQL__. 

SQL is important because many companies have databases based on the relational model that are powered by SQL related technologies.


In this lesson, we describe the overall architecture of MySQL RDBMS.

Introduction

Basic SQL

Joins

Nested Queries

Multi Table Operations

Views

Stored Procedures

Triggers

Miscellaneous

Practice & Prep

Epilogue

MySQL History & Architecture

MySQL history & architecture

SQL standard and implementations