Beginner's Introduction to SQL and Databases
Beginner's Introduction to SQL and Databases, available at Free, has an average rating of 4.3, with 33 lectures, based on 366 reviews, and has 10813 subscribers.
You will learn about Introduction to SQL Introduction to Databases Connect to MySQL Introduction to MySQL Beginner's SQL This course is ideal for individuals who are Beginner Analysts or Aspiring Analysts or Product Owners or Product Manager or Data Professional or Students It is particularly useful for Beginner Analysts or Aspiring Analysts or Product Owners or Product Manager or Data Professional or Students.
Enroll now: Beginner's Introduction to SQL and Databases
Summary
Title: Beginner's Introduction to SQL and Databases
Price: Free
Average Rating: 4.3
Number of Lectures: 33
Number of Published Lectures: 33
Number of Curriculum Items: 33
Number of Published Curriculum Objects: 33
Original Price: Free
Quality Status: approved
Status: Live
What You Will Learn
- Introduction to SQL
- Introduction to Databases
- Connect to MySQL
- Introduction to MySQL
- Beginner's SQL
Who Should Attend
- Beginner Analysts
- Aspiring Analysts
- Product Owners
- Product Manager
- Data Professional
- Students
Target Audiences
- Beginner Analysts
- Aspiring Analysts
- Product Owners
- Product Manager
- Data Professional
- Students
In this course, you’ll create a foundation for data manipulation and analysis using SQL. If you are completely new to SQL and have an interest on how to work with large volumes of data in an efficient and sophisticated way, then you came to the right course.
This course contents consist of the following:
-
Installing a GUI / Software to connect to database
-
Connecting to a MySQL database
-
Tables Explained
-
Inserting Records
-
Dropping Tables
-
SELECT Statement
-
COUNT, MIN, MAX and other functions
-
WHERE clause (for filtering data)
-
String and comparison operators
Course Curriculum
Chapter 1: Database Fundamentals
Lecture 1: Introduction
Lecture 2: Choosing a GUI
Lecture 3: Connecting to our Database
Lecture 4: Connection Properties
Lecture 5: Database Tables Explained
Lecture 6: Creating a Database Table
Lecture 7: Inserting Records
Lecture 8: Exercise: Inserting Records
Lecture 9: Data Types
Lecture 10: Dropping a Table
Lecture 11: Start Querying your data using SELECT
Lecture 12: Counting Records
Lecture 13: You have access to other databases! Check it out!
Lecture 14: Previewing your records
Lecture 15: Filtering records and numeric data types
Lecture 16: Filtering records using Greater Than operator
Lecture 17: Filtering records using Less Than operator
Lecture 18: Using the BETWEEN condition
Lecture 19: Counting a subset of records
Lecture 20: Intro to AND
Lecture 21: Solutions to Exercise
Lecture 22: Using the OR condition
Lecture 23: Sorting data with ORDER BY
Lecture 24: Ordering by ordinal column
Lecture 25: Solutions to Excercise
Lecture 26: The LIKE operator
Lecture 27: The NOT LIKE operator
Lecture 28: THE IN operator
Lecture 29: Solutions to Excercise
Lecture 30: Using MIN and MAX
Lecture 31: Rounding and other Arithmetic
Lecture 32: Solution to Excercise
Lecture 33: End of Part I
Instructors
-
Oscar Valles
Analytics and Business Intelligence Professional
Rating Distribution
- 1 stars: 3 votes
- 2 stars: 6 votes
- 3 stars: 42 votes
- 4 stars: 139 votes
- 5 stars: 176 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024