8903 Courses

Understand and use common expressions in modern greek in order to be able to communicate in simple, every day situations. Introduce yourselves and others, ask and answer questions about your life such as where you come from, where you live, and exchange information about family members. Interact in a simple way as long as the person you are talking to speaks slowly, clearly, and is prepared to help. The main topics to be covered in this course are about home, work, family, daily routine, food, likes, dislikes, describing people, shopping and much more...

Duration 4.5 Days 27 CPD hours This course is intended for This course is intended for individuals who have basic knowledge on cloud computing; on-premise system administrators; IT specialists, interested in AWS and Cloud Technologies. Overview Upon successful completion of this course, students will know how to design and deploy scalable, highly accessible and fault-tolerant systems in AWS. In this course, students will learn the main 'Managed Service' offered by AWS; How to design and deploy scalable, highly accessible and fault-tolerant systems in AWS; How to choose the most appropriate AWS service. Introduction Course overview Exam Blue Print Public clouds & cloud economics AWS Overview & Whitepapers Setting up AWS Account Identity and Access Management (IAM) Local users, groups & roles SAML providers Policies Cross Account Access Best practices & Examples Lab Exam highlights Sample questions Simple Storage Service (S3) & Glacier Buckets Objects Lifecycle Configurations and permissions Custom bucket policies Best Practices & Examples Lab Exam highlights Sample questions Virtual Private Cloud (VPC) VPC Internet gateway vs NAT Gateway Elastic IPs Subnets & Routing tables Security Groups & Network Access Lists VPC Peering & Endpoints Managed VPN Connections Best Practices & Examples Lab Exam highlights Sample questions Elastic Compute Cloud (EC2) Instances Amazon Machine Images(AMIs) Elastic Block Store (EBS) Network & Security Load Balancers (ELB) Auto Scaling Groups (ASG) Instance Management Best Practices & Examples Lab Exam highlights Sample questions Route 53 Hosted Zones Health checks Traffic flow Best Practices & Examples Lab Exam highlights Sample questions Relational Database Service (RDS) Engine types Performance & Resilience Subnet groups Best Practices & Examples Lab Exam highlights Sample questions CloudWatch Dashboard and Metrics CloudWatch logs CloudWatch rules Best Practices & Examples Lab Exam highlights Sample questions Other AWS Services Simple Overview CloudFront DynamoDB Elasticache Redshift SQS SWF SNS Elastic Transcoder API Gateway Kenesis CloudFormation Exam highlights Sample questions Multiple AWS Services exercise Lab 1 - Architecting multi-tier environment Lab 2 - Configure backup and monitoring Practice Exam Additional course details: Nexus Humans AWS Certified Solutions Architect - Associate training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AWS Certified Solutions Architect - Associate course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for Analyst End User Implementer Manager Overview Create a Work Breakdown Structure Define roles and resources Assign roles Assign resources Analyze resources Optimize the project plan Understand data structures Create a project Add activities View calendars Create relationships Schedule the project Assign constraints Create reports Format schedule data Execute the project Enrolling in this course will help you understand P6 Professional's basic features and functionality so you can apply them to your organization's project management processes. You'll also learn how to manage projects on time and within budget Understanding P6 Data Describing Enterprise and Project-Specific data Logging In Opening an Existing Project Opening and Customizing Layouts Enterprise Project Structure Describing Components of EPS Creating a Project Create a project Navigating in the Projects Window Viewing Project Details Creating a Work Breakdown Structure Defining a Work Breakdown Structure Creating the WBS Hierarchy Adding Activities Describing an Activity and its Components Describing Activity Types Adding Activities Adding a Notebook Topic Adding Steps to an Activity Assigning Activity Codes Creating Relationships Viewing a Network Logic Diagram Relationship Types Creating Relationships Scheduling Performing a Forward and Backward Pass Describing Float Assigning Constraints Applying an Overall Deadline to a Project Apply a Constraint to an Activity Using Reflection Projects Creating a Reflection Project Merging Changes Formatting Schedule Data Grouping Activities Sorting Filtering Roles and Resources Describing Roles and Resources Viewing Dictionaries Assigning Roles Assigning Roles to an Activity Assign Rates on Roles Assigning Resources Assigning Resources Adjusting Budgeted Units/Time Analyzing Resources Displaying the Resource Usage Profile Optimizing the Project Plan Analyzing Schedule Dates Shortening a Project Schedule Analyzing Resource Availability Baselining the Project Plan Creating a Baseline Plan Display Baseline Bars on the Gantt Chart Project Execution and Control Describing Methods for Updating the Schedule Using Progress Spotlight Statusing Activities Rescheduling the Project Reporting Performance Describing Reporting Methods Running a Schedule Report Creating a report with the Report Wizard Additional course details: Nexus Humans Primavera P6 Professional Fundamentals Rel 19 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Primavera P6 Professional Fundamentals Rel 19 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

SQL programming is the programming that manages data in the Relational Database Management System. The Mastering SQL Programming course aims to teach you how to optimise the accessibility and maintenance of data with the Structured Query Language SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This SQL Programming course will provide you the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Learn what SQL is and how to create, manipulate, and create reports from database tables from the best SQL courses. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Enrol Now to start boosting your SQL skills! Key topics to be covered Stored Procedures Returning Data Testing and Debugging SQL CLR Code Dynamic SQL Column sets Learning Outcomes Know the tools for creating views with examples, columns and indexed views, creating stored procedures, testing and debugging. Learn how to create triggers, execute with result sets, use inline table valued functions, and use the multi statement function. Learn about transaction concepts, explicit transactions, and structured error handling. Understanding of different functions, data tools, database management, comparing database schemas, offline database management and much more. Master partitioning, managing partitions, querying partitions, complex querying, table expressions, efficient queries and complex queries. Why Choose this Course Earn a digital 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 supplies Mock tests Multiple-choice evaluation Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and expert skills in SQL programming. Those who have an interest in production planning. Students from any academic backgrounds

Managing a purchase ledger efficiently is fundamental to maintaining an organisation’s financial health. This course offers a detailed introduction to the purchase ledger, highlighting its role in the broader accounting framework and why accurate management is essential for smooth business operations. Participants will explore the key principles behind purchase ledger control accounts and learn how to oversee transactions to maintain balance and accuracy in financial records. Through this course, learners will gain insight into the skills required to manage purchase ledgers effectively, including reconciliation techniques and the benefits of adopting paperless systems. The modules are designed to guide you through the processes involved in handling supplier invoices, payments, and ledger reconciliation with confidence. Whether you are new to finance or seeking to refresh your knowledge, this course delivers the knowledge needed to improve ledger accuracy and efficiency, boosting overall financial organisation performance. Course Curriculum: Module 01: Introduction to Purchase Ledger Module 02: Importance of Purchase Ledger Module 03: Skills for Purchase Ledger Management Module 04: Purchase Ledger Control Account Module 05: Managing Purchase Ledger Successfully Module 06: Reconciliation Module 07: The Key to a Paperless Purchase Ledger World Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Purchase Ledger - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Purchase Ledger - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Purchase Ledger - CPD Accredited training.

Everyday workplace activities—from lifting small boxes to adjusting office equipment—can carry risks when done incorrectly. This course offers a clear and structured look at the principles of safe manual handling, with a focus on reducing strain, preventing injury, and encouraging responsible movement in various job settings. Whether you work in an office, warehouse, or retail environment, understanding the basics of manual handling is vital for personal safety and a healthier work culture. Presented in a straightforward format, this CPD-accredited course is tailored for learners seeking flexible, online training without unnecessary jargon or filler. You'll explore the key causes of musculoskeletal injuries, understand how to assess movement risks, and learn how to apply basic safety strategies that can be easily remembered and implemented. It's a smart choice for those looking to enhance their awareness and approach to physical tasks—without needing to leave their desk. Course Curriculum: Introduction to Manual Handling Manual Handling: Introduction, Legislation and Guidance Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Introduction to Manual Handling - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Introduction to Manual Handling - CPD Accredited training.

Discover the art and craft of compelling copywriting with this expertly designed online course. Whether you're a budding writer or a marketing professional looking to sharpen your messaging, this course offers a deep dive into creating content that captures attention and drives results. From mastering the basics to crafting headlines that command interest, each module builds your confidence in writing clear, persuasive copy tailored to various media formats. Explore the nuances of writing for digital platforms, print, press, and mainstream outlets, ensuring your words resonate with diverse audiences. Along the way, you’ll refine essential skills that enhance clarity, creativity, and impact, all presented in a format that fits your schedule. By the end, you'll have a solid grasp of what makes copy effective and how to keep readers engaged—ready to take your writing to new heights. Course Curriculum: Module 01: Introduction to Copywriting Module 02: Basics of Copywriting Module 03: Eye-Catching Headlines Module 04: Attention-Grabbing Advertisements Module 05: Essential Copywriting Skills Module 06: Online Copywriting Module 07: Press Related Copywriting Module 08: Print Media Copywriting Module 09: Copywriting for Mainstream Media Module 10: Copywriting for Other Media Module 11: How to Write Better Copy Module 12: Making an Impact with Creative Copy Module 13: So You Want to be a Copywriter? Module 14: Final Tips Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Copywriting - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Copywriting - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Copywriting - CPD Accredited training.

Quality management is the cornerstone of any successful organisation aiming to consistently deliver exceptional products and services. This CPD accredited course offers a thorough introduction to the principles and practices that underpin effective quality management. From understanding the fundamentals of Total Quality Management to exploring advanced techniques such as Six Sigma, learners will gain valuable insights into maintaining and improving quality standards across various business functions. Throughout the course, participants will explore essential topics including quality measurement, quality control, and the vital role of supply chain management in upholding product integrity. Emphasis is also placed on recognising and addressing customer expectations, ensuring organisations meet and exceed their needs. Additionally, the course covers quality audits, enabling a structured approach to evaluating quality systems and processes. Designed for professionals seeking to deepen their knowledge in quality management, this course provides a structured path to enhancing organisational efficiency and customer satisfaction without the need for physical attendance. Course Curriculum: Module 01: Introduction to Quality Management Module 02: Total Quality Management Module 03: Quality Measurement and Improvement Module 04: Quality Control Module 05: Understanding Customer Expectations and Needs Module 06: Six Sigma Module 07: Supply Chain Management Module 08: Quality Audits Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Quality Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Quality Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Quality Management - CPD Accredited training.

Stress is part of life. Now managing it can be, too. Mindful Stress Management is a self-paced course designed to help you handle everyday stress in a healthier, more sustainable way. Developed by NASM wellness experts, this course provides simple, science-backed tools you can put to use immediately – including guided audio sessions, gentle movement flows, printable worksheets, and everyday techniques that fit into your real routine. Whether you need quick relief or you're ready to build long-term habits, this course gives you the support to respond instead of react. So you can start feeling more like yourself again. One moment at a time.

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00