Want to know more about our Complete SQL Course? Click the link below to secure your spot in the next class: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- Download File Link: https://pages.hashtagtreinamentos.com... ► Installing MySQL and Creating the First Queries • Installing MySQL and Creating the First... -------------------------------------------------------------------- TO DOWNLOAD THE FREE SQL MINICOURSE: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- In this course, I will teach you everything you need to know to start working with SQL. This will be a true SQL Course for beginners. You will learn what SQL is, understand its importance, learn about the different types of SQL programs, and get an overview of the language. I will explain why it is important to learn SQL and how you can apply it in practice. I will show you how to build your first SQL codes, starting with basic queries using commands such as SELECT, DISTINCT, LIMIT and ORDER BY. In addition, we will cover the use of filters with WHERE and operators such as AND, OR, IN and BETWEEN. We will also see how to perform data analysis in SQL, using aggregate functions such as COUNT, SUM, AVG, MIN and MAX, and how to group data with GROUP BY. We will cover fundamental concepts related to the relationship between tables in SQL, such as JOIN, Fact and Dimension Tables, Primary and Foreign Keys, SUBQUERY and VIEWS. Finally, we will end the course with the creation of databases in SQL, covering the main steps, data types and essential commands, including the application of rules, such as Constraints: NOT NULL, and the commands CREATE TABLE, INSERT INTO, UPDATE and DELETE. Now let's start this SQL course for beginners, so that you learn everything you need to know and can start working with SQL and databases effectively! ----------------------------------------------------------------------- Recommended Videos: ► Basic SQL Course: • SQL Fundamentals - SQL Course - A... ----------------------------------------------------------------------- Hashtag Programming ► Subscribe to our channel: http://bit.ly/3c0LJQi ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► Blog: https://bit.ly/2MRUZs0 ► YouTube: http://bit.ly/3c0LJQi ► Instagram: https://bit.ly/3o6dw42 ► Facebook: http://bit.ly/3qGtaF2 Here in the videos on the Hashtag Programming channel we teach several SQL tips so that you can develop in databases! ----------------------------------------------------------------------- Class Content 00:00 Introduction 01:15 Hashtag Black Friday 02:52 Class Presentation and Schedule 07:30 Daily and Personal Relationship with Data 14:36 ​​Professional Relationship with Data 18:40 Where Does Data Go? 20:15 What are Databases? 22:33 Database Example 24:05 How to Access Data? 25:53 What is SQL? 28:15 How Does SQL Work? 31:07 Where to Use SQL 34:36 Which SQL to Learn? 45:15 Why Learn SQL? 52:11 Can I Use Excel? Power BI? Python? 53:39 Summary – Introduction and General Context of SQL 56:15 SQL Language in Practice 57:10 Introducing MySQL 59:34 How to Write Your First Codes in SQL 01:01:00 Schemas and Databases in MySQL 01:01:42 Tables and Data Types in SQL 01:02:44 SELECT in SQL - First Query 01:04:53 Dealing with Possible Errors 01:10:30 Creating New Queries and Analyzing Table Data 01:14:57 Selecting Specific Columns from a Table 01:21:10 DISTINCT in SQL 01:26:54 ORDER BY in SQL 01:38:00 Filters in SQL – WHERE 01:51:50 Filters with More than One Condition – AND and OR 01:59:50 IN and BETWEEN Operators 02:09:00 Like and Wildcard Operators in SQL 02:17:55 IS NULL and IS NOT NULL in SQL 02:21:21 Data Analysis in SQL 02:23:34 Calculations in SQL – COUNT 02:32:00 SUM Function in SQL 02:34:40 AVG, MIN and MAX Functions 02:39:20 GROUP BY – Groupings in SQL 02:54:00 Relationships between Tables 02:56:55 JOINS: Relationships in SQL 02:58:16 Primary Key and Foreign Key 03:01:45 Dimension Table and Fact Table 03:06:18 Types of JOINS in SQL 03:29:30 SUBQUERY in SQL 03:37:05 VIEWS in SQL 03:41:51 Creating Databases 03:45:45 Creating Tables in the Database 03:49:25 INSERT INTO – Inserting Data into the Table 03:54:44 Constraints 03:59:25 UPDATE – Updating Table Values ​​04:01:45 DELETE – Deleting Data from the Table 04:02:55 Conclusion #sql #hashtagprogramacao