2987 Software Development courses in Leicester delivered Online

Overview This comprehensive course on Blender 3D - Create a Cartoon Character will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Blender 3D - Create a Cartoon Character 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 Blender 3D - Create a Cartoon Character. It is available to all students, of all academic backgrounds. Requirements Our Blender 3D - Create a Cartoon Character 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 4 sections • 12 lectures • 01:24:00 total length •Introduction: 00:01:00 •Blender Basics: 00:05:00 •Bench Modeling Part 01: 00:08:00 •Bench Modeling Part 02: 00:14:00 •Character Modeling Part 01: 00:06:00 •Character Modeling Part 02: 00:13:00 •Character Modeling Part 03: 00:10:00 •Character Modeling Part 04: 00:13:00 •Create Materials: 00:12:00 •Rendering: 00:02:00 •Resources - Blender 3D - Create a Cartoon Character: 00:00:00 •Assignment - Blender 3D - Create a Cartoon Character: 00:00:00

The digital landscape is brimming with opportunities. As our reliance on technology continues to burgeon, so does the demand for rigorous data protection, cyber security, and the legal frameworks surrounding them. At the epicentre of this evolution stands GDPR. Seize the opportunity to lead this thriving industry with our "GDPR Compliance, Data Protection & Cyber Security" bundle. This 8-course bundle seamlessly integrates key areas from GDPR to AML. Tailored for the digital age, it offers a comprehensive grasp of data protection, cyber security, and relevant laws, ensuring professionals are equipped for modern challenges. The CPD Accredited Eight Courses Are: Course 1: GDPR Course 2: Data Protection Course 3: Paralegal Training Course 4: Commercial Law Course 5: Cyber Law Online Course Course 6: Business Law Course 7: Cyber Security Awareness Training Course 8: Anti-Money Laundering (AML) Training Learning Outcomes of the GDPR Compliance, Data Protection & Cyber Security Bundle: Understand GDPR's core principles, compliance needs, and business implications. Implement best practices for safeguarding sensitive information. Grasp essential concepts in paralegal, commercial, cyber, and business law. Recognise and prevent potential money laundering activities in line with global regulations. Understand the interplay between commercial law and GDPR within business operations. Navigate GDPR, data protection, and related legal landscapes with confidence. Course 1: GDPR Dive deep into the core principles of the General Data Protection Regulation (GDPR). Understand its purpose, implications, and the necessary compliance mechanisms for businesses. Course 2: Data Protection Beyond just GDPR, explore the broader landscape of data protection. Equip yourself with the tools and strategies to safeguard sensitive information in various contexts. Course 3: Paralegal Training A cornerstone for those keen to step into the legal world, this course lays down the groundwork for legal principles, processes, and professional responsibilities. Course 4: Commercial Law Engage with the intricacies of commercial law. Gain insights into business contracts, trade, and the legal framework that governs commercial operations. Course 5: Cyber Law Online Course The digital realm is rife with its own set of legal challenges. This course delves into the regulations, rights, and responsibilities of online activities and digital interactions. Course 6: Business Law A comprehensive look into the rules, regulations, and laws that dictate how a business should operate. Ideal for professionals, entrepreneurs, and those interested in the legal side of business. Course 7: Cyber Security Awareness Training With cyber threats escalating, this course heightens awareness about the importance of cybersecurity. Learn the best practices to keep data safe and recognise potential cyber threats. Course 8: Anti-Money Laundering (AML) Training Tackle the dark side of finance. Grasp the essential principles behind AML, the mechanisms to detect suspicious activities, and the protocols to prevent illegal money movements. CPD 45 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This GDPR Compliance, Data Protection & Cyber Security Course are suitable for: Business Professionals: Understand GDPR's impact on operations. Legal Enthusiasts: Deepen knowledge in data and cyber law. IT Experts: Enhance cybersecurity and data protection strategies. Entrepreneurs: Navigate legal and compliance landscapes. Finance Experts: Grasp anti-money laundering protocols. DPOs: Master GDPR implementation and related areas. After Completing this bundle, anyone can later enroll in this following course: NCFE Level 2 Certificate in the Principles of Cyber Security Certified Governance & Compliance Audit Professional Association of Governance, Risk and Compliance Highfield Awarding Body for Compliance Exam SC-900: Microsoft Security, Compliance, and Identity Fundamentals Level 7 Diploma in International Business Law Requirements Without any formal requirements, you can delightfully enrol in this GDPR Compliance, Data Protection & Cyber Security course. Just get a device with internet connectivity, and you are ready to start your learning journey. Thus, complete this GDPR course at your own pace. Career path Our GDPR Compliance, Data Protection & Cyber Security course will prepare you for a range of careers, including: Paralegal GDPR Consultant Data Protection Officer (DPO) Cybersecurity Specialist Legal Consultant in Cyber Law Compliance Officer AML Analyst Business Law Advisor The Combined Salary Range for this bundle is approximately £35,000 to £135,000+ per annum. Certificates Certificate of Completion Digital certificate - Included Certificate of Completion Hard copy certificate - £9.99

Description Do you want to know how to be an expert in creating forms and gathering data? Are you looking for the easiest method regarding MS InfoPath? You may look at the MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course. This course may assist you to get an approximate idea about this field. The MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course incorporates some basic ideas regarding the use of MS InfoPath. It enables to know you how to make forms and collect data by using Infopath within SharePoint. It also teaches you how to edit, create, and publish a form along with a strong command of associated properties. It gives you a proper direction to use Infopath forms by utilizing WebParts. After the end of the course, you will be an expert on some advanced functions of InfoPath that enables you to modify data source and work with it vivid sections. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS InfoPath 2013: Working With InfoPath 2013 in SharePoint 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 MS InfoPath 2013: Working With InfoPath 2013 in SharePoint 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. Introduction Introduction FREE 00:01:00 SharePoint and InfoPath Using InfoPath with SharePoint 00:04:00 Exploring the InfoPath Interface 00:03:00 Creating a Form from an Existing List 00:03:00 Creating a new List and Form within InfoPath 00:04:00 Creating a Form in InfoPath Using SharePoint Designer 00:02:00 Editing a Form 00:02:00 Publishing a Form 00:02:00 Restoring the Default SharePoint Form 00:03:00 Working with List Forms Components of the InfoPath Form 00:03:00 Formatting Text in the Form 00:03:00 Spellcheck Your Form 00:02:00 Inserting or Deleting a Table 00:02:00 Formatting a Table 00:03:00 Add or Remove Rows and Columns 00:02:00 Merging and Splitting Cells 00:04:00 Adding or Removing a Field 00:03:00 Resizing and Formatting a Field 00:03:00 Changing Field Controls 00:05:00 Inserting a Section 00:03:00 Inserting a Picture 00:02:00 Inserting a Button 00:05:00 Inserting a Calculated Value 00:04:00 Setting Default Field Values 00:05:00 Creating a Validation Rule 00:04:00 Creating a Formatting Rule 00:04:00 Creating an Action Rule 00:05:00 Modifying or Deleting a Rule 00:02:00 Setting the Form Load Rules 00:03:00 Advanced InfoPath Features Exploring the Fields Pane 00:02:00 Creating a Data Source 00:05:00 Modifying and Deleting a Data Source 00:02:00 Creating a View 00:03:00 Configuring View Settings 00:03:00 Creating Cascading Columns 00:06:00 Understanding Repeating Sections and Tables 00:03:00 Creating a Repeating Section 00:04:00 Using Repeating Tables to Add Multiple Items to a List 00:08:00 Using Repeating Sections to Show Existings Records 00:07:00 Hiding a Form Section Based on Field Values 00:05:00 InfoPath Forms Within SharePoint Using the InfoPath Form WebPart on a SP Page 00:04:00 Using Form Views for Different Groups 00:06:00 InfoPath Form WebPart and WebPart Filters 00:08:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Beautiful and efficient web design can help your clients understand products, reach you and increase their customer satisfaction. As 81% of customers do online research before reaching to you, your online presentation determines their decision. Learn how you can design your website using CSS from this Fundamental of CSS3 Tutorial course and impress your customers. This Fundamental of CSS3 Tutorial course will help you to understand CSS basics and functions from scratch. You will learn about contexts of CSS basic, styling and Positioning, creating responsive designs, changing layout, colors and many other functions from this course.  This course will help you to understand how you can use CSS effectively and boost your marketing strategies. This course is perfect for anyone who wants to learn CSS techniques easily. Learning Outcomes Get a clear understanding of the functions of CSS Familiarize with basic styling and positioning elements Be able to create different styling using color, shape, size and different fonts Learn how to apply CSS to websites Understand the most important CSS rules and how to use them Arrange elements based on different preferences in CSS Be able to practice various CSS designing and styling techniques Who is this course for? This course is ideal for anyone who wants to learn web designing or web development and style their websites using CSS. This course will help you to understand the functions of CSS and how to design websites from scratch. 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 Fundamental of CSS3 Tutorial is a useful qualification to possess and would be beneficial for any related profession or industry such as: Web Designers Web Developers App Developers Software Engineers Programmers Unit 01: CSS in Context Module 01: What Was CSS Originally Intended To Do? 00:07:00 Module 02: DEMO: The Most Basic CSS Usage 00:07:00 Module 03: Responsive Design 00:02:00 Module 04: Chapter Summary 00:02:00 Unit 02: Overview of CSS Module 01: What is CSS? 00:04:00 Module 02: Where Can You Find CSS? 00:03:00 Module 03: What CSS Can and Can't Do 00:02:00 Module 04: Optional Demo - Serving an HTML Application 00:05:00 Module 05: How Do we Add CSS to a Website? 00:04:00 Module 06: Demo - Adding CSS to a Website 00:06:00 Module 07: CSS Selectors 00:03:00 Module 08: Demo - Using CSS Selectors 00:05:00 Module 09: Module Summary 00:01:00 Unit 03: Styling HTML Elements with CSS Module 01: Why do We Style CSS Elements? 00:03:00 Module 02: CSS and Fonts 00:03:00 Module 03: DEMO: Styling Text with CSS 00:07:00 Module 04: Sizing HTML Elements with CSS 00:06:00 Module 05: DEMO: Sizing HTML Elements with CSS 00:08:00 Module 06: Colorizing HTML Elements with CSS 00:05:00 Module 07: DEMO: Colorizing HTML Elements with CSS 00:07:00 Module 08: Summary of this Chapter 00:01:00 Unit 04: Arranging Elements with CSS Module 01: Introduction 00:01:00 Module 02: Adding Margin with CSS 00:01:00 Module 03: Advanced Positioning with CSS 00:04:00 Module 04: DEMO: Positioning Elements Absolutely and Relatively 00:07:00 Module 05: Positioning HTML Elements with Float 00:02:00 Module 06: DEMO: Positioning HTML Elements with Float 00:07:00 Module 07: Summary of this Course 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for The primary audience for this course is database developers who plan to migrate their MongoDB or Cassandra DB workloads to Azure using Cosmos DB. Overview Building Globally Distributed Applications with Cosmos DB Migrate MongoDB Workloads to Cosmos DB Migrate Cassandra DB Workloads to Cosmos DB This course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB. Building Globally Distributed Applications with Cosmos DB Cosmos DB overview Cosmos DB APIs Provisioning Throughput Partitioning/Sharding Best Practices Migrate MongoDB Workloads to Cosmos DB Understand Migration Benefits Migration Planning Data Migration Application Migration Post-migration considerations Migrate Cassandra DB Workloads to Cosmos DB Understand Migration Benefits Migration Planning Data Migration Application Migration Post-migration considerations Additional course details: Nexus Humans DP-060T00 Migrate NoSQL workloads to Azure Cosmos DB 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 DP-060T00 Migrate NoSQL workloads to Azure Cosmos DB course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Those who will provide container orchestration management in the AWS Cloud including: DevOps engineers Systems administrators Overview In this course, you will learn to: Review and examine containers, Kubernetes and Amazon EKS fundamentals and the impact of containers on workflows. Build an Amazon EKS cluster by selecting the correct compute resources to support worker nodes. Secure your environment with AWS Identity and Access Management (IAM) authentication by creating an Amazon EKS service role for your cluster Deploy an application on the cluster. Publish container images to ECR and secure access via IAM policy. Automate and deploy applications, examine automation tools and pipelines. Create a GitOps pipeline using WeaveFlux. Collect monitoring data through metrics, logs, tracing with AWS X-Ray and identify metrics for performance tuning. Review scenarios where bottlenecks require the best scaling approach using horizontal or vertical scaling. Assess the tradeoffs between efficiency, resiliency, and cost and impact for tuning one over the other. Describe and outline a holistic, iterative approach to optimizing your environment. Design for cost, efficiency, and resiliency. Configure the AWS networking services to support the cluster. Describe how EKS/Amazon Virtual Private Cloud (VPC) functions and simplifies inter-node communications. Describe the function of VPC Container Network Interface (CNI). Review the benefits of a service mesh. Upgrade your Kubernetes, Amazon EKS, and third party tools Amazon EKS makes it easy for you to run Kubernetes on AWS without needing to install, operate, and maintain your own Kubernetes control plane. In this course, you will learn container management and orchestration for Kubernetes using Amazon EKS. You will build an Amazon EKS cluster, configure the environment, deploy the cluster, and then add applications to your cluster. You will manage container images using Amazon Elastic Container Registry (ECR) and learn how to automate application deployment. You will deploy applications using CI/CD tools. You will learn how to monitor and scale your environment by using metrics, logging, tracing, and horizontal/vertical scaling. You will learn how to design and manage a large container environment by designing for efficiency, cost, and resiliency. You will configure AWS networking services to support the cluster and learn how to secure your Amazon EKS environment. Module 0: Course Introduction Course preparation activities and agenda Module 1: Container Fundamentals Best practices for building applications Container fundamentals Components of a container Module 2: Kubernetes Fundamentals Container orchestration Kubernetes objects Kubernetes internals Preparing for Lab 1: Deploying Kubernetes Pods Module 3: Amazon EKS Fundamentals Introduction to Amazon EKS Amazon EKS control plane Amazon EKS data plane Fundamentals of Amazon EKS security Amazon EKS API Module 4: Building an Amazon EKS Cluster Configuring your environment Creating an Amazon EKS cluster Demo: Configuring and deploying clusters in the AWS Management Console Working with eksctl Preparing for Lab 2: Building an Amazon EKS Cluster Module 5: Deploying Applications to Your Amazon EKS Cluster Configuring Amazon Elastic Container Registry (Amazon ECR) Demo: Configuring Amazon ECR Deploying applications with Helm Demo: Deploying applications with Helm Continuous deployment in Amazon EKS GitOps and Amazon EKS Preparing for Lab 3: Deploying App Module 6: Configuring Observability in Amazon EKS Configuring observability in an Amazon EKS cluster Collecting metrics Using metrics for automatic scaling Managing logs Application tracing in Amazon EKS Gaining and applying insight from observability Preparing for Lab 4: Monitoring Amazon EKS Module 7: Balancing Efficiency, Resilience, and Cost Optimization in Amazon EKS The high level overview Designing for resilience Designing for cost optimization Designing for efficiency Module 8: Managing Networking in Amazon EKS Review: Networking in AWS Communicating in Amazon EKS Managing your IP space Deploying a service mesh Preparing for Lab 5: Exploring Amazon EKS Communication Module 9: Managing Authentication and Authorization in Amazon EKS Understanding the AWS shared responsibility model Authentication and authorization Managing IAM and RBAC Demo: Customizing RBAC roles Managing pod permissions using RBAC service accounts Module 10: Implementing Secure Workflows Securing cluster endpoint access Improving the security of your workflows Improving host and network security Managing secrets Preparing for Lab 6: Securing Amazon EKS Module 11: Managing Upgrades in Amazon EKS Planning for an upgrade Upgrading your Kubernetes version Amazon EKS platform versions Additional course details: Nexus Humans Running Containers on Amazon Elastic Kubernetes Service (Amazon EKS) 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 Running Containers on Amazon Elastic Kubernetes Service (Amazon EKS) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate level course for students that will perform Database Administration tasks, who plan, implement, and maintain D22 11.1 databases. Overview These skills can be developed by taking: DB2 SQL Workshop DB2 Fundamentals This course teaches database administrators to perform basic database administrative tasks using Db2 11.1. These tasks include creating database objects like tables, indexes and views, and loading data into the database with Db2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference Db2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. The course covers using EXPLAIN tools to review the access plans for SQL statements and adding indexes to improve SQL performance. We will cover the locking performed by Db2 and the effect the application isolation level has on locking and lock wait conditions. Students will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing Db2 native encryption for a database. Overview of Db2 11.1Db2 Command Line Processor (CLP) and GUI toolsThe Db2 database manager instanceCreating Databases and Data PlacementCreating Database ObjectsMoving DataBackup and RecoveryDatabase Maintenance, Monitoring and Problem DeterminationLocking and concurrencySecurity

In today’s fast-paced world, effective communication is more important than ever. Whether you’re a student, a professional, or just someone who wants to improve your writing skills, the ChatGPT Masterclass is the perfect course for you.

Overview This SQL course will unlock your full potential and will show you how to excel in a career in SQL. So upskill now and reach your full potential. Everything you need to get started in SQL is available in this course. Learning and progressing are the hallmarks of personal development. This SQL will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your SQL skills to help you advance your career. Acquire a comprehensive understanding of various SQL topics and tips from industry experts. Learn in-demand SQL skills that are in high demand among UK employers, which will help you to kickstart your career. This SQL course covers everything you must know to stand against the tough competition in the SQL field.  The future is truly yours to seize with this SQL. Enrol today and complete the course to achieve a SQL certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the SQL course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the SQL course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the SQL course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This SQL is suitable for anyone aspiring to start a career in SQL; even if you are new to this and have no prior knowledge on SQL, this course is going to be very easy for you to understand.  And if you are already working in the SQL field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this SQL course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This SQL course has no prerequisite.  You don't need any educational qualification or experience to enrol in the SQL course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online SQL course. Course Curriculum Unit 01: Course and Instructor Introduction Course and Instructor Introduction 00:05:00 Unit 02: Laying out the foundation - Overview & Installation Pre-requisites & Different Editions of SQL Server 00:06:00 Downloading Express Edition & sample database 00:03:00 Installing the downloads & Configuration 00:19:00 The sa Login 00:04:00 Wrap up - what we went over! 00:01:00 Unit 03: Core concepts - Taming the RDBMS beast! What is RDBMS? 00:12:00 Where does SQL Server fit in? 00:02:00 Basic database objects 00:16:00 Different Files that got installed - MDF & LDF 00:03:00 Wrap up - what we went over! 00:01:00 Unit 04: Tool of the trade - SQL Server Management Studio Getting started with SSMS 00:07:00 Getting around Object Explorer 00:05:00 Query Window 00:06:00 Pre-built DB - system database 00:04:00 Wrap up - what we went over! 00:01:00 Unit 05: Simple SELECT Bare Minimum: SELECTING a literal 00:05:00 Retrieving / querying data from a table - using FROM clause 00:06:00 Playing with Column Names 00:03:00 Rearranging columns to your liking 00:01:00 Wrap up - what we went over! 00:01:00 Unit 06: Filtering out unwanted data Narrowing down and ordering result set - WHERE and ORDER clause 00:17:00 Narrowing down result set - BETWEEN / NOT BETWEEN 00:09:00 Narrowing down result set - IN and NOT IN operator 00:05:00 Narrowing down result set - Pattern Matching: LIKE and Wildcards 00:11:00 Wrap up - what we went over! 00:01:00 Unit 07: Expressions and Functions Dealing with nothing: NULL 00:06:00 Working with strings: Concatenation and other string functions 00:15:00 Working with dates: Date Functions 00:07:00 Some System Functions 00:05:00 Wrap up - what we went over! 00:02:00 Unit 08: Getting data out of multiple tables Joining multiple tables - INNER JOIN 00:09:00 Join types - OUTER JOIN - LEFT / RIGHT / FULL 00:08:00 Join types - CROSS JOIN 00:02:00 Holy UNION! 00:03:00 Subqueries 00:04:00 Wrap up - what we went over! 00:02:00 Unit 09: Summarizing and Grouping data DISTINCT and ALL Predicates 00:02:00 Aggregate Functions 00:03:00 GROUP BY clause / HAVING clause 00:04:00 WHERE and ORDER BY in aggregate queries 00:04:00 Wrap up - what we went over! 00:01:00 Unit 10: Bonus Bonus_Section 00:01:00

Learn basic Database Design, use of Microsoft SQL Management Studio, creating Complex Database Objects & boost up your