SQL

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

  1. Install MS SQL Server
  2. SQL Select Command
  3. SQL Select Functions (Top, Count, Distinct, Min and Max)
  4. SQL: Where Clause
  5. SQL: Aggregates, Group By, and Having
  6. SQL: Case Statement
  7. SQL: Intro to Joins
  8. SQL: 4 Types of Joins
  9. SQL: Stored Procedures
  10. SQL: Create a View
  11. SQL: Working with Date/Time Functions
  12. SQL: Learn to use Cursors – List table names
  13. SQL: Reindex a Database

Please Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s