SQL Foundations

A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.

4.60 (1932 reviews)
Udemy
platform
English
language
Databases
category
instructor
SQL Foundations
49,222
students
3 hours
content
Sep 2019
last update
FREE
regular price

What you will learn

Understand how to the design the database schema.

Learn SQL commands along with key insights about the logic behind the command.

Design queries, apply aggregations and combine information from multiple tables.

Why take this course?

SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant. 

This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema. 

It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features.  Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.

It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.



Content

Getting Started

Course Overview
MySQL Installation Guide
Introduction & Terminology
Getting started with basic commands
Script
Quiz

Basic DML

Projecting required columns through Query
Script
Insert data into the table
Script
Inserting multiple records
Script
Quiz
Arranging the data before display
Script
Filtering Data
Script
Quiz
Updating and Delete
Script
Quiz

Designing the Tables/Relations

Primary Constraints
Script
Identity Column
Script
Primary Key
Script
Need for splitting data into multiple tables
Referential Integrity
Script
Relationship and Cardinality
Script
Constraints over multiple columns
Script
Quiz

Query Design

Aggregate functions
Script
Grouping and applying aggregate functions
Script
Filtering groups
Script
Memorising queries 2
Quiz
Joins Introduction
Script
Inner and Outer Joins
Script
Subqueries
Script
Correlated Subqueries
Script
Quiz
Problem Set

Example Social App Schema Design

Schema Design - Part 1
Schema Design - Part 2
Schema Design - Part 3
Schema Design - Part 4
Social App Schema - Part 5
Script
Solutions to Problems in the Script

Other essential topics

ALTER command
Views
Index
Transactions
Quiz

Source

Scripts

What's next?

Bonus Lecture: OFFER Coupons for my other courses

Screenshots

SQL Foundations - Screenshot_01SQL Foundations - Screenshot_02SQL Foundations - Screenshot_03SQL Foundations - Screenshot_04

Our review

--- **Overview of Course Rating and Reviews** The global course rating stands at a robust **4.60**, with all recent reviews painting a positive picture of the course. The majority of learners have found the course to be thorough, well-structured, and highly recommended for beginners and those looking to refresh their SQL knowledge. Here's a detailed breakdown of the course based on the reviews: **Pros:** - **Comprehensive Content**: The course covers a wide array of SQL concepts in a logical progression from basic to advanced. - **Engaging Presentation**: Short videos are used to explain each step, ensuring that information is not overwhelming and is easily digestible. - **Practical Application**: Quizzes and problems throughout the course allow learners to apply what they've learned in real-time. - **Free Access**: As a free course, it provides an excellent opportunity for those who wish to explore database design and SQL concepts without any financial commitment. - **Diverse Learning Opportunities**: The course caters to different learning styles with visual and practical examples. - **Quality Quizzes**: The quizzes are challenging and help reinforce the material taught in the lessons. - **Refresher for Experienced Users**: Even those with prior experience in databases found the course valuable as a refresher. **Cons:** - **Minor Errors**: Some learners encountered minor issues such as questions from later sections appearing in earlier quizzes, which could potentially cause errors. - **Pacing**: The pace of the course was reported to be fast for some beginners, who found it challenging to keep up. - **Grammatical Issues**: A few reviews mentioned grammatical errors in the scripts' descriptions and the instructor's English. - **Quiz Correlation**: There were instances where the quizzes at the end of sections did not align with the content presented, leading to confusion. - **Technical Interface Challenges**: Some learners experienced difficulties with the workbook editor or the process of opening materials. - **Enthusiasm and Enthication in Teaching**: A couple of reviews pointed out that the instructor seemed eager to finish topics quickly, which might have impacted the learning experience for some students. **Additional Feedback:** - **Improvement Suggestions**: Learners suggested improvements such as providing a check feature for code/answers during the quizzes and enhancing the quality of grammar in the scripts' descriptions. - **Diverse Audience**: The course was praised by both beginners and those with previous database experience, indicating its applicability across different skill levels. - **Course Effectiveness**: One learner who hadn't touched databases in 25 years found the course a great refresher, highlighting its effectiveness for revisiting SQL concepts. **Conclusion:** Overall, this online SQL course has been positively received by the majority of learners, with many highlighting its thoroughness and practical approach to learning. While there are areas for improvement, such as pacing, technical interface issues, and some grammatical errors, the course remains a valuable resource for both beginners and those looking to refresh their SQL knowledge. The positive reviews and high rating are a testament to the quality of content and instruction provided in the course.

Charts

Price

SQL Foundations - Price chart

Rating

SQL Foundations - Ratings chart

Enrollment distribution

SQL Foundations - Distribution chart
976478
udemy ID
10/5/2016
course created date
7/17/2019
course indexed date
Bot
course submited by