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
- 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
Advanced SQL
Advertisements