794 Amazon courses

Overview This comprehensive course on Java Certification Cryptography Architecture will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Java Certification Cryptography Architecture comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Java Certification Cryptography Architecture. It is available to all students, of all academic backgrounds. Requirements Our Java Certification Cryptography Architecture 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 4 sections • 10 lectures • 00:40:00 total length •Introductory Lecture: 00:02:00 •Setup: 00:03:00 •Simple Hashing Example: 00:05:00 •Real-world Hashing Example: 00:07:00 •Efficient Stream-Based Hashing: 00:02:00 •Message Authentication Code (MAC): 00:05:00 •Secure Password Hashing with PBKDF2/PKCS#5: 00:10:00 •Commercial Wrapper Libraries: Demo: 00:03:00 •JCE Unlimited Strength Policy File Installation: 00:03:00 •Assignment - Java Certification Cryptography Architecture: 00:00:00

Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •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 •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 •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 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •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 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00

What Will I Learn? Build their first Affiliate Business Generate their first sales online Setup their website for success Leverage the power of google, video and social media to generate traffic Earn and optimize for long term success Build a new online income stream fast! Requirements You need a computer and internet access. No prior experience needed.  Description ALREADY OVER 1750+ HAPPY STUDENTS ENROLLED AND 23+ 5 STAR RATINGS for 'Affiliate Marketing Hacking - The 5 Steps Fast Track Method' ***LAST UPDATED ON 21 April 2016*** 'This course explains EVERYTHING' - Imad Yaici 'I really recommend taking this course, it contains complete explanation of the process of setting up a compaign with REAL WORLD examples to help you understand. Also, the instructor is very kind and available to reply to your questions.' There are so many opportunities out there because of the internet and that makes it so frustrating to see other people succeding with business after business in the online arena and having the lifestyle and freedom that they have always wished for. Maybe you are looking for your first method that really works for building your first online income and business or maybe you alredy have some success and want to build a new income stream, either way, this course can be for you. Have you ever wondered how this people actually are making it online? It's simple and the answer is the same like for anything else in life: apply the methods that are proven to work and put in the actual work. That's it, seems so simple right?...Yet so many people are falling into the trap of the 'shiny object syndrom' and 'the new hype thing' and are not focusing on using methods that work. One of the most productive online business models that are out there is affiliate marketing. With budgest that well exceed 4 billion $ every year it's becoming a huge industry in the context of switching to a performance based economy. You probably now already that there are top affiliates that are crushing it, earning more than 1,5 million dollars every year from affiliate marketing alone. It involves a lot of work but it definilty worths it but we won't talk in this course about how they got there. In this course we will talk about the method that i've used with some very good friends to generate fast affiliate commissions almost instantly by using a special affiliate marketing tehnique. I am sure this method can help you to make your first online money fast, have a breakthrough or build another online income stream using affiliate marketing. So what you will learn in this course: What is Affiliate Marketing and how you can earn from it! Which are the main channels to promote and earn from affiliate offers. My 5 Steps Method to earn commissions fast from affiliate marketing. How to setup a website to maximize your chances for success. Where to find a good domain that you can use in your advantage. How to find an offer that you can promote and sell through affiliate marketing. How to sell a product through your website and get traffic almost instantly when that product it's launched. How to use video and social media in your favor to get better positioning, exposure, traffic and ultimatly sales in your affiliate marketing business! How to optimize my method and start to build a long term successfull business. and many more... Other Benefits Lifetime Access to all other updates! Surprise Bonuses! New Methods and Systems introduced in the course! FULL Support through the discussion area of the course! 30 Day Money Back GUARANTEE if you feel this course didn't help you at all and you can't apply anything...that is how dedicated we are to your success! Time To Take ACTION! So, what are you waiting for? Click the 'take this course' button, top right, now...every day and hour you delay you could be earning your first money from affiliate marketing! To Your Massive Online Success, Sorin Constantin Who is the target audience? Anyone who wants to make money online Anyone who wants to build an additional income stream People who want to earn money from affiliate marketing Anyone who is looking for an online business that can work fast for them Introduction to Affiliate Marketing What is Affiliate Marketing? 00:15:00 About Me 00:02:00 Why should You chose Affiliate Marketing? 00:05:00 Affiliate Marketing Sites/Offers Examples 00:06:00 Methods of promoting and earning from Affiliate Marketing Promotion Methods and Earning Models 00:08:00 CPA Offer Example 00:04:00 The Proven Strategy to Fast Track Affiliate Commissions 'The 5 Steps Fast Track Method' 00:05:00 Step-by-Step Plan Explanations How to chose the right domain 00:15:00 How to setup your website for the best results possible! 00:09:00 Where to setup your affiliate accounts 00:02:00 Affiliate Account Example - What to look for? 00:04:00 Where to find the best offer to promote 00:10:00 How to do research for your potential offers 00:09:00 How to get information for your reviews 00:06:00 How to write good reviews that rank and convert! 00:07:00 How to create videos for your reviews 00:06:00 It's link building time! 00:06:00 How to optimize for long term success! 00:05:00 What Email Services you can use 00:03:00 UpViral Study Case Part 1 00:06:00 UpViral Study Case Part 2 00:05:00 Conclusions Conclusions 00:03:00 BONUS - The Clickbank Easy Formula 00:10:00

If you aim to enhance your Advanced C++ Programming skills, our comprehensive Advanced C++ Programming course is perfect for you. Designed for success, this Advanced C++ Programming course covers everything from basics to advanced topics in Advanced C++ Programming. Each lesson in this Advanced C++ Programming course is crafted for easy understanding, enabling you to become proficient in Advanced C++ Programming. Whether you are a beginner or looking to sharpen your existing skills, this Advanced C++ Programming is the ideal choice. With our Advanced C++ Programming exclusive bundle, you will get a PDF Certificate, PDF Transcript and Digital Student ID Card (worth £50) Absolutely FREE. Courses are Included in This Advanced C++ Programming Bundle: Course 01: C++ Programming for Absolute Beginners Course 02: C++ Development: The Complete Coding Guide Course 03: Game Development using Cocos2d-x v3 C++ Course 04: Tic-Tac-Toe Clone - The Complete SFML C++ Game Course Course 05: Flappy Bird Clone: SFML C++ Game Course 06: Modern OpenGL 3D Game Why Choose Our Advanced C++ Programming Course? FREE Advanced C++ Programming certificate accredited Get a free student ID card with Advanced C++ Programming Training Get instant access to this Advanced C++ Programming course. Learn Advanced C++ Programming from anywhere in the world The Advanced C++ Programming is affordable and simple to understand The Advanced C++ Programming is an entirely online, interactive lesson with voiceover audio Lifetime access to the Advanced C++ Programming course materials The Advanced C++ Programming comes with 24/7 tutor support So enrol now in this Advanced C++ Programming Today to advance your career! Start your learning journey straightaway! This Advanced C++ Programming's curriculum has been designed by Advanced C++ Programming experts with years of Advanced C++ Programming experience behind them. The Advanced C++ Programming course is extremely dynamic and well-paced to help you understand Advanced C++ Programming with ease. You'll discover how to master the Advanced C++ Programming skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Advanced C++ Programming bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Advanced C++ Programming bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Advanced C++ Programming bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Description There are infinite ways to earn real money through online, and Affiliate Marketing is one of them. If you are interested in reviewing products as an Affiliate Marketer and earn a profit by sharing your opinion, then you've come to the right place. In this Affiliate Marketing Level 2 Course, you'll learn how to set up a 'home base' with WordPress including how to find profitable products to promote as an affiliate. Discovers techniques on how to properly review products and create 'pre-sale' videos to get your audience excited about a new product. Also, explore how to use an email list to promote others products. You'll also go through real-life examples of how to make consistent affiliate commissions with ease.  What Will I Learn? Setup a 'home base' with WordPress Learn how to find profitable products to promote as an affiliate How to properly review products as an affiliate How to create 'pre-sale' videos to get your audience excited about a new product Use an email list to promote others products Requirements Webcam (optional but preferred) for recording Screen capture software (free or paid) A 'Home base' such as a WordPress blog Who is the target audience? Those who are interested in promoting products by reviewing them Those who are interested in an income stream that is both profitable and stable for many years to come If you are not someone who enjoys reviewing products this may not be for you Introduction To The Course Introduction FREE 00:11:00 Your Home Base Home Base 00:05:00 Start Now 00:06:00 Know Numbers 00:05:00 Audience Relationships 00:06:00 Authority by Association 00:05:00 Value, Value, Value 00:05:00 Networking 00:05:00 Build your list 00:07:00 Create Products 00:06:00 Where the heck is the money 00:05:00 The Secret to Scaling 00:04:00 How the heck do I get started? 00:06:00 Step Two Introduction FREE 00:05:00 Find a high converting product on Munch Eye 00:02:00 Contact the product creator and get the Sales Page and product access 00:04:00 Go through the product and make a quick presell video prior to launch 00:05:00 Make a 5-10 minute review video showing the sales page and product 00:03:00 Show the review to the product creator and ask if you can add a bonus 00:05:00 Send the presell video to your list the night before 00:01:00 Send your review video to your list when the product launches 00:04:00 Repeat 00:04:00 Taking it to the next level 00:04:00

Beats - the headphone company - spends 90% of their budget in marketing, as they have identified that this is one of the most crucial parts of selling a product. This is absolutely true, as you can see that Apple phones keep outselling Samsung all the time even though they are the same and Samsung products are cheaper. This strategy about marketing could now be applied by you too through this Affiliate Marketing Diploma course. Affiliate marketing is essentially marketing and selling for other people and getting a percentage of that sale in return. Through this course you will learn how affiliate marketing works. This is not however going to be a guideline to cheat visitors, search engines or do anything unethical. In this course you will learn how to get started with affiliate marketing and how to structure your websites in order to generate large amounts of traffic. You have to remember this is not a get rich quick scheme; you have to keep working on your credibility and on your affiliate sites. If you get this course you will be able to learn about generating revenues using affiliate marketing in the right way. Course Highlights Affiliate Marketing Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Affiliate Marketing Diploma into 15 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 8 hours, 15 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Affiliate Marketing Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Affiliate Marketing Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Affiliate Marketing Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Affiliate Marketing Diploma Introduction FREE 00:15:00 Affiliate - Blueprint FREE 00:30:00 Website Layout FREE 00:30:00 The Absolute Simplest And Easiest Way To Get Started! 01:00:00 How exactly do you pick a topic? 00:45:00 How to Find Good Content And Fill Up Your Website 00:30:00 Search Engine Optimization is a must - each step of the way 00:30:00 Make Your Sites Easy To Edit And Link To Other Sites You Own 01:00:00 Make As Many Sites As You Like With Out Spending More Money 00:15:00 Pumping Your Websites Full Of Traffic 01:00:00 Using forums to really get the traffic flowing 00:30:00 Using articles to generate traffic 00:30:00 Great places to get FREE keyword rich links 00:15:00 Sticking It All Together And Getting Everything To Work 00:15:00 How To Save Some Time 00:30:00

Description: When it comes to going into business online, one of the easiest and most lucrative methods is through Affiliate Marketing. This is because becoming an affiliate marketer requires no experience, no website and simple promotional techniques that will convert prospective buyers into customers. This course will teach you all the important strategies, ways and methods of affiliate marketing. So if you are someone who wants to take advantage of modern technology internet but does not have any items to sell, you can still earn in advertisements through affiliate marketing. This type of marketing is centred around each progression you take to make your blog or sites more profitable and the initial steps you ought to be taking is to quit working for another person and attempt to build up your own particular business.  Who is the course for? Employees of the business industry and other businessmen who want to learn how to communicate effectively with their current and potential clients through affiliate marketing People who have an interest in marketing through email and how to effectively communicate on the internet. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in Affiliate Marketing Course will be very beneficial and helpful, especially to the following careers: Bloggers Marketing and Promotions Specialists Marketing Managers Sales Managers Sales and Promotions Specialists Top Executives And Much More! Advanced Diploma in Affiliate Marketing Introduction 00:30:00 Section I - What Is An Affiliate Marketing? Basics of Affiliate Marketing 00:30:00 Affiliate Marketing 101 - The Basics 00:15:00 Researching Your Products 01:00:00 Section II - Newbie to Profitable Affiliate Build Up To About 10 Products To Promote 01:00:00 Getting Traffic To Your Site 01:00:00 Section III: Step-by-Step Checklist To Affiliate Success Step-by-Step Checklist To Affiliate Success 01:00:00 Sign Up For Web 2.0 Social Networking 00:30:00 Consider Setting Up Your Own Website 01:00:00 Mock Exam Mock Exam - Advanced Diploma in Affiliate Marketing 00:20:00 Final Exam Final Exam - Advanced Diploma in Affiliate Marketing 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00