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. What is SQL and its sub languages
  2. Install MS SQL Server
  3. SQL Select Command
  4. SQL Select Functions (Top, Count, Distinct, Min and Max)
  5. SQL: Where Clause
  6. SQL: Aggregates, Group By, and Having
  7. SQL: Case Statement
  8. SQL: Intro to Joins
  9. SQL: 4 Types of Joins
  10. SQL: Coalesce
  11. SQL: Stored Procedures
  12. SQL: User Defined Functions
  13. SQL: Create a View
  14. SQL: Working with Date/Time Functions
  15. SQL: Learn to use Cursors – List table names
  16. SQL: Reindex a Database
  17. SQL Server: Importing Excel File to SQL Server

DDL and DML

  1. SQL: What is DDL and DML
  2. SQL: Common Data Types in MySQL 
  3. SQL: Create a Table in SQL
  4. SQL: Add, rename, or remove a column from an existing table
  5. SQL: Load/Insert data into table
  6. SQL: Drop, Delete, and Truncate data
  7. SQL: Undo a Mistake in SQL with Rollback and Commit

Advanced SQL

  1. XML Parsing: Advanced SQL
  2. SQL: Check if table exists
  3. SQL: Check if table exists MySQL
  4. SQL Server: Linked Servers
  5. SQL: Create Temporary Table

One thought on “SQL

  1. Pingback: MS SQL Server: Installation – Analytics4All

Leave a Reply