• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

40 Educators providing Cube courses delivered Online

Art with Tricia

art with tricia

I studied Art & Design at Stourbridge Art College in the West Midlands for three years, before moving to West Sussex to gain an Art with Related Arts degree at Chichester University. My sculpture work featured nationally on ITV’s morning programme. Exhibitions of my work include West Dean College and Worthing Museum and Art Gallery, West Sussex. I have also had the privilege of exhibiting my work in the Awagami International Miniature Print Exhibition, Tokushima, Japan. Along with exhibitions at; Banks Mill Studios Derby, The Art House Wakefield, neo: Gallery Bolton, Gallery@OXO Oxo Tower Wharf South Bank London, Greenpea press Huntville Alabama, Hong Kong Baptist University Hong Kong and Cube gallery Moscow. After a period focusing on other art disciplines, I returned to printmaking and the joy of the process is what pushes my work forward creatively. Learning different printing methods has helped me to begin experimenting with distinctive approaches to my prints and printing style. I continue to enjoy drawing and working painterly with a variety of mixed media, developing my own instinctive style over many other art disciplines. After gaining my degree I went on to achieve my teaching qualifications, to teach 16+ students. I then gained my Qualified Teacher Learning & Skills (QTLS) professional status, which enables me to teach through all age groups (pre and post 16). I have been teaching Art classes in the West Sussex area for 20 years, both for local Adult Education and Chichester College, along with my own private workshops. I enjoy, and have taught, a wide variety of Arts & Crafts subjects and have an extensive & practical knowledge of many areas of the arts. Currently, I teach subjects as varied as Life Drawing, Watercolour, iPad Painting, Acrylics, Pastels and Chinese Brush Painting. I have also taught Pottery, Weaving, Face Painting and numerous craft classes. I am always striving to learn and pass on new techniques and ideas to my students. I hold a Level 3 NVQ in British Sign Language and am currently studying for my Level 6 NVQ. I also teach in this subject.

Ashley Leeds - The 15 Minute Guy

ashley leeds - the 15 minute guy

Sidmouth,

Do you love Instagram & FaceBook but are confused by LinkedIn? Does the stuffiness of LinkedIn intimidate you? Or, do you lack the confidence to do much on this platform or end up scrolling without getting anywhere? Don't worry. Using LinkedIn doesn’t have to be stuffy or hard. I am so confident that I can help you that I offer a Money-Back Guarantee with my interactive LIVE training. How I can help 1. Free Video Review Let me start off with a personalised video review of YOUR profile. In the video, I’ll tell you what I see when I look at your profile and offer ideas for optimisation. 2. Weekly Nudge to help you create content If you’d like the Video Review then all you need to do to get this is sign up for my weekly email which gives you 5 original ideas for creating content, every Monday. SIGN UP HERE https://www.fullcupcoaching.co.uk/free-video-review (or click the link in my Contact Info above) 3. Let’s have a quick chat. Why not book 15 minutes with me to find out why you need to do more on LinkedIn and how it can help you get a steady stream of inbound leads and position you as an expert in your industry.  Book 15 mins in my diary https://calendly.com/fullcup/15min.  A little bit about me. I've been using LinkedIn for over 11 years and have been helping people to get started with their LinkedIn journey. With over 30 years of sales experience, I know how this works. I deliver fun and energising sessions to people who want to get more from LinkedIn on a daily basis. I do this either 1:1, in Live group Zoom calls, or in my recorded workshop. My LinkedIn Daily Habit Workshops run for a whole week from 8:45 each morning for just 15 minutes. In this time you'll get into a habit that will help you get better and increase your visibility and help you to get more leads on this incredible platform.  TRAINING ACADEMY HERE ➡ https://www.letslevelup.io/ashley-leeds-learning-academy ✅ I am so confident that you’ll see improvements and love LinkedIn that I offer a 100% Money Back Guarantee.  Something FUN?  (Just in case you'd like to have a natter about something other than work): 🎸 I'm a musician. Over 370 Live streams on my FB Channel https://www.facebook.com/justdandymusic  🧘‍♀️ I do yoga and 150 of each SPS every day (Squats Sit-Ups and Press-Ups) 🦮 I'm a Puppy Raiser at Guide Dogs 🧊 I was the first person at my school in the 80's to solve the Rubik Cube (I raised £150 for Cancer in a lunch break that was when £150 would buy a hospital wing 😂)

Nick Dale Photography

nick dale photography

Here’s a brief biographical profile and outline of my photography career. If you want to see a few pictures of me, click here. If you have any questions, just click the chat button or get in touch at nick@nickdalephotography.com or on +44 7942 800921 . Photographer | Writer | Speaker | Teacher | Judge I dreamed of becoming a photographer when I was 15, but my mother wanted me to go to Oxford instead! I ended up reading English at Oxford and working as a strategy consultant for a few years before retiring at the age of 29. I then travelled round the world for seven years, doing four ski seasons and working on an internet start-up in San Francisco before finally returning to London in 2005. At that point, consulting work felt too stressful, so I decided to go 'quality of life'. I'm now a private tutor and international award-winning wildlife photographer. I became a tutor in 2009 when I happened to read an article in the paper called 'Ten Ways to Beat the Recession', and I started taking pictures again when I received a random email inviting me to go on safari and climb Mount Kenya. I've been a wildlife photographer since 2013, taking pictures in 26 countries on all seven continents and winning various awards including the Sunday Times/Audley Travel Big Shot. I spend a lot of time in Africa, and I’ve been on over 300 game drives and boat rides there. I’ve also worked as a Resident Photographer at various safari lodges: 2019: Klein’s Camp, Serengeti Under Canvas, Grumeti Serengeti Tented Camp and Cottar’s 1920s Safari Camp 2020: Gabus Game Ranch and Etosha National Park in Namibia 2022: Ol Jogi in Kenya and Muchenje in Botswana. I'm always happy to answer questions from guests, whether it’s about camera settings, the rules of composition or just identifying all the different species of wildlife. Back at camp, I'll give the odd talk on camera technique, give feedback on their images and show them some of my own. Maybe I’ll see you out there…! Artist’s Statement I have a passion for wildlife, and I want to celebrate all its facets in my photography, including power, beauty, cuteness and humour. These are the qualities I want to share with people. I’m not a conservationist, so I don’t take pictures of endangered animals to put on posters for Greenpeace or Friends of the Earth. I take them because I love close encounters with the natural world, and I want to share the excitement, relaxation, tenderness and wonder they evoke. I started out taking 'portraits' of animals. That was all very well, and a lion might look beautiful sitting on the African savannah at sunset, but there isn't much energy in that sort of picture. What I try to do now is to focus on action shots. I still take portraits - and sometimes I don't have a choice! - but my ideal image is much more likely to be a cheetah chasing down a Thomson’s gazelle than a bird sitting on a branch! My favourite animals are the predators, and the advantage of a long lens is that it can create the impression of being right up close and personal with some pretty dangerous beasts. It’s that sense of excitement that I try to capture in my work, and I'm happy to use whatever technology I can find to do the job. Cameras 2 x Sony a1 mirrorless cameras 2 x Sony VGC-4EM Vertical Grip for A1 2 x Sony 160GB TOUGH CFexpress Type A Flash Memory Cards Lenses Sony FE 12-24 mm f/2.8 G Master lens Sony FE 24-70 mm f/2.8 G Master lens Sony FE 70-200 mm f/2.8 G Master OSS II lens Sony FE 400 mm f/2.8 G Master lens Sony FE 600 mm f/4 G Master lens Sony SEL E Mount 14TC 1.4x Teleconverter - White Sony SEL E Mount 20TC 2x Teleconverter - White All that, combined with the wonders of Lightroom and Topaz Labs, gives me the best possible chance to show off the wonders of Nature. Contact If you’d like to hire me for a talk, a lesson, a photo shoot or a safari, please contact me on +44 7942 800921 or at nick@nickdalephotography.com. 99 Ormonde Court Upper Richmond Road London SW15 6TR Mobile: +44 7942 800921 Skype: nicholas_dale Facebook: facebook.com/nickdalephotography Flickr: flickr.com/photos/nickdalephotography Instagram: instagram.com/nickdalephotography LinkedIn: linkedin.com/company/nickdalephotography Pinterest: pinterest.com/nickdalephotography Twitter: twitter.com/nickdale_photo YouTube: youtube.com/@nickdalephotography View fullsize View fullsize View fullsize View fullsize View fullsize View fullsize View fullsize View fullsize View fullsize View fullsize View fullsize View fullsize Donations If you’d like to support my photographic career by making a donation, please click the button below. DONATE Sales Sold over 25,000 images to buyers including National Geographic, Africa Geographic, BBC Wildlife Magazine, The Evening Standard, The Daily Telegraph, The Guardian, Daily Mail Online, The Sun, The Sunday Express, The Times and Lonely Planet. Sold my best-selling shot of a jumping Adélie penguin over 2,000 times - and it even appeared on a poster inside the hero's locker on the US TV show Atypical! Provided the cover photo for SMT magazine. Sold 65 fine art prints to private collectors around the world. Sold over 1,000 copies of my Expert Photography ebooks on Social Success Strategies and Wonderful Wildlife. Sold over 200 greeting cards and postcards at various exhibitions, Gerhold in Putney and Willow Bough Tea Rooms. Worked for clients including a tennis club, a milliner, a local councillor, a tuition agency and a procurement consultancy. Publications Wrote ebooks on wildlife photography and social media for Expert Photography, books on Predators & Prey, India, Antarctica and a local wedding, plus Resident Photographer: Tanzania & Kenya. Wrote articles for Expert Photography, Fusion Art, Outdoor Photography, Wildlife Photographic, PhotoPXL, Clipping Path Creative and SLR Lounge. Interviewed by Fusion Art for A Day in the Life. Posted articles, images and videos online: Nick Dale Photography website: 1.0k unique monthly visitors Facebook: 4.1k followers, 22.0k engagement, 700.6k people reached, 1.1m impressions (last 28 days) Instagram: 322 accounts engaged, 2.6k accounts reached, 14.4k total followers (last 30 days) LinkedIn: 492 connections Pinterest: 399 followers, 64k impressions, 2.4k engagements, 49k total audience, 1.8k engaged audience (last 30 days) Twitter: 18 followers YouTube: 50.1k subscribers, 205k watch hours and seven videos with more than a million views - (here, here, here, here, here, here and here). Awards Shoot The Frame’s October 2022 and May 2020 Shoot The Wild competitions The Best Modern and Contemporary Artists Prize 2022 The Faces of Peace Art Prize 2022 Tailor-Made Tour Company of the Year 2022 for England in the Travel & Hospitality Awards International Prize Leonardo da Vinci - The Universal Artist 2022 ATIM's Top 60 Masters for 2022 (see magazine feature on p25 and video starting at 26:26) Wildlife category in the Professional Photographer of the Year 2021 Best International Wildlife Photographer 2021 in the Southern Enterprise Awards hosted by SME News 2021 LUX Life Photography Coach of the Year - UK National Geographic: Photo of the Day award twice (here and here), both images being chosen for the Daily Dozen and Best of Photo of the Day 2017 and winning over 25,000 likes on Instagram Monthly finalist in the Greatest Maasai Mara Photographer of the Year 2021 Gold in the Animal Portrait category of the 2020 World Nature Photography Awards Sunday Times/Audley Travel Big Shot competition Wildlife Series in the 15th Pollux Awards/The Worldwide Photography Gala Awards Best of Contest in 35 Awards’ Wildlife: Mammals competition Guru’s Top Pick in the Gurushots Up Close with Birds challenge Best of Show in Grey Cube Gallery's Nature exhibition (see video) February 2020 Arthola competition Wildlife Worldwide Photography Competition 2019 (Animal Action category) Fusion Art: Artist Spotlight (Photography & Digital) in April 2020 (see video) and Best in Show at the 3rd Annual Animal Kingdom Art Exhibition (see video) Art Room Gallery: Nature competition (see video) Exodus Travels Monthly Photo Competition The Societies of Photographers: Gold Awards in the Wildlife, Nature and The Natural World categories Society of International Nature & Wildlife Photographers (SINWP): In the Wild Photography Competition (leading to stories in The Times, Express, The Sun, The Daily Star and the Mail Online, followed by an interview on London Live!) Various: Picture Frames Express's All Creatures Great and Small plus BBC Wildlife, Chiiz, Digital Photographer, Dodho, Wild Planet and Outdoor Photography competitions ePHOTOzine: two Daily Competitions, two Photos of the Week, 10 Editor’s Choice, 26 Highly Commended, 19 Guest Editor, 119 Readers' Choice and 213 User Awards Exodus Travels: 2018 calendar (February image) Facebook groups EP Cover Photo of the Week and Admin’s Choice from Expert Photography Photo of the Day and Photo of the Week for the International Photography Group Photo of the Day and Administrator’s Choice for Light and Shade Top Post of the Day from Nature & Creativity Cover Page and Weekly Contest for Nature Photography Administrator Choice for Photographers of the World Photo of the Week for Photography Certificate of Excellence, Weekly Contest, Cover Page and Admin Choice for the Professional Photographers Community Faunistic Selection for Renaissance Photography Top of the Day, Photo of the Day and Cracker of the Day for Save Earth Admin’s Choice from Superb Photography Cover photo for Wildlife & Nature Photography Certificate of Excellence from World Photographer - Wonderful Photography Magazine Award for World’s Top Photographers Instagram: Featured photo for @wildlifeplanet.ig, Featured Artist for @all_animals_addiction and @raw_africa_ and Daily Features for @instaperfect_capture, @wildlife__perfection, @OnlyAfrica, @kings_animals_love and Bonvac_Fauna Artist of the Week for Artlimes, Photographer of the Month for Picture Frames Express, Artist in Focus for LUMIarts and featured in Pond5’s Instagram Takeover and the May 2020, January 2021 February 2021 and March 2021 APÉRO catalogues. Exhibitions Chosen to take part in the Butterfly Effect online art exhibition put on by Contemporary Art Curator Magazine. Held solo exhibitions at the Norman Plastow Gallery in Wimbledon Village, Lumi Arts in Pimlico and 508 King's Road, where I am an artist-in-residence. Took part in Glaziers' Art Fair, Parallax Art Fair, PhotoX Awards 2018 at the Menier Gallery and various group shows at 508 King's Road and Gabriel Fine Arts. Took part in the Indian Photography Festival Exhibition and see | me exhibitions on Facebook and in New York. Was chosen for the online art galleries at Art Bridge, Artfinder, Art Gallery, Arthola, The Art Online Gallery, Artlimes, Printscapes and Saatchi Art. Sold six prints of a leopard at Greatest Maasai Mara Photographer of the Year exhibitions in Melbourne, Brisbane, Cape Town, Atlanta, Dallas and Johannesburg. Other Worked as Resident Photographer at Klein’s Camp, Serengeti Under Canvas, Grumeti Serengeti Tented Camp and Cottar’s 1920s Safari Camp in Africa for four months in 2019. Worked as Resident Photographer at Gabus Game Ranch in 2020. Gave talks for The Societies of Photographers, on two Antarctic cruise ships and at The Athenaeum Club, Grumeti Serengeti Tented Camp, Cottar’s 1920s Safari Camp, the SW19 Women's Institute, the Putney Women’s Institute, Malden Camera Club, Watford Camera Club, Putney Library, the London Institute of Photography and Beckenham Photographic Society. Helped judge the 2019 Canary Wharf Wildlife Photography Competition. Ran photography workshops at Canary Wharf and Putney Library. Gave private lessons to various amateur photographers. Recorded six wildlife photography videos with Coinaphoto, covering Africa, Asia, Europe, North America, South America and the polar regions. Had my work reviewed by Anthony Morganti on YouTube Became lifetime member of the Circle for the Foundation of the Arts (CFA). Joined the Society of International Nature and Wildlife Photographers in October 2013.

Courses matching "Cube"

Show all 80

ICCC-CT-Installing and Configuring Cisco Cube/Gateways

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is as follows: Network Video Engineer Voice/UC/Collaboration/Communications Engineer Collaboration Tools Engineer Collaboration Sales/Systems Engineer In this 3 Day Cisco Course, students will learn how to deploy Voice Gateways/CUBE and setup Cisco Unified Communication Manager (CUCM) to deploy SIP Trunking. The course starts out with an overview of Cisco gateways and their uses. Next, students learn about MGCP and SIP and how to implement each protocol. Students will then learn how to use Cisco CUBE to connect CUCM, Gateways and Service Providers together. This course details how to connect a Cisco environment to a Service Provider using a Cisco CUBE. Introduction to Voice Gateways Cisco UC Networks and the Role of Gateways Gateway Call Routing and Call Legs Configuring Gateway Voice Ports DSP Functionality, Codecs, and Codec Complexity Router Requirements for CUBE SIP Protocol Overview Gateway Dial Plans VoIP Call Legs Dial Plan Implementation Configuring (CUCM) Cisco Unified Communication Manager 12.5 Cisco UCM Audio Codec Preference List Cisco UCM Region Configuration Device Pool Configuration Annunciator Configuration Conference Bridge Configuration Media Termination Point Configuration Music on Hold Server Configuration Music on Hold Service (IP Voice Media Streaming App) Parameter Settings Music on Hold Service (Duplex Streaming) Parameter Settings Media Resource Group Configuration Media Resource Group List Configuration UC Service Configuration Service Profile Configuration End User Configuration SIP Trunk Security Profile Configuration used by SIP trunk to Cisco UBE SIP Profile Configuration used by SIP trunk to Cisco UBE SIP Trunk to Cisco UBE Configuration Route Pattern Configuration Configuring Cisco Unified Border Element (CUBE) Deploying Cisco VCUBE CUCM to CUBE Integration Configuration Steps to connecting to a SIP Trunk Provider Interworking Security and Call Admission Control Media Manipulation, Enhancement & Optimization SIP UA Translation Rules VoIP Dial Peer SIP Registration SIP attributes of CUBE Transcoding services Creating and configuring Sip Trunks CUBE Configuration CUBE Call Flow CUBE Dial-Peers Call Routing CUBE Advanced Call Routing Media Manipulation External/PSTN Call Recording Call Admission Control Multiple Non-Authenticated SIP Trunks on a CUBE Multiple Authenticated/Registered SIP Trunks on a CUBE Configuring High Availability High availability on ISR G2 High availability on ISR 4k High availability on ASR Cisco Unified Border Element (CUBE) Security Five Layers of Security in CUBE SIP TLS Support with SRTP Monitoring and Troubleshooting Cisco CUBE Dialed Number Analyzer (DNA) for CUBE SIP Profile Test Tool Troubleshooting Serviceability

ICCC-CT-Installing and Configuring Cisco Cube/Gateways
Delivered OnlineFlexible Dates
Price on Enquiry

B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Data Modelers Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data. Introduction to IBM Cognos Dynamic Cubes Define and differentiate Dynamic Cubes Dynamic Cubes characteristics Examine Dynamic Cube requirements Examine Dynamic Cube components Examine high level architecture IBM Cognos Dynamic Query Review Dimensional Data Structures Dynamic Cubes caching Create & Design a Dynamic Cube Explore the IBM Cognos Cube Designer Review the cube development process Examine the Automatic Cube Generation Manual development overview Create dimensions Model the cube Best practice for effective modeling Deploy & Configure a Dynamic Cube Deploy a cube Explore the Estimate Hardware Requirements Identify cube management tasks Examine Query Service administration Explore Dynamic Cube properties Schedule cube actions Use the DCAdmin comment line tool Advanced Dynamic Cube Modelling Examine advanced modeling concepts Explore modeling caveats Calculated measures and members Model Relative Time Explore the Current Period property Define period aggregation rules for measures Advanced Features of Cube Designer Examine multilingual support Examine ragged hierarchies and padding members Define Parent-Child Dimensions Refresh Metadata Import Framework Manager packages Filter measures and dimensions Optimize Performance with Aggregates Identify aggregates and aggregate tables In-memory aggregates Use Aggregate Advisor to identify aggregates User defined in-memory aggregates Optimize In-Memory Aggregates automatically Aggregate Advisor recommendations Monitor Dynamic Cube performance Model aggregates (automatically vs manually) Use Slicers to define aggregation partitions Define Security Overview of Dynamic Cube security Identify security filters The Security process - Three steps Examine security scope Identify scope rules Identify roles Capabilities and access permissions Cube security deep dive Model a Virtual Cube Explore virtual cubes Create the virtual cube Explore virtual cube objects Examine virtual measures and calculated members Currency conversion using virtual cubes Security on virtual cubes Introduction to IBM Cognos Analytics Define IBM Cognos Analytics Redefined Business Intelligence Self-service Navigate to content in IBM Cognos Analytics Interact with the user interface Model data with IBM Cognos Analytics IBM Cognos Analytics components Create reports Perform self-service with analysis and Dashboards IBM Cognos Analytics architecture (high level) IBM Cognos Analytics security Package / data source relationship Create Data modules Upload files Additional course details: Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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 B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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.

B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)
Delivered OnlineFlexible Dates
Price on Enquiry

Oracle SQL Advanced

5.0(3)

By Systems & Network Training

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

Oracle SQL Advanced
Delivered in Internationally or OnlineFlexible Dates
£1,727

77-728 Complete Techniques for the MOS Excel Expert Exam

By Packt

Become a Microsoft Certified Excel Expert - includes lectures, test exercises, and video solutions

77-728 Complete Techniques for the MOS Excel Expert Exam
Delivered Online On Demand9 hours 18 minutes
£121.99

55125 Quick SQL Server Analysis Services

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals. Overview ?Understand common Analysis Services solutions.?Understand version changes of SSAS from 2008-2014.?Understand Analysis Services installation and architecture.?Understand how to choose the right model.?Understand the Analysis Services tools available.?Understand the multidimensional model.?Utilize data sources and data source views.?Create a cube.?Understand and utilize dimensions.?Understand and utilize attributes.?Understand and utilize relationships.?Understand and utilize hierarchies.?Understand and utilize measures and measure groups.?Understand and utilize calculated members.?Understand and utilize perspectives.?Understand and utilize translations.?Browse perspectives and translations.?Understand and utilize deployment options.?Understand and utilize processing strategies.?Understand and utilize security.?Deploy a multidimensional model.?Understand the tabular model.?Create a tabular project.?Analyze the data using Microsoft Excel.?Create and configure calculated measures and calculated fields.?Backup and Restore. This course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. Course Overview Introduction Course Materials Facilities Prerequisites What We'll Be Discussing Lab 1: Course Overview Introduction to Microsoft SQL Server Analysis Services Common Analysis Services Solutions Version Changes of SSAS from 2008-2014 Analysis Services Installation and Architecture: One Product, Two Models Choosing the Right Model Analysis Services Tools Lab 1: Introduction to Microsoft SQL Server Analysis Services The Multidimensional Solution Understanding the Multidimensional Model Utilizing Data Sources and Data Source Views Creating a Cube Lab 1: The Multidimensional Solution Dissecting with Dimensions Developing Dimensions Utilizing Attributes Relating with Relationships Handling Hierarchies Lab 1: Dissecting with Dimensions Managing Measures Measures and Measure Groups Calculated Members Lab 1: Managing Measures Configuring Cube Options Understanding Perspectives Utilizing Translations Browsing Perspectives and Translations Lab 1: Configuring Cube Options Deploying Examining Deployment Options Processing Strategies Exploring Security Lab 1: Deploying The Tabular Solution Understanding the Tabular Model Creating a Tabular Project Deploying Browsing the Model Querying the Solution and Understanding DAX Maintaining and Optimizing Lab 1: The Tabular Solution

55125 Quick SQL Server Analysis Services
Delivered OnlineFlexible Dates
Price on Enquiry

Querying Microsoft SQL Server

5.0(3)

By Systems & Network Training

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Querying Microsoft SQL Server
Delivered in Internationally or OnlineFlexible Dates
£2,797

From Traditional to Digital Drawing

5.0(10)

By Apex Learning

Give a compliment to your career and take it to the next level. This From Traditional to Digital Drawing bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this From Traditional to Digital Drawing bundle will help you stay ahead of the pack. Throughout the From Traditional to Digital Drawing programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this From Traditional to Digital Drawing course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This From Traditional to Digital Drawing Bundle Consists of the following Premium courses: Course 01: Fundamentals of Drawing Course Course 02: Drawing and Illustration Level 2 Course 03: Art, Drawing and Painting Diploma Course 04: Read Construction & Structural Drawing Like Expert Course 05: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 06: Digital Art - Sketching In Photoshop Course 07: Advanced Digital Painting Course Course 08: Learn to Make Vector Art on Adobe Illustrator Course 09: Architectural Studies Course 10: Mastering Colour-Architectural Design & Interior Decoration Course 11: Creative Thinking for Everyday Life Enrol now in From Traditional to Digital Drawing to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your From Traditional to Digital Drawing expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum: Fundamentals of Drawing Course Introduction Introduction Materials Perspective What is a Horizone Line One Point Perspective of a Cube Two Point Perspective of a Cube Perspective of a Cylinder How to draw a Perfect Sphere Shading Shading a Sphere Shading a Cylinder Shading a Cube Measuring How to Measure Still Life Drawing Compostion and placement Finding the perspective and drawing the box Constructing the Cup Drawing the Drapes Shading - Part 1 Shading - Part 2 Shading - Part 3 Drawing a Portrait Drawing a Face - Part 1. Construction Drawing a Face - Part 2. Refining the features Drawing a Face - Part 3. Shading Drawing a Face - Part 4. Final touches Drawing a Tree Drawing a Tree And 10 more courses ... CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this From Traditional to Digital Drawing bundle. Requirements This From Traditional to Digital Drawing course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Cost of PDF Certificates is included in course price Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Fundamentals of Drawing Course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cos

From Traditional to Digital Drawing
Delivered Online On Demand
£39

Drawing Fundamentals

By The Teachers Training

Drawing Fundamentals is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Drawing Fundamentals and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 5 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Introduction Introduction 00:03:00 Materials 00:08:00 Perspective What is a Horizone Line 00:11:00 One Point Perspective of a Cube 00:10:00 Two Point Perspective of a Cube 00:12:00 Perspective of a Cylinder 00:17:00 How to draw a Perfect Sphere 00:09:00 Shading Shading a Sphere 00:22:00 Shading a Cylinder 00:19:00 Shading a Cube 00:13:00 Measuring How to Measure 00:07:00 Still Life Drawing Compostion and placement 00:09:00 Finding the perspective and drawing the box 00:18:00 Constructing the Cup 00:22:00 Drawing the Drapes 00:05:00 Shading - Part 1 00:14:00 Shading - Part 2 00:19:00 Shading - Part 3 00:22:00 Drawing a Portrait Drawing a Face - Part 1. Construction 00:21:00 Drawing a Face - Part 2. Refining the features 00:10:00 Drawing a Face - Part 3. Shading 00:18:00 Drawing a Face - Part 4. Final touches 00:12:00 Drawing a Tree Drawing a Tree 00:16:00 Resources Resources - Drawing Fundamentals 00:00:00

Drawing Fundamentals
Delivered Online On Demand5 hours 17 minutes
£27.99

Art, Drawing and Painting Diploma

By The Teachers Training

Overview Art, Drawing and Painting Diploma Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Art, Drawing and Painting Diploma Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Introduction Introduction 00:03:00 Materials 00:08:00 Perspective What is a Horizone Line 00:11:00 One Point Perspective of a Cube 00:10:00 Two Point Perspective of a Cube 00:12:00 Perspective of a Cylinder 00:17:00 How to draw a Perfect Sphere 00:09:00 Shading Shading a Sphere 00:22:00 Shading a Cylinder 00:19:00 Shading a Cube 00:13:00 Measuring How to Measure 00:07:00 Still Life Drawing Compostion and placement 00:09:00 Finding the perspective and drawing the box 00:18:00 Constructing the Cup 00:22:00 Drawing the Drapes 00:05:00 Shading - Part 1 00:14:00 Shading - Part 2 00:19:00 Shading - Part 3 00:22:00 Drawing a Portrait Drawing a Face - Part 1. Construction 00:21:00 Drawing a Face - Part 2. Refining the features 00:10:00 Drawing a Face - Part 3. Shading 00:18:00 Drawing a Face - Part 4. Final touches 00:12:00 Drawing a Tree Drawing a Tree 00:16:00 Resources Resources - Art, Drawing and Painting Diploma 00:00:00

Art, Drawing and Painting Diploma
Delivered Online On Demand5 hours 17 minutes
£24.99

Drawing and Illustration Level 2

5.0(10)

By Apex Learning

Overview Have you always had a passion for art, and are you trying to improve your relationship with artists? Enhance your creative abilities with our Drawing and Illustration Level 2 course. Learn the fundamentals of sketching, shading, still-life composition, and portrait drawing. Our best-selling Drawing and Illustration course will provide you with all the necessary details and pieces of knowledge to learn more about a new and challenging profession in art, drawing, or painting. The course aims to impart strategies that will enable you to communicate your creative vision. This training also helps you develop your creative abilities and reach new heights in your creativity. This engaging course covers everything from composition, painting, and style experimentation to the basics of sketching and colouring. It covers various subjects, such as painting on canvas, selecting brushes for your artwork, practising different painting techniques, creating artwork with pencil, and learning the fundamentals of sketching and colouring. 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? Art enthusiasts eager to enhance their drawing skills. Beginners looking to explore the world of illustration in a structured learning environment. Students seeking to build a strong foundation in art and design. Hobbyists interested in refining their techniques and expanding their artistic repertoire. Anyone passionate about self-expression and visual storytelling through drawing. Requirements Our Drawing and Illustration Level 2 has been designed to be fully compatible with tablets and smartphones. Here are some common requirements you may need: Computer, smartphone, or tablet with internet access. English language proficiency. Required software/tools. (if needed) Commitment to study and participate. There is no time limit for completing this course; it can be studied at your own pace. Career Path Popular Career Paths for a Drawing and Illustration Level 2Course: Illustrator: £20,000 - £40,000 Graphic Designer: £20,000 - £35,000 Art Teacher: £25,000 - £40,000 Freelance Artist: Earnings vary based on projects Storyboard Artist: £25,000 - £45,000 Art Director: £30,000 - £60,000 Salary ranges can vary by location and experience. Course Curriculum 8 sections • 24 lectures • 05:17:00 total length •Introduction: 00:03:00 •Materials: 00:08:00 •What is a Horizone Line: 00:11:00 •One Point Perspective of a Cube: 00:10:00 •Two Point Perspective of a Cube: 00:12:00 •Perspective of a Cylinder: 00:17:00 •How to draw a Perfect Sphere: 00:09:00 •Shading a Sphere: 00:22:00 •Shading a Cylinder: 00:19:00 •Shading a Cube: 00:13:00 •How to Measure: 00:07:00 •Compostion and placement: 00:09:00 •Finding the perspective and drawing the box: 00:18:00 •Constructing the Cup: 00:22:00 •Drawing the Drapes: 00:05:00 •Shading - Part 1: 00:14:00 •Shading - Part 2: 00:19:00 •Shading - Part 3: 00:22:00 •Drawing a Face - Part 1. Construction: 00:21:00 •Drawing a Face - Part 2. Refining the features: 00:10:00 •Drawing a Face - Part 3. Shading: 00:18:00 •Drawing a Face - Part 4. Final touches: 00:12:00 •Drawing a Tree: 00:16:00 •Assignment - Drawing and Illustration Level 2: 00:00:00

Drawing and Illustration Level 2
Delivered Online On Demand5 hours 17 minutes
£12