USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 坚定正确的转行方向 高薪捷径 视频试看 => Topic started by: USA LaoTu Support Team 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
-
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