61 Cube courses in Birmingham delivered On Demand

Dive into the dynamic realm of WebGL 2D/3D Programming and Graphics Rendering through this comprehensive course. Explore various sections, from foundational concepts to advanced techniques in drawing objects, applying colors and textures, transforming objects, camera movement, lighting, and shading. Participants will develop the skills to create captivating and immersive graphics using WebGL technology. Learning Outcomes: Grasp the fundamentals of WebGL programming and graphics rendering. Create and manipulate objects using WebGL for both 2D and 3D environments. Apply colors and textures to enhance the visual quality of graphics. Implement object movement and transformation techniques. Understand camera manipulation and movement for dynamic views. Master lighting and shading techniques for realistic visual effects. Apply learned concepts to real-world graphics rendering projects. Develop proficiency in WebGL programming for interactive graphics applications. Why buy this WebGL 2D/3D Programming and Graphics Rendering?  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 WebGL 2D/3D Programming and Graphics Rendering you will be able to take the MCQ test that will assess your knowledge. 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 WebGL 2D/3D Programming and Graphics Rendering course is ideal for Programmers and developers interested in graphics programming using WebGL. Computer graphics enthusiasts seeking to expand their knowledge and skills. Students pursuing degrees in computer science or related fields. Designers looking to integrate interactive and visually appealing graphics into their projects. Prerequisites This WebGL 2D/3D Programming and Graphics Rendering 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 Junior Web Developer: £20,000 - £30,000 WebGL Developer: £30,000 - £45,000 Graphics Programmer: £35,000 - £50,000 Senior Software Engineer (Graphics): £45,000 - £70,000 Technical Lead (Graphics Programming): £60,000 - £90,000. Course Curriculum Section 01: Introduction WebGL vs OpenGL vs OpenGL ES 00:05:00 Setup Server (Mac, Windows and Linux) 00:05:00 Setup WebGL Project 00:08:00 Section 02: Drawing Objects WebGL Rendering Pipeline 00:04:00 Drawing A Point 00:22:00 Normalised Coordinates vs Device Coordinates 00:10:00 Drawing A Simple Triangle 00:06:00 Drawing A Line Using gl.LINES 00:03:00 Drawing A Line Using gl.LINE_STRIP & gl.LINE_LOOP 00:03:00 Drawing A Triangle With Lines Using gl.TRIANGLE_STRIP & gl.TRIANGLE_FAN 00:03:00 Drawing A Quad 00:07:00 Drawing A 3D Cube 00:24:00 Setup Three.js 00:06:00 Loading & Drawing A Model Using Three.js 00:16:00 Section 03: Colours and Textures Applying Color To Shapes 00:09:00 One Color Per Triangle 00:15:00 One Color Per Vertex Using Interpolation 00:02:00 Applying A Texture To Shapes 00:23:00 Texture Coordinates 00:08:00 Section 04: Moving & Transforming Objects Moving Objects Using Translation 00:06:00 Left Handed vs Right Handed Coordinate System 00:06:00 Sizing Objects Using Scaling 00:06:00 Combining Transformations 00:07:00 Section 05: Movement & Camera Mouse Input 00:11:00 Keyboard Input 00:09:00 Fixing Rotation and Adding Individual Rotation 00:08:00 Section 06: Lighting & Shading Ambient Lighting 00:13:00 Section 07 Resource Resource 00:00:00 Assignment Assignment - WebGL 2D/3D Programming and Graphics Rendering 00:00:00

Are you a business owner or managing director, looking forward to improving safety issues at the workplace? Then Workplace Safety Diploma will be beneficial for you and your needs! Providing safety in the workplace is one of the most complicated jobs for any business owner. Through this course, you will learn about the roles and duties of a manager or a business owner towards their employees linked to its safety. Following that, you will also learn about the methods of developing and implementing safety standards and the benefits of applying the health and safety procedures at the workplace in order to create a positive and healthy environment. Furthermore, this course delivers you an understanding of risk management and its process. With the help of this diploma course, you will learn how to maintain safety at the workplace, plan and execute an effective safety policy that will prevent injuries and guard your employees against any kind of accident or unexpected circumstances. Learning Outcomes: What a safety plan will include How to understand and write an Organizational Safety Policy The importance of the Introduction to the Safety Plan How to develop a basic Communications Plan for a specific accident/incident occurrence Ways to decide on training solutions to common accidents/incidents How to understand and explain the importance and structure of Incident Response Plans and Critical Incident Response Plans How to understand Safety Inspections and Safety Audits as methods to identify unsafe conditions and apply corrective action How to use a 6S Inspection Checklist to conduct a 6S Inspection How to brainstorm policies and procedures that you might find in the Appendix of a Safety Plan How to help your organization write, implement, and review a safety plan Devise a Safety Procedure Framework Improvise a flowchart to perform process activities with an accurate depiction Exploit the brainstorming so that you can gather the crucial information for a safety procedure creation Realise a range of procedure types including (Step-by-step, Playscript, The Decision Tree and Decision Tables) Learn how to write and review Step-by-Step safety procedures Impart communication contents for the safety procedures Provide a definition for risk along with risk management Relate the COSO ERM cube as well as ISO 31000 Learn how to establish a risk management context Narrate the 7 R's along with the 4 T's forming the framework of your risk management activities Design and complete a basic risk assessment Device designs to complete a fundamental risk management Fix the the proper response linked to risks as well as form a strategy for those responses Narrate the prime elements for reporting, monitoring, as well as evaluating a risk management program Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Workplace Safety Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Workplace Safety Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Defining a Safety Culture 00:15:00 Governing Bodies and Resources 00:15:00 Getting Started 00:15:00 Identifying Hazards 00:15:00 Resolving Hazards 00:19:00 Taking Proactive Measures 00:17:00 Identifying Groups at Risk 00:30:00 Writing a Safety Plan 00:15:00 Implementing the Plan 00:15:00 Incident Management 00:30:00 Reviewing the Program 00:15:00 Module : 2 Writing a Safety Plan 00:15:00 Organizational Safety Policy 00:15:00 Introduction to the Safety Plan 00:15:00 Communications Plan 00:15:00 Safety Training 00:15:00 Incident Response Plan (with Critical Incident Response Plan) 00:15:00 Safety and Health Inspections (with 6S) 00:15:00 Safety Audits 00:15:00 Module : 3 Setting the Stage 00:15:00 Safety Procedures Basics 00:15:00 Flowcharting 00:30:00 Gathering Information 00:30:00 Procedure Writing 00:15:00 Honing the Draft Procedure 00:30:00 Some Other Methods 00:15:00 Module : 4 What is a High Reliability Organization? 00:30:00 Key Concepts 00:30:00 The Anticipation Principles 00:30:00 The Containment Principles 00:15:00 Auditing for High Reliability 00:15:00 Test Driving 00:30:00 Module : 5 Understanding Risk 00:30:00 Risk Management Activities 00:05:00 Assessing Risk 00:15:00 Responding to Risks 00:15:00 Resourcing Controls 00:05:00 Reaction Planning 00:15:00 Reporting and Monitoring 00:15:00 Reviewing and Evaluating the Framework 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Speed Up Your Calculation with Mental Mathematics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Speed Up Your Calculation with Mental Mathematics 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 Speed Up Your Calculation with Mental Mathematics. It is available to all students, of all academic backgrounds. Requirements Our Speed Up Your Calculation with Mental Mathematics 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 19 sections • 74 lectures • 09:08:00 total length •Introduction: 00:02:00 •Important Instructions: 00:01:00 •Multiplication by 11,22,33 Part 1: 00:05:00 •Multiplication by 11,22,33 Part 2: 00:07:00 •Multiplying with 12,13,14,15 etc. Part 3: 00:08:00 •Multiplying with 12,13,14,15 etc. Part 4: 00:06:00 •Downloadable Resources: 00:00:00 •Finding squares of numbers ending with 5: 00:05:00 •When numbers add up to ten in unit place and ten's place digits are same: 00:06:00 •Downloadable Resources: 00:00:00 •Product of two numbers below the base: 00:11:00 •Product of two numbers one above and other below the base: 00:10:00 •Squaring of numbers near to the base: 00:10:00 •Multiples and Sub-Multiples Technique Part 1: 00:15:00 •Multiples and Sub-Multiples Technique Part 2: 00:08:00 •Multiples and Sub-Multiples Technique Part 3: 00:07:00 •Multiplication of three numbers near to base: 00:07:00 •Multiplication of three numbers near to base - Special Case: 00:08:00 •Multiplying any digit number by series of 9; 99; 999; 99999 Part 1: 00:10:00 •Multiplying any digit number by series of 9; 99 ; 999 ; 99999 Part 2: 00:09:00 •Multiplying any digit number by series of 9; 99 ; 999 ; 99999 Part 3: 00:06:00 •Downloadable Resources: 00:00:00 •Multiplying any two digit numbers using Vertically and Crosswise: 00:06:00 •Multiplying three digit numbers using Vertically and Crosswise: 00:07:00 •Multiplying four digit numbers using Vertically and Crosswise: 00:07:00 •Multiplying different digit numbers using Vertically and Crosswise: 00:06:00 •Finding remainder when any digit number is divided by 9: 00:06:00 •Multiplying any digit number by 5, 25, and 125 faster than calculator: 00:09:00 •Downloadable Resources: 00:00:00 •Times Tables Part 1: 00:10:00 •Times Tables Part 2: 00:10:00 •Times Tables Part 3: 00:12:00 •Downloadable Resources: 00:00:00 •Simple Mental Addition: 00:09:00 •Left to Right Addition Part 1: 00:12:00 •Left to Right Addition Part 2: 00:05:00 •Left to Right Addition Part 3: 00:13:00 •Downloadable Resources: 00:00:00 •Addition by Dropping ten's method single digit numbers: 00:07:00 •Addition by Dropping ten's method two-digit numbers: 00:04:00 •Addition by Dropping ten's method three-digit numbers: 00:07:00 •Addition by grouping to ten's method single digit numbers: 00:04:00 •Addition by grouping to ten's method two-digit numbers: 00:06:00 •Addition by grouping to ten's method three-digit numbers: 00:03:00 •Simple Mental Subtraction: 00:05:00 •Left to Right Subtraction Part 1: 00:09:00 •Left to Right Subtraction Part 2: 00:10:00 •Left to Right Subtraction Part 3: 00:10:00 •Left to Right Subtraction Using Nikhilam Sutra: 00:09:00 •Downloadable Resources: 00:00:00 •Division by 9 in 2 seconds: 00:05:00 •Division by 9 continues: 00:06:00 •Division by Nikhiliam Sutra in single line in 2 seconds: 00:14:00 •Division by Nikhiliam Sutra for non-terminating recurring decimals: 00:06:00 •Straight Division by Vedic Math: 00:09:00 •Division by two-digit number: 00:07:00 •Division by three-digit number: 00:07:00 •Division - when answers are in decimals: 00:12:00 •Division by three or four-digit numbers: 00:09:00 •Straight Division - Two special problems: 00:08:00 •What is digital sum of a number?: 00:07:00 •Application of digital sum in addition & subtraction: 00:12:00 •Application of digital sum in multiplication: 00:06:00 •Application of digital sum in Division: 00:08:00 •Duplex of any Digit Number: 00:07:00 •Straight Squaring using Duplex Method Part 1: 00:12:00 •Straight Squaring using Duplex Method Part 2: 00:12:00 •Square Root Using Duplex Method Part 1: 00:15:00 •Square Root Using Duplex Method Part 2: 00:11:00 •Square Root Using Duplex Method Part 3: 00:10:00 •Finding cubes of two Digit Numbers: 00:12:00 •Cube roots Using Fastest Techniques: 00:08:00 •How to find Day of the week in 2 Seconds Part 1: 00:09:00 •How to find Day of the week in 2 Seconds Part 2: 00:09:00

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 08 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 09 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 10 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 11 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 12 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 13 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 SQL for Data Analytic - Advanced Level Module: 16 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 17 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00

Wood Therapy aka Maderoterapia What is wood therapy? Wood therapy is a technique in which a rigorous and complete massage is performed with the help of various utensils made of wood. Each of these instruments has a specific shape and size since they adapt to different areas of the body to fulfil a function. Benefits: Redaction of cellulite Body contouring Bum Lift Helps to reduce stress and muscle tension Increases blood circulation Lymphatic drainage support Course Content: What is wood therapy History of wood therapy Benefits of wood therapy Contraindications Tools and their usage Anatomy Lymphatic system Health and Safety Consultation Step by step process Aftercare Training kit(if purchased with course) *Please note this is essential to complete the course Cube roller Diamond Roller Swiss Cup Contouring board Certificate You will receive an end of course certificate which is accredited by the cpd group and allows you to work on public How do Online Courses work? http://www.kbhtrainingacademy.com/online-courses Duration of Course? You will have 3 months to complete the course before it expires Will I require a model? Yes, 1 case of studies required Are there video tutorials? Yes, you will have links to YouTube and training videos to watch the treatment being performed Do you offer finance? http://www.kbhtrainingacademy.com/finance

In this course, our focus is to create an entire foliage pack completely made in Blender-one of the top open-source and free 3D modeling software out there. You will learn how to create 12 different foliage types with over 30 variations, including plants, grass, water lilies, and reeds; you will also learn how to integrate them into UE5 (Unreal Engine 5).

This course will teach you Unity game development and C# scripting in a simple and practical way. You will work on more than 20 amazing mini projects to understand the 2D and 3D features of Unity and C# programming concepts.

This course is a perfect option if you are interested in 3D printing and/or laser cutting as you will learn to design for both. Explore the specific factors you need to take into account for laser cutting and 3D printing, and advance your 3D modeling skills using Autodesk Fusion 360 software to realize your ideas.

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Follow your dreams by enrolling on the A to Z SQL Programming course today and develop the experience, skills and knowledge you need to enhance your professional development. A to Z SQL Programming will help you arm yourself with the qualities you need to work towards your dream job. Study the A to Z SQL Programming training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The A to Z SQL Programming course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This A to Z SQL Programming course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the A to Z SQL Programming course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the A to Z SQL Programming course, to ensure you are supported every step of the way. Get a digital certificate as proof of your A to Z SQL Programming course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the A to Z SQL Programming course. The A to Z SQL Programming course is designed by industry experts and is tailored to help you learn new skills with ease.  The A to Z SQL Programming is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the A to Z SQL Programming when it suits you. Access the A to Z SQL Programming course modules from any internet-enabled device, including computers, tablets, and smartphones. The A to Z SQL Programming course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the A to Z SQL Programming now and start learning instantly! What You Get Out Of Studying A to Z SQL Programming With Janets: Receive a digital Certificate upon successful completion of the A to Z SQL Programming course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The A to Z SQL Programming training course is delivered through Janets' online learning platform. Access the A to Z SQL Programming content from any internet-enabled device whenever or wherever you want to. The A to Z SQL Programming course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the A to Z SQL Programming course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the A to Z SQL Programming course. After successfully passing the A to Z SQL Programming course exam, you will be able to apply for a CPD-accredited certificate as proof of your A to Z SQL Programming qualification. Certification All students who successfully complete the A to Z SQL Programming course can instantly download their digital certificate. You can also purchase a hard copy of the A to Z SQL Programming course certificate, which will be delivered by post for £9.99. Who Is This Course For: The A to Z SQL Programming is ideal for those who already work in this sector or are an aspiring professional. This A to Z SQL Programming course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The A to Z SQL Programming is open to all students and has no formal entry requirements. To study the A to Z SQL Programming course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The A to Z SQL Programming is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the A to Z SQL Programming and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Beginner Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 Intermediate Module: 01 Topic A Aggregates 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 02 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 03 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 04 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 05 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 06 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 07 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 08 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 09 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 Advanced Module: 01 Topic A Partitioning 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 02 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 03 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 04 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00 Mock Exam Mock Exam - A to Z SQL Programming 00:20:00 Final Exam Final Exam - A to Z SQL Programming 00:20:00