SQL 101: Mastering the Basics

Focused View

Anita DeSouza

44:41

10 View

1. Introduction to Databases and SQL

1. Welcome to SQL 101 Mastering the Basics.mp4

03:34

2. Introduction.html

3. Define a Database.mp4

03:45

4. Types of Databases.html

5. Databases.html

6. Common Database Management Systems (DBMSs).html

7. Common Database Management Systems (DBMSs).html

8.1 How to Download and Install SQLite to Your Computer.html

8.2 SQLite Installation.html

8. Setting Up Your Environment - Installing a DBMS and Creating a Sample Database.mp4

04:45

9. Creating a Database.html

2. Basic SQL Queries

1. Introduction to Basic SQL Queries.html

2. Introduction to SQL.mp4

03:51

3. Understanding CREATE TABLE and SELECT-FROM-Statement in SQL.mp4

04:35

4. Introduction to SQL.html

5. Creating a Simple Database.html

6. The use of Characters in SQL.html

7. The Use of Characters in SQL.html

8. Common Data Types in SQL Databases.html

9. Common Data Types in SQL.html

10. Adding Comments.html

11. SELECT-FROM Statement in SQL.html

12. SQL Commands - CREATE TABLE, INSERT INTO, SELECT, FROM, WHERE.mp4

14:14

13. Exploring Data with the SELECT-FROM-WHERE-INSERT INTO Clauses.html

14. Using SELECT-FROM-WHERE.html

3. Filtering Data

1. Filtering Based on Conditions (=, , , , =, =).html

2. Filtering Data in SQL.html

3. Combining Conditions (AND, OR, and NOT).html

4. Combining Conditions (AND, OR, and NOT).html

5. Sorting Data - Ascending and Descending Order.html

6. Filtering and Sorting Data Real-World Example.mp4

05:21

7. Sorting Data - Ascending and Descending Order.html

4. Data Manipulation

1. Changing Existing Data with UPDATE.html

2. SQL UPDATE statement.html

3. The DELETE Statement.html

4. SQL DELETE statement.html

5.1 SQL Alias.html

5. Understanding Aliases.html

6. Understanding Aliases.html

7. Real-World Example - Applying Aggregate Functions.html

8. Analyzing Sales Data.html

9. Grouping data using GROUP BY.html

10. Applying Aggregate Functions (COUNT, SUM, AVG, MAX, and MIN) and GROUP BY.mp4

04:36

11. SQL GROUP BY Mastery Quiz.html

12. Sales Analysis by Region.html

5. CAPSTONE - Course Conclusion

1. Applying Your Skills in Real-World Scenarios with a Practical Project.html

2. Course Project - Creating a Mini Database Application.html

Description

Building a Strong Foundation in SQL

What You'll Learn?

Understanding the basics of databases and their role in data management
Relational Database Concepts: Learning about tables, rows, columns, and relationships in a relational database
SQL Syntax: Grasping the basic syntax and structure of SQL queries.
Data Retrieval with SELECT: Writing queries to retrieve specific data from one or more tables
Filtering and Sorting Data: Using WHERE clause for filtering data based on specific conditions and employing ORDER BY clause for sorting query results.
Data Manipulation: Using the INSERT, UPDATE, and DELETE statements.
Aggregation Functions: Utilizing functions like COUNT, SUM, AVG, MIN, and MAX for summarizing data.
Grouping and Group Functions: Grouping data using the GROUP BY clause. Applying aggregate functions to grouped data.
Data Constraints: Applying constraints like PRIMARY KEY and NOT NULL.
Critical Problem-Solving Skills through practical exercises and projects by tackling real-world scenarios
Confidence to Explore Advanced SQL Concepts

Who is this for?

This course assumes that participants have little to no prior experience with SQL or database management.

What You Need to Know?

No prior knowledge of SQL is required, but participants should have a basic understanding of computer usage and data concepts.

More details

Description
Welcome to SQL 101: Mastering the Basics, your comprehensive introduction to the world of Structured Query Language (SQL). This is the perfect course for beginners who want to learn the fundamentals of SQL. SQL is a programming language used to manage and manipulate relational databases. Whether you are a budding data analyst, software developer, looking to enter the workforce as a database administrator or simply want to learn how to manage your own database, this course is for you.
The course will cover the basics of SQL, including creating and modifying tables, inserting and retrieving data, and performing basic queries. Students will also learn how to use SQL to filter and sort data, and perform complex calculations. One of the best things about SQL is its versatility. It can be used with a variety of database management systems, including MySQL, SQLite, Oracle, and Microsoft SQL Server. This means that the skills you learn in this course will be transferable to a wide range of professional settings.
Throughout this course, you will:
Learn the Fundamentals: We start with the fundamentals, covering SQL's basic syntax, data types, and essential commands. You'll become adept at querying databases to retrieve valuable information.
Database Design: Discover the art of designing databases for efficient data storage and retrieval. We'll guide you through creating well-structured, normalized databases.
Data Manipulation: Dive into data manipulation as you learn how to insert, update, and delete data in databases. You'll understand how to maintain the integrity of your data.
Practical Experience: Put your knowledge into practice through hands-on exercises and real-world examples. Gain confidence in applying SQL concepts to solve practical problems.
By the end of this course, you'll have a solid understanding of SQL You will be equipped with the ability to work with databases, extract meaningful insights from data, and contribute to data-driven decision-making processes. SQL 101 is your gateway to unlocking the potential of data.
Join SQL 101 today and embark on a transformative journey to become a proficient data wrangler, opening doors to a wide range of career opportunities and enhancing your ability to work with data effectively.
Who this course is for:
This course assumes that participants have little to no prior experience with SQL or database management.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Anita DeSouza

Instructor's Courses

I am an accomplished and dedicated educator who has devoted over 15 years to shaping the minds of college students through a diverse array of subjects. With a strong academic background, including a B.S. in Mathematics, an M.A. in Education, and significant progress toward an M.A. in Economics, I have become a respected figure in the fields of mathematics, economics, statistics, and critical thinking skills. In addition to my formal education, I have completed additional training and certifications in the field of data analytics.From an early age, I demonstrated a natural aptitude for mathematics. This passion led me to pursue a Bachelor of Science degree in Mathematics, laying the foundation for a career dedicated to the exploration and teaching of quantitative concepts. The analytical skills honed during my studies would serve as the cornerstone of my pedagogical approach.After completing my undergraduate studies, I realized that my true calling was in education. Armed with the desire to share my knowledge and inspire future generations, I pursued a Master of Arts in Education, a decision that would open the door to a rewarding career as a college-level educator.With my comprehensive educational background, I have been able to offer a wide range of courses, reflecting my diverse expertise. From teaching college-level mathematics, where I demystified complex concepts and encouraged students to embrace the beauty of numbers, to guiding students through the intricacies of economics, I have demonstrated a remarkable ability to make intricate subjects accessible and engaging.As I look back on my remarkable 15-year teaching journey, I find fulfillment in the countless students I have inspired, the minds I have nurtured, and the love for learning I have instilled. My tireless dedication to education, coupled with my genuine passion for my subjects, continues to shape the next generation of thinkers and problem solvers.

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.