SQL 101: A Beginner's Guide to Structured Query Language

Focused View

Anass Cherkaoui

2:24:17

90 View

1. Course Overview

1. Course Overview.mp4

01:19

2. Introduction to SQL (Structured Query Language)

1. Introduction.mp4

03:27

2. The Relational Model.mp4

05:19

3. MySQL Workbench installation.mp4

08:28

4. Summary.mp4

00:14

3. Understanding Basic SQL Syntax

1. Introduction to the Section.mp4

02:32

2. Basic SQL Commands - SELECT.mp4

00:44

3. Basic SQL Commands - INSERT.mp4

01:41

4. Basic SQL Commands - UPDATE.mp4

01:25

5. Basic SQL Commands - DELETE.mp4

01:17

6. Course Housekeeping.mp4

02:16

7. Summary.mp4

00:16

4. Querying Data with the SELECT Statement

1. Introduction to the Section.mp4

03:02

2. Demo - SELECT.mp4

01:11

3. The SELECT List.mp4

01:44

4. SELECT List Wildcard - - .mp4

01:20

5. The FROM Clause.mp4

03:39

6. Demo - FROM Clause.mp4

02:38

7. How to Constrain the Result Set.mp4

00:38

8. DISTINCT and NOT DISTINCT.mp4

02:28

9. Demo - Distinct.mp4

01:50

10. Summary.mp4

00:17

5. Filtering Results with the WHERE Clause

1. The WHERE Clause.mp4

02:57

2. Demo - WHERE Clause.mp4

00:32

3. Boolean Operators.mp4

01:30

4. The AND Keyword.mp4

01:16

5. Demo - AND.mp4

01:18

6. The OR Keyword.mp4

01:10

7. Demo - OR.mp4

01:32

8. Other Boolean Operators.mp4

00:19

9. BETWEEN.mp4

01:55

10. Demo - BETWEEN.mp4

01:34

11. LIKE.mp4

01:28

12. Demo - LIKE.mp4

01:56

13. IN.mp4

01:02

14. Demo - IN.mp4

01:34

15. IS.mp4

01:17

16. IS NOT.mp4

01:07

17. Demo - IS AND IS NOT.mp4

04:05

18. Summary.mp4

00:23

6. Shaping Results with ORDER BY and GROUP BY

1. Introduction to the Section.mp4

00:34

2. ORDER BY.mp4

01:30

3. Demo - ORDER BY.mp4

01:00

4. Set Functions.mp4

02:51

5. Demo - Set Functions.mp4

03:15

6. Set Function And Qualifiers.mp4

01:33

7. Demo - Set Function And Qualifiers.mp4

01:00

8. GROUP BY.mp4

01:49

9. Demo - GROUP BY.mp4

01:34

10. HAVING.mp4

01:44

11. Demo - HAVING.mp4

02:20

12. Summary.mp4

00:27

7. Matching Different Data Tables with JOINs

1. Introduction to the Section.mp4

00:54

2. CROSS JOIN.mp4

00:49

3. Demo - CROSS JOIN.mp4

01:09

4. INNER JOIN.mp4

01:51

5. Demo - INNER JOIN.mp4

01:13

6. OUTER JOINs.mp4

00:44

7. LEFT OUTER JOIN.mp4

01:07

8. Demo - LEFT OUTER JOIN.mp4

00:44

9. RIGHT OUTER JOIN.mp4

00:51

10. Demo - RIGHT OUTER JOIN.mp4

01:20

11. FULL OUTER JOIN.mp4

01:00

12. Demo - FULL OUTER JOIN.mp4

01:00

13. SELF JOIN.mp4

01:04

14. Summary.mp4

00:22

8. Adding, Changing, and Removing Data

1. Introduction to the Section.mp4

00:58

2. INSERT.mp4

01:36

3. Demo - INSERT.mp4

02:58

4. BULK INSERT.mp4

01:41

5. Demo - BULK INSERT.mp4

00:40

6. UPDATE.mp4

01:20

7. Demo - UPDATE.mp4

02:05

8. DELETE.mp4

01:18

9. Demo - DELETE.mp4

01:15

10. Summary.mp4

00:13

9. Creating Database Tables

1. Introduction to the Section.mp4

00:51

2. CREATE DATABASE.mp4

01:51

3. Demo - CREATE DATABASE.mp4

00:46

4. CREATE TABLE.mp4

02:36

5. Demo - CREATE TABLE.mp4

01:51

6. NULL Values.mp4

02:38

7. PRIMARY KEY.mp4

01:13

8. CONSTRAINT.mp4

01:39

9. ALTER TABLE.mp4

01:54

10. DROP TABLE.mp4

00:54

11. Demo - CREATE TABLE.mp4

03:50

12. Summary.mp4

00:45

10. Conclusion

1. Final Words And Conclusion.mp4

01:00

Description

SQL Fundamentals: Get Started with Database Queries and Boost Your Data Skills

What You'll Learn?

The fundamentals of SQL and its importance in database management.
How to write basic SQL queries and understand their syntax.
The SELECT statement and its role in retrieving data from a database.
Techniques for filtering query results using the WHERE clause.
How to shape and organize query results using ORDER BY and GROUP BY.
The concept of JOINs and how to combine data from different database tables.
Skills for adding, modifying, and deleting data within a database.
The process of creating well-structured database tables.
Practical hands-on experience through interactive exercises and examples.

Who is this for?

Beginners who have little to no experience with SQL or database management and want to learn from scratch.

Students studying computer science, data analysis, or related fields who need to acquire SQL skills for their coursework or future careers.

Professionals from various fields who want to enhance their data manipulation and analysis skills, such as data analysts, business analysts, software developers, and project managers.

Individuals who have a general interest in databases and want to understand how SQL is used to retrieve and manipulate data.

Business owners or entrepreneurs who want to gain insights from their data and make informed decisions based on database analysis.

Individuals considering a career in data management or data analysis who want to build a strong foundation in SQL.

What You Need to Know?

No prior experience or knowledge of SQL is required.

A curious mindset and eagerness to explore the world of SQL and database queries.

More details

Description
Ready to dive into the world of databases and become a SQL superstar? Look no further than our Introduction to SQL course!
Whether you're a beginner or have some basic knowledge, this course is designed to equip you with the essential skills needed to manipulate and analyze data like a pro.
Why Enroll?
SQL skills are in high demand, and it's a fantastic tool for anyone dealing with data. Whether you're a budding data analyst, a tech enthusiast, or just curious about databases, this course is tailor-made for you. Plus, mastering SQL will open doors to countless opportunities in the tech industry.
In this course, we'll cover all the fundamental aspects of SQL, breaking down complex concepts into easy-to-understand lessons.
No jargon or technical mumbo-jumbo, just practical knowledge delivered in a fun and engaging way.
Here's what you can expect to learn by the end of this course:
Course Overview: Get a sneak peek into what lies ahead and discover the exciting world of SQL.
Introduction: Familiarize yourself with databases and understand their importance in the digital age.
Understanding Basic SQL Syntax: Learn the building blocks of SQL and how to structure your queries effectively.
Querying Data with the SELECT Statement: Dive into the core of SQL by mastering the SELECT statement to retrieve specific data from databases.
Filtering Results with the WHERE Clause: Harness the power of the WHERE clause to filter and narrow down your query results.
Shaping Results with ORDER BY and GROUP BY: Discover how to sort and group your data for better analysis and presentation.
Matching Different Data Tables with JOINs: Explore the art of joining tables to combine and analyze data from multiple sources.
Adding, Changing, and Removing Data: Learn how to insert, update, and delete data within databases to keep your information up to date.
Creating Database Tables: Get hands-on experience in creating and designing your own database tables to store and organize data efficiently.
What sets our course apart:
Simple explanations and a friendly tone that make complex concepts easy to grasp.
Interactive exercises and practical examples that reinforce your learning.
Clear demonstrations and step-by-step guidance to build your confidence.
Engaging quizzes to test your knowledge and solidify your understanding.
Access to a vibrant community of learners to share insights and support each other.
What to Expect?
Expect a fun, laid-back atmosphere where you can ask questions, make mistakes, and learn from each other. No boring lectures here! Our engaging videos, interactive quizzes, and hands-on exercises will keep you hooked from start to finish.
So what are you waiting for? Join now and let's embark on this SQL adventure together!
Let's unlock the secrets of data management and take your skills to a whole new level.
Enroll now and embark on an exciting journey to harness the power of SQL.
Unleash your data-driven potential and elevate your skills to new heights. Join us today and unlock the doors to endless opportunities in the world of data management!
See you inside!
Who this course is for:
Beginners who have little to no experience with SQL or database management and want to learn from scratch.
Students studying computer science, data analysis, or related fields who need to acquire SQL skills for their coursework or future careers.
Professionals from various fields who want to enhance their data manipulation and analysis skills, such as data analysts, business analysts, software developers, and project managers.
Professionals from various fields who want to enhance their data manipulation and analysis skills, such as data analysts, business analysts, software developers, and project managers.
Individuals who have a general interest in databases and want to understand how SQL is used to retrieve and manipulate data.
Business owners or entrepreneurs who want to gain insights from their data and make informed decisions based on database analysis.
Individuals considering a career in data management or data analysis who want to build a strong foundation in SQL.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi there, my name is Anass Cherkaoui, I'm a Udemy instructor and I'm a passionate about 3D, Graphic Design as well as programming and web development.I remember what it was like to start from zero, self-teach myself and struggle day and night to acquire the skills needed to build my own career. And this what pushes me to decide teaching on Udemy.With Udemy, I can actually share my knowledge and experience I've gained past several years and help as many people as I can learn how to be 3D artists.I will teach you in a simple and entertaining way. To me, learning should be easy to comprehend no matter what skill level you're at, and you should have fun doing it.If you like to learn things quickly and thoroughly and like to have loads of fun on the way, then with my enthusiasm and energy throughout the lessons of my course, I'm sure you'll have a blast in your journey and be able to build a solid career that you'll be very proud of.I look forward to being your friend first, then your instructor and mentor second, and look to help you and respond to all your questions in a timely manner.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.