HOT
blank

SQL Foundations

Development

Rating4.4
Free Enroll Now

SQL Foundations, available at Free, has an average rating of 4.4, with 59 lectures, 8 quizzes, based on 2017 reviews, and has 51764 subscribers.

You will learn about 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. This course is ideal for individuals who are If you are a newbie to SQL and looking forward to understand it through step by step approach or you would like to finetune your SQL foundations, this course is apt for you. or It is NOT for you if you are familiar with SQL and looking for advanced topics. It is particularly useful for If you are a newbie to SQL and looking forward to understand it through step by step approach or you would like to finetune your SQL foundations, this course is apt for you. or It is NOT for you if you are familiar with SQL and looking for advanced topics.

Enroll now: SQL Foundations

Summary

Title: SQL Foundations

Price: Free

Average Rating: 4.4

Number of Lectures: 59

Number of Quizzes: 8

Number of Published Lectures: 59

Number of Published Quizzes: 8

Number of Curriculum Items: 67

Number of Published Curriculum Objects: 67

Original Price: Free

Quality Status: approved

Status: Live

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.

Who Should Attend

  • If you are a newbie to SQL and looking forward to understand it through step by step approach or you would like to finetune your SQL foundations, this course is apt for you.
  • It is NOT for you if you are familiar with SQL and looking for advanced topics.

Target Audiences

  • If you are a newbie to SQL and looking forward to understand it through step by step approach or you would like to finetune your SQL foundations, this course is apt for you.
  • It is NOT for you if you are familiar with SQL and looking for advanced topics.

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.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Course Overview

Lecture 2: MySQL Installation Guide

Lecture 3: Introduction & Terminology

Lecture 4: Getting started with basic commands

Lecture 5: Script

Chapter 2: Basic DML

Lecture 1: Projecting required columns through Query

Lecture 2: Script

Lecture 3: Insert data into the table

Lecture 4: Script

Lecture 5: Inserting multiple records

Lecture 6: Script

Lecture 7: Arranging the data before display

Lecture 8: Script

Lecture 9: Filtering Data

Lecture 10: Script

Lecture 11: Updating and Delete

Lecture 12: Script

Chapter 3: Designing the Tables/Relations

Lecture 1: Primary Constraints

Lecture 2: Script

Lecture 3: Identity Column

Lecture 4: Script

Lecture 5: Primary Key

Lecture 6: Script

Lecture 7: Need for splitting data into multiple tables

Lecture 8: Referential Integrity

Lecture 9: Script

Lecture 10: Relationship and Cardinality

Lecture 11: Script

Lecture 12: Constraints over multiple columns

Lecture 13: Script

Chapter 4: Query Design

Lecture 1: Aggregate functions

Lecture 2: Script

Lecture 3: Grouping and applying aggregate functions

Lecture 4: Script

Lecture 5: Filtering groups

Lecture 6: Script

Lecture 7: Memorising queries 2

Lecture 8: Joins Introduction

Lecture 9: Script

Lecture 10: Inner and Outer Joins

Lecture 11: Script

Lecture 12: Subqueries

Lecture 13: Script

Lecture 14: Correlated Subqueries

Lecture 15: Script

Lecture 16: Problem Set

Chapter 5: Example Social App Schema Design

Lecture 1: Schema Design – Part 1

Lecture 2: Schema Design – Part 2

Lecture 3: Schema Design – Part 3

Lecture 4: Schema Design – Part 4

Lecture 5: Social App Schema – Part 5

Lecture 6: Script

Lecture 7: Solutions to Problems in the Script

Chapter 6: Other essential topics

Lecture 1: ALTER command

Lecture 2: Views

Lecture 3: Index

Lecture 4: Transactions

Chapter 7: Source

Lecture 1: Scripts

Chapter 8: What's next?

Lecture 1: Bonus Lecture: OFFER Coupons for my other courses

Instructors

Rating Distribution

  • 1 stars: 22 votes
  • 2 stars: 26 votes
  • 3 stars: 243 votes
  • 4 stars: 786 votes
  • 5 stars: 940 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 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024