SharePoint 2016 / Office 365 SharePoint Online
Development Course Details
Intended for: Developers / Architects / Enterprise Content Managers / Administrators
Majority of SharePoint development courses start the development portion without giving you practical understanding of out-of-box SharePoint functionality and its strengths and limitations. By the time you open Visual Studio in our course, you will be an expert in collaboration, enterprise document management, search, workflows, and many other aspects of SharePoint. With that knowledge you will understand not only the how but the why of SharePoint development.
We will cover the most important aspects of the SharePoint API and how to access it using client and JavaScript object models. Additionally, you will learn to access and manipulate SharePoint lists using REST API. For the app development, you will build a SharePoint hosted app that uses SharePoint components. Also, you will create a provider hosted app that utilized Windows Azure web app, SQL, no SQL tables and BLOB storage. We will discuss app security, developer workflow, and deployment options in details.
Learn the following topics:
- All the topics covered in the Fundamentals / Administration courses.
- Learn the most important aspects of the SharePoint client, JavaScript, and REST APIs.
- Build and deploy SharePoint hosted app that uses pages, ribbon actions, lists, and app parts.
- Learn about app deployment in an organization and SharePoint app store licensing model.
- Understand developer workflow.
- Understand app security
- Build an asp.net MVC provider hosted app that resides on Windows Azure.
- Use entity framework to access SQL Azure data.
- Use Azure blobs and no SQL tables storage, CORS, signed URLs, and REST APIs
Core Features
Power User / Site Administrator
- Introduction to SharePoint 2016 / SharePoint Online
- Overview
- History
- What's New
- How to Make SharePoint Successful
- Sites Organization
- Content Creation and Organization
- Site collection
- Site
- Top link bar
- App launcher: SharePoint homepage
- Site navigation
- Quick launch bar
- Site contents
- Site Templates and Features
- Features
- Site template comparison
-
Lists
- Columns
- Filters
- Views
- Form configuration
- Versions
- Alerts
- Large lists: metadata navigation and indexed columns
- Search
- Documents
- Columns, views, managed metadata
- Get a link functionality
- Co-authoring and track changes
- Syncing using OneDrive for Business
- Versions
- When are versions created
- Check out / Check in
- Major, minor, and approval
- Folders vs. metadata
- Search and Delve
- Pages, Web Parts, Apps
- Classic and modern pages
- Types of pages: Wiki, Standard, Modern, Application
- Web Parts
- Apps
- What's not supported in modern pages
- Outlook Groups
- Navigation
- Group members and settings
- Conversations
- Calendar
- Group library
- Planner
- OneDrive
- Personal documents and site
- User profile
- Personal and social features
- User Profiles
- MyAnalytics
- Yammer
- Classic Tasks and Calendars
- Tasks
- Organize for project management
- Indents
- Timeline
- Calendars
- Connect to Outlook
- Overlays in SharePoint
-
Security and Permissions
- Authentication vs. authorization
- Permission levels
- Site collection administrator
- SharePoint groups
- Sharing - Get a link functionality
- Members groups security
- External users
- Templates and Publishing Infrastructure
- Site and list templates
- Publishing infrastructure and limitations in the modern interface
- Project: Libraries and Lists
- Research documents
- Document library with metadata
- Permissions by folder
- Views without folders
- Metadata creation and navigation
- Project site management
- Project directory
- Project site template
Custom Forms and Workflows
Business Intelligence Analyst
- Microsoft Flow Basics
- Events, actions, conditions, dynamic content
- Create, Run, Check Flow
- Demo: Training/class sign up
- Demo: Recurrence, send monthly email
- Demo: Flow buttons
- Demo: Document approval
- Workflow deployment
- Security
- Seperate site collection
- Reusable flow
- Microsoft Flow Custom Services
- JSON and dictionary actions
- SharePoint REST APIs
- Read and write data from SharePoint
- Power Apps
- Form Design
- Visual layout
- Logic and rules
- Validation
- External data
- Forms with one to many relationships
Business Intelligence
Business Intelligence Analyst
- Business Intelligence Introduction
- Definition
- Information collection, analysis, and delivery
- Microsoft product descriptions
- Excel and Data Modeling
- Excel Data Model
- Create tables and identify relationships
- PowerPivot – advanced data model manipulation
- Presentation
- Pivot tables, slides, and charts
- PowerView
- Publishing to SharePoint
- Cloud: PowerBI.com or Office 365 SharePoint
- On premise: SharePoint 2013 or 2016 with BI
- Publishing options and permissions
- Pages and web parts
- Excel with PowerPivot
- Import data and create relationships
- Calculated columns and DAX
- Measures, hierarchies, and KPIs
- Excel PowerQuery
- Getting data using PowerQuery from SharePoint lists and public APIs
- Publishing to SharePoint or PowerBI.com
- Scheduling data refresh
- Power BI Desktop
- Datasets
- Visualizations
- Reports, Dashboards, Tiles
- Gateways to on premise data
- Gateways and datasources
- Power BI Security
- Azure AD users
- Groups workspaces
- Dashboard security
- External sharing and embedding
- Row level security
- SharePoint Security
Administration
Enterprise Content Manager / Administrator / Project Manager
- Site Collection Management
- Definition
- Why separate site collections
- Management
- Site Columns
- Definition
- Scopes and updates
- Managed Metadata - Taxonomy Term Store
- Terms sets and term groups
- Choice Column vs. Managed Metadata Column
- Enterprise keywords
- General Recommendations for Taxonomy Development
- Content Types
- Content type information architecture
- Hierarchies and inheritance
- Document templates
- Workflows
- Information management policies
- Use cases
- Content Type Syndication Hub
- Document sets
- Metadata and page layouts
- Versioning and workflows
- User Profiles
- User Profiles
- Properties
- Settings
- Permissions
- Audiences
- My Sites
- Configuration
- Promoted sites
- Search Administration
- Search administration
- Search Schema – properties and refiners
- Content search web parts
- Query suggestions
- Query rules
- Analytics
- Final Project
- Metadata and Search
- EDiscovery
- eDiscovery cases
- eDiscovery sets
- Sources
- Custodians
- Queries
- Using PowerShell in SharePoint Online
Development
Developer / Architect
- Development Goals
- SharePoint APIs
- How to access the SharePoint API
- JavaScript Object Model - JSOM
- REST
- Server and client object model
- Working with SharePoint API
- Site collection organization
- List manipulation
- List data retrieval
- Permissions
- App Development
- What to do
- Host web, app web, isolated domain
- Development options
- SharePoint hosted vs. provider hosted
- Components
- Pages, custom actions, modules, app parts
- Features, packages
- App manifest and permissions
- SharePoint App Deployment
- Organizational deployment
- App gallery
- Deployment scope: tenancy vs web
- Updating apps
- Provider Hosted App
- Solution Structure
- App and web projects
- ASP.NET MVC (Model View Controller)
- Running locally
- Deployment
- Registering in the tenant – client id and secret
- Publishing to Azure website
- Data Storage
- SQL – Entity framework
- Blob storage - signed URLs
- No SQL Tables - REST APIs and CORS
- Licensing
- App Security Model
- General
- App authorization policy types
- Low trust and high trust apps
- Registering apps
- Context token auth flow
- Context and access tokens details
- Helper classes
- Caching context token beyond the session
- Office 365 App Development
- Architecture
- SharePoint Apps vs Office 365 apps
- Connecting from external systems