自2006年至今, 帮全球无数人能做会说高薪转行做数据, 进大公司! inquiries@usalaotu.com 650-648-3646
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
首页
首页 Home page
学生登录 Student login
注册新课 Register course
联系我们 Contact us
注册新课
Help
Calendar
Login
Register
USA LaoTu 高薪转行做数据第一平台
»
只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司!
»
注重实战的教学作风 新开课程 时间内容
»
业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text
« previous
next »
Print
Pages: [
1
]
Author
Topic: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02 (Read 5316 times)
USA LaoTu Support Team
Administrator
Hero Member
Posts: 4810
Karma: +35/-11
业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
«
on:
July 08, 2018, 08:36:36 PM »
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.
Logged
USA LaoTu Support Team
Administrator
Hero Member
Posts: 4810
Karma: +35/-11
Re: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
«
Reply #1 on:
July 29, 2018, 11:56:14 AM »
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
Logged
USA LaoTu Support Team
Administrator
Hero Member
Posts: 4810
Karma: +35/-11
Re: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
«
Reply #2 on:
August 01, 2018, 10:58:11 AM »
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
Logged
USA LaoTu Support Team
Administrator
Hero Member
Posts: 4810
Karma: +35/-11
Re: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
«
Reply #3 on:
August 01, 2018, 07:09:37 PM »
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.
Logged
Print
Pages: [
1
]
« previous
next »
USA LaoTu 高薪转行做数据第一平台
»
只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司!
»
注重实战的教学作风 新开课程 时间内容
»
业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02