課程名稱 |
簡介 |
版本 |
講師 |
試讀 |
上課 |
SQL Server資料庫概論之一:資料庫系統 |
|
2016 |
蘇紘賢 |
|
|
SQL Server資料庫概論之二:關聯式資料庫模型 |
|
2016 |
蘇紘賢 |
|
|
SQL Server資料庫概論之三:實體關聯模型與正規化 |
|
2016 |
蘇紘賢 |
|
|
SQL Server資料庫概論之四:SQL Server資料庫管理系統 |
|
2016 |
蘇紘賢 |
|
|
SQL Server資料庫概論之五:資料庫設計工具的使用 |
|
2016 |
蘇紘賢 |
|
|
SQL Server資料庫概論之六:SQL語言與資料庫建置 |
|
2016 |
蘇紘賢 |
|
|
SQL Server資料庫概論之七:建立資料表與完整性限制條件 |
|
2016 |
蘇紘賢 |
|
|
20761 Module 1:Introduction to Microsoft SQL Server 2016 |
|
2016 |
楊志強 |
|
|
20761 Module 2:Introduction to T-SQL Querying |
|
2016 |
楊志強 |
|
|
20761 Module 3:Writing SELECT Queries |
|
2016 |
楊志強 |
|
|
20761 Module 4:Querying Multiple Tables |
|
2016 |
楊志強 |
|
|
20761 Module 5:Sorting and Filtering Data |
|
2016 |
楊志強 |
|
|
20764 Module 1: SQL Server Security |
|
2016 |
林傳宗 |
|
|
20764 Module 2: Assigning Server and Database Roles |
|
2016 |
林傳宗 |
|
|
20764 Module 3: Authorizing Users to Access Resources |
|
2016 |
林傳宗 |
|
|
20764 Module 4: Protecting Data with Encryption and Auditing |
|
2016 |
林傳宗 |
|
|
20764 Module 5: Recovery Models and Backup Strategies |
|
2016 |
林傳宗 |
|
|
20764 Module 6: Backing Up SQL Server Databases |
|
2016 |
林傳宗 |
|
|
20764 Module 7: Restoring SQL Server 2016 Databases |
|
2016 |
林傳宗 |
|
|
20761 Module 6: Working with SQL Server Data Types |
|
2016 |
蘇紘賢 |
|
|
20764 Module 8: Automating SQL Server Management |
|
2016 |
林傳宗 |
|
|
10774 Module 1:Introduction to Microsoft SQL Server 2012 |
|
2012 |
楊志強 |
|
|
10774 Module 2:Introduction to Microsoft SQL Server Azure |
|
2012 |
楊志強 |
|
|
10774 Module 3:Introduction to Transact SQL Querying |
|
2012 |
楊志強 |
|
|
10774 Module 4:Writing SELECT Statements |
|
2012 |
楊志強 |
|
|
10774 Module 5:Querying Multiple Tables |
|
2012 |
楊志強 |
|
|
10774 Module 6:Sorting and Filtering Data |
|
2012 |
楊志強 |
|
|
10774 Module 7:Working with SQL Server Data Types |
|
2012 |
楊志強 |
|
|
10774 Module 8:Using Built-In Functions |
|
2012 |
楊志強 |
|
|
10774 Module 9:Grouping and Aggregating Data |
|
2012 |
楊志強 |
|
|
10774 Module 10:Using Subqueries |
|
2012 |
楊志強 |
|
|
10774 Module 11:Using Table Expressions |
|
2012 |
楊志強 |
|
|
10774 Module 12:Using Set Operators |
|
2012 |
楊志強 |
|
|
10774 Module 13:Using Window Ranking, Offset and Aggregate Functions |
|
2012 |
楊志強 |
|
|
10774 Module 14:Pivoting and Grouping Sets |
|
2012 |
楊志強 |
|
|
10774 Module 15:Querying SQL Server Metadata |
|
2012 |
楊志強 |
|
|
10774 Module 16:Executing Stored Procedures |
|
2012 |
楊志強 |
|
|
10774 Module 17:Programming with T-SQL |
|
2012 |
楊志強 |
|
|
10774 Module 18:Implementing Error Handling |
|
2012 |
楊志強 |
|
|
10774 Module 19:Implementing Transactions |
|
2012 |
楊志強 |
|
|
10774 Module 20:Improving Query Performance |
|
2012 |
楊志強 |
|
|
10775 Module 1:Introduction to SQL Server 2012 and Its Toolset |
|
2012 |
楊志強 |
|
|
10775 Module 2:Preparing Systems for SQL Server 2012 |
|
2012 |
楊志強 |
|
|
10775 Module 3:Installing and Configuring SQL Server 2012 |
|
2012 |
楊志強 |
|
|
10775 Module 4:Working with Databases |
|
2012 |
楊志強 |
|
|
10775 Module 5:Understanding SQL Server 2012 Recovery Models |
|
2012 |
楊志強 |
|
|
10775 Module 6:Backup of SQL Server 2012 Databases |
|
2012 |
楊志強 |
|
|
10775 Module 7:Restoring SQL Server 2012 Databases |
|
2012 |
楊志強 |
|
|
10775 Module 8:Importing and Exporting Data |
|
2012 |
楊志強 |
|
|
10775 Module 9:Authenticating and Authorizing Users |
|
2012 |
楊志強 |
|
|
10775 Module 10:Assigning Server and Database Roles |
|
2012 |
楊志強 |
|
|
10775 Module 11:Authorizing Users to Access Resources |
|
2012 |
楊志強 |
|
|
10775 Module 12:Auditing SQL Server Environments |
|
2012 |
楊志強 |
|
|
10775 Module 13:Automating SQL Server 2012 Management |
|
2012 |
楊志強 |
|
|
10775 Module 14:Configuring Security for SQL Server Agent |
|
2012 |
楊志強 |
|
|
10775 Module 15:Monitoring SQL Server 2012 with Alerts and Notifications |
|
2012 |
楊志強 |
|
|
10775 Module 16:Performing Ongoing Database Maintenance |
|
2012 |
楊志強 |
|
|
10775 Module 17:Tracing Access to SQL Server 2012 |
|
2012 |
楊志強 |
|
|
10775 Module 18:Monitoring SQL Server 2012 |
|
2012 |
楊志強 |
|
|
10775 Module 19:Managing Multiple Servers |
|
2012 |
楊志強 |
|
|
10775 Module 20:Troubleshooting Common SQL Server 2012 Administrative Issues |
|
2012 |
楊志強 |
|
|
10777 Module 1&2:Data Warehousing and Hardware Design |
|
2012 |
楊志強 |
|
|
10777 Module 3:Designing and Implementing a Data Warehouse |
|
2012 |
楊志強 |
|
|
10777 Module 4:Creating an ETL Solution with SSIS |
|
2012 |
楊志強 |
|
|
10777 Module 5:Implementing Control Flow in an SSIS Package |
|
2012 |
楊志強 |
|
|
10777 Module 6:Debugging and Troubleshooting SSIS Packages |
|
2012 |
楊志強 |
|
|
10777 Module 7:Implementing an Incremental ETL Process |
|
2012 |
楊志強 |
|
|
10777 Module 8:Incorporating Data from the Cloud into a Data Warehouse |
|
2012 |
楊志強 |
|
|
10777 Module 9:Enforcing Data Quality |
|
2012 |
楊志強 |
|
|
10777 Module 10:Using Master Data Services |
|
2012 |
楊志強 |
|
|
10777 Module 11:Extending SQL Server Integration Services |
|
2012 |
楊志強 |
|
|
10777 Module 12:Deploying and Configuring SSIS Packages |
|
2012 |
楊志強 |
|
|
10777 Module 13:Consuming Data in a Data Warehouse |
|
2012 |
楊志強 |
|
|