好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02  (Read 4984 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
USA LaoTu 同学受益多多的好课: 微软 T-SQL Database Programming

业界专家经验传给你: 微软 T-SQL  第6期  8:00am to 12:00 noon Sunday 08/05-09/02

把多年业界 微软 T-SQL Database Programming 专家经验传给你。
把你很快带到高级水平,使你的面试脱颖而出,使你在工作中如虎添翼。

Course Content.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
This only gives the outline of what will the course cover, more contents will be added before it starts and the order may change.

1. Introduction to TSQL (class 1~2)
   SELECT
   Aggregations and Grouping
   Working with Strings
   Working with Dates and Times
   Working with Numbers
   Views
   Stored Procedures
   UDF
   Indexes
   Triggers
   
2. Advanced TSQL (class 2~4)
   Elementary Programming
   Working with Nulls
   Querying from Multiple Tables
   Advanced Select Techniques
   Windowing Functions
   Inserting, Updating and Deleting
   Transactions, Locking, Blocking and Deadlocking
   Managing large tables and Database
   Managing indexes
   In-Memory OLTP


3. Query tuning (class 4)
   TO BE ADDED

4. Basic Defensive Database Programming (class 5)
   Code Vulnerabilities
   Defensive Error handling
   Defensive Data Modificatin
   Reusing T-SQL Code
   
Reference:
[1]. Inside Microsoft SQL Server 2012: T-SQL Querying. Steve Kass, Lubor Kollar, Itzik Ben-Gan, Dejan Sarka
[2]. SQL Server T-SQL Recipes, Forth Edition. Jason Brimhall; Jonathan Gennick; Wayne Sheffield
[3]. T-SQL Querying. Itzik Ben-Gan; Adam Machanic; Dejan Sarka; Kevin Farlee.
[4]. Defensive Database Programming with SQL Server. Alex Kuznetsov

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
This class meets 5 times.

Sun, Aug 5, 2018 8:00 AM - 12:00 PM PDT

Sun, Aug 12, 2018 8:00 AM - 12:00 PM PDT

Sun, Aug 19, 2018 8:00 AM - 12:00 PM PDT

Sun, Aug 26, 2018 8:00 AM - 12:00 PM PDT

Sun, Sep 16, 2018 8:00 AM - 12:00 PM PDT

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Class web page is ready. Student can access the class:  tsql_term6.php

The benefit for Old Core Package students: After register this T-SQL class,
-- You will get a free listen of Core Package course (SQL 2017, Oracle 18c, Microsoft Power BI ).
-- You will get one year access of Wednesday Job & Career Counselling webinar.