40399 Design courses

Course Overview Gain the skills to create low poly mobile games, explore the fundamentals of 3D art, and learn how to model complex shapes, and more in this Maya masterclass. The Maya: UV Mapping 3D Knife course will teach you step-by-step how to create a 3D weapon model using Maya, from basic primitives. Through instructor-guided video tutorials, you will learn tips and best practices for using Maya's modelling, rendering and texturing tools, to make high quality AAA game assets from scratch. It will equip you with the skills to utilise the shortest possible pipeline, and master UV mapping in no time. This comprehensive training course is open to learners of all levels. Start building your portfolio and kickstart an exciting career in game development today. This best selling Maya: UV Mapping 3D Knife has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Maya: UV Mapping 3D Knife is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Maya: UV Mapping 3D Knife is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Maya: UV Mapping 3D Knife is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Maya: UV Mapping 3D Knife, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Maya: UV Mapping 3D Knife will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Maya: UV Mapping 3D Knife to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Learn how to create an animated 3D cartoon owl in Blender 3D, with our step-by-step guide. The Create a Cartoon Owl with Blender 3D course will walk you through the process of creating a simple low poly owl character from scratch. You will start from the very basics, from downloading and setting up the program, to starting your first project. It will introduce you to Blender's essential tools and features which you will learn about in-depth to create 3D films, animations, applications, and 3D models. By the end of the course, you will have a valuable set of industry skills, from 3D rendering to modelling. You will also be able to work efficiently with the camera view, and use Boolean modifiers. This best selling Create a Cartoon Owl with Blender 3D has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Create a Cartoon Owl with Blender 3D is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Create a Cartoon Owl with Blender 3D is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Create a Cartoon Owl with Blender 3D is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Create a Cartoon Owl with Blender 3D, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Create a Cartoon Owl with Blender 3D will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Create a Cartoon Owl with Blender 3D to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Learn how to create a low poly tree for games in Maya and upload it to Unity for mobile game development, with this complete video-guide course. The Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D course is a complete walk through masterclass for beginners, starting with familiarising you with the basic tools. Through video training tutorials and instructor-led guidance, it will take you through the necessary steps to create a low poly tree from scratch in less than 10 minutes.  From mastering 3D mapping, to texturing techniques, you will gain the expertise required to create professional low poly trees for video games and apps. This course is ideal for 3D artists and game developers, and there are no specific entry requirements for enrolment. This best selling Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Modeling Lowpoly Tree for Mobile Games in Maya & Unity 3D to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Learn how to create a low poly scene in Maya and import it into Unity for mobile game development, with this step-by-step training course. The Modeling Environments for Mobile Games in Maya & Unity 3D course covers everything you need to know to set up and create your project. It will teach you how to import and export the models from Maya to Unity, model the base of the island, add special camera effects, birds and much more. This course is ideal for game developers and 3D artists. By the end of this training, you will be able to set up the scene in Unity 3D to create the incredible mood and atmosphere of the Monument Valley game. You will have a range of in-demand skills required to work across a wide range of creative fields. This best selling Modeling Environments for Mobile Games in Maya & Unity 3D has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Modeling Environments for Mobile Games in Maya & Unity 3D is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Modeling Environments for Mobile Games in Maya & Unity 3D is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Modeling Environments for Mobile Games in Maya & Unity 3D is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Modeling Environments for Mobile Games in Maya & Unity 3D, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Modeling Environments for Mobile Games in Maya & Unity 3D will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Modeling Environments for Mobile Games in Maya & Unity 3D to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Make a dynamic image of a fictional figure from a far-off future by taking this course on how to Create a Character from The Post-Apocalypse. Exploring the years ahead of humanity has never been more popular in the media and provides plenty of artistic potentials. This tutorial will guide you in visually conceptualising a resident from a distant possible reality. By taking this Character Creation coaching, you can follow the steps to produce a drawing of a fictional figure that might be able to survive and thrive in any circumstance. From blank paper to the final image, you will be guided in seeking inspiration and bringing your ideas to the page. By creating this character and producing an eye-catching image, you will learn how to populate a post-apocalypse world with more of your creations. This best selling Create A Character From The Post-Apocalypse has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Create A Character From The Post-Apocalypse is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Create A Character From The Post-Apocalypse is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Create A Character From The Post-Apocalypse is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Create A Character From The Post-Apocalypse, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Create A Character From The Post-Apocalypse will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Create A Character From The Post-Apocalypse to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Flash Sale Now On | Gifts: PDF Certificate

⚠️ Be Ready to Act. Be Ready to Save a Life. 💉 Anaphylaxis is a severe, life-threatening allergic reaction — and every second counts. The RQF Level 3 Management of Anaphylaxis course gives you the knowledge, skills, and confidence to respond effectively in an emergency. 🧠 What you’ll learn: ✅ Causes, triggers & symptoms of anaphylaxis 👁️ How to recognise and respond to anaphylactic reactions 💉 Safe use of adrenaline auto-injectors (e.g. EpiPen) 📋 Risk assessment & allergy management planning 🗣️ Communication & support during emergencies ⚖️ Legal and ethical responsibilities Perfect for schools, workplaces, healthcare, and community settings. 📅 Get certified. Be prepared. Save lives. #AnaphylaxisAwareness #FirstAidTraining #EpiPen #LifeSavingSkills #AllergyAwareness #RQFLevel3 #EmergencyResponse

Unlock Your Filmmaking Potential with Taraq Qureshi** Discover the art of filmmaking with Taraq Qureshi, an acclaimed British producer, director, and actor. With over 20 years of experience in the film industry and a unique perspective as a disabled filmmaker, Taraq brings a wealth of knowledge and passion to his teaching. **About Taraq Qureshi:** - **Seasoned Filmmaker**: With over two decades of experience, Taraq has produced and directed numerous feature films and short films. His journey began in community theatre with a year-long course accredited by Middlesex University London in 1999. - **Industry Leader**: Founder and artistic director of the "Golden Nugget International Film Festival," which has been running for six years. In 2023, Taraq also founded the "Global Film Producers Alliance" (www.gfa.com), a platform dedicated to connecting and supporting film producers worldwide. - **Innovative Storyteller**: Taraq's notable projects include "Strictly Salsa - The Beginning," "The Chosen Ones," and "Do Not Enter." His work is marked by a deep passion for storytelling and a commitment to creating both commercially successful and niche market films. - **Mentor and Educator**: As an acting teacher, creative executive, and development coordinator, Taraq has inspired countless aspiring filmmakers to pursue their dreams and achieve success in the industry. **Why Learn from Taraq?** - **Expert Guidance**: Gain insights from a seasoned professional with a proven track record in the film industry. - **Unique Perspective**: Learn from Taraq's experiences as a disabled filmmaker, providing a fresh and inclusive approach to storytelling. - **Hands-On Learning**: Benefit from practical, real-world advice and techniques that you can apply to your own filmmaking projects. - **Community and Support**: Join a network of passionate filmmakers and industry professionals through Taraq's initiatives, including the "Golden Nugget International Film Festival" and the "Global Film Producers Alliance." **Enroll Now and Transform Your Filmmaking Journey!** Don't miss this opportunity to learn from one of the industry's most respected and innovative filmmakers. Enroll in Taraq Qureshi's online teaching course today and take the first step towards realizing your filmmaking dreams. #Master the Art of Film Directing: Enroll in Our Comprehensive 10-Day Course!** Are you passionate about storytelling? Do you dream of bringing your cinematic visions to life? Our 10-day course on Feature Film Directing is your gateway to mastering the craft and making your mark in the film industry! #### **Course Highlights:** 🎬 **Expert Instruction:** Learn from seasoned directors and industry professionals. 📜 **Script Analysis:** Break down screenplays and develop compelling characters. 🎥 **Visual Storytelling:** Master cinematography, shot composition, and visual style. 👥 **Actor Collaboration:** Discover techniques for casting and directing actors. 🎨 **Production Design:** Create immersive sets, props, and costumes. 🎧 **Sound and Music:** Enhance your film with expert sound design and music. ✂️ **Editing Mastery:** Gain hands-on experience in editing and post-production. 📣 **Marketing and Distribution:** Learn to promote and distribute your film successfully. 🌟 **Final Project:** Showcase your skills with a short film project and receive valuable feedback. #### **Who Should Enroll:** - Aspiring Directors - Film Students - Storytellers and Creatives - Film Enthusiasts #### **Why Choose Our Course:** - **Intensive Learning:** Each 90-minute session is packed with valuable insights and practical exercises. - **Hands-On Experience:** Apply what you learn with real-world projects and interactive sessions. - **Networking Opportunities:** Connect with fellow filmmakers and industry experts. - **Flexible Schedule:** Designed to fit into your busy lifestyle. #### **Ready to Start Your Directing Journey?** Don't miss this opportunity to turn your passion for film into a rewarding career. Enroll now and take the first step towards becoming a masterful film director! --- *Limited seats available. Sign up today to secure your spot!* 🎥✨ --- ### **Day 1: Introduction to Directing** - **Welcome and Course Overview:** - Introduction to the role of a film director. - Course objectives and expectations. - **History of Film Directing:** - Overview of influential directors and their contributions. - Evolution of directing styles and techniques. --- ### **Day 2: Script Analysis and Development** - **Script Breakdown:** - Understanding the screenplay. - Identifying themes, characters, and plot structure. - **Character Development:** - Techniques for creating and developing characters. - Analyzing character arcs. --- ### **Day 3: Visual Storytelling** - **Cinematography Basics:** - Shot composition and framing. - Camera movements and angles. - **Visual Style:** - Creating a visual style and tone. - Working with a cinematographer. --- ### **Day 4: Working with Actors** - **Casting:** - Techniques for casting the right actors. - Conducting auditions. - **Directing Actors:** - Techniques for effective communication. - Understanding actors' needs and processes. --- ### **Day 5: Production Design** - **Set Design:** - Understanding the importance of production design. - Working with the production designer. - **Props and Costumes:** - The role of props and costumes in storytelling. - Collaborating with the art department. --- ### **Day 6: Sound and Music** - **Sound Design:** - Basics of sound recording and mixing. - Creating an audio landscape. - **Music in Film:** - The role of music in enhancing the narrative. - Working with a composer. --- ### **Day 7: Editing and Post-Production** - **Editing Techniques:** - Understanding the editing process. - Types of cuts and transitions. - **Post-Production Workflow:** - Overview of post-production stages. - Collaborating with editors and post-production teams. --- ### **Day 8: Directing on Set** - **Pre-Production Planning:** - Creating a shooting schedule. - Conducting technical rehearsals. - **On-Set Communication:** - Managing the cast and crew. - Problem-solving on set. --- ### **Day 9: Marketing and Distribution** - **Film Festivals and Markets:** - Overview of film festivals and markets. - Strategies for submitting and promoting films. - **Distribution Channels:** - Understanding traditional and digital distribution. - Creating a distribution plan. --- ### **Day 10: Final Project and Presentation** - **Project Work:** - Finalizing the short film project. - Preparing for the presentation. - **Presentations:** - Screening of short films. - Feedback and discussion. - **Course Wrap-Up:** - Reflecting on the course experience. - Final thoughts and future steps. --- This version is condensed to fit into 90-minute sessions, ensuring each lesson is focused and impactful. Does this meet your expectations? Of course! Here's a revised version of the 10-day course, with 90-minute sessions each day: --- ### **Day 1: Introduction to Directing** - **Welcome and Course Overview:** - Introduction to the role of a film director. - Course objectives and expectations. - **History of Film Directing:** - Overview of influential directors and their contributions. - Evolution of directing styles and techniques. --- ### **Day 2: Script Analysis and Development** - **Script Breakdown:** - Understanding the screenplay. - Identifying themes, characters, and plot structure. - **Character Development:** - Techniques for creating and developing characters. - Analyzing character arcs. --- ### **Day 3: Visual Storytelling** - **Cinematography Basics:** - Shot composition and framing. - Camera movements and angles. - **Visual Style:** - Creating a visual style and tone. - Working with a cinematographer. --- ### **Day 4: Working with Actors** - **Casting:** - Techniques for casting the right actors. - Conducting auditions. - **Directing Actors:** - Techniques for effective communication. - Understanding actors' needs and processes. --- ### **Day 5: Production Design** - **Set Design:** - Understanding the importance of production design. - Working with the production designer. - **Props and Costumes:** - The role of props and costumes in storytelling. - Collaborating with the art department. --- ### **Day 6: Sound and Music** - **Sound Design:** - Basics of sound recording and mixing. - Creating an audio landscape. - **Music in Film:** - The role of music in enhancing the narrative. - Working with a composer. --- ### **Day 7: Editing and Post-Production** - **Editing Techniques:** - Understanding the editing process. - Types of cuts and transitions. - **Post-Production Workflow:** - Overview of post-production stages. - Collaborating with editors and post-production teams. --- ### **Day 8: Directing on Set** - **Pre-Production Planning:** - Creating a shooting schedule. - Conducting technical rehearsals. - **On-Set Communication:** - Managing the cast and crew. - Problem-solving on set. --- ### **Day 9: Marketing and Distribution** - **Film Festivals and Markets:** - Overview of film festivals and markets. - Strategies for submitting and promoting films. - **Distribution Channels:** - Understanding traditional and digital distribution. - Creating a distribution plan. --- ### **Day 10: Final Project and Presentation** - **Project Work:** - Finalizing the short film project. - Preparing for the presentation. - **Presentations:** - Screening of short films. - Feedback and discussion. - **Course Wrap-Up:** - Reflecting on the course experience. - Final thoughts and future steps. --- This version is condensed to fit into 90-minute sessions, ensuring each lesson is focused and impactful. Let me know if there is anything you want help with taraqqureshi@gmail.com

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The UK mobile app market is expected to reach a staggering £20.5 billion by 2025. With the app development industry booming, there's never been a better time to acquire the skills to build your own apps and potentially launch your next big venture. This App Development Advanced Diploma Bundle equips you with the knowledge and tools to create various applications across different platforms and technologies. With this App Development Advanced Diploma course you will get 20 CPD Accredited PDF Certificates, Hard Copy Certificate Flutter & Dart Development for Building iOS and Android Apps and our exclusive student ID card absolutely free. Courses Are Included In This App Development Advanced Diploma Bundle: Course 01: Flutter & Dart Development for Building iOS and Android Apps Course 02: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 03: Level 3 Creating Web App for iPad Course 04: Web Application Penetration Testing Course 05: Industry 4.0 - Automation & Applications Course 06: Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course Course 07: Tic-Tac-Toe Clone - The Complete SFML C++ Game Course Course 08: Flappy Bird Clone: SFML C++ Game Course 09: Modern OpenGL 3D Game Course 10: Blender 3D - Create a Cartoon Character Course 11: Developing Game in Unity 3D Course 12: Unreal Engine 4 for Beginners Course 13: Unreal Engine 4 Course 14: Make Cinematics Using Unreal Engine 5 Course 15: Maya & Unity 3D: Modeling Lowpoly Tree for Mobile Games Course 16: Maya & Unity 3D: Modeling Environments for Mobile Games Course 17: Publish Game Assets to the Unity & Unreal Marketplace for Passive Income Course 18: Monetize Your Mobile Game or App Course 19: The Media Crash Course Course 20: Environment Design Using Unreal Engine 5 Each lesson in this App Development course is crafted for easy understanding, enabling you to become proficient in App Development. Whether you are a beginner or looking to sharpen your existing skills, this App Development is the ideal choice. Learning Outcomes of this Bundle Grasp fundamental programming concepts in various languages like Dart, C#, and C++. Master essential app development frameworks like Unity, Unreal Engine, and Maya. Explore web application security principles to protect your creations. Design and develop engaging 2D and 3D games for different platforms. Enrol in App Development Advanced Diploma today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of this Bundle Get a free student ID card with this Bundle Lifetime access to the course materials Get instant access to this Bundle course Learn from anywhere in the world 24/7 tutor support with the App Development Advanced Diploma course. App Development Advanced Diploma is an entirely online, interactive lesson with voice-over audio. Start your learning journey straightaway with our App Development Advanced Diploma Training! App Development Advanced Diploma premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of App Development Advanced Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. The App Development course is extremely dynamic and well-paced to help you understand App Development with ease. Certification of App Development You have to complete the assignment given at the end of the App Development Advanced Diploma course and score a minimum of 60% to pass each exam. After passing the App Development Advanced Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This App Development Advanced Diploma course is ideal for: Students seeking mastery in App Development Professionals seeking to enhance App Development skills Individuals looking for a App Development related career. Anyone passionate about App Development Requirements This App Development Advanced Diploma doesn't require prior experience and is suitable for diverse learners. Career path This App Development Advanced Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Mobile App Developer Game Developer Web Developer UI/UX Designer Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Course Overview The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. 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. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. 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 Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00