Author Topic: Content of SQL Server 2012 T-SQL Programming  (Read 11566 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3969
  • Karma: +35/-11
Content of SQL Server 2012 T-SQL Programming
« on: March 18, 2014, 08:36:42 AM »
SQL Server 2012 T-SQL Programming

Teacher has more than 15 years Database Analysis/Development experience in many large USA companies.
After SQL server 2012 SQL course, the purpose of this five sessions course is show you real world skills and cases of how to use T-SQL, bring your T-SQL skill to a new advanced level, make you ready for database analyst jobs need T-SQL skills.
8:00am to 12:00 noon (USA PST), Sunday

Five 4 hour sessions, total 20 hours.

Class content:

1. Overal View
   Migration of Database
   Data type
     Date
     Strings
     Numeric
   SQL server built in functions
   DDL,  DML, Control Language
   
   Project: Billing System Reconcilition

2. SQL server objects
   Function
   Procedure
   Prigger
   Views
   Sequence
   Index

   Project: Web Application (password, table function)

3  SQL Server Objects (continued)
   Cursor
   Set operation
   Analytic Function
   Hirerachical query
   Pivotal query

   Peoject: A DW application(Type 2 Inert)

4. Error Handling and Debugging
   Legacy Error Handling
   The Raiseerror Statment
   Try Catch
    Debugging Tools
    Danamic SQL

   Project: a QA application(Dynamic SQL)

5. Performance
   General Guide Line
   Database Design Performance Tips
   Index Performance Tips
   Select Performance Tips
   Insert Performance Tips
   Cursor Performance Tips

   Peoject: A cognos reporting application (DOC HIST)

Registration: http://student.usalaotu.com/make_payment.php

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3969
  • Karma: +35/-11
Re: Content of SQL Server 2012 T-SQL Programming
« Reply #1 on: October 15, 2015, 09:40:29 PM »
Below is the outline of  this course:

Transact SQL Programming

Chapter 01 Introduction to T-SQL
    Brief History
    SQL 3VL
    T-SQL Control-Folw-Language
    SQL Server 2014 Environment and Tools for T-SQL(SSMS)
    Logical Query Processing
    Cases Demo

Chapter 02 -  Transact-SQL Programming Constructs
    Basic T-SQL Programming Constructs
      Database and Main Objects for T-SQL querying
      Data Types -- All Data Type Demo
      Control-Flow-Statement
      Cursor
   Composite T-SQL Constructs
      Batches, Scripts, and Transactions

Chapter 03 - Importing and Exporting File Data Sources
    BCP, Bulk Insert, xp_cmdshell, etc
    Rowset Functions (Openquery, OpenRowset, OpenDatasource) vs. Linked Server
    Project: Load/Query Excel files

Chapter 04 - Querying Tables with SELECT and Multiple Tables With Joins
        Information_Schema.Columns/Tables
        TOP and OFFSET-FETCH
        GO N
        Objects_Find
        TABLE Joins vs Set Operators

Chapter 05 - Using Functions and Aggregating Data
Chapter 06 - Using Subqueries and APPLY
Chapter 07 - Grouping, Pivoting and Windowing
Chapter 08 - Data Modification
Chapter 09 - Programming with Transact-SQL
Chapter 10 - Error Handling and Transactions
Chapter 11 - Query Tuning
Chapter 12 - T-SQL for BI
Chapter 14 - Graphs and Recursive Queries
Chapter 14 - Programmable Objects
Chapter 15 - Project -- Migrate SQL Server Database Data