SQL for Beginners: Learn SQL using MySQL and Database Design

BY
Udemy

Learn the fundamentals of SQL by designing a database with MySQL and analysing data with normalisation and relationships.

Mode

Online

Fees

₹ 599 4099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Database design is a technique for identifying gaps and opportunities to create a proper utilisation method. It is the primary system component that serves as a framework for the data and its behavior within the system. SQL for Beginners: Learn SQL using MySQL and Database Design online certification is developed by Tim Buchalka's Learn Programming Academy -  a team of professional programmers & teachers in partnership with Jon Avis - IT Systems Engineer & SQL Instructor and is offered by Udemy.

SQL for Beginners: Learn SQL using MySQL and Database Design online course is a self-paced program that involves 8 hours of video-based lectures supported by 29 downloadable resources which focus on helping the candidates in acquiring SQL database skills using MySQL to become professional SQL developers. With SQL for Beginners: Learn SQL using MySQL and Database Design online classes, candidates will be taught about topics like data manipulation, data analysis, subqueries, aggregate functions, MySQL functions, tables, and much more.

The highlights

  • Certificate of completion
  • Self-paced course
  • 8 hours of pre-recorded video content
  • 29 downloadable resources

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 599  ₹4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Database knowledge Sql knowledge

After completing the SQL for Beginners: Learn SQL using MySQL and Database Design certification course, candidates will acquire a solid understanding of the principles of SQL using the fundamentals of MySQL and database design activities. In this SQL course, candidates will explore the concepts involved with data manipulation as well as acquire the skills to select tables. In this SQL certification, candidates will also learn about the methodologies involved with aggregate functions, MySQL functions, and subqueries.

The syllabus

Course Introduction

  • Welcome to the Course
  • Syllabus Explanation

Installation and Setup

  • Section Introduction
  • Databases, SQL and MySQL
  • Relational Database Management System
  • MySQL Installation for Windows
  • MySQL Installation for Mac
  • MySQL Installation for Linux
  • MySQL Workbench Overview
  • Create Database

Data Definition Language

  • Section Introduction
  • Data Types
  • Primary and Foreign Keys
  • Creating the Coffee Store Database
  • Modifying Tables: Adding and Removing Columns
  • Deleting Tables
  • Truncating Tables

More On Alter Table

  • Section Introduction
  • Creating Our Test Database
  • Add and Remove Primary Key
  • Add and Remove Foreign Key
  • Add Unique Constraint
  • Change Column Name
  • Change Column Data Type
  • Exercise 1
  • Solution 1

Data Manipulation Language

  • Section Introduction
  • Inserting Data Into Tables
  • Updating Data in Tables
  • Deleting Data from Tables
  • Completing the Coffee Store Database

Selecting from a Table

  • Section Introduction
  • Select Statement
  • Where Clause
  • Using Inequality Symbols
  • Null Values
  • Exercise 1
  • Solution 1
  • In, Not In
  • Between
  • Like
  • Order By
  • Exercise 2
  • Solution 2
  • Distinct
  • Limit
  • Column Name Alias
  • Exercise 3
  • Solution 3

Selecting From Multiple Tables

  • Section Introduction
  • What Are Joins?
  • Inner Join
  • Left Join
  • Right Join
  • Joining more than Two Tables
  • Exercise 1
  • Solution 1

Database Design

  • Section Introduction
  • Normalization - What is it?
  • 1st Normal Form (1NF)
  • 2nd Normal Form (2NF)
  • 3rd Normal Form (3NF)
  • Relationships
  • Relationships - One to One
  • Relationships - One to Many
  • Relationships - Many to Many
  • Constraints

Creating a Cinema Booking System Database

  • Section Introduction
  • Database Schema Overview
  • Create Films Table
  • Create Customers Table
  • Create Rooms Table
  • Create Screenings Table
  • Create Seats Table
  • Create Bookings Table
  • Create Reserved_Seat Table
  • Insert the Data

Aggregate Functions

  • Section Introduction
  • What are Aggregate Functions
  • Count
  • Sum
  • Min and Max
  • Average
  • Exercise 1
  • Solution 1
  • Grouping Data
  • Having Clause
  • Exercise 2
  • Solution 2

Subqueries

  • Section Introduction
  • What Are Subqueries
  • Non-Correlated Subqueries: Part 1
  • Non-Correlated Subqueries: Part 2
  • Correlated Subqueries
  • Exercise 1
  • Solution 1

MySQL Functions - String Functions and Date Functions

  • Section Introduction
  • What Are MySQL Functions?
  • Concatenation
  • Substrings
  • Upper and Lower Case
  • Exercise 1
  • Solution 1
  • Date Function
  • Month Function
  • Year Function
  • Exercise 2
  • Solution 2

Challenges

  • Section Introduction
  • Challenge One
  • Solution One
  • Challenge Two
  • Solution Two
  • Challenge Three
  • Solution Three
  • Challenge Four
  • Solution Four
  • Challenge Five
  • Solution Five
  • Challenge Six
  • Solution Six

Extra Information - Source code, and other stuff

  • Bonus Lecture and Information

Instructors

Mr Jon Avis

Mr Jon Avis
IT Systems Engineer
Udemy

Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books