1286 Courses

Embark on a journey to mastering the world of web design with our 'CSS Fundamentals' course. This meticulously designed program invites learners into the heart of website styling, starting with 'CSS in Context' in Unit 01. Here, you'll be introduced to the significance of CSS in modern web design, laying a solid foundation for the modules ahead. In Unit 02, 'Overview of CSS', the course unravels the mysteries of CSS, providing an in-depth look at its functionality and scope. This is where your adventure in web styling truly begins. As you progress, Unit 03, 'Styling HTML Elements with CSS', immerses you in the practical aspect of web design. You'll learn how to breathe life into HTML elements, transforming them from basic structures to visually appealing components of a web page. In Unit 04, 'Arranging Elements with CSS', the course takes a deeper dive, guiding you through the intricacies of layout design. This unit equips you with the skills to meticulously organize and present content on a web page, ensuring both functionality and aesthetic appeal. Throughout the course, you'll engage with interactive learning resources, practical exercises, and real-world examples, ensuring that you not only understand the theory behind CSS but also gain the confidence to apply it in practical scenarios. Whether you're a beginner looking to start a career in web design or a professional seeking to enhance your skill set, this course offers a comprehensive, user-friendly approach to understanding and mastering CSS. Learning Outcomes Acquire a thorough understanding of the role and importance of CSS in web design. Develop the skills to style HTML elements effectively using CSS. Gain proficiency in arranging web page elements for optimal layout and design. Understand the principles behind responsive design and cross-browser compatibility. Enhance your ability to create visually appealing and user-friendly websites. Why choose this CSS Fundamentals course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this CSS Fundamentals course for? Beginners aspiring to become proficient in web design. Front-end developers seeking to strengthen their CSS skills. Graphic designers looking to expand their digital skillset. Website hobbyists interested in creating more engaging web pages. Professionals in digital marketing aiming to understand web design fundamentals. Career path Web Designer: £25,000 - £40,000 Front-End Developer: £30,000 - £50,000 UX/UI Designer: £28,000 - £45,000 Web Content Manager: £24,000 - £38,000 Freelance Web Developer: £35,000 - £60,000 Digital Marketing Specialist: £26,000 - £42,000 Prerequisites This CSS Fundamentals does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum 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 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 Assignment Assignment - CSS Fundamentals 00:00:00

Overview Dive into the dynamic world of computer science with our comprehensive 'Computer Science with Python Course'. Python, a versatile and widely used programming language, serves as the foundation for this course, offering learners a gateway into the intricate realm of computing. From installing Python and understanding its documentation to mastering advanced concepts like closures, classes, and data hiding, this course is meticulously designed to cater to beginners and those looking to deepen their knowledge. With a curriculum that's rich and varied, you'll be equipped with the skills to tackle real-world challenges, making you a sought-after asset in the ever-evolving tech industry. The course curriculum is structured to ensure a smooth learning curve. Starting with foundational topics such as command line usage, variables, and simple Python syntax, learners will gradually progress to more advanced subjects.  In the digital age, proficiency in a programming language like Python is invaluable. Whether you're aiming to kickstart a career in tech, enhance your current skill set, or simply satiate your curiosity, this course promises a transformative learning experience. With a blend of theoretical knowledge and its practical application, you'll be poised to make significant strides in the world of computer science. Learning Outcomes of Computer Science with Python Course: Understand Python's foundational concepts, including its installation, documentation, and basic syntax. Gain proficiency in working with various Python data types such as strings, lists, dictionaries, and tuples. Develop the ability to create and manipulate functions, including lambda functions, generators, and closures. Acquire skills in object-oriented programming with a focus on classes, inheritance, and data hiding. Implement advanced programming constructs and handle exceptions efficiently.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2020/01/Computer-Science-with-Python-Course-Introduction-Video-1.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why buy this Computer Science with Python Course? 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 Computer Science with Python Course 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 Computer Science with Python course for? Beginners eager to delve into the realm of computer science and programming. Individuals looking to add Python programming to their skill set. Tech enthusiasts keen on understanding advanced Python concepts. Students pursuing computer science and needing a comprehensive Python guide. Professionals in tech roles aiming to enhance their coding capabilities. Prerequisites This Computer Science with Python Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. Career Path Python Developer: £45,000 - £70,000 Annually Data Scientist: £50,000 - £80,000 Annually Software Engineer: £40,000 - £75,000 Annually Backend Developer: £45,000 - £72,000 Annually Systems Analyst: £35,000 - £60,000 Annually DevOps Engineer: £50,000 - £85,000 Annually Course Curriculum Module 01 A Installing Python FREE 00:17:00 Documentation 00:30:00 Command Line 00:17:00 Variables 00:29:00 Simple Python Syntax 00:15:00 Keywords 00:18:00 Import Module 00:17:00 Module 02 Additional Topics 00:23:00 If Elif Else 00:31:00 Iterable 00:10:00 For 00:11:00 Loops 00:20:00 Execute 00:05:00 Exceptions 00:18:00 Module 03 Data Types 00:24:00 Number Types 00:28:00 More Number Types 00:13:00 Strings 00:20:00 More Strings 00:11:00 Files 00:08:00 Lists 00:15:00 Dictionaries 00:04:00 Tuples 00:07:00 Sets 00:09:00 Module 04 Comprehensions 00:10:00 Definitions 00:02:00 Functions 00:06:00 Default Arguments 00:06:00 Doc Strings 00:06:00 Variadic Functions 00:07:00 Factorial 00:07:00 Module 05 Function Objects 00:07:00 Lambda 00:11:00 Generators 00:06:00 Closures 00:10:00 Classes 00:09:00 Object Initialization 00:05:00 Class Static Members 00:07:00 Classic Inheritance 00:10:00 Data Hiding 00:07:00 Mock Exam Mock Exam - Python Developer 00:20:00 Final Exam Final Exam - Python Developer 00:20:00

Embark on a transformative journey into the realm of data mastery with our comprehensive course, 'Advanced SAS Programming Using MacrosSQL.' From demystifying the intricacies of SAS Studio to unlocking the potential of Proc SQL, this course is a gateway to proficiency in SAS programming and macro scripting. The curriculum, thoughtfully designed to accommodate learners of all levels, takes you through the essential foundations of SAS, the nuances of macro variables, and the power-packed functionalities of Proc SQL. Dive into the world of nested macro variables, conditional logic, and data manipulation, all while honing your skills through practical examples. This course isn't just about learning syntax; it's a hands-on exploration that empowers you to seamlessly connect the dots between SAS Studio and Proc SQL, bringing your data analytics capabilities to new heights. Learning Outcomes Master the fundamentals of SAS Studio and navigate through its interface effortlessly. Develop a deep understanding of macro variables, exploring their applications and delving into nested variations. Acquire proficiency in SAS Macros, from basic examples to advanced keyword usage and conditional logic. Unlock the potential of Proc SQL, gaining expertise in data copying, filtering, sorting, and removing duplicates. Harness the power of data merging using Joins, creating macro variables dynamically in the process. Why choose this Advanced SAS Programming Using MacrosSQL course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Advanced SAS Programming Using MacrosSQL course for? Data enthusiasts seeking to enhance their SAS programming skills. Business analysts aiming to leverage SAS for more effective data analysis. IT professionals aspiring to streamline data management through SAS. Career path SAS Programmer: £35,000 - £55,000 Data Analyst: £30,000 - £50,000 Business Intelligence Developer: £40,000 - £60,000 Database Administrator: £35,000 - £60,000 Data Scientist: £45,000 - £70,000 Analytics Manager: £50,000 - £80,000 Prerequisites This Advanced SAS Programming Using MacrosSQL does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced SAS Programming Using MacrosSQL 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Advanced SAS Programming Using MacrosSQL Unit - 1 Section 0-00- Why SAS 00:01:00 Unit - 2 Section 2-02- SAS Studio through SAS OnDemand- Registration 00:04:00 Section 2-03- Logging-in to SAS after installation 00:01:00 Section 2-04- SAS Interface and windows 00:06:00 Unit - 3 Section 3-00- Section Overview - Macros 00:01:00 Section 3-01-Macro Variables - introduction 00:14:00 Section 3-02-Application of macro variables 00:13:00 Section 3-03-01-Nested macro vars 00:11:00 Section 3-03-02-More on Ampersand resolutions using a cool example 00:09:00 Section 3-04-00-SAS Macros - introduction 00:10:00 Section 3-04-01-SAS Macros - Examples 00:07:00 Section 3-04-02-Keyword positional and mixed params 00:06:00 Section 3-04-03-Conditional Logic in Macros 00:11:00 Section 3-05-Macro Functions 00:12:00 Section 3-05-Options Statement- mprint-mlogic-symbolgen 00:13:00 Section 3-07-Connecting the two worlds - Call Symput - Symget 00:14:00 Section 3-09-01-02- Bringing data into SAS using Import Wizard 00:04:00 Section 3-09-02- Bringing data into SAS using LIBNAME statement 00:05:00 Section 3-09-03- Bringing data into SAS using FILENAME 00:05:00 Unit - 4 Section 4-00- Section Overview - Proc SQL 00:01:00 Section 4-01-01-Proc SQL - copying data 00:13:00 Section 4-01-02-Proc SQL - filtering data 00:07:00 Section 4-01-03-Proc SQL - sorting data 00:08:00 Section 4-01-04-Proc SQL - removing duplicates 00:05:00 Section 4-02-01-Proc SQL - Union 00:09:00 Section 4-02-02-Proc SQL - Except 00:04:00 Section 4-02-03-Proc SQL - Intersect 00:02:00 Section 4-03-00-Merging data using Joins-Introduction 00:08:00 Section 4-03-01-Proc SQL - inner join 00:14:00 Section 4-03-02-Proc SQL - full join 00:08:00 Section 4-03-03-Proc SQL - left and right joins 00:07:00 Section 4-04-01-Proc SQL - creating macro vars 00:07:00 Unit - 5 Section 5-00- Bonus lecture 00:02:00

This course will help you to prepare for the Cisco Certified Network Associate (CCNA) certification exam. The course covers all the major topics of computer networking and network devices, such as Internet Protocol (IP) addressing, routing, switching, Transmission Control Protocol/Internet Protocol (TCP/IP), Network Address Translation (NAT), Dynamic Host Configuration Protocol (DHCP), and Domain Name System (DNS).

Welcome to the exciting world of C# (C-Sharp)! This course is your gateway to mastering one of the most versatile and in-demand programming languages in the world. As technology continues to advance, C# remains at the forefront, offering endless opportunities for those who can harness its power. In this course, we will take you on a journey that begins with the fundamentals and leads you to become a proficient C# developer. In the first section, 'Introduction,' you'll gain insight into the world of C# and understand its significance in the modern software development landscape. We'll guide you through the process of setting up your development environment, ensuring you're ready to dive into coding with confidence. The course progresses to cover essential topics such as C# console programming, Winforms applications, database operations, user management, and source control. By the end, you'll have a deep understanding of C# and the practical skills needed to develop robust software applications. Join us on this exhilarating journey, and let's unlock the incredible potential of web development together. Learning Outcomes of C# (C-Sharp): Develop a solid foundation in C# programming, including mastery of basic control structures and more advanced concepts. Create Windows forms applications and understand the basics of Multi-Document Interface (MDI) for efficient user interface development. Manage databases effectively, covering CRUD (Create, Read, Update, Delete) operations and database changes. Implement user management and login functionality to enhance the security and usability of your applications. Learn the importance of source control and acquire the skills to add your projects to source control repositories. Why buy this C# (C-Sharp) course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the C# (C-Sharp) Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this C# (C-Sharp) course for? Aspiring software developers looking to build a strong foundation in programming. Computer science students seeking practical knowledge and skills for real-world application development. IT professionals aiming to expand their expertise and career opportunities in software development. Individuals interested in creating Windows applications with user-friendly interfaces. Anyone eager to understand source control and its role in collaborative software development. Career path Junior Developer: £25,000 - £40,000 Per Annum Software Engineer: £40,000 - £60,000 Per Annum Database Developer with C#: £35,000 - £55,000 Per Annum Senior C# Developer: £55,000 - £80,000 Per Annum Software Development Team Lead (C#): £70,000 - £100,000 Per Annum C# Solutions Architect: £90,000 - £130,000 Per Annum Prerequisites This C# (C-Sharp) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This C# (C-Sharp) 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:03:00 Development Environment Setup Install Visual Studio 2019 Community Edition 00:04:00 Install .Net Core SDK 00:02:00 Tour Of Visual Studio 00:11:00 C# Console Programming - Basic Control Structures Write a Simple Hello World Program 00:15:00 Input and Output Programs 00:18:00 C# Data Types and Conversion 00:22:00 Operators in C# 00:17:00 Condition Statements 00:32:00 Repetition Statements 00:28:00 Methods and Return Types 00:27:00 C# Console Programming - More Advanced Concepts String Manipulation Functions 00:21:00 Handling Exceptions 00:13:00 Classes and Objects 00:37:00 Arrays, Lists and Other Collections 00:35:00 Winforms Applications - The Basics Create a Simple Winforms Application (Car Rental Application) 00:26:00 Understand Winforms Controls, Properties and Events 00:21:00 Form Validation and Exception Handling 00:34:00 Create Database in SQL Server 00:10:00 Create Database Model with ADO.NET 00:13:00 Select Data from the Database Using LINQ 00:15:00 Submit to Database from Form 00:17:00 Multi Document Interface (MDI) and More Database Operations Creating Additional Forms and Windows 00:14:00 Create an MDI Application 00:17:00 Managing Database Changes and CRUD Operations View Data In A Grid 00:29:00 Managing Database Changes 00:18:00 Create and Edit Records (Using one form) 00:48:00 Vehicle Data Validations and Exception Handling 00:07:00 Manage Car Rental Records 00:45:00 Enhancing Application Flow and User Experience 00:28:00 User Management and Login Functionality Simple Login Form 00:39:00 Control Features Based on User Roles 00:35:00 User Password and Active Status Reset 00:21:00 Add New Users and Password Reset 00:45:00 Add To Source Control Add Project to GitHub 00:19:00 Assignment Assignment - C# (C-Sharp) 00:00:00

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the SQL For Data Analytics & Database Development Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00

This UI Design course is concerned with the development of interactive systems, including for mobile / portable devices, with a strong focus on user-centred design and usability principles. You will learn what characteristics of a user interface can make it easy or hard for people to use, and how to design user interfaces that take into account human capabilities and constraints. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of 9.99 and PDF Certificate at 4.99. Who is this course for? UI Design course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject Course Content Setting Up Photoshop for UI Design Setting up Photoshop CC Preferences 00:06:00 Color Profile Settings for ui design 00:05:00 Creating Custom Shortcut Keys 00:04:00 Installing scripts in Photoshop 00:06:00 What area Photoshop Extensions 00:07:00 Power of Photoshop Extensions 00:09:00 How to install Extension in mac and win update 00:16:00 (Optional - Can watch at the end) Color Calibration and Monitors for Designers Color Calibration 00:08:00 Monitor You Need-1 00:02:00 OS Based clor Calibration 00:07:00 Basics of Photoshop for Beginners Customize Toolbar 00:04:00 how Photoshop interface works 00:05:00 creating photoshop new document 00:04:00 What are artboards 00:06:00 Layers Panel Part 1 00:06:00 Layer Panel Filtering And Finding Part 2 00:06:00 Type tool 00:05:00 Character Panel 00:07:00 Paragraph Panel 00:04:00 New Shape Tool 00:08:00 Deep dive in Pen Tool 00:16:00 selections-april2017 New 00:07:00 pen tool in web design 00:04:00 Alignments 00:06:00 common-shortcuts 00:15:00 Clipping_Masks 00:03:00 exercise_clipping_mask 00:01:00 LayerMasks_HB 00:05:00 Smart_objects 00:08:00 linked smart objects_Revised 00:07:00 Layer comps usage 00:06:00 Using Smart Guides In Photoshop-1 00:05:00 Layer Styles Basics for UI Design Drop Shadow Llayer Effect 00:04:00 Inner Shadow UI Design 00:02:00 Stroke_effect 00:03:00 Re-using layer styles 00:02:00 Gradients in Web and UI Design What.are.gradients 00:02:00 Uses.of.gradients 00:04:00 Ways-to-create-gradients 00:05:00 How to use gradient editor 00:08:00 Using-gradient-overlay 00:06:00 Using Patterns in Web and UI Design What are patterns 00:02:00 Two methods of applying patterns 00:05:00 Create Pattern From an Img File 00:03:00 Using .pat files in photoshop 00:05:00 Basics of UI Design | Light, Shadows, Color schemes & Typography How light and shadow works in UI Design 00:04:00 examples of lightshadow 00:02:00 Color schemes for beginners 00:02:00 Getting scheme from logo and hsb 00:01:00 Online tools for color schemes 00:07:00 How to choose fonts and typography 00:09:00 Using Grids for Web Design 00:06:00 Creating Grids In Photoshop 00:06:00 UI Design Exercises & Challanges with Step by Step solutions Soft-shadow button challange 00:01:00 Soft_button_solution 00:13:00 D Button Challange 00:01:00 Pressed effect in Photoshop 00:07:00 Modern pattern part 1 00:09:00 Modern header design part 2 00:09:00 Moder header design new variation 00:09:00 Color overlay header 00:11:00 Gradienteffect Header Design-audiosynced 00:13:00 Actual Exercise Transparent Image Header-1 00:13:00 Tabs-intro 00:01:00 Tabs-part1 00:14:00 Tabs-part2 00:08:00 Image Editing 101 for UI Designers removing White Bg With Blending Options 00:03:00 Spot Healing brush usage 00:04:00 Making Colors Pop in Photohsop 00:07:00 Magnetic Lasso Tool to remove background 00:16:00 Select And Mask Tool 00:10:00 IOS App Design : Exercise Iphone Food Deals App Gathering Resources IOS App-Design 00:04:00 Lets Start The IOS App Design 00:05:00 Adding Images To Design the App design 00:06:00 Adding Text On App Screen 00:06:00 Adding Phone And Book Now Buttons 00:12:00 Using Mobile Mockups 00:04:00 BONUS: Dribbble styled Dashboard UI Design (Student Request) area graph base design 00:04:00 Area graph grid 00:05:00 Adding text to graph area 00:08:00 Drwaing area graph with pen tool 00:04:00 Designing extras adding dots and hover info 00:06:00 Final Adjustments To Area Graph-1 00:10:00 Area graph to line graph 00:04:00 circular bar graph base shape.mp4 00:06:00 adding Gradients And Shadows To Circular Graphs-1 00:13:00 designing stats with text 00:09:00 bar Graph Design In Photoshop Pt 00:09:00 Bar Graph Adding Text 00:06:00 Student-request-ciruclar-percentage graph 00:08:00 Wifreframes in UI Design + Ultimate Web Design Challange What Are Wirefreams 00:04:00 Tools Used For Wireframes 00:12:00 Dribbble Shot Redesign Exercise - Student Request dribbble redesig part 1 00:15:00 dribble shot part 2 00:15:00 Exercises : Form UI Design with Photoshop Base Of Login Form 00:07:00 Form Fields Design 00:12:00 Finishing Form Design 00:12:00 Pro Secret Tips and Tools for Designers and Developers Converting psd to CSS 00:06:00 Exporting Images from Photoshop 00:07:00 Tips on Using Grids 00:02:00 Photoshop Features Updates and New Versions Match Fonts Cc2015.5-1 00:03:00 Cc2018 Update-1 00:04:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Dive into the world of sustainable architecture and environmental design with the 'LEED V4 - Diploma in Building Design and Construction at QLS Level 4.' This comprehensive course, meticulously structured over eleven units, offers a deep exploration of green building principles and practices. Starting with an introductory unit that sets the stage for a transformative learning journey, the course progresses through a series of meticulously crafted modules. Each unit, from the integrative process to regional priority considerations, is designed to enhance understanding and skills in creating environmentally responsible and resource-efficient buildings. The curriculum culminates with a completion unit, ensuring learners emerge with a holistic grasp of the subject matter. The diploma not only educates but inspires, focusing on critical areas such as location and transportation, sustainable site development, water efficiency strategies, energy and atmosphere considerations, and the use of sustainable materials and resources. It also delves into the nuances of indoor environmental quality and innovative approaches to building design and construction. This course is an invaluable resource for those aspiring to make a significant impact in the building and construction industry, equipping them with the knowledge to design and construct buildings that align with the advanced standards of LEED V4. Learning Outcomes Acquire comprehensive knowledge of sustainable building practices and principles. Develop expertise in optimizing water usage and energy efficiency in construction. Gain skills in selecting and utilizing sustainable materials and resources. Understand the significance of indoor environmental quality in building design. Master innovative strategies for building design and construction with a focus on regional priorities. Why choose this LEED V4 - Diploma in Building Design and Construction at QLS Level 4 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this LEED V4 - Diploma in Building Design and Construction at QLS Level 4 course for? Aspiring architects and designers keen on specializing in sustainable construction. Professionals in the construction industry aiming to enhance their eco-friendly building skills. Environmental consultants seeking to deepen their knowledge of green building practices. Urban planners interested in incorporating sustainable strategies in city designs. Project managers in the construction sector aiming to adopt LEED V4 standards. Career path Sustainable Architect: £30,000 - £50,000 Green Building Consultant: £35,000 - £55,000 Environmental Design Coordinator: £32,000 - £48,000 Urban Sustainability Planner: £28,000 - £45,000 Resource Efficiency Manager: £34,000 - £52,000 Eco-friendly Construction Project Manager: £36,000 - £60,000 Prerequisites This LEED V4 - Diploma in Building Design and Construction at QLS Level 4 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £95 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Unit 01: Introduction Introduction 00:01:00 Getting Started 00:04:00 Minimum Program Requirements 00:07:00 Rating System Selection 00:07:00 Unit 02: Integrative Process Integrative Process 00:04:00 Integrative Project Planning and Design 00:02:00 Unit 03: Location & Transportation Overview 00:03:00 Neigbourhoud Development 00:03:00 Sensitive Land 00:02:00 Surrounding Density & Diverse Uses 00:07:00 High Priority Site 00:02:00 Access to Quality Transit 00:06:00 Bicycle Facilities 00:06:00 Reduced Parking Footprint 00:04:00 Green Vehicles 00:04:00 Unit 04: Sustainable Sites Overview 00:02:00 Construction Activity Pollution Prevention 00:03:00 Environmental Site Assessment 00:03:00 Restore or Protect Habitat 00:04:00 Open Space 00:03:00 Rainwater Management 00:03:00 Heat Island Reduction 00:04:00 Light Pollution Reduction 00:05:00 Site Master Plan 00:02:00 Tenant Design and Construction Guidelines 00:02:00 Places of Respite 00:03:00 Direct Exterior Access 00:02:00 Joint Use Facilities 00:03:00 Unit 05: Water Efficiency Overview 00:01:00 Prereq Outdoor Water Use 00:03:00 Prereq Indoor Water Use 00:04:00 Prereq Building Water Metering 00:02:00 Credit Outdoor Water Use 00:02:00 Credit Indoor Water Use 00:03:00 Cooling Tower Water use 00:03:00 Building Water Metering Credit 00:02:00 Unit 06: Energy & Atmosphere Overview 00:02:00 Fundamental Commissioning & Verification 00:04:00 Minimum Energy Performance 00:05:00 Prereq Building Level Energy Metering 00:02:00 Fundamental Refrigerant Management 00:02:00 Enhanced Commissioning 00:05:00 Minimum Energy Performance 00:04:00 Advanced Energy Metering 00:02:00 Demand Response 00:03:00 Renewable Energy Production 00:02:00 Enhanced Refrigerant Management 00:03:00 Green Powerand Carbon Offsets 00:02:00 Unit 07: Materials & Resources Overview 00:02:00 Storage and Collection of Recyclables 00:03:00 Construction and Demolition Waste Management Planning 00:02:00 Preq PBT Source Reduction - Mercury 00:03:00 Building Life Cycle Impact Reduction 00:05:00 BPDO Environmental Product Declaration 00:04:00 BPDO Sourcing of Raw Materials (2020 Update Web) 00:03:00 BPDO Material Ingredients 00:05:00 PBT Source Reduction - Mercury Credit 00:02:00 PBT Source Reduction - Lead Cadmium Copper 00:03:00 Furniture and Medical Furnishings 00:04:00 Design for Flexibilty 00:02:00 Construction and Demolition Waste Management 00:03:00 Unit 08: Indoor Environment Quality Overview 00:01:00 Min Indoor Air Quality Performance 00:06:00 Environmental Tobacco Smoke Control 00:03:00 Minimum Accoustic Performance 00:03:00 Enhanced Indoor Air Quality Strategies 00:02:00 Low Emitting Materials 00:03:00 Construction Indoor Air Quality Management Plan 00:04:00 Indoor Air Quality Assessment 00:03:00 Thermal Comfort 00:04:00 Interior Lighting 00:06:00 Daylight 00:06:00 Quality Views 00:03:00 Accoustic Performance 00:03:00 Unit 09: Innovation Innovation Credit 00:03:00 Innovation LEED AP 00:01:00 Unit 10: Regional Priority Regional Priority Overview 00:01:00 Regional Priority Credit 00:02:00 Unit 11: Completion Completion 00:01:00 Assignment Assignment - LEED V4 - Diploma in Building Design and Construction at QLS Level 4 02:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This AWS Solutions Architect & SysOps Administrator will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The AWS Solutions Architect & SysOps Administrator will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to AWS Solutions Architect & SysOps Administrator and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited AWS Solutions Architect & SysOps Administrator is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this AWS Solutions Architect & SysOps Administrator. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The AWS Solutions Architect & SysOps Administrator will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum AWS Tutorial | Course Introduction AWS Tutorial Introduction 00:02:00 What You Will Become 00:01:00 Cloud Computing Basics - Introducing IaaS, PaaS & SaaS Service Models Cloud Computing Introduction 00:07:00 Cloud service models 00:10:00 Cloud Deployment Models 00:05:00 Pre-Requisites - Key Skills Required Before Get Started with AWS Linux Basics 00:02:00 AWS Free Tier Account 00:01:00 Desire to adopt Cloud Model 00:01:00 AWS Global Infrastructure AWS Regions 00:03:00 Availability Zones 00:06:00 EC2 Basics- Virtual Servers in AWS Cloud What is Amazon EC2? 00:03:00 How to Create EC2 Instance - Linux 00:13:00 How to Create EC2 Instance - Windows 00:06:00 How to configure EC2 Instance? 00:15:00 Instance States 00:05:00 EC2 Instance Types 00:08:00 EC2 Pricing Models 00:17:00 Networking Basics - Basics of Network Topology and IP address classes Know Networking Terms - IP, Port, Protocol, Service, Daemon 00:15:00 Apache HTTP Server 00:19:00 VPC - Configure Custom Virtual Private Cloud in the AWS Cloud Build Your Own Datacenter 00:04:00 What is AWS VPC? 00:04:00 Create Custom VPC 00:07:00 Create Custom VPC - LAB 00:17:00 Private Subnet Vs Public Subnet 00:08:00 Private Subnet Vs Public Subnet - LAB 00:15:00 VPC Peering Connections 00:04:00 VPC Peering Connections - LAB 00:11:00 Network ACLs Vs Security Groups 00:09:00 Virtual Private Network (VPN) 00:03:00 EC2 Advanced - Virtual Servers in AWS Cloud EC2 Instance Meta Data 00:03:00 How to Manage Instance Settings 00:07:00 BootStrap EC2 instances 00:05:00 AMI - Create, Copy & Manage Permissions 00:10:00 EC2 Placement Groups 00:05:00 Public IP Vs. Elastic IP 00:03:00 EC2 Summary 00:05:00 Introduction to Elastic Block Store - EBS 00:06:00 Instance Store Volumes 00:06:00 EBS Snapshots 00:03:00 Cloud Watch Basics - Monitor AWS Resources & Applications Performance Cloud Watch Metrics 00:04:00 Cloud Watch Dashboards 00:03:00 Cloud Watch Alarms 00:05:00 Simple Notification Service SNS Introduction 00:03:00 Create Topic & Subscriptions to the Topic 00:03:00 Cloud Watch Alarms - LAB 00:11:00 Certificate Manager - Provision, Manage & Deploy SSL/TLS Certificates Data Encryption Introduction & Types 00:04:00 Create SSL/TLS Certificates - LAB 00:05:00 Route 53 - Scalable DNS and Domain Registration What is Route 53? | How DNS works? 00:06:00 How to Create Hosted Zone 00:07:00 DNS Record Types 00:07:00 Route53 Health Checks 00:03:00 Load Balancing - High Availability Solution for the Applications & Servers High Availability & Load Balancer - Architecture 00:16:00 Classic Load Balancer 00:08:00 Application Load Balancer 00:15:00 Network Load Balancer 00:06:00 Auto Scaling - Scale EC2 instances Proportion to Application Load What is Auto Scaling? 00:08:00 Auto Scaling Group - Architecture 00:08:00 Auto Scaling Group with ELB Association 00:08:00 Create launch Configuration 00:03:00 Create Auto Scaling group 00:16:00 S3 - Scalable Object Storage in the AWS Cloud What is S3? 00:08:00 Create First S3 Bucket 00:03:00 Create First S3 Object 00:04:00 S3 Storage Classes 00:06:00 S3 Versioning 00:10:00 S3 Life Cycle Management 00:08:00 IAM - Manage User Access and Encryption Keys What is IAM ? | IAM Architecture 00:12:00 IAM User, IAM Group - LAB 00:11:00 IAM Policy - LAB 00:07:00 IAM Role - LAB 00:04:00 S3 Cross-Region Replication - LAB 00:10:00 IAM MFA & Security Best Practices 00:07:00 AWS CLI - Manage AWS Services & Resources through AWS CLI How to Install AWS CLI on Windows Systems 00:05:00 How to Install AWS CLI on Linux 00:03:00 Explore AWS CLI Real-time Use Cases 00:07:00 Key Management Service - Generate & Manage AWS Encryption Keys KMS Architecture 00:05:00 Key Management Service (LAB) 00:05:00 EBS Volume Encryption 00:02:00 S3 Encryption 00:02:00 EFS - Managed Network File Storage for EC2 EFS Architecture 00:04:00 Create EFS 00:05:00 Mount on EC2 Instances 00:04:00 S3 Glacier - Data Archival Solution in the AWS Cloud What is S3 Glacier? 00:02:00 Create Vault 00:02:00 Retrieval Policies 00:03:00 Cloud Watch Advanced - Monitor AWS Resources & Applications Performance Cloud Watch Logs 00:13:00 Cloud Watch Custom Metrics 00:04:00 Cloud Watch Events 00:07:00 Cloud Front - Global Content Delivery Network Cloud Front Architecture 00:05:00 Create Cloud Front Distribution - LAB 00:05:00 Cloud Trail - Track IAM user activity & API Usage What is Cloud Trail 00:02:00 Create Trail - LAB 00:05:00 Lambda - Run Code without Thinking About Code | Serverless Architecture What is AWS Lambda? 00:06:00 Getting started with AWS Lambda - LAB 00:08:00 RDS RDS Introduction 00:05:00 Get started with RDS - LAB 00:07:00 DynamoDB Create DynamoDB Table 00:02:00 API Gateway - Build, Deploy & Manage APIs API Gateway Architecture 00:06:00 Create an API - LAB 00:06:00 API Gateway Realtime Use Case 00:03:00 Elastic Beanstalk What is Elastic Beanstalk? 00:06:00 Create a web app - LAB 00:06:00 Cloud Formation - Create & Manager resources with Cloud Formation Templates What is Cloud Formation? 00:06:00 Create Stack - LAB 00:11:00 Cloud Formation Designer - LAB 00:07:00 Systems Manager - Session Manager, Run Command, Parameter Store, Patch Manager What is a Systems Manager? 00:09:00 Session Manager 00:03:00 Run Command 00:06:00 Patch Manager 00:03:00 Secrets Manager - Rotate, Manage & Retrieve Secret through their life cycle What is Secrets Manager? 00:03:00 Store a new secret in Secrets Manager - LAB 00:03:00 Secrets Manager Use Cases 00:02:00 Inspector - Analyze Application Security & Report Inspector Architecture 00:05:00 Inspector Install Run Analyze - LAB 00:06:00 LightSail - Launch & Manage Virtual Private Servers LightSail Architecture 00:05:00 Get Started with LightSail! 00:04:00 AWS Limitations AWS Free Tier Limitations 00:04:00 AWS Service Limits 00:04:00 AWS Cost Explorer What is AWS Cost Explorer? How to Analyze Cost Report? 00:04:00 AWS Support AWS Support Plans 00:04:00 How to raise support tickets with AWS? 00:03:00 AWS Trusted Advisor What is AWS Trusted Advisor? 00:06:00 AWS Project - Realtime 3-Tier Architecture AWS Project - 3-Tier Architecture Deep Drive 00:11:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00