Tag Archives: SQL server

SQL Basics – Part 2: Create Tables and Variables and more

We’ll dive into CREATE command. We’ll ‘Create’ Tables, Temp Tables, Table Variables and Variables. We are going to ‘Insert’ data into this table (INSERT INTO) and we’ll occasionally ‘DROP’ the tables

FAIR USE-
“Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.”

Advertisements

Build me a Database

A business leader wants a database

What is a Database?
A database is a collection of data. That may sound overly simplistic but it pretty much sums up what any database is.

Different type of databases: Oracle, SQL Server, MS Access, MySQL, Postgresql etc.

Oracle databases are the de facto standard for large Internet sites, and Oracle advertisers are boastful but honest when they proclaim,

The Internet Runs on Oracle.”

-FAIR USE-
“Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.”