The Complete SQL Bootcamp 2021: Go from Zero to Hero

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Learn how to use SQL quickly and effectively with this course!

You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!

In this course you will learn everything you need to become a SQL Pro! Including:

  • Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools

  • Learn he basics of SQL syntax

  • Analyzing data using aggregate functions with GROUP BY commands

  • Running advanced queries with string operations and comparison operations

  • Learn to use logical operators to add logic flow to your SQL queries

  • Learn common SQL JOIN commands

  • Learn to create tables and databases with constraints on data entries

  • Learn to use Python to further advanced your SQL skills

  • and much, much more!

This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.

I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

I'll see you inside the course!

Check out the free preview videos for more information!

Who this course is for:

  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!
  • Use SQL to perform data analysis Be comfortable putting SQL and PostgreSQL on their resume Learn to perform GROUP BY statements Replicate real-world situations and query reports Curated for the Udemy Business collection Requirements No prior technical experience is required! All you need a computer! Description Learn how to use SQL quickly and effectively with this course! You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more. Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding! In this course you will learn everything you need to become a SQL Pro! Including: Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools Learn he basics of SQL syntax Analyzing data using aggregate functions with GROUP BY commands Running advanced queries with string operations and comparison operations Learn to use logical operators to add logic flow to your SQL queries Learn common SQL JOIN commands Learn to create tables and databases with constraints on data entries Learn to use Python to further advanced your SQL skills and much, much more! This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations. I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional. SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today! I'll see you inside the course! Check out the free preview videos for more information! Who this course is for: Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis! Show more Show less Featured review Igor Ristovski 137 courses 30 reviews Rating: 5.0 out of 5 a year ago I took this course by recommendation from a you tube video, and I didn't regret it. By far this is the most digestible SQL course I took. The instructor talks in clear and understandable way with perfect pace and small bites for good understanding. I feel like I paid too little for this course and things I've learned. I recommend it with pleasure. Show more Show less Course content 12 sections • 83 lectures • 8h 51m total length Expand all sections Course Introduction 8 lectures • 1hr 7min Welcome Message 00:34 Introduction Preview 02:15 Course Curriculum Overview 01:41 Overview of Databases 07:37 Course FAQs 01:14 Windows Installation - PostGreSQL and PgAdmin with Database Setup Preview 21:09 MacOS Installation - PostgreSQL and PgAdmin with First Query 23:06 pgAdmin Overview 09:44 SQL Statement Fundamentals 18 lectures • 1hr 37min Overview of Challenges! Preview 01:36 SQL Cheat Sheet 00:18 SQL Statement Fundamentals 00:42 SELECT Statement 08:40 Challenge: SELECT 04:29 SELECT DISTINCT 05:38 Challenge: SELECT DISTINCT 01:54 COUNT 07:23 SELECT WHERE - Part One 04:30 SELECT WHERE - Part Two 07:04 Challenge: SELECT WHERE 05:35 ORDER BY Preview 08:11 LIMIT 05:06 Challenge: ORDER BY 05:01 BETWEEN 06:57 IN 04:55 LIKE and ILIKE 09:36 General Challenge 1 09:54 GROUP BY Statements 7 lectures • 41min Introduction to GROUP BY 00:57 Aggregation Functions 07:59 GROUP BY - Part One Preview 07:48 GROUP BY - Part Two Preview 10:42 GROUP BY - Challenge 04:05 HAVING 06:25 HAVING - Challenge Tasks 02:48 Assessment Test 1 3 lectures • 2min Overview of Assessment Test 1 01:08 Assessment Test 1 00:20 Solutions to Assessment Test 1 00:13 JOINS 9 lectures • 1hr 9min Overview of JOINS 00:16 Introduction to JOINs 01:14 AS Statement 07:48 Inner Joins Preview 14:49 Full Outer Joins 14:22 Left Outer Join 11:18 Right Joins 04:21 UNION 02:26 JOIN Challenge Tasks 12:15 Advanced SQL Commands 9 lectures • 1hr 2min Overview of Advanced SQL Commands 00:47 Timestamps and Extract - Part One 07:38 Timestamps and Extract - Part Two 10:06 Quick Note on TO_CHAR 00:15 Timestamps and Extract - Challenge Tasks 03:38 Mathematical Functions and Operators 05:00 String Functions and Operators 08:24 SubQuery 15:11 Self-Join 10:55 Assessment Test 2 4 lectures • 33min READ ME FIRST PLEASE 01:20 Setting up New Database for Assessment Exercises 07:26 Assessment Test 2 00:15 Solutions to Assessment Test 2 23:45 Creating Databases and Tables 11 lectures • 1hr 18min Introduction to Section 01:12 Data Types 06:27 Primary Keys and Foreign Keys 09:04 Constraints 05:17 CREATE Table 18:28 INSERT 09:05 UPDATE 07:58 DELETE 03:12 ALTER Table 06:47 DROP Table 03:18 CHECK Constraint 07:04 Assessment Test 3 2 lectures • 1min Assessment Test 3 00:53 Solutions to Assessment Test 3 00:26 Conditional Expressions and Procedures 8 lectures • 1hr 10min Conditional Expressions and Procedures Introduction 00:43 CASE 22:39 CASE - Challenge Task 03:08 COALESCE 05:35 CAST 07:07 NULLIF 10:34 Views 07:07 Import and Export 13:30 2 more sections Instructor Jose Portilla Head of Data Science, Pierian Data Inc. 4.6 Instructor Rating 779,165 Reviews 2,400,948 Students 33 Courses Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University and years of experience as a professional instructor and trainer for Data Science and programming. He has publications and patents in various fields such as microfluidics, materials science, and data science technologies. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data science to help other people learn the power of programming the ability to analyze data, as well as present the data in clear and beautiful visualizations. Currently he works as the Head of Data Science for Pierian Data Inc. and provides in-person data science and python programming training courses to employees working at top companies, including General Electric, Cigna, The New York Times, Credit Suisse, McKinsey and many more. Feel free to contact him on LinkedIn for more information on in-person training sessions or group training sessions in Las Vegas, NV. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6772e357ce620662',m:'83e5bbe7c8bf01cfeb437b33f3609e0dbd60cb73-1627693209-1800-AS1bpD7kFJjXX/0ijbMqLnh3E4ctaqnE8KP1Z2U+ujn4xSZTXYVlJk7dQBDQybOgh4GtFdYnwrZtkNJ4Nhp4QeWkRX372LLTmjOGjfzXcGwqvCcpLLlpGRvOOmEpjQ2U3jCm2M1ai9hmGYIssWHozn8+rsN4t3NylephsO51PFu/',s:[0x2c612a315b,0x47e26628a1],}})();
  • Be comfortable putting SQL and PostgreSQL on their resume Learn to perform GROUP BY statements Replicate real-world situations and query reports Curated for the Udemy Business collection Requirements No prior technical experience is required! All you need a computer! Description Learn how to use SQL quickly and effectively with this course! You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more. Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding! In this course you will learn everything you need to become a SQL Pro! Including: Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools Learn he basics of SQL syntax Analyzing data using aggregate functions with GROUP BY commands Running advanced queries with string operations and comparison operations Learn to use logical operators to add logic flow to your SQL queries Learn common SQL JOIN commands Learn to create tables and databases with constraints on data entries Learn to use Python to further advanced your SQL skills and much, much more! This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations. I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional. SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today! I'll see you inside the course! Check out the free preview videos for more information! Who this course is for: Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis! Show more Show less Featured review Igor Ristovski 137 courses 30 reviews Rating: 5.0 out of 5 a year ago I took this course by recommendation from a you tube video, and I didn't regret it. By far this is the most digestible SQL course I took. The instructor talks in clear and understandable way with perfect pace and small bites for good understanding. I feel like I paid too little for this course and things I've learned. I recommend it with pleasure. Show more Show less Course content 12 sections • 83 lectures • 8h 51m total length Expand all sections Course Introduction 8 lectures • 1hr 7min Welcome Message 00:34 Introduction Preview 02:15 Course Curriculum Overview 01:41 Overview of Databases 07:37 Course FAQs 01:14 Windows Installation - PostGreSQL and PgAdmin with Database Setup Preview 21:09 MacOS Installation - PostgreSQL and PgAdmin with First Query 23:06 pgAdmin Overview 09:44 SQL Statement Fundamentals 18 lectures • 1hr 37min Overview of Challenges! Preview 01:36 SQL Cheat Sheet 00:18 SQL Statement Fundamentals 00:42 SELECT Statement 08:40 Challenge: SELECT 04:29 SELECT DISTINCT 05:38 Challenge: SELECT DISTINCT 01:54 COUNT 07:23 SELECT WHERE - Part One 04:30 SELECT WHERE - Part Two 07:04 Challenge: SELECT WHERE 05:35 ORDER BY Preview 08:11 LIMIT 05:06 Challenge: ORDER BY 05:01 BETWEEN 06:57 IN 04:55 LIKE and ILIKE 09:36 General Challenge 1 09:54 GROUP BY Statements 7 lectures • 41min Introduction to GROUP BY 00:57 Aggregation Functions 07:59 GROUP BY - Part One Preview 07:48 GROUP BY - Part Two Preview 10:42 GROUP BY - Challenge 04:05 HAVING 06:25 HAVING - Challenge Tasks 02:48 Assessment Test 1 3 lectures • 2min Overview of Assessment Test 1 01:08 Assessment Test 1 00:20 Solutions to Assessment Test 1 00:13 JOINS 9 lectures • 1hr 9min Overview of JOINS 00:16 Introduction to JOINs 01:14 AS Statement 07:48 Inner Joins Preview 14:49 Full Outer Joins 14:22 Left Outer Join 11:18 Right Joins 04:21 UNION 02:26 JOIN Challenge Tasks 12:15 Advanced SQL Commands 9 lectures • 1hr 2min Overview of Advanced SQL Commands 00:47 Timestamps and Extract - Part One 07:38 Timestamps and Extract - Part Two 10:06 Quick Note on TO_CHAR 00:15 Timestamps and Extract - Challenge Tasks 03:38 Mathematical Functions and Operators 05:00 String Functions and Operators 08:24 SubQuery 15:11 Self-Join 10:55 Assessment Test 2 4 lectures • 33min READ ME FIRST PLEASE 01:20 Setting up New Database for Assessment Exercises 07:26 Assessment Test 2 00:15 Solutions to Assessment Test 2 23:45 Creating Databases and Tables 11 lectures • 1hr 18min Introduction to Section 01:12 Data Types 06:27 Primary Keys and Foreign Keys 09:04 Constraints 05:17 CREATE Table 18:28 INSERT 09:05 UPDATE 07:58 DELETE 03:12 ALTER Table 06:47 DROP Table 03:18 CHECK Constraint 07:04 Assessment Test 3 2 lectures • 1min Assessment Test 3 00:53 Solutions to Assessment Test 3 00:26 Conditional Expressions and Procedures 8 lectures • 1hr 10min Conditional Expressions and Procedures Introduction 00:43 CASE 22:39 CASE - Challenge Task 03:08 COALESCE 05:35 CAST 07:07 NULLIF 10:34 Views 07:07 Import and Export 13:30 2 more sections Instructor Jose Portilla Head of Data Science, Pierian Data Inc. 4.6 Instructor Rating 779,165 Reviews 2,400,948 Students 33 Courses Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University and years of experience as a professional instructor and trainer for Data Science and programming. He has publications and patents in various fields such as microfluidics, materials science, and data science technologies. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data science to help other people learn the power of programming the ability to analyze data, as well as present the data in clear and beautiful visualizations. Currently he works as the Head of Data Science for Pierian Data Inc. and provides in-person data science and python programming training courses to employees working at top companies, including General Electric, Cigna, The New York Times, Credit Suisse, McKinsey and many more. Feel free to contact him on LinkedIn for more information on in-person training sessions or group training sessions in Las Vegas, NV. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6772e357ce620662',m:'83e5bbe7c8bf01cfeb437b33f3609e0dbd60cb73-1627693209-1800-AS1bpD7kFJjXX/0ijbMqLnh3E4ctaqnE8KP1Z2U+ujn4xSZTXYVlJk7dQBDQybOgh4GtFdYnwrZtkNJ4Nhp4QeWkRX372LLTmjOGjfzXcGwqvCcpLLlpGRvOOmEpjQ2U3jCm2M1ai9hmGYIssWHozn8+rsN4t3NylephsO51PFu/',s:[0x2c612a315b,0x47e26628a1],}})();
  • Learn to perform GROUP BY statements Replicate real-world situations and query reports Curated for the Udemy Business collection Requirements No prior technical experience is required! All you need a computer! Description Learn how to use SQL quickly and effectively with this course! You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more. Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding! In this course you will learn everything you need to become a SQL Pro! Including: Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools Learn he basics of SQL syntax Analyzing data using aggregate functions with GROUP BY commands Running advanced queries with string operations and comparison operations Learn to use logical operators to add logic flow to your SQL queries Learn common SQL JOIN commands Learn to create tables and databases with constraints on data entries Learn to use Python to further advanced your SQL skills and much, much more! This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations. I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional. SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today! I'll see you inside the course! Check out the free preview videos for more information! Who this course is for: Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis! Show more Show less Featured review Igor Ristovski 137 courses 30 reviews Rating: 5.0 out of 5 a year ago I took this course by recommendation from a you tube video, and I didn't regret it. By far this is the most digestible SQL course I took. The instructor talks in clear and understandable way with perfect pace and small bites for good understanding. I feel like I paid too little for this course and things I've learned. I recommend it with pleasure. Show more Show less Course content 12 sections • 83 lectures • 8h 51m total length Expand all sections Course Introduction 8 lectures • 1hr 7min Welcome Message 00:34 Introduction Preview 02:15 Course Curriculum Overview 01:41 Overview of Databases 07:37 Course FAQs 01:14 Windows Installation - PostGreSQL and PgAdmin with Database Setup Preview 21:09 MacOS Installation - PostgreSQL and PgAdmin with First Query 23:06 pgAdmin Overview 09:44 SQL Statement Fundamentals 18 lectures • 1hr 37min Overview of Challenges! Preview 01:36 SQL Cheat Sheet 00:18 SQL Statement Fundamentals 00:42 SELECT Statement 08:40 Challenge: SELECT 04:29 SELECT DISTINCT 05:38 Challenge: SELECT DISTINCT 01:54 COUNT 07:23 SELECT WHERE - Part One 04:30 SELECT WHERE - Part Two 07:04 Challenge: SELECT WHERE 05:35 ORDER BY Preview 08:11 LIMIT 05:06 Challenge: ORDER BY 05:01 BETWEEN 06:57 IN 04:55 LIKE and ILIKE 09:36 General Challenge 1 09:54 GROUP BY Statements 7 lectures • 41min Introduction to GROUP BY 00:57 Aggregation Functions 07:59 GROUP BY - Part One Preview 07:48 GROUP BY - Part Two Preview 10:42 GROUP BY - Challenge 04:05 HAVING 06:25 HAVING - Challenge Tasks 02:48 Assessment Test 1 3 lectures • 2min Overview of Assessment Test 1 01:08 Assessment Test 1 00:20 Solutions to Assessment Test 1 00:13 JOINS 9 lectures • 1hr 9min Overview of JOINS 00:16 Introduction to JOINs 01:14 AS Statement 07:48 Inner Joins Preview 14:49 Full Outer Joins 14:22 Left Outer Join 11:18 Right Joins 04:21 UNION 02:26 JOIN Challenge Tasks 12:15 Advanced SQL Commands 9 lectures • 1hr 2min Overview of Advanced SQL Commands 00:47 Timestamps and Extract - Part One 07:38 Timestamps and Extract - Part Two 10:06 Quick Note on TO_CHAR 00:15 Timestamps and Extract - Challenge Tasks 03:38 Mathematical Functions and Operators 05:00 String Functions and Operators 08:24 SubQuery 15:11 Self-Join 10:55 Assessment Test 2 4 lectures • 33min READ ME FIRST PLEASE 01:20 Setting up New Database for Assessment Exercises 07:26 Assessment Test 2 00:15 Solutions to Assessment Test 2 23:45 Creating Databases and Tables 11 lectures • 1hr 18min Introduction to Section 01:12 Data Types 06:27 Primary Keys and Foreign Keys 09:04 Constraints 05:17 CREATE Table 18:28 INSERT 09:05 UPDATE 07:58 DELETE 03:12 ALTER Table 06:47 DROP Table 03:18 CHECK Constraint 07:04 Assessment Test 3 2 lectures • 1min Assessment Test 3 00:53 Solutions to Assessment Test 3 00:26 Conditional Expressions and Procedures 8 lectures • 1hr 10min Conditional Expressions and Procedures Introduction 00:43 CASE 22:39 CASE - Challenge Task 03:08 COALESCE 05:35 CAST 07:07 NULLIF 10:34 Views 07:07 Import and Export 13:30 2 more sections Instructor Jose Portilla Head of Data Science, Pierian Data Inc. 4.6 Instructor Rating 779,165 Reviews 2,400,948 Students 33 Courses Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University and years of experience as a professional instructor and trainer for Data Science and programming. He has publications and patents in various fields such as microfluidics, materials science, and data science technologies. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data science to help other people learn the power of programming the ability to analyze data, as well as present the data in clear and beautiful visualizations. Currently he works as the Head of Data Science for Pierian Data Inc. and provides in-person data science and python programming training courses to employees working at top companies, including General Electric, Cigna, The New York Times, Credit Suisse, McKinsey and many more. Feel free to contact him on LinkedIn for more information on in-person training sessions or group training sessions in Las Vegas, NV. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6772e357ce620662',m:'83e5bbe7c8bf01cfeb437b33f3609e0dbd60cb73-1627693209-1800-AS1bpD7kFJjXX/0ijbMqLnh3E4ctaqnE8KP1Z2U+ujn4xSZTXYVlJk7dQBDQybOgh4GtFdYnwrZtkNJ4Nhp4QeWkRX372LLTmjOGjfzXcGwqvCcpLLlpGRvOOmEpjQ2U3jCm2M1ai9hmGYIssWHozn8+rsN4t3NylephsO51PFu/',s:[0x2c612a315b,0x47e26628a1],}})();
  • Replicate real-world situations and query reports Curated for the Udemy Business collection Requirements No prior technical experience is required! All you need a computer! Description Learn how to use SQL quickly and effectively with this course! You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more. Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding! In this course you will learn everything you need to become a SQL Pro! Including: Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools Learn he basics of SQL syntax Analyzing data using aggregate functions with GROUP BY commands Running advanced queries with string operations and comparison operations Learn to use logical operators to add logic flow to your SQL queries Learn common SQL JOIN commands Learn to create tables and databases with constraints on data entries Learn to use Python to further advanced your SQL skills and much, much more! This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations. I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional. SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today! I'll see you inside the course! Check out the free preview videos for more information! Who this course is for: Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis! Show more Show less Featured review Igor Ristovski 137 courses 30 reviews Rating: 5.0 out of 5 a year ago I took this course by recommendation from a you tube video, and I didn't regret it. By far this is the most digestible SQL course I took. The instructor talks in clear and understandable way with perfect pace and small bites for good understanding. I feel like I paid too little for this course and things I've learned. I recommend it with pleasure. Show more Show less Course content 12 sections • 83 lectures • 8h 51m total length Expand all sections Course Introduction 8 lectures • 1hr 7min Welcome Message 00:34 Introduction Preview 02:15 Course Curriculum Overview 01:41 Overview of Databases 07:37 Course FAQs 01:14 Windows Installation - PostGreSQL and PgAdmin with Database Setup Preview 21:09 MacOS Installation - PostgreSQL and PgAdmin with First Query 23:06 pgAdmin Overview 09:44 SQL Statement Fundamentals 18 lectures • 1hr 37min Overview of Challenges! Preview 01:36 SQL Cheat Sheet 00:18 SQL Statement Fundamentals 00:42 SELECT Statement 08:40 Challenge: SELECT 04:29 SELECT DISTINCT 05:38 Challenge: SELECT DISTINCT 01:54 COUNT 07:23 SELECT WHERE - Part One 04:30 SELECT WHERE - Part Two 07:04 Challenge: SELECT WHERE 05:35 ORDER BY Preview 08:11 LIMIT 05:06 Challenge: ORDER BY 05:01 BETWEEN 06:57 IN 04:55 LIKE and ILIKE 09:36 General Challenge 1 09:54 GROUP BY Statements 7 lectures • 41min Introduction to GROUP BY 00:57 Aggregation Functions 07:59 GROUP BY - Part One Preview 07:48 GROUP BY - Part Two Preview 10:42 GROUP BY - Challenge 04:05 HAVING 06:25 HAVING - Challenge Tasks 02:48 Assessment Test 1 3 lectures • 2min Overview of Assessment Test 1 01:08 Assessment Test 1 00:20 Solutions to Assessment Test 1 00:13 JOINS 9 lectures • 1hr 9min Overview of JOINS 00:16 Introduction to JOINs 01:14 AS Statement 07:48 Inner Joins Preview 14:49 Full Outer Joins 14:22 Left Outer Join 11:18 Right Joins 04:21 UNION 02:26 JOIN Challenge Tasks 12:15 Advanced SQL Commands 9 lectures • 1hr 2min Overview of Advanced SQL Commands 00:47 Timestamps and Extract - Part One 07:38 Timestamps and Extract - Part Two 10:06 Quick Note on TO_CHAR 00:15 Timestamps and Extract - Challenge Tasks 03:38 Mathematical Functions and Operators 05:00 String Functions and Operators 08:24 SubQuery 15:11 Self-Join 10:55 Assessment Test 2 4 lectures • 33min READ ME FIRST PLEASE 01:20 Setting up New Database for Assessment Exercises 07:26 Assessment Test 2 00:15 Solutions to Assessment Test 2 23:45 Creating Databases and Tables 11 lectures • 1hr 18min Introduction to Section 01:12 Data Types 06:27 Primary Keys and Foreign Keys 09:04 Constraints 05:17 CREATE Table 18:28 INSERT 09:05 UPDATE 07:58 DELETE 03:12 ALTER Table 06:47 DROP Table 03:18 CHECK Constraint 07:04 Assessment Test 3 2 lectures • 1min Assessment Test 3 00:53 Solutions to Assessment Test 3 00:26 Conditional Expressions and Procedures 8 lectures • 1hr 10min Conditional Expressions and Procedures Introduction 00:43 CASE 22:39 CASE - Challenge Task 03:08 COALESCE 05:35 CAST 07:07 NULLIF 10:34 Views 07:07 Import and Export 13:30 2 more sections Instructor Jose Portilla Head of Data Science, Pierian Data Inc. 4.6 Instructor Rating 779,165 Reviews 2,400,948 Students 33 Courses Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University and years of experience as a professional instructor and trainer for Data Science and programming. He has publications and patents in various fields such as microfluidics, materials science, and data science technologies. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data science to help other people learn the power of programming the ability to analyze data, as well as present the data in clear and beautiful visualizations. Currently he works as the Head of Data Science for Pierian Data Inc. and provides in-person data science and python programming training courses to employees working at top companies, including General Electric, Cigna, The New York Times, Credit Suisse, McKinsey and many more. Feel free to contact him on LinkedIn for more information on in-person training sessions or group training sessions in Las Vegas, NV. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6772e357ce620662',m:'83e5bbe7c8bf01cfeb437b33f3609e0dbd60cb73-1627693209-1800-AS1bpD7kFJjXX/0ijbMqLnh3E4ctaqnE8KP1Z2U+ujn4xSZTXYVlJk7dQBDQybOgh4GtFdYnwrZtkNJ4Nhp4QeWkRX372LLTmjOGjfzXcGwqvCcpLLlpGRvOOmEpjQ2U3jCm2M1ai9hmGYIssWHozn8+rsN4t3NylephsO51PFu/',s:[0x2c612a315b,0x47e26628a1],}})();