Join Gini von Courter for an in-depth discussion in this video What you need for this course, part of SharePoint Designer 2013: Creating Data-Driven Sites.
- To get the most out of this course you need to know something about three different technologies: SharePoint, websites and databases. This course is not an introduction to SharePoint. I assume that you already know your way around SharePoint 2013 or SharePoint Online. You're a SharePoint power-user, perhaps even a SharePoint administrator. You already know how to work with SharePoint sites, with lists and libraries. You know how to work with Web Parts. You know how to use the ribbon in SharePoint 2013, and you know how SharePoint works with Office.
If that's not the case take a look at one of my other courses on Lynda.com, either SharePoint 2013 Essential Training, or SharePoint Online Essential Training. Then come on back. If you have web development experience and know some html or some CSS, that's great. Most of what we cover in this course doesn't even need that, but for some of the advance features any experience that you have developing websites will come in handy. Even experience you have using websites will be useful to you here.
We're going to need to talk to databases. Whether you're using Access or SQL Server, Oracle or Filemaker Pro, I don't need you to be a database expert, but you should be solid with the core database concepts, the idea that relational databases are comprised of tables of data in rows and columns that you can sort and filter, and that you can create queries in order to hang on to those sorts and filters that you've created. That's what you need. Here's what you don't need. You don't need to have any programming experience for this course.
If you know a little bit about XML or markup languages, html for example, those will serve you well. You will not need to sit and write code. We'll be using two tools to be able to create data driven pages. The first is actually SharePoint in the browser, which has been really beefed up in the 2013 versions, so that we'll be able to add Web Parts and edit pages without ever leaving SharePoint itself. The second tool we have is a tool that's called SharePoint Designer, and it has gotten both more and less impressive in this version.
Some features have been deprecated, removed, and some other features have been added. If you bring experience from SharePoint Designer 2010 that may be helpful to you, but it may also serve as somewhat of a disappointment, because some of the favorite features that many of us had in SharePoint Designer 2010 are the features that were actually removed. If you're brand new to SharePoint Designer you may actually be a happier camper. What we're going to do in this course is very specific to the 2013 versions of SharePoint: SharePoint Foundation, SharePoint Server 2013, either standard or enterprise, SharePoint Online.
If you're working with SharePoint 2010 please go back to the training library and take the excellent SharePoint 2010 version of this course that Simon Allerdice created. You and I won't build many finished products in this course, but you may still want to work along with me for many or all of the movies, and if you want to do this taking a hands-on approach you'll need access to an installed SharePoint 2013 infrastructure, one of those listed on the screen. As much as possible I'm going to cover features that exist in all of these versions of SharePoint.
When that's not the case I'll point it out. As you know SharePoint is a platform that's installed and configured differently from company to company. As we go through this your experience will almost certainly look a little different from mine, based on your licensing, the version of SharePoint you're using, the permissions you have in your organization, and the features that your SharePoint system administrator has enabled or disabled. However the core of what you and I are going to do should be very similar.
- Managing data sources
- Displaying external data with RSS, XML, and Data View Web Parts
- Using Business Connectivity Services
- Creating data-driven pages
- Enhancing data presentation
- Filtering data
- Displaying associated lists