SQL Bootcamp - MYSQL for Beginner to Advanced
- Description
- Curriculum
- FAQ
- Reviews
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.
Prerequisites: None. Basic computer skills and a willingness to learn are sufficient.
-
12
Introduction to our Project -
13
INT (Integer) - Numerical data type
-
14
BIGINT (Big Integer) - Numerical data type
-
15
TINYINT (Tiny Integer) Data type and when to use it
-
16
DECIMALS - Numerical data type
-
17
FLOAT and DOUBLE - Numerical data type
-
18
BIT and BOOLEAN - Numerical data type
-
19
CHAR - String data type
-
20
VARCHAR - String data type
-
21
TEXT - String data type
-
22
ENUM - String data type
-
23
DATE and TIME - Date and Time data type
-
24
DATETIME - Date and Time data type
-
25
TIMESTAMP - Date and Time data type
-
26
YEAR - Date and Time data type
-
27
BLOB - Other data types
-
28
JSON - Other data types
-
29
Why we need Database Schema
-
30
Levels of Schema
-
31
Introduction to Star Schema
-
32
Installing MYSQL Server and Workbench on Mac
-
33
Creating our First Database
-
34
Code for Creating Database and Time Fact Table -
35
Introduction to SnowFlake Schema
-
36
Creating our Database in Snowflake Schema
-
37
Code for creating database in Snowflake Schema
-
44
Creating our Database
-
45
Creating our first table
-
46
Code for Creating Database and Creating Table
-
47
Inserting Data to our Table
-
48
Code for Inserting data to our Table
-
49
Reading Data from our Table
-
50
Updating our Table
-
51
Code for Altering the table and Updating info
-
52
Deleting data from our table
-
53
Importing Data and Schema to MYSQL Workbench
-
54
Download Data Dump file
-
55
Selecting ALL the fields or columns
-
56
Selecting a column -
57
Selecting Specific columns from our Table
-
58
Selecting 3 different columns
-
59
Selecting only the Unique or Distinct values of filed from our table
-
60
Retrieving distinct values from a column
-
61
Selecting Distinct of Multiple Columns
-
62
Selecting data with WHERE clause and Equals to operator
-
63
Limitations of WHERE and its Operators
-
64
Filtering entire table with WHERE and =
-
65
Filtering data with WHERE and LESSER THAN and EQUALS
-
66
Using LESSER THAN along with WHERE
-
67
Using LESSER THAN and EQUALS along with WHERE
-
68
Filtering data with WHERE and GREATER THAN and EQUALS
-
69
Using GREATER THAN along with WHERE
-
70
Using GREATER THAN and EQUALS along with WHERE
-
71
Using WHERE with AND
-
72
Using WHERE & AND : Example 1
-
73
Using WHERE with AND : Example 2
-
74
Using WHERE with OR
-
75
Using WHERE with OR
-
76
Using WHERE with IN
-
77
Using WHERE with IN
-
78
Understanding MYSQL WildCards
-
79
Using WHERE and LIKE
-
80
Using WHERE and LIKE : Example 1
-
81
Using WHERE and LIKE : Example 2
