SQL (Structured Query Language) is one of the most common languages found in the data profession. Don’t let the NoSQL chatter scare you away from learning SQL, as the appearance of applications such as SQL on Hadoop are testimony that no matter what the underlying data structure, SQL is still going to have a strong presence in the data world
Automating Data Preparation with SQL Server
Getting Full Days Worth of Data
MS SQL Server: Database Diagrams
Simple Methods to Recover MDF File Password
Intro to SQL
- What is SQL and its sub languages
- Install MS SQL Server
- SQL Select Command
- SQL Select Functions (Top, Count, Distinct, Min and Max)
- SQL: Where Clause
- SQL: Aggregates, Group By, and Having
- SQL: Case Statement
- SQL: Intro to Joins
- SQL: 4 Types of Joins
- SQL: Coalesce
- SQL: Stored Procedures
- SQL: User Defined Functions
- SQL: Create a View
- SQL: Working with Date/Time Functions
- SQL: Learn to use Cursors – List table names
- SQL: Reindex a Database
- SQL Server: Importing Excel File to SQL Server
DDL and DML
- SQL: What is DDL and DML
- SQL: Common Data Types in MySQL
- SQL: Create a Table in SQL
- SQL: Add, rename, or remove a column from an existing table
- SQL: Load/Insert data into table
- SQL: Drop, Delete, and Truncate data
- SQL: Undo a Mistake in SQL with Rollback and Commit
Pingback: MS SQL Server: Installation – Analytics4All