Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to understand configuration for installation, configuration of a host system, using Oracle Restart framework, troubleshooting tips, how the database fits with other systems, internals of the database, database failures and other topics. In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems. Oracle Database Architercture Overview The Database Instance Database Memory Structures Database Process Structures Database Storage Architecture Oracle Clusterware Configuring the Host for Standalone Installlation Host Configuration Overview Choosing a Database Host Choosing an Operating System Proprietary Unix vs Open-Source Linux Making the OS Selection Prepare an Oracle LINUX Installation Perform Oracle LINUX Installation Configure the LINUX Host Step 1 - Confirm General System Requirements Step 2 - Confirm The Operating System Platform Step 3 - Confirm LINUX Package Requirements Step 4 - Confirm Network Configuration Configure Host for Virtualization VM Technologies Configure Oracle Linux for Virtualization Step 1 - Download Linux Updates Step 2 - Check Linux Kernel Step 3 - Download Latest yum Configuration File Step 4 - Enable Oracle Linux Add-ons Step 5 - Install VirtualBox Oracle Optimal Flexible Architecture OFA Goals ORACLE_BASE ORACLE_HOME Database Files Multiple ORACLE_HOMEs Databse Software Upgrades Mutliple Oracle Software Installations GRID Infrastructure Configuration Configure the Linux Installation About ASM Devices Configure Linux Devices for ASM Partioning a Device Oracle ASMLib Configue MS Windows Devices GRID Infrastructure Installation Perform the Installation Download Unpack the Installation Package Launch the Installation Session The Installation Dialog Verify the Installation Operating System Confirmation Oracle Utilities Setup SQL*Plus Confirmation Using EM Cloud Control Troubleshooting Problems DATABASE Installation Configuraion Configure a Linux Installation System Groups & Users Configure Kernel Parameters Create the Physical Directories Configure MS Windows Installation Prerequisite Checks & Fixup Utility DATABASE Installation ABOUT THE INSTALLATION The Installation Tools About The Installation Dialog The Installation Session Log PERFORM INSTALLATION ON LINUX Download Unpack The Installation Files Set Environment Variables Launch The Installation SERVER CLASS INSTALLATION DIALOG More About The Global Database Name About Enterprise Manager Cloud Control Secure The New Database PERFORM INSTALLATION ON WINDOWS Launch The Installation POST---INSTALLATION CONFIGURATION Required Environment Variables Defining The Environment Variables About SSH VERIFY THE INSTALLATION SQL*PlusConfirmation Operating System Confirmation Firewall Configuration Accessing EM Database Express Creating Databses Using DBCA About DBCA DBCA Templates Are You Sure? DEFAULT CONFIGURATION DATABASE ADVANCED MODE DATABASE File Location Variables Database Vault and Label Security CONFIGURE AN EXISTING DATABASE DELETE A DATABASE MANAGE TEMPLATES MANUALLY CREATE A DATABASE The CREATE DATABASE Command Using Oracle Restart WHAT IS ORACLE RESTART? What Oracle Restart Does Is Oracle Restart Deprecated? Registering With Oracle Restart More About srvctl Terminal Session Configuration COMPONENT STATUS USING SRVCTL Database Status Grid Infrastructure Status Oracle Home Status CONFIGURATION USING SRVCTL Examining A Database Configuration Examining The Listener Configuration Examining The ASM Configuration Manual Registration ListenerConfiguration Modification Database ConfigurationModification STARTUP/SHUTDOWN USING SRVCTL Why Use srvctl? MANAGING ORACLE RESTART Obtaining Oracle Restart Status Start/Stop Oracle Restart Preparing for a Database Upgrade What is a Database Upgrade? Database Upgrade Methods Real World Database Upgrade Develop A Database Upgrade Plan ABOUT THE DATABASE VERSION Direct Upgrade The COMPATIBLE Database Parameter PRE-UPGRADE PREPARATIONS Oracle Warehouse Builder Oracle Label Security (OLS) Oracle Database Vault Locating The Older Database Installations THE PRE-UPGRADE INFORMATION TOOL Pre-Upgrade Information Tool Files Run The Pre---Upgrade Information Tool Examining The Pre---Upgrade Information Tool Results Upgrade to Oracle Databse 12c Launch DBUA Database Upgrade Dialog Post-Upgrade Tasks Post-Upgrade Checklist Enable Unified Auditing Migrate to Unified Auditing Database Parameter Changes Enable New Features Source Destination Specific Post-Upgrade Tasks Oracle Architecture: The Systems Infrastructure About Enterprise Architectures The Relational Database Legacy Computing Models The Multi-Tiered Computing Model Scaling Up Cloud-Based Deployment ORACLE INFRASTRUCTURE ECOSYSTEM USING ORACLE ENTERPRISE MANAGER More About EM Using EM Database Express Using EM Cloud Control Oracle Architecture: The Database Host The Database Server Stack PROCESSOR LAYER CPU Resources Memory Resources I/O & STORAGE PROCESSING OS LAYER PROCESSING MODES DATABASE SERVER VIRTUALIZATION STORAGE VIRTUALIZATION ORACLE DATABASE SERVER STACK ORACLE ENGINEERED SYSTEMS Oracle Exadata Database Platform Exalogic Cloud Machine Exalytics BI Machine Oracle Architecture: Princilples & Technology Concepts Grid Computing Principles Why Grid Computing? What Is Grid Computing? PARALLELIZATION PRINCIPLES Hardware Parallelization Grid Computing Devices Clustered Database Servers CLOUD COMPUTING PRINCIPLES Multi-Tenancy Oracle Architecture: The RDBMS Installation & the Database Instance The Database Server Software Database Versions & Releases Database Editions Using PRODUCT_COMPONENT_VERSION View The Core Database Components Using V$VERSION View Understanding The Database Version Number The COMPATIBLE Database Parameter DATABASE INSTANCE ELEMENTS Individual Elements Of A Database Instance Physical Database Elements An Operational Database installation DATABASE INSTANCE CONFIGURATIONS Single Instance Parameter Files & Instance Configuration MAX_STRING_SIZE Parameter Example Independent Instances Clustered Instances The Database Instance In A Multi-tenant Configuration RECONFIGURING A DATABASE INSTANCE Static Vs. Dynamic Parameters Dynamic Parameter Setting Parameter Setting Scope Parameter Setting Level Setting Upgrade Related Parameters DATABASE COMPONENTS Advanced Data Functionality Components Security Components High-Performance Components Administration Components Database F
Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. Introduction: Managing the Database Instance The Database Management Tools EM Database Express EM Cloud Control SQL Developer Database Administrator Introduction: Database Architecture Review Database Instance Configurations Memory Structures Process Structures Storage Architecture Introduction: Starting & Stopping Databse Services Start & Stop the Database Listener ABOUT DATABASE STARTUP/SHUTDOWN SYSOPER SYSDBA DATABASE STATE & STAGES STARTUP WITH EM CLOUD CONTROL STARTUP WITH SQL*PLUS SHUTDOWN WITH EM CLOUD CONTROL SHUTDOWN WITH SQL*PLUS USING MS WINDOWS SERVICES Introduction: Oracle Network Environment Oracle Net Services Architecture ORACLE NET CONFIGURATION ASSISTANT ORACLE NET MANAGER USING EM CLOUD CONTROL ADVANCED NETWORK COMPRESSION TROUBLESHOOTING NETWORK PROBLEMS Introduction: Diagnostics & Oracle Support About Database Diagnostics Fault Diagnosability Infrastructure DATABASE INSTANCE HEALTH SNAPSHOT THE SUPPORT WORKBENCH PROACTIVE DATABASE HEALTH CHECKS PACKAGE DIAGNOSTIC DATA WORKING WITH THE KNOWLEDGE BASE Storage: Tablespace Management Starter Tablespaces CREATE TABLESPACE WITH EM CC CREATE TABLESPACE WITH SQL MANAGE TABLESPACES WITH EM CC MANAGE TABLESPACES WITH EM DE MANAGE TABLESPACES WITH SQL DROP TABLESPACE ALTER TABLESPACE Storage: Advanced Tablespace Management Managing Temporary Tablespaces TEMP TABLESPACE GROUPS WITH EM TEMP TABLESPACE GROUPS WITH SQL DEFAULT PERMANENT TABLESPACES BIGFILE TABLESPACES MANAGING THE SYSAUX TABLESPACE Storage: Data Files & Temp Files Management Manage Data Files with EM ACCESS METADATA WITH SQL MANAGE DATA FILES WITH SQL MANAGE TEMP FILES ORACLE-MANAGED FILES (OMF) Storage: UNDO Data & UNDO Tablespaces About UNDO Space Management GUARANTEE UNDO RETENTION MONITOR UNDO SPACE WITH SQL USE THE EM UNDO ADVISOR Security & Schemas: Security Overview & Database Privileges Database Security Principles DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES SUPER ADMINISTRATOR ROLES PRIVILEGE ANALYSIS Security & Schemas: User Security Create & Manage User Accounts MANAGE USERS WITH EM MANAGE USERS WITH SQL CREATE USER ALTER USER DROP USER GRANT & REVOKE PRIVILEGES RESOURCE LIMITS VIA PROFILES ALTER PROFILE DROP PROFILE PASSWORD MANAGEMENT VIA PROFILES ROLE-BASED SECURITY MANAGEMENT ALTER USER...DEFAULT ROLE SET ROLE DELEGATING PRIVILEGE AUTHORIZATION WITH ADMIN OPTION & System Privileges WITH GRANT OPTION & Object Privileges PRINCIPLE OF LEAST PRIVILEGE CHECKLIST Security & Schemas: Database Auditing Auditing Database Activity Traditional Auditing Unified Auditing Create Audit Policy Security & Schemas: SQL Loader Loader Concepts Loader From the Command Line control File Options Load Methods Loader Express Mode Loader From EM Security & Schemas: Export & Import Manage Directory Objects The Data Pump Architecture Data Pump Export Data Pump Import Data Pump Dictionary Views Using the EM CC Interface Performance & Availability: Managing Performance & SQL Tuning Management Advisory Framework Performance Monitoring & AWR The SQL Tuning Advisor Monitoring Exceptions with Metrics Performance & Availability: Data Concurrency About System & User Locks Monitor & Manage User Locks Moitor Locks with Data Dictionary Manage Locks with EM Performance & Availability: Backup & Recovery Concepts Backup & Recovery Structures Managing REDO Data Configuring for Recoverability Instance Recovery Recoverability Checklist Additional course details: Nexus Humans Oracle 12c Administration II training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c Administration II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
This SharePoint 2016 Site Owner course is intended to introduce you to the SharePoint 2016 and provide a comprehensive overview of SharePoint Site Owner roles and responsibilities in an accessible and extensive guide to the mind. Throughout the course, you'll learn how to add and configure sites, create libraries and lists, create and modify views. Discover how to implement SharePoint sites, features, and content structures suitably and securely share files, collaborate on documents, and access information and work with colleagues more productively. In addition to that, learn how to create and customize columns, manage content types and create a document set. This course also includes how to enhance the site using web parts and working with pages, navigate within SharePoint and how to change regional settings. This course will be ideal for you for sharing information and collaborating efficiently with your team or organisation. What Will I Learn? Understand the Role of the Site Owner Add and Configuring Sites Create Libraries Create Lists Create and Modify Views Create and Customize Columns Create and Manage Content Types Manage Permissions Enhance the Site Work with navigation and regional settings Requirements Pre-requisites: SharePoint 2016 Site User or similar experience Who is the target audience? Any student wishing to learn more about the SharePoint Site Owner roles and responsibilities Introduction Introduction FREE 00:02:00 Role of the Site Owner 012-16-Site Owner-C1L1-Understanding the Role of the Site Owner 00:04:00 012-16-Site Owner-C1L2-The Limitations of Folders 00:05:00 Adding and Configuring Sites 012-16-Site Owner-C2L1-Working with Collaboration Site Templates 00:02:00 Creating a Subsite with the Team Site Template 00:05:00 Creating a Subsite with the Project Site Template 00:04:00 012-16-Site Owner-C2L4-Creating a Subsite with a Blog Site Template 00:05:00 012-16-Site Owner-C2L5-Creating a Subsite with a Community Site Template 00:05:00 012-16-Site Owner-C2L6-Understanding Site Settings 00:05:00 012-16-Site Owner-C2L7-Customizing the Look of a Site 00:06:00 012-16-Site Owner-C2L8-Changing a Site's Title, Description, Logo, or URL 00:04:00 Creating Libraries 012-16-Site Owner-C3L1-Adding Apps 00:04:00 012-16-Site Owner-C3L2-Creating a Document Library 00:04:00 012-16-Site Owner-C3L3-Reviewing Library Settings 00:04:00 Switching Between the New and Classic Views 00:04:00 012-16-Site Owner-C3L5-Creating a Picture Library 00:03:00 012-16-Site Owner-C3L6-Deleting and Restoring a Library 00:03:00 012-16-Site Owner-C3L7-Changing the Name of a Library or List 00:02:00 012-16-Site Owner-C3L8-Modifying Library Versioning Options 00:04:00 012-16-Site Owner-C3L9-Restoring a Previous Version 00:03:00 012-16-Site Owner-C3L10-Overriding a Checked Out Document 00:03:00 012-16-Site Owner-C3L11-Saving a Library as a Template 00:03:00 012-16-Site Owner-C3L12-Adding Enterprise Key Words to a Library or List 00:03:00 012-16-Site Owner-C3L13-Allowing Folder Creation in Libraries and Lists 00:02:00 012-16-Site Owner-C3L14-Adding or Removing the Sync Library Feature 00:03:00 012-16-Site Owner-C3L15-Using Content Approval for a Library 00:04:00 012-16-Site Owner-C3L16-Using Content Approval with Alerts for Simple Workflows 00:06:00 Creating Lists 012-16-Site Owner-C4L1-Creating Lists 00:04:00 012-16-Site Owner-C4L2-Reviewing List Settings 00:02:00 012-16-Site Owner-C4L3-Deleting and Restoring a List 00:02:00 012-16-Site Owner-C4L4-Creating a Calendar List 00:02:00 012-16-Site Owner-C4L5-Adding or Removing the Group Calendar Option 00:02:00 012-16-Site Owner-C4L6-Creating a Task List. 00:03:00 012-16-Site Owner-C4L7-Creating an Announcement List 00:02:00 012-16-Site Owner-C4L8-Creating a Links List or Promoted Links List 00:04:00 012-16-Site Owner-C4L9-Creating a Contact List 00:02:00 012-16-Site Owner-C4L10-Creating a Survey 00:05:00 012-16-Site Owner-C4L11-Creating an Issue Tracking List 00:03:00 012-16-Site Owner-C4L12-Creating a List From an Excel Worksheet 00:04:00 012-16-Site Owner-C4L13-Creating a Custom List 00:02:00 012-16-Site Owner-C4L14-Changing a List Name or Description 00:02:00 012-16-Site Owner-C4L15-Adding or Removing Versioning from a List 00:03:00 012-16-Site Owner-C4L16-Adding or Disabling the Add Attachments Feature for a List 00:02:00 012-16-Site Owner-C4L17-Adding or Removing the Quick Edit Feature for a Library or List 00:02:00 Creating and Modifying Views 012-16-Site Owner-C5L1-Changing or Modifying the List or Library Default View 00:04:00 012-16-Site Owner-C5L2-Creating Public Views 00:06:00 012-16-Site Owner-C5L3-Creating a Grouped Library or List View 00:05:00 012-16-Site Owner-C5L4-Creating a Flat Library View 00:03:00 Creating and Customizing Columns 012-16-Site Owner-C6L1-Understanding SharePoint Columns 00:04:00 012-16-Site Owner-C6L2-Adding an Existing Site Column to a Library or List 00:03:00 Creating a Site Column 00:05:00 012-16-Site Owner-C6L4-Modifying, Renaming, or Deleting a Site Column 00:03:00 012-16-Site Owner-C6L5-Creating a Library or List Column 00:04:00 Modifying or Renaming a List or Library Column 00:03:00 012-16-Site Owner-C6L7-Removing a Column from a List or Library 00:03:00 012-16-Site Owner-C6L8-Creating a Text Column 00:03:00 012-16-Site Owner-C6L9-Creating a Choice Column 00:05:00 012-16-Site Owner-C6L10-Creating a Number Column 00:03:00 012-16-Site Owner-C6L11-Creating a Currency Column 00:02:00 012-16-Site Owner-C6L12-Creating a Date and Time Column 00:03:00 012-16-Site Owner-C6L13-Creating a Look Up Column 00:05:00 012-16-Site Owner-C6L14-Creating a Calculated Column 00:04:00 Creating and Managing Content Types 012-16-Site Owner-C7L1-Exploring Content Types 00:03:00 012-16-Site Owner-C7L2-Creating a Custom Content Type 00:08:00 012-16-Site Owner-C7L3-Adding a Custom Content Type into a List or Library 00:03:00 012-16-Site Owner-C7L4-Removing a Content Type from a Library or List 00:03:00 012-16-Site Owner-C7L5-Creating a Document Set 00:08:00 012-16-Site Owner-C7L6-Modifying a Content Type 00:03:00 Managing Permissions 012-16-Site Owner-C8L1-Understanding Permissions 00:05:00 012-16-Site Owner-C8L2-Editing Permission Level Priveleges 00:04:00 012-16-Site Owner-C8L3-Understanding Default Permission Groups 00:04:00 012-16-Site Owner-C8L4-Viewing and Editing Group Permissions 00:04:00 012-16-Site Owner-C8L5-Changing Permission Levels for a Group 00:02:00 012-16-Site Owner-C8L6-Viewing,Adding, or Removing Users from a Group 00:03:00 012-16-Site Owner-C8L7-Creating New SharePoint Groups 00:05:00 012-16-Site Owner-C8L8-Changing a Group Name or Group Owner 00:02:00 012-16-Site Owner-C8L9-Adding a SharePoint Group to a Site 00:03:00 012-16-Site Owner-C8L10-Adding, Removing, or Editing Permission Levels for an Individual 00:02:00 012-16-Site Owner-C8L11-Checking an Individuals Permission on a Site 00:02:00 012-16-Site Owner-C8L12-Granting Access to the Site Using the Share Option 00:03:00 012-16-Site Owner-C8L13-Changing the Default Share Group for the Site 00:02:00 012-16-Site Owner-C8L14-Creating and Removing Unique Permissions for a Site 00:05:00 012-16-Site Owner-C8L15-Creating and Removing Unique Permissions for a Library 00:06:00 012-16-Site Owner-C8L16-Creating and Removing Unique Permissions for a Document or Folder 00:06:00 Enhancing the Site 012-16-Site Owner-C9L1-Working with Pages in SharePoint 00:04:00 012-16-Site Owner-C9L2-Modifying or Adding Text to a Page 00:06:00 012-16-Site Owner-C9L3-Understanding Web Parts or App Parts 00:09:00 012-16-Site Owner-C9L4-Creating a Page in SharePoint 00:06:00 012-16-Site Owner-C9L5-Adding a Page to the Quick Launch 00:03:00 012-16-Site Owner-C9L6-Adding the Excel Web Access Web Part 00:07:00 012-16-Site Owner-C9L7-Adding the Relevant Documents Web Part 00:04:00 Navigation and Regional Settings 012-16-Site Owner-C10L1-Changing Regional Time and Work Week Settings 00:05:00 012-16-Site Owner-C10L2-Inheriting Top Links Navigation 00:02:00 012-16-Site Owner-C10L3-Working with Top Links Bar 00:05:00 012-16-Site Owner-C10L4-Working with the Quick Launch Area 00:06:00 012-16-Site Owner-C10L5-Enabling Tree View 00:03:00 Conclusion Course Recap 00:01:00 Course Certification
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:02:00 Section 02: Setup Project Setup 00:15:00 Section 03: Scene Setup Scene Creation 00:07:00 Splash Scene 00:08:00 Main Menu Scene 00:33:00 Section 04: Grid & Gameplay Grid System 00:17:00 Grid System Part 2 00:26:00 AI 00:34:00 Section 05: Popups Game Over 00:28:00 Pause 00:23:00 Section 06: Extras Achievements 00:08:00 Extras & Going Forward 00:11:00 Assignment Assignment - Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course 00:00:00
Overview This comprehensive course on Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course. It is available to all students, of all academic backgrounds. Requirements Our Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 13 lectures • 03:32:00 total length •Introduction: 00:02:00 •Project Setup: 00:15:00 •Scene Creation: 00:07:00 •Splash Scene.: 00:08:00 •Main Menu Scene: 00:33:00 •Grid System: 00:17:00 •Grid System Part 2: 00:26:00 •AI: 00:34:00 •Game Over: 00:28:00 •Pause: 00:23:00 •Achievements: 00:08:00 •Extras & Going Forward: 00:11:00 •Assignment - Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course: 00:00:00
Our Creative Writing course, running for five weeks, will explore the art of storytelling in depth. Is your child a budding writer aiming to excel in 11+ exams in the UK? Our Creative Writing course is designed just for them Over five weeks, we'll delve into the art of storytelling, focusing on creating pieces that set your child apart and building essential exam skills. From mastering the nuances of the five senses to paragraph and story structure, our expert exam tutor, Kristen, will guide students every step of the way. We'll help your child answer those seemingly boring questions with enthusiasm, explore figures of speech, enrich vocabulary, and unleash their creative potential. This will be the perfect course to learn about exam skills for 11+ creative writing tasks!
For those who are looking to get top marks in the Maths 11+ exam Save Your Child’s Spot in the 11+ Advanced Maths Small Group Classes Tricky Algebra Confusing word problems Fractions, Decimals and Percentages Tricks to answer questions more efficiently (and save time!) Topics that really stretch your child Personalised weekly homework Exam-style questions PLUS! Bettering Youth's Signature Mindset Coaching + exam stress management tools Our engaging course doesn’t just teach numbers; Our Maths courses build confidence. This course is perfect for students in Year 5 students who are at "greater depth" and are preparing for their 11+ Exam in 2024. Course breakdown: Each week begins with independent completion of a topic pre-learning I use the data from these pre-learning activities to build a personalised and highly intentional in-person weekly lesson We ensure full mastery of the topic through discussions around efficient methods and provide plenty of opportunities for practise At the end of the topic, students will complete a mock exam to measure their progress and understanding. We use spaced repetition and interleaving throughout the course to ensure that students have multiple exposures to each topic. You regularly get feedback and have a parent's portal to view your child's assignments! We transform 11+ Maths exam prep from a challenge to an exciting adventure, helping your child become a resilient and prepared student. Mathematics can be a battleground for many students, especially when faced with word problems. We understand the fear of numbers, the confusion with multiplication tables, and the frustration of not being able to solve real-world math challenges. Key Details: Duration: Each half term is 5 weeks Official Lesson Start Date: January 11th at 6pm Maths Focus Areas:Algebra, advanced geometry, tricky word problems Group Size: 4 to 8 students For Just £127.00 *save 20% with our Small Business Saturday offer! What our families have to say: