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
Health & Social Care workers play a crucial role in supporting individuals with their health and well-being. They work in a variety of settings, including hospitals, residential care homes, community centres, and private homes. The Organisation for Economic Co-operation and Development (OECD) reports that the health & social care sector is one of the fastest growing employment sectors, with the number of jobs increasing by 42% between 2000 and 2017. According to Reed a Health and Safety Officer can earn from £30,000 to £40,000 in a year depending on qualification, experience, location and other factors. Don't miss out on this incredible opportunity to kickstart your career in nursing and social care. Enrol in our Diploma in Nursing (Level 3) with a Health & Social Care Certificate course today and take the first step towards a rewarding and fulfilling career in healthcare! Key Features: CPD Certified Nursing (Level 3) with Health & Social Care Certificate course Free Certificate Developed by Specialist Lifetime Access Course Curriculum: Advanced Diploma in Nursing (Level 3) with Health & Social Care Certificate Module 1: Nursing Fundamentals 1.1 Overview of Nursing 1.2 Ethical Practice: Legal and Professional Dimensions - Part 1 1.3 Ethical Practice: Legal and Professional Dimensions - Part 2 1.4 Effective Communication within the Nursing Context 1.5 Nursing and the Promotion of Health and Safety Module 2: Practical Nursing Skills 2.1 Controlling Infections in Healthcare Settings 2.2 Administration of Medications in Nursing 2.3 Nurses' Role in Pain Management 2.4 Nutritional Practices in Nursing 2.5 Maintaining Fluid and Electrolyte Balance 2.6 Assisting with Elimination Processes 2.7 Respiratory Care in Nursing Module 3: Specialized Roles and Responsibilities 3.1 Ensuring the Safety and Well-being of Young Children 3.2 Overview of Health & Social Care 3.3 Significance of Communication in Healthcare 3.4 Rights and Duties in Health & Social Care 3.5 Dual Role as a Caregiver and Healthcare Professional Module 4: Healthcare Ethics and Policies 4.1 Key Principles and Policies in Health & Social Care 4.2 Promoting Equality, Diversity, and Rights in Health & Social Care Practice Learning Outcomes: Demonstrate understanding of nursing fundamentals, including ethical practice and communication skills. Apply practical nursing skills, including infection control, medication administration, and pain management. Explore specialized roles and responsibilities in health & social care contexts. Understand healthcare ethics and policies, promoting equality, diversity, and rights. Ensure safety and well-being of young children and dual caregiving roles. Demonstrate knowledge of key principles and policies in health & social care. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Nursing (Level 3) with Health & Social Care Certificate course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Nursing (Level 3) with Health & Social Care Certificate. Moreover, this course is ideal for: Suitable for employees seeking essential first-aid skills in the health & social care. Ideal for managers and supervisors responsible for work incident management. Relevant for individuals working in diverse industries and occupational environments. Essential for health and safety representatives in corporate or industrial settings. Suitable for anyone interested in acquiring emergency response skills at work. Individuals interested in health & social care Requirements There are no requirements needed to enrol into this Diploma in Nursing (Level 3) with Health & Social Care Certificate course. We welcome individuals from all backgrounds and levels of experience to enrol into this Diploma in Nursing (Level 3) with Health & Social Care Certificate course. Career path After finishing this Nursing (Level 3) with Health & Social Care Certificate course you will have multiple job opportunities waiting for you. Some of the Job sectors of Nursing (Level 3) with Health & Social Care Certificate are: Workplace First Aid Coordinator Health and Safety Officer Emergency Response Team Member Incident Management Specialist Occupational Health and Safety Advisor Certificates Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Real Estate: Real Estate Agent, Property Management, Property Development & Marketing 5-in-1 Package Are you looking to excel in the real estate industry? Our all-inclusive 5-in-1 Real Estate bundle course covers everything you need to succeed: Real Estate Agent training, Property Management skills, Property Development insights, and effective Marketing strategies. According to Reed a Real Estate Agent can earn from £45,000 to £55,000 in a year depending on qualification, experience, location and other factors. Transform your career with our expert-led real estate course. Whether you are just starting out or looking to enhance your skills, this course is designed to provide you with the knowledge and tools you need to thrive in the real estate market. Enrol now and take the first step towards a successful career in real estate! Key Features: This Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course comes with: CPD Certified Developed by Specialist Lifetime Access Enrol this 5-in-1 Package This Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course TODAY and Excel in this field. Course Curriculum Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course: Section 1: Foundations of Real Estate 1.1 Real Estate Agent Overview 1.2 Various Real Estate Agent Specializations 1.3 Regulatory Framework for Real Estate Agents Section 2: Starting & Building Your Career as an Agent 2.1 Initiating Your Professional Journey 2.2 Property Listing: Identifying Sellers 2.3 Property Valuation Procedures 2.4 Negotiation Techniques for Real Estate Agents 2.5 Property Sales: Attracting Buyers 2.6 Property Leasing 2.7 Technological Tools for Real Estate Professionals Section 3: Property Management Essentials 3.1 Basics of Property Management 3.2 Legal Considerations in Property Management Section 4: Introduction to Property Development 4.1 Introduction to Property Development 4.2 Diverse Property Types 4.3 Property Research Fundamentals 4.4 Compliance with Building Regulations 4.5 The Planning Phase in Property Development 4.6 Project Management in Property Development Section 5: Financing & Marketing in Real Estate 5.1 Varied Financing Options 5.2 Property Marketing Techniques Learning Outcomes After completing this Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course, you will be able to: Identify diverse roles within the real estate agent profession. Apply techniques for property listing and valuation processes. Understand the legal aspects of property management and ownership. Analyse various property development types and regulatory frameworks. Evaluate different financing options relevant to real estate transactions. Implement marketing strategies specific to the property market. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Real Estate Agent, Property Management, Property Development & Marketing course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Real Estate Agent, Property Management, Property Development & Marketing. Moreover, this course is ideal for: Aspiring real estate agents seeking foundational knowledge. Individuals interested in property management basics. Those exploring property development as a potential career. Individuals keen on understanding real estate financing options and also property development & marketing. Professionals looking to enhance their real estate marketing skills. Requirements There are no requirements needed to enrol into this Real Estate Agent, Property Management, Property Development & Marketingcourse. We welcome individuals from all backgrounds and levels of experience to enrol into this Real Estate: Real Estate Agent, Property Management, Property Development & Marketing course. Career path After finishing this Real Estate Agent, Property Management, Property Development & Marketing course you will have multiple job opportunities waiting for you. Some of the Job sectors of Real Estate Agent, Property Management, Property Development & Marketing are: Property Valuer Letting Agent Property Developer Real Estate Analyst Property Manager Marketing Executive in Real Estate Sector Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.
Are you planning to start a company or want to make a profit? Then, join our Financial Modelling course and take your business to the next level. You will gain the expertise and knowledge to evaluate your business, handle the finance and predict the market. In addition, you will learn to handle unwanted circumstances and make proper decisions under pressure. This Financial Modelling course includes easy-to-digest modules from which you can learn the most up-to-date knowledge about the current market condition. Also, you will learn the fundamental calculations required to forecast takings and values in the near future and receive a masterclass on the essentials of the financial market itself. You will be able to build financial models, conduct sensitivity analyses, research market opportunities, and arrive at exact valuations based on your correlated data. Sign up for our Financial Modelling course and enjoy your learning journey. Course Curriculum ✓ Module 01: Basic Financial Calculations ✓ Module 02: Overview of Financial Markets, Financial Assets, and Market Participants ✓ Module 03: Financial Statement Modelling ✓ Module 04: Types of Financial Models ✓ Module 05: Sensitivity Analysis ✓ Module 06: Sales and Revenue Model ✓ Module 07: Cost of Goods Sold and Inventory Model ✓ Module 08: Valuation Methods Learning Outcomes By the end of this course, you will: Study the maths and financial terms used in financial modelling. Understand the financial markets, financial assets, and market participants. Sort various financial model types according to their criteria Learn about sensitivity analysis in financial modelling Possess the ability to use tools to analyse multiple independent variables Use the valuation approach to determine your company’s or an asset’s fair market value Assessment and Certification At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Eligibility Requirements There are no special requirements to join this course. Anyone with an interest in yoga or mindfulness can enrol. You just need an open mind and the desire to learn. Career Path This Financial Modelling Course will give you an in-depth understanding of the subject. On successful completion, you will have the skills, confidence and practical knowledge to fast-track a successful career in relevant sectors. Professions in this field include: Market Analyst Finance Administrator Finance Manager Finance Advisor Accountant (Learn more about this online course)
Flappy Bird Clone: Cocos2d-x C++ Game Course Overview: This course provides a comprehensive introduction to game development using Cocos2d-x and C++. Learners will create a fully functional Flappy Bird clone, mastering the fundamentals of game mechanics, user interface design, and game physics. The course covers essential topics in object-oriented programming, handling user input, collision detection, and scene management. By the end, learners will have the knowledge to design and develop their own 2D games, making this course an excellent starting point for anyone interested in game development. The practical value lies in learning how to implement complex game features, which can be used in future projects or professional roles. Course Description: In this course, learners will dive into the process of developing a 2D game using C++ and Cocos2d-x. Starting with the basics of game creation, the course introduces essential programming concepts including classes, object handling, and event-driven programming. Key topics include building the game environment, implementing gravity and jump mechanics, handling user inputs, and managing game scenes. Learners will also focus on game physics such as collision detection and the continuous movement of the game elements. The course encourages learners to break down complex game features into manageable components while using a leading game engine. By the end of the course, participants will be equipped with a strong foundation in game programming and the skills needed to create their own games. Flappy Bird Clone: Cocos2d-x C++ Game Curriculum: Module 01: Introduction to Cocos2d-x and C++ (See full curriculum) Who is this course for? Individuals seeking to start a career in game development Professionals aiming to enhance their programming and game design skills Beginners with an interest in learning game development Aspiring developers looking to create their own 2D games Career Path Junior Game Developer Game Programmer Game Designer Mobile Game Developer Software Developer in the gaming industry
Blockchain Project Management Training Course Overview This Blockchain Project Management Training course offers a comprehensive introduction to managing projects within the rapidly evolving blockchain and Web3 environments. It equips learners with essential knowledge of project and product management principles tailored specifically for blockchain technology. Participants will gain insights into the unique challenges and opportunities presented by Web3 projects, learning how to navigate this innovative landscape efficiently. By the end of the course, learners will be able to understand key concepts, develop management strategies, and prepare effectively for careers in the blockchain sector. This training is designed to enhance career prospects by providing relevant skills aligned with current industry demands. Course Description This course delves deeply into the fundamentals of project and product management in the context of blockchain technology and Web3. Topics include understanding the roles and responsibilities of a Web3 project manager, critical considerations when overseeing blockchain initiatives, and strategies for securing employment in the blockchain sector. Learners will explore how to manage complex, decentralised projects, balancing technical requirements with business objectives. The course delivers a structured learning experience that sharpens analytical and organisational abilities, helping participants become confident and competent in blockchain project environments. Delivered in clear UK English, this course prepares learners to contribute effectively within one of the most innovative and fast-growing industries today. Blockchain Project Management Training Curriculum Module 01: Introduction Module 02: Project / Product Management in Web Module 03: Important Things to Remember about being a Web3 PM Module 04: Getting a Job in Web3 Module 05: End Notes (See full curriculum) Who Is This Course For? Individuals seeking to understand blockchain project management fundamentals. Professionals aiming to develop a career in blockchain or Web3 project management. Beginners with an interest in blockchain technology and digital innovation. Project managers transitioning into emerging technologies and decentralised systems. Career Path Blockchain Project Manager Web3 Product Manager Digital Transformation Specialist Decentralised Application (dApp) Coordinator Blockchain Consultant
Marketing Strategies for Business Course Overview This course offers a comprehensive exploration of marketing strategies essential for business growth and competitive advantage. Learners will gain insight into analysing current market positions, defining strategic goals, and developing effective go-to-market plans. Emphasising the integration of theory and strategic planning, the course equips participants with the ability to design and implement marketing initiatives that drive success. Through structured learning, individuals will develop critical thinking skills to evaluate market opportunities, understand customer needs, and align marketing efforts with broader business objectives. This course is designed to empower learners with the knowledge and confidence to contribute meaningfully to marketing strategy development in various business contexts. Course Description Delving deeper into core marketing concepts, this course covers strategic analysis of the current market environment, goal setting for future positioning, and detailed approaches to launching marketing campaigns. Learners will engage with topics such as market segmentation, competitive analysis, brand positioning, and the execution of marketing plans that ensure measurable outcomes. The learning experience emphasises strategic decision-making, fostering skills in assessing market trends and consumer behaviour. Participants will be equipped to formulate coherent marketing strategies that align with organisational aims, enhancing business growth and sustainability. Throughout, the course maintains a professional and informative tone, suitable for those seeking to develop expertise in marketing within diverse industries. Marketing Strategies for Business Curriculum Module 01: Welcome Module 02: Strategic Outline: Where Are We Now? Module 03: Strategic Outline: Where Do We Want to Be? Module 04: It’s Time to Go to Market Module 05: Ensure Success (See full curriculum) Who Is This Course For? Individuals seeking to understand core marketing strategy principles Professionals aiming to enhance strategic marketing skills for career progression Beginners with an interest in marketing and business development Entrepreneurs looking to improve market positioning and customer engagement Career Path Marketing Coordinator Business Development Executive Brand Strategist Market Research Analyst Marketing Consultant
Legal Secretary and Office Skills Diploma Course Overview The Legal Secretary and Office Skills Diploma is a comprehensive course designed for those aiming to pursue a career as a legal secretary or administrative professional. This course covers a wide range of essential office skills and legal secretarial duties, offering a strong foundation in the tools and techniques needed to succeed in the office environment. Learners will gain proficiency in Microsoft Office tools, including Word, PowerPoint, Outlook, and Excel, as well as essential knowledge of legal office practices. Upon completion, learners will be well-equipped to manage office operations, handle legal documentation, and assist with legal professionals' administrative tasks, enhancing their career prospects in both the legal and administrative fields. Course Description This diploma provides a structured learning experience, covering essential topics such as legal secretary duties, and Microsoft Office tools, including Word, PowerPoint, Outlook, and Excel. Learners will explore essential office management techniques, including document preparation, managing correspondence, organising meetings, and understanding legal terminology. The course also introduces top Excel keyboard shortcuts to boost efficiency in document management and office tasks. As learners progress through the modules, they will gain key skills required to assist legal teams in their day-to-day operations. The course is designed for those looking to enter the legal, administrative, or office management fields and offers in-depth exposure to both the technical and professional skills that employers seek. Legal Secretary and Office Skills Diploma Curriculum Module 01: Legal Secretary Module 02: Microsoft Word Essentials Module 03: Microsoft PowerPoint Essentials Module 04: Microsoft Outlook Essentials Module 05: Microsoft Excel - Top 50 Keyboard Shortcuts (See full curriculum) Who is this course for? Individuals seeking to become proficient in legal secretary and office management roles. Professionals aiming to advance in administrative careers within the legal sector. Beginners with an interest in learning essential office skills and legal office practices. Those who wish to work in law firms or corporate legal departments. Career Path Legal Secretary Office Administrator Executive Assistant Paralegal Administrative Assistant in Law Firms Office Manager in Corporate Settings
Marketing Secrets for High Sales Course Overview "Marketing Secrets for High Sales" is a dynamic course designed to equip learners with advanced strategies for driving sales success. Throughout the course, participants will explore cutting-edge marketing techniques, tools, and insights that have proven effective in boosting sales across various industries. By the end of the course, learners will understand how to craft compelling marketing strategies, leverage customer psychology, and implement tactics that consistently lead to high sales conversions. The course is structured to provide learners with both the theoretical knowledge and actionable skills needed to excel in a competitive market. Course Description This course delves into a wide range of topics including sales funnel optimisation, creating persuasive marketing messages, targeting the right audience, and leveraging digital platforms for maximum impact. Learners will explore the intricacies of consumer behaviour, the role of brand positioning, and the importance of data-driven decision-making. By engaging with the course materials, participants will gain in-depth insights into the strategies that fuel high sales numbers and discover how to adapt these methods to suit their unique business goals. The course is designed to offer a structured learning experience, ensuring that all essential concepts are covered and applicable to real-world scenarios. Marketing Secrets for High Sales Curriculum Module 01: Understanding Sales Psychology Module 02: Crafting Compelling Marketing Campaigns Module 03: Leveraging Social Media for High Sales Module 04: Data-Driven Marketing Techniques Module 05: Email Marketing for Conversion Optimisation Module 06: Building Brand Loyalty to Drive Long-Term Sales Module 07: Advanced Sales Funnel Strategies (See full curriculum) Who is this course for? Individuals seeking to enhance their marketing knowledge and skills. Professionals aiming to boost their sales strategies and performance. Beginners with an interest in learning the principles of high sales. Entrepreneurs and business owners looking to optimise their marketing efforts. Career Path Marketing Manager Sales Director Digital Marketing Specialist Brand Strategist Sales Consultant
This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00