This course assumes that you have a basic familiarity with the concept of relational databases and a basic understanding of what SQL Server is and the high-level tools in it, as well as how to create and manage objects using Management Studio. You should also have a basic understanding of how SQL Server implements security, including its authentication and authorization schemes, and how to assign permissions on securable objects to principals. You should know the fundamentals of Transact-SQL to write queries to retrieve and update data, and how to execute scripts using the query editor in Management Studio.
The course spends a lot of time deep in T-SQL code, so you should feel comfortable writing basic queries that involve joins of multiple tables, as well as using built-in T-SQL functions and other code modules.
It will be very helpful, but not absolutely necessary, to have experience with .NET development using Visual Studio 2010 or 2012 for the portions of the course that deal with SQL Server Data Tools.
<p><strong class="lnoblue">Don Kiely</strong> is a featured instructor on many of our SQL Server and Visual Studio videos. He is a nationally recognized author, instructor and consultant who travels the country sharing his expertise in SQL Server and security. Don has several years of teaching experience, is the author or co-author of several programming books, and is a featured speaker at SQL Server conferences. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.</p>
<p>Learn practical skills you can apply to your current projects with our full-motion video learning – an engaging combination of instructor presentations, detailed slides, and step-by-step code walkthroughs. Take an entire course for in-depth learning within a topic, or watch 5-15 minute tutorials for quick on-the-spot help as you work. You’ll learn new skills and technologies at your own pace, whenever and wherever it’s convenient for you on your PC or mobile device.</p>
– Viewable on all major PC and Mac browsers.
– Viewable on any iOS or flash-supported Android mobile device.
Microsoft® Windows® XP Service Pack 2 or higher, Microsoft® Media Player 10 or higher,
Microsoft® Silverlight™ 3 and Internet Explorer 6.0 or higher.
Microsoft® Windows® XP Service Pack 2 or higher, Microsoft® Silverlight™ 3 and a
Silverlight-supported Browser (e.g. Internet Explorer, Chrome, FireFox).
Macintosh OS 10.5.7 (Intel-based) or higher, Microsoft® Silverlight™ 3 and a Silverlight-supported
Browser (e.g. Safari, Chrome, FireFox).
iPhone or iPad running iOS 4 or higher
Android phone or tablet running Android 2.2 or higher and Adobe® Flash®
Mobile Device Requirements:
- iPad running iOS 4 or greater
- iPhone running iOS version 4 or greater
- Android Phone running OS version 2.2 or greater
- Android Tablet running OS version 3.0 or greater
- Wifi access or cellular data plan (Data charges may apply - please consult your data plan agreement)
<p>Enhance your learning with thousands of pages of printable courseware that work hand-in-hand with our video content. Highlight, take notes, print key pages for reference material. Your very own comprehensive eBook library – you won’t get this with the other guys.</p>
<p>Once you’ve viewed the video, roll up your sleeves and dig in to real-world step-by-step lab exercises. You’ll practice what you’ve learned, reinforce key concepts, and get some great ideas to help jump start your own projects.</p>
<p>Try for yourself the examples and demonstrations presented by our instructors with sample code that can be easily accessed within your learning library and downloaded to your computer.</p>
<p>Already have knowledge within a technology? Don’t waste time on concepts you already understand. Take our course pre-exams and save time by skipping topics you already know and focusing on those you don’t. Take our post-exams to see your growth and identify any areas in need of additional learning time.</p>
<p>Our built-in learning management system (LMS) is loaded with administrative and reporting tools, allowing you to easily manage your learning program and measure ROI. Oversee learning at one location or many worldwide. Create groups and custom learning tracks. Monitor usage reports and exam results to measure ROI. You can do it all and more with the AppDev Enterprise LMS. </p>
<p><i>Already have an LMS? Our courses are fully SCORM compliant and can be seamlessly integrated into your existing system for consistent tracking, reporting and analysis.</i></p>