Post Description

0101. Welcome
0102. Course Overview
0103. Understanding SQL
0104. Understanding TSQL
0105. SQL Server History
0106. Microsoft SQL Server Certifications
0201. Getting SQL Server 2012
0202. Installing SQL Server 2012
0203. Attaching the Sample Database
0204. Getting SQL Books Online Locally
0205. Code Examples
0301. SSMS Tour
0302. Graphical Queries
0303. SSMS Options
0304. Query Results Options
0305. Database Diagrams
0401. Table Design Basics
0402. Creating a Table
0403. Altering Tables
0404. Dropping Tables
0405. Understanding Views
0406. Creating Views pt. 1
0407. Creating Views pt. 2
0408. Dropping Views
0409. Understanding Constraints
0410. Creating Constraints
0411. Understanding Triggers
0412. Trigger Options
0413. Inserted and Deleted Tables
0414. Creating Triggers
0501. The Basic Select Statement
0502. Select Statement Structure
0503. The FROM Clause
0504. The WHERE Clause
0505. WHERE Clause Example
0506. The ORDER BY Clause
0507. ORDER BY Example
0508. The GROUP BY Clause pt. 1
0509. The GROUP BY Clause pt. 2
0510. The HAVING Clause
0511. The Power of LIKE
0601. Using Distinct
0602. Column Aliasing
0603. Using the Top Option
0604. Top Option Example
0605. Using the OFFSET-FETCH Option
0606. Understanding NULLs
0607. Working with NULLs
0608. Using the Case Statement
0609. SELECT INTO
0610. The UNION Statement
0611. Using INTERSECT
0612. Using EXCEPT
0613. Understanding Synonyms
0614. Creating and Using Synonyms
0615. Using Concatenation
0616. Dynamic Queries pt. 1
0617. Dynamic Queries pt. 2
0618. INSERT Into
0701. Understanding GUIDs
0702. NEWID() vs. NEWSEQUENTTIALID()
0703. Using GUIDs
0704. Data Type Basics
0705. Numerical Data Types
0706. Character Data Types
0707. Date and Time Data Types
0708. Binary Data Types
0801. Understanding Joins
0802. Table Aliasing
0803. Inner Joins
0804. Outer Joins
0805. Cross Joins
0806. The Merge Statement pt. 1
0807. The Merge Statement pt. 2
0901. Catalog Views
0902. Information Schema Views
0903. System Stored Procedures
1001. The Basic INSERT Statement
1002. INSERT Examples
1003. The Basic UPDATE Statement
1004. UPDATE Examples
1005. The Basic DELETE Statement
1006. DELETE Examples
1007. Using ROWCOUNT
1101. Scalar Subqueries
1102. Multi-Valued Subqueries
1103. Correlated Subqueries
1201. Understanding Temporary Results Sets
1202. Understanding Derived Tables
1203. Understanding Common Table Expressions
1204. Using CTEs
1205. Understanding Temporary Tables
1206. Table Variables
1207. Temporary Table or Table Variable
1301. Understanding Stored Procedures
1302. Creating a Stored Procedure
1303. Using Input Parameters
1304. Stored Procedure Return Codes
1305. Stored Procedure Permissions
1401. Understanding Functions
1402. Built-in Functions
1403. Scalar Functions Example
1404. Table Valued Functions Example pt. 1
1405. Table Valued Functions Example pt. 2
1501. Understanding Concurrency
1502. Understanding Transactions
1503. Coding Explicit Transactions
1504. Transactions and Locking
1601. Course Wrap Up
1701. About the Author

Voor de \\\'fout bij parsen\\\' probleem: Probeer het een uurtje later. Indien dat nog niet werkt, haal de nzb bij binsearch en ga downloaden. Blijf je je er aan storen, neem een andere server.
Probleem komt een enkele keer vaker voor, ik kan het niet reproduceren en niet iedereen heeft het.