Brochure
Enquire- Welcome to the Course
- Syllabus Explanation
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 ...Read more
Online
₹ 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
Who it is for
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
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
IT Systems Engineer
Udemy
Articles
Popular Articles
prev
next
Latest Articles
prev
next
