English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 113 lectures (7h 9m) | 4.53 GB
A-Z in SQL and MYSQL in Animation for database design, analytics and business intelligence – Beginner to advanced
Are you ready to dive into the world of databases and master the art of querying with MySQL? This beginner-friendly course is designed to provide you with a solid foundation in MySQL while progressively taking you through advanced concepts. Whether you’re a complete novice or have some prior experience, this course will equip you with the skills to confidently interact with databases.
Highlights:
- Beginner-Friendly: No prior database experience required! This course starts from the ground up, ensuring learners of all backgrounds can grasp the concepts easily.
- Interactive Practice: Reinforce your learning with a plethora of practice questions. Gain hands-on experience by writing real-world queries and solving challenges that mirror real-life scenarios.
- Easy Project-Based Approach: Learning by doing is the core of this course. Engage in practical projects that simulate real-world database applications. From designing schemas to querying data, these projects will solidify your understanding.
- Quick Bites of Knowledge: Time is valuable. That’s why we’ve crafted short, bite-sized videos that deliver concise explanations and demonstrations. Each video is 1 to 2 minutes long, making learning convenient and efficient.
- Comprehensive Coverage: Starting with the basics of SQL and data manipulation, this course gradually delves into more complex concepts. Topics covered include filtering data, sorting results, aggregate functions, subqueries, and much more. The course culminates in advanced topics like various types of joins and the power of using the UNION operator.
By the end of this course, you will have:
- Developed a strong foundation in SQL and MySQL.
- Acquired the ability to design and create efficient databases.
- Mastered the art of constructing queries to extract, modify, and analyze data.
- Applied your knowledge to real-world projects that showcase your skills.
Whether you’re looking to enhance your professional capabilities or simply exploring the world of databases, this course is your gateway to becoming a proficient MySQL user. Enroll now and embark on a journey towards database mastery.
What you’ll learn
- Ideal for individuals interested in roles such as SQL developers, Database administrators, Business Analysts, and Business Intelligence professionals.
- Caters to beginners in Programming
- Data Analytics Enthusiasts
- Anyone who likes to update your tech stack with MYSQL
Table of Contents
Introduction
1 Introduction to SQL
2 Understanding the SQL Language
3 Writing our First SQL Query
4 Instructions on Coding Exercise
Building a strong SQL foundation
5 Important Notes to New Students
6 Introduction to Database
7 Types of Database
8 SQL vs MYSQL – Understanding RDBMS
9 Difference between a Database and Spreadsheets
10 What is a Relational Database
Data Types in MYSQL
11 Introduction to our Project
12 INT (Integer) – Numerical data type
13 BIGINT (Big Integer) – Numerical data type
14 TINYINT (Tiny Integer) Data type and when to use it
15 DECIMALS – Numerical data type
16 FLOAT and DOUBLE – Numerical data type
17 BIT and BOOLEAN – Numerical data type
18 CHAR – String data type
19 VARCHAR – String data type
20 TEXT – String data type
21 ENUM – String data type
22 DATE and TIME – Date and Time data type
23 DATETIME – Date and Time data type
24 TIMESTAMP – Date and Time data type
25 YEAR – Date and Time data type
26 BLOB – Other data types
27 JSON – Other data types
Database Schema
28 Why we need Database Schema
29 Levels of Schema
30 Introduction to Star Schema
31 Installing MYSQL Server and Workbench on Mac
32 Creating our First Database
33 Code for Creating Database and Time Fact Table
34 Introduction to SnowFlake Schema
35 Creating our Database in Snowflake Schema
36 Code for creating database in Snowflake Schema
KEYS
37 Understanding Primary Key
38 Understanding Foreign Key
39 Understanding Unique Key, Composite Key and Candidate Key
Relationships
40 One to One Relationship
41 One to Many relationship
42 Many to Many Relationship
CRUD Operations
43 Creating our Database
44 Creating our first table
45 Code for Creating Database and Creating Table
46 Inserting Data to our Table
47 Code for Inserting data to our Table
48 Reading Data from our Table
49 Updating our Table
50 Code for Altering the table and Updating info
51 Deleting data from our table
Analyzing Data – Single Table Analysis
52 Importing Data to our MYSQL workbench
53 Importing Data and Schema to MYSQL Workbench
54 Download Data Dump file
55 Selecting ALL the fields or columns
56 Selecting Specific columns from our Table
57 Selecting only the Unique or Distinct values of filed from our table
58 Selecting data with WHERE clause and Equals to operator
59 Limitations of WHERE and its Operators
60 Filtering data with WHERE and LESSER THAN and EQUALS
61 Filtering data with WHERE and GREATER THAN and EQUALS
62 Using WHERE with AND
63 Using WHERE with OR
64 Using WHERE with IN
65 Understanding MYSQL WildCards
66 Using WHERE and LIKE
Analyzing Data with Aggregations
67 Section Introduction
68 Using SUM on a Single field
69 Performing SUM aggregation along with WHERE
70 Understanding Alias
71 Applying COUNT aggregation
72 Counting values in complex situations
73 Averaging the values with AVG
74 MAX and MIN
Level 1 Assignment
75 What to accomplish in this Assignment
76 Assignment Solution
GROUP BY, ORDER BY and HAVING
77 Understanding GROUP BY
78 Applying GROUP BY on multiple business situations
79 Understanding ORDER BY
80 Introduction to HAVING and practicing
JOINS
81 Why we need JOINS and Type of Joins
82 Understanding the Databases for Joins
83 CROSS JOIN
84 Understanding LEFT JOIN as a concept
85 Practicing LEFT JOIN in a simple situation
86 Answer Code for LEFT Join practice
87 LEFT JOIN Example 2
88 LEFT JOIN Example 3
89 LEFT JOIN Example 4
90 Understanding RIGHT JOIN and some examples
91 Practicing RIGHT join on MYSQL – Joining and aggregations
92 Practicing RIGHT join on MYSQL – Joining Multiple tables and aggregation
93 Understanding INNER JOIN and some examples
94 Practicing INNER JOIN on MYSQL – RIGHT JOIN vs INNER JOIN difference
95 Understanding UNION
96 Understanding UNION ALL
Advanced SELECT Functions
97 SELECT with BETWEEN and AND
98 SELECT with NOT BETWEEN and AND
99 SELECT with BETWEEN, NOT BETWEEN on DATE values
100 SELECT using NULL and NOT NULL
101 Understanding IS NULL
102 Understanding LIMIT
103 SELECT using HAVING
104 HAVING vs WHERE
Advanced SQL Topics
105 Understanding CASE Statement
106 Practicing CASE statement – Simple CASE
107 Practicing CASE with varying Operators
108 Practicing CASE with multiple CASE statements in a single Query
SQL Subqueries
109 Introduction to Subqueries
110 Understanding Scalar type of SubQueries
111 Applying Subqueries with WHERE clause
112 Writing SubQuery with WHERE Clause Example 2
113 Complex SubQuery with multiple table Joins and WHERE
Conclusion
114 Course Conclusion
Resolve the captcha to access the links!