International Customers: Have a Sales Question? Request a Call.

Are you sure you want to cancel your subscription?

Sorry to see you go

Your subscription will remain active until . If you change your mind, you may rectivate your subscription anytime before that date.

Are you sure you want to reactivate?

Welcome Back!

Your subscription has been reactivated and you will continue to be charged on .

Reactivate Subscription

Thank you for choosing to reactivate your subscription. In order to lock in your previous subscription rate, you owe: .

Your Subscription term is from - .

Questions? Call Sales.

541-284-5522

Payment Due:

OK

Auto-Renew Subscription

To auto-renew your subscription you need to select or enter your payment method in "Your Account" under Manage Payments.

Click continue to set up your payments.

CONTINUE

CANCEL

Microsoft Database SQL Server 2008 Develop 70-433

Database training for Microsoft's SQL Server 2008

Julie Johnson

CBT Nuggets Trainer

"Hello, and thank you for giving me the opportunity to share with you my technical knowledge. I have a passion for programming languages which dates back to computer camp in the fourth grade! (Aut... Read more.

Every database administrator dreams about zero downtime. With SQL Server 2008 that dream can be yours. SQL's self-management features eliminate much of your database busy work, giving you the time you need to keep your databases secure and running smoothly.

Get the most from SQL Server 2008 while you're becoming a database star. You'll be ready to handle your on-the-job database tasks -- while you gain the database skills and solid exam prep you need to advance your career.

This training maps to Microsoft MCTS certification exam 70-433.

All trademarks and copyrights are the property of their respective holders.

Videos

		Title	Duration
		SQL Server tables, SQL Server data types, SQL Server computed and persisted columns SQL Server tables, SQL Server data types, SQL Server computed and persisted columns	00:38:44
		SQL Server 2008 views, SQL Server WITH CHECK OPTION, SQL Server view encryption, SQL Server schema binding SQL Server 2008 views, SQL Server WITH CHECK OPTION, SQL Server view encryption, SQL Server schema binding	00:26:01
		SQL Server 2008 Selecting data, inserting, updating, transactions SQL Server 2008 Selecting data, inserting, updating, transactions	00:25:56
		SQL Server 2008 indexes, index hints, index types SQL Server 2008 index overview, index types, implementing indexes	00:29:01
		SQL Server 2008 partitioned tables, partitioned indexes, managing partitions SQL Server 2008 partitioning tables, partitioning indexes, range and list partitions	00:35:06
		SQL Server 2008 procedures, functions, managing procedures, managing functions, executing functions, executing procedures SQL Server 2008 procedures, functions, parameters, procedure and function options	00:21:54
		SQL Server 2008 subqueries, common table expressions, merge statement, aggregate queries, combining datasets SQL Server 2008 subqueries, CTEs, MERGE statement, aggregate queries, combining datasets	00:32:06
		SQL Server 2008 triggers, instead of triggers, DML triggers, DDL triggers, nested and recursive triggers SQL Server 2008 DML triggers, DDL triggers, INSTEAD OF triggers, recursive triggers	00:24:14
		SQL Server 2008 XML syntax, XML data type, FOR XML clause, XPATH, XQuery functions SQL Server 2008 XML syntax, XML data type, FOR XML clause, XPATH, XQUERY	00:33:20
		SQL Server 2008 advanced XML, parsing XML SQL Server 2008 namespaces, XML Schema, openxml(), XML indexes	00:30:35
		SQL Server 2008 database mail. email architecture, profiles, sending email, email logs SQL Server 2008 database mail architecture, mail profiles, sending email, email logs	00:21:57
		SQL Server 2008 execution plan, profiler, Database Engine Tuning Advisor, query hints, catalog views SQL Server 2008 execution plans, profiler traces, templates, database engine tuning advisor, query hints, catalog views	00:24:08
		SQL Server 2008 service broker, asynchronous messaging, transactional messaging, implementing service broker SQL Server 2008 service broker, asynchronous and transactional messaging, implementing service broker	00:32:51
		SQL Server 2008 CLR, CLR vs. T-SQL, implementing CLR, Windows Power Shell SQL Server 2008 CLR integration, CLR vs. T-SQL, CLR restriction categories, Windows PowerShell, SMOs	00:31:39
		SQL Server 2008 international considerations, full text search, tracking data changes SQL Server 2008 International considerations, full text search, tracking data changes	00:35:27

Total Series Duration: 07:22:59

RELATED SERIES	RELATED CERTIFICATIONS
Microsoft Database PRO SQL Server 2008 Design 70-451 Microsoft Lync Server 2010 70-664 Microsoft Desktop Support Windows Vista Deploy 70-624 Microsoft Windows Server 2008: Server Core In Depth Microsoft System Center 2012 Private Cloud 70-246	MCITP: SQL Server 2008 Database Developer Certification Playlist

Bookmarks

Microsoft Database SQL Server 2008 Develop 70-433

Database training for Microsoft's SQL Server 2008

Julie Johnson

CBT Nuggets Trainer

No Bookmarks