SQL Foundations

A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.
Rating: 4.3 out of 5 (491 ratings)
17,328 students
SQL Foundations
Rating: 4.3 out of 5 (491 ratings)
17,358 students
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.

Requirements

  • You need to download and install either MySQL or SQL Server and should have the environment setup in your machine. For general users community editions are available for both the products which are free.
Description

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.



Who this course is 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.
  • It is NOT for you if you are familiar with SQL and looking for advanced topics.
Curriculum
8 sections • 59 lectures • 3h 12m total length
  • Course Overview
  • MySQL Installation Guide
  • Introduction & Terminology
  • Getting started with basic commands
  • Script
  • Quiz
  • 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
  • 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
  • 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
  • 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
  • ALTER command
  • Views
  • Index
  • Transactions
  • Quiz
  • Scripts
  • Bonus Lecture: OFFER Coupons for my other courses

Instructor
Software Architect and a passionate trainer
Sagar Uppuluri
  • 4.3 Instructor Rating
  • 2,334 Reviews
  • 49,209 Students
  • 6 Courses

Sagar an M.Tech graduate from ANU a passionate application developer and a trainer apart from being a good learner and a listener, started his career as a trainer and later he was part of design and development of several software projects and products. Earned his reputation as a hard core Java developer and Systems Integration Specialist and was instrumental in success of several projects with his technical, leadership and mentoring skills.