262 MySQL courses in Leeds delivered On Demand

Tired of browsing and searching for a Web Development course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Web Development bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Web Development course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Web Development and help you along your learning journey. Advanced audio-visual learning modules of these Web Development courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Web Development, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Web Development Bundle Consists of the following Premium courses: Course 01: Diploma in PHP Web Development Course 02: HTML Web Development for Beginners Course 03: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 04: WordPress Website Creation and Hosting System with Affiliate Marketing! Course 05: Computer Science With Python Course 06: Python Programming for Everybody Course 07: Complete Web Application Penetration Testing & Security Course 08: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 09: Web Design in Affinity Designer Course 10: Advanced Diploma in User Experience UI/UX Design Course 11: Level 2 Adobe Graphics Design Course Course 12: Diploma in Animation Design Course 13: Cyber Security Incident Handling and Incident Response Course 14: Decision Making and Critical Thinking Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum: Course 01: Diploma in PHP Web Development Introduction Environment Configuration PHP Basics and Syntax PHP Forms and MySQL and User Authentication Course 02: HTML Web Development for Beginners Setup and Overview Basic Tags Headings Lists Links Images Tables Advanced Tables Meta Tags Description Lists Presentation Iframe Video Audio Forms CSS JavaScript Course 03: Create Your First Responsive Website Introduction Project Files Project Setup Website Structure Part-1 Website Structure Part-2 Chrome Dev Tools Top Menu Image Area Service Responsive Page Conclusion Course 04: WordPress Website Creation and Hosting System with Affiliate Marketing! Section 01: I Wish this Class Was Available for me When I Started My Business Online! Executive Summary of My Website with WordPress Section 02: Introduction Part 1: Best WordPress Website Creation and Hosting System with Affiliate Marketing! How to Build the Website, Hire Help, and Earn Money Making Websites on Upwork Affiliate Marketing Setup with Footer Links Plus a Bitly Custom Short Domain What Email Marketing Provider Do I Use? The System I Used to Get 400 Blog Posts on My Website Fast in My Voice WordPress Plugins, Collecting Emails, Consistency, and More Questions Section 03: Introduction Part 2: Why I Switched to the Google Cloud Platform Managed by Kinsta With My Faster Website Hosting, I have Improved my Website Rapidly! Why I Deleted My Email List! Section 04: Thank You for Watching! Course 05: Computer Science With Python Module 01: Introduction Module 02: Getting Started Module 03: Procedures and Loops Module 04: How to Manage Data Course 06: Python Programming for Everybody Course 07: Complete Web Application Penetration Testing & Security Course 08: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 09: Web Design in Affinity Designer Course 10: Advanced Diploma in User Experience UI/UX Design Course 11: Level 2 Adobe Graphics Design Course Course 12: Diploma in Animation Design Course 13: Cyber Security Incident Handling and Incident Response Course 14: CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Web Development bundle. Requirements Our Web Development course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Web Development expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Overview This comprehensive course on Django Rest Framework Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Django Rest Framework Level 4 comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Django Rest Framework Level 4. It is available to all students, of all academic backgrounds. Requirements Our Django Rest Framework Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 82 lectures • 04:40:00 total length •Module 01: Course and Instructor Introduction: 00:03:00 •Module 02: How to make the best of this course: 00:02:00 •Module 01: What is REST?: 00:06:00 •Module 02: Why REST: 00:08:00 •Module 03: What and Why DJango REST Framework: 00:06:00 •Module 01: Install DJango: 00:03:00 •Module 02: Install DJango REST Framework: 00:01:00 •Module 03: Install MySql and MySql workbench: 00:03:00 •Module 04: Launch MySql workbench: 00:02:00 •Module 05: Install python mysqlclient: 00:01:00 •Module 06: Install ATOM: 00:03:00 •Module 07: Install Postman: 00:01:00 •Module 01: Create the project: 00:02:00 •Module 02: Create a view: 00:02:00 •Module 03: Configure the URL and TEST: 00:03:00 •Module 04: Create app level urls: 00:02:00 •Module 05: Create a model class: 00:03:00 •Module 06: Configure the database and run migrations: 00:03:00 •Module 07: Use the model in the view and test: 00:03:00 •Module 01: DRF Components: 00:06:00 •Module 02: Function Based Views: 00:05:00 •Module 03: Serializers: 00:04:00 •Module 04: Create the Project: 00:02:00 •Module 05: Create the Model: 00:02:00 •Module 06: Create the Serializer: 00:02:00 •Module 07: GET single student: 00:04:00 •Module 08: Create Student: 00:04:00 •Module 09: Implement Non Primary Key Based Operations: 00:07:00 •Module 10: Use @api_view: 00:01:00 •Module 11: Configure the URLs: 00:02:00 •Module 12: Test: 00:07:00 •Module 13: Test Using Postman: 00:04:00 •Module 01: Introduction: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Implement Non Primary Key Based Operations: 00:06:00 •Module 04: Implement Primary Key Based Operations: 00:07:00 •Module 05: Configure the URLs and TEST: 00:04:00 •Module 01: Introduction: 00:05:00 •Module 02: Non Primary Key based operations: 00:04:00 •Module 03: Primary Key based operations: 00:02:00 •Module 04: Configure the URLs and TEST: 00:02:00 •Module 01: Generics: 00:03:00 •Module 02: Generics in action: 00:03:00 •Module 01: Introduction: 00:03:00 •Module 02: Create ViewSet: 00:02:00 •Module 03: Configure URLs and Test: 00:04:00 •Module 01: Create the Project: 00:03:00 •Module 02: Create model: 00:03:00 •Module 03: Create Serializers: 00:04:00 •Module 04: Create REST endpoints: 00:03:00 •Module 05: Configure URLs: 00:02:00 •Module 06: Test: 00:03:00 •Module 01: Introduction: 00:06:00 •Module 02: Pagination in action: 00:05:00 •Module 03: Pagination at class level: 00:03:00 •Module 04: Using LimitOffsetPagination: 00:01:00 •Module 01: Introduction: 00:04:00 •Module 02: Authentication in action: 00:03:00 •Module 03: Authorization in action: 00:06:00 •Module 04: Global Security: 00:04:00 •Module 01: Usecase: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Create Model Classes: 00:03:00 •Module 04: Create Reservation Model: 00:01:00 •Module 05: Create Serializers: 00:01:00 •Module 06: Create ViewSets: 00:02:00 •Module 07: Configure the Router: 00:02:00 •Module 08: Run Migrations: 00:01:00 •Module 09: Initial round of testing: 00:04:00 •Module 10: Implement findFlights endpoint: 00:03:00 •Module 11: Test findFlights: 00:05:00 •Module 12: Implement Save Reservation: 00:06:00 •Module 13: Test Save Reservation: 00:04:00 •Module 01: In-Built Validations: 00:04:00 •Module 02: Allowing Blank and Null Values: 00:02:00 •Module 03: Create Custom Validator: 00:05:00 •Module 04: Two more ways: 00:07:00 •Module 01: Introduction: 00:03:00 •Module 02: Configure Token Auth: 00:05:00 •Module 03: Create Users and Token: 00:04:00 •Module 04: Token Auth in action: 00:03:00 •Module 05: Automate Token Creation: 00:09:00

Get ready for an exceptional online learning experience with the Web Design & Web Development Bootcamp bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Web Design & Web Development Bootcamp is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Web Design package has something for everyone. As part of the Web Design & Web Development Bootcamp package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Web Design bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Learn Web Development from Scratch Web Design in Affinity Designer Web Design with Adobe XD Creative Web Design with HTML5, CSS3 and Bootstrap Secure Programming of Web Applications Bootstrap 4 Responsive Web Development Basics of WordPress: Create Unlimited Websites Essential Wix Training Modern PHP Web Development w/ MySQL, GitHub & Heroku Ultimate PHP & MySQL Web Development Course & OOP Coding Ionic & Angular JS: Mobile and Web Development Start Your Career as Web Developer - Complete Training C++ Development: The Complete Coding Guide Python Programming Bible | Networking, GUI, Email, XML, CGI Mastering Java for Beginners & Experts Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Web Design Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Web Design Bundle. Build a strong knowledge base in your chosen course via the Web Design Bundle. Benefit from the flexibility and convenience of online learning. With the Web Design package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Web Design & Web Development Bootcamp, a rich anthology of 15 diverse courses. Each course in the Web Design bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisWeb Design & Web Development Bootcamp bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Web Design & Web Development Bootcamp bundle offers you the flexibility and convenience to learn at your own pace. Make the Web Design package your trusted companion in your lifelong learning journey. CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Web Design & Web Development Bootcamp bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Web Design & Web Development Bootcamp bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Web Design & Web Development Bootcamp bundle package. Certificates CPD Quality Standard Certificate Digital certificate - £4.99 Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99

Flash Sale: Upto 50% OFF! CPD Certified| 15-in-1 Diploma Bundle | 15 Free PDF Certificate| Lifetime Access

Master MongoDB, an open-source document database and leading NoSQL database that provides high performance, high availability, and automatic scaling. This course covers the MongoDB Community version for beginners and provides over 50 live-running queries, including creating new databases and tables.

CPD Certified | 17-in-1 Diploma Bundle | 170 CPD Points | Free PDF & Transcript Certificate | Lifetime Access

"Start your career as a Full Stack Web Developer and earn up to £70,000 per month." Did you know? The UK digital sector is booming, with over 2 million job openings expected by 2025! Full stack web developers are in high demand, earning an average salary of £50,000, with top earners exceeding £100,000. Are you ready to join this exciting field and build the websites and applications of tomorrow? Our Full Stack Web Developer Job Ready Program is your all-in-one solution to learn web development from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job in web development. By choosing our Full Stack Web Developer Job Ready Program, you're not just gaining skills; you're gaining a lifelong career partner. Our mission is simple - to be your trusted partner every step of the way, from Training to Employment. Enrol Now and Kickstart Your Full Stack Web Development Career. Don't miss this opportunity to transform your career with the Full Stack Web Developer Job Ready Program. With our comprehensive training, career support, and money-back guarantee, you're not just enrolling in a program; you're investing in a brighter future. Join us now and become a part of the next generation of Full Stack Web Developer! In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Full Stack Web Developer, so we can help you get the job you want. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Full Stack Web Developer Job Ready Program today and start your journey to becoming a successful Full Stack Web Developer! Why Choose Us? So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Full Stack Web Developer Job Ready Program: Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Full Stack Web Development. One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Full Stack Web Developer field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Full Stack Web Developers. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Our aim is to maximise your employment prospects and provide you with a range of exciting opportunities to choose from. Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee. Courses we will provide once you enrol in the program: Course 01: Diploma in Complete Web Development at QLS Level 5 Course 02: HTML Web Development Crash Course Course 03: Fundamentals of CSS Course 04: CSS Web Development Crash Course Course 05: Learn Web Development from Scratch Course 06: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 07: Ionic & Angular JS: Mobile and Web Development Course 08: SQL for Data Science, Data Analytics and Data Visualization Course 09: MySql Masterclass Course 40: Basics of WordPress: Create Unlimited Websites Course 11: Masterclass Bootstrap 5 Course - Responsive Web Design Course 12: Diploma in User Experience UI/UX Design (Advanced) Course 13: CSS - Responsive Design Course 14: PHP Webforms for Everyone Course 15: Cyber Security Advanced Training The Full Stack Web Developer Job Ready Program with Career Support & Money Back Guarantee is completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the Full Stack Web Developer Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 15 premium courses related to Full Stack Web Development. These courses will teach you the knowledge and skills required to become a successful Full Stack Web Developer. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3: Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the Full Stack Web Development industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Full Stack Web Developer career begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Full Stack Web Developer Job Ready Program is perfect for: Beginners eager to break into the field of Full Stack Web Development and get a job. Professionals looking to move their career towards data science. Individuals seeking a comprehensive understanding of data analysis tools and techniques. Those aiming for a career upgrade with advanced analytics skills. Anyone interested in gaining practical, job-ready skills in Full Stack Web Development. Requirements No experience required. Just enrol & start learning. Career path This Full Stack Web Developer Job Ready Program will help you get a job in different roles, such as: Junior Web Developer: £25,000 - £35,000+ Web Developer: £35,000 - £50,000+ Senior Web Developer: £50,000 - £70,000+ Full Stack Developer: £50,000 - £100,000+ Front-End Developer: £40,000 - £60,000+ Back-End Developer: £45,000 - £75,000+ Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included

Gain n-depth knowledge about Docker technology and the confidence to help your company or your own project to apply the right Docker deployment workflow. Learn all about Docker, Docker REST API, and Docker continuous integration to build Docker images.

The course is intended to help design and implement industry-standard frameworks using Appium with TestNG Maven, Jenkins, GitHub, Apache Log4J2, and Extent Reports.

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