SQL Tutorials for Citizen Data Scientists

Beginners Guide to SQL – SQL SELECT Statement

Hits: 6 (SQL Tutorials for Citizen Data Scientist) SQL SELECT Statement In this tutorial you will learn how to select records from database tables using SQL. Selecting Data from Table In the previous chapter we’ve learned how to insert data in a database table. Now it’s time to select the data from existing tables using the SQL …

Beginners Guide to SQL – SQL INSERT Statement

Hits: 9 (SQL Tutorials for Citizen Data Scientist) SQL INSERT Statement In this tutorial you will learn how to insert records in a database table using SQL. Inserting Data in Table In the preceding chapter we’ve created a table named persons in our demo database. Now it’s time to insert some data inside our newly created database table. The INSERT INTO statement is used to …

Beginners Guide to SQL – SQL CREATE TABLE Statement

Hits: 11 (SQL Tutorials for Citizen Data Scientist) SQL CREATE TABLE Statement In this tutorial you will learn how to create a table inside the database using SQL. Creating a Table In the previous chapter we have learned how to create a database on the database server. Now it’s time to create some tables inside our database …

Beginners Guide to SQL – SQL CREATE DATABASE Statement

Hits: 13 (SQL Tutorials for Citizen Data Scientist) SQL CREATE DATABASE Statement In this tutorial you will learn how to create database in a relational database management system like, MySQL, SQL Server, etc. using SQL. Creating a Database Before doing anything with the data we must need to create a database first. We’re assuming that you already …

Beginners Guide to SQL – SQL Syntax

Hits: 10 (SQL Tutorials for Citizen Data Scientist) SQL Syntax The syntax of SQL is governed by the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO). SQL Statements SQL statements are very simple and straightforward like plain English but with specific syntax. An SQL statement is composed of a sequence of keywords, …