SQL for Beginners: Learn SQL using MySQL and Database Design

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Have you heard that database skills are essential for developers to be skilled in and understand?

Are you wanting to understand SQL and databases in general, but don't know where to start?

Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn.

Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases.

Whatever the reason you have arrived here, this course will...

Help you understand and apply SQL with MySQL, including Database Design and Data Analysis.

Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities.

Key concepts you will learn and work with in this course.

SQL (Structured Query Language - very much an in-demand technology).
MySQL (one of the worlds most popular and widely used databases).
Database Design
Data Analysis

The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy. You will struggle to find another MySQL course that has a section on this. This section alone, will give you a huge edge over other applicants for jobs.

Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section.

Creating, Modifying and Deleting Tables in a Database (DDL)
Inserting, Updating and Deleting Data from Tables (DML)
Select Queries
Joins
Aggregate Functions
Subqueries
Database Design
Creating Databases.

In addition there are installation videos covering MySQL on Windows, Mac or Linux.

Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material.

Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database.

Why enrolling in this course is the best decision you can make.

Become skilled as a database developer generally needs you to learn SQL, a database, and then database design. Often this will require multiple courses. However you learn all those topics, and data analysis in this one course.

Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday. Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course.

Essentially, you are learning from someone who has all the professional training, skills, and experience needed to teach you how to become proficient with SQL, MySQL and Database design as quickly as possible.

If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you!

After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design.

The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities.

SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course.

Your new job or consulting opportunity awaits!

Why not get started today?

Click the Signup button to sign up for the course!


Who this course is for:

  • Anyone who wants to learn how to use SQL and MySQL.

Instructors

Professional Programmers and Teachers - 1.24M students
  • 4.5 Instructor Rating
  • 361,923 Reviews
  • 1,254,942 Students
  • 53 Courses

The Learn Programming Academy was created by Tim Buchalka, a software developer with 35 years experience, who is also an instructor on Udemy, with over 1.24M+ students in his courses on Java, Python, Android, C# and the Spring framework.

The Academy’s goal in the next three years, is to teach one million people to learn how to program.

Apart from Tim’s own courses, which are all available here, we are working with the very best teachers, creating courses to teach the essential skills required by developers, at all levels.

One other important philosophy is that our courses are taught by real professionals; software developers with real and substantial experience in the industry, who are also great teachers. All our instructors are experienced, software developers!

Our team is busy creating new courses right now.

Whether you are a beginner, looking to learn how to program for the very first time, or to brush up on your existing skills, or to learn new languages and frameworks, the Academy has you covered.

IT Systems Engineer and SQL Instructor
  • 4.5 Instructor Rating
  • 17,450 Reviews
  • 75,823 Students
  • 2 Courses

Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Systems Engineer. This has allowed me to become an expert in SQL, Databases, Unix, Shell Scripting and coding in multiple languages.

Part of my role as a Systems Engineer is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe.

Expected Outcomes

  1. Have a detailed knowledge and understanding of using MySQL, one of the most widely used databases in the world. Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector. In-depth knowledge of database design will give students an edge over other applicants. Curated for the Udemy Business collection Course content 14 sections • 122 lectures • 7h 51m total length Expand all sections Course Introduction 2 lectures • 5min Welcome to the Course Preview 01:28 Syllabus Explanation 03:42 Installation and Setup 8 lectures • 1hr 1min Section Introduction 00:41 Databases, SQL and MySQL 03:08 Relational Database Management System 02:18 MySQL Installation for Windows Preview 15:00 MySQL Installation for Mac 12:17 MySQL Installation for Linux 11:07 MySQL Workbench Overview 13:13 Create Database Preview 03:23 Data Definition Language 7 lectures • 26min Section Introduction 01:32 Data Types Preview 06:34 Primary and Foreign Keys 02:53 Creating the Coffee Store Database 08:54 Modifying Tables: Adding and Removing Columns 03:08 Deleting Tables 01:28 Truncating Tables 01:39 More On Alter Table 9 lectures • 39min Section Introduction 01:25 Creating Our Test Database 05:30 Add and Remove Primary Key 05:25 Add and Remove Foreign Key 04:56 Add Unique Constraint 03:25 Change Column Name 03:15 Change Column Data Type 04:44 Exercise 1 01:30 Solution 1 08:27 Data Manipulation Language 5 lectures • 18min Section Introduction 00:50 Inserting Data Into Tables Preview 05:37 Updating Data in Tables 06:07 Deleting Data from Tables 02:49 Completing the Coffee Store Database 02:38 Selecting from a Table 18 lectures • 58min Section Introduction 01:14 Select Statement 01:46 Where Clause Preview 04:53 Using Inequality Symbols 03:03 Null Values 03:10 Exercise 1 01:06 Solution 1 03:55 In, Not In 03:44 Between 04:04 Like 04:52 Order By 06:19 Exercise 2 00:55 Solution 2 04:23 Distinct Preview 05:11 Limit 02:56 Column Name Alias 02:03 Exercise 3 00:50 Solution 3 03:45 Selecting From Multiple Tables 8 lectures • 33min Section Introduction 01:08 What Are Joins? 03:08 Inner Join 08:55 Left Join 05:23 Right Join 03:15 Joining more than Two Tables 04:33 Exercise 1 01:06 Solution 1 05:55 Database Design 10 lectures • 40min Section Introduction 01:23 Normalization - What is it? Preview 05:23 1st Normal Form (1NF) 03:30 2nd Normal Form (2NF) 06:27 3rd Normal Form (3NF) 09:30 Relationships 01:05 Relationships - One to One 02:30 Relationships - One to Many 02:00 Relationships - Many to Many 04:00 Constraints 03:53 Creating a Cinema Booking System Database 10 lectures • 41min Section Introduction 01:11 Database Schema Overview 07:26 Create Films Table 04:55 Create Customers Table 02:53 Create Rooms Table 02:19 Create Screenings Table 04:45 Create Seats Table Preview 03:53 Create Bookings Table 03:52 Create Reserved_Seat Table 04:35 Insert the Data 05:22 Aggregate Functions 12 lectures • 34min Section Introduction 00:41 What are Aggregate Functions 02:30 Count 02:38 Sum 02:36 Min and Max 02:39 Average Preview 02:09 Exercise 1 00:46 Solution 1 04:09 Grouping Data 08:52 Having Clause 01:44 Exercise 2 00:44 Solution 2 04:11 4 more sections Requirements A PC (Windows or Linux) or Mac is required No prior knowledge of Databases, SQL or MySQL is needed. Description Have you heard that database skills are essential for developers to be skilled in and understand? Are you wanting to understand SQL and databases in general, but don't know where to start? Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn. Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases. Whatever the reason you have arrived here, this course will... Help you understand and apply SQL with MySQL, including Database Design and Data Analysis. Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities. Key concepts you will learn and work with in this course. SQL (Structured Query Language - very much an in-demand technology). MySQL (one of the worlds most popular and widely used databases). Database Design Data Analysis The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy. You will struggle to find another MySQL course that has a section on this. This section alone, will give you a huge edge over other applicants for jobs. Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section. Creating, Modifying and Deleting Tables in a Database (DDL) Inserting, Updating and Deleting Data from Tables (DML) Select Queries Joins Aggregate Functions Subqueries Database Design Creating Databases. In addition there are installation videos covering MySQL on Windows, Mac or Linux. Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material. Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database. Why enrolling in this course is the best decision you can make. Become skilled as a database developer generally needs you to learn SQL, a database, and then database design. Often this will require multiple courses. However you learn all those topics, and data analysis in this one course. Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday. Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course. Essentially, you are learning from someone who has all the professional training, skills, and experience needed to teach you how to become proficient with SQL, MySQL and Database design as quickly as possible. If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you! After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design. The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities. SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course. Your new job or consulting opportunity awaits! Why not get started today? Click the Signup button to sign up for the course! Who this course is for: Anyone who wants to learn how to use SQL and MySQL. Show more Show less Featured review Daniel Council 62 courses 16 reviews Rating: 5.0 out of 5 2 years ago Great basics course, tim's team is stellar, using him for python at the moment as well, and took some of his java course in the past when i did work with it. Highly reccomend this if you are new to databases Show more Show less Instructors Tim Buchalka's Learn Programming Academy Professional Programmers and Teachers - 1.24M students 4.5 Instructor Rating 361,923 Reviews 1,254,942 Students 53 Courses The Learn Programming Academy was created by Tim Buchalka, a software developer with 35 years experience, who is also an instructor on Udemy, with over 1.24M+ students in his courses on Java, Python, Android, C# and the Spring framework. The Academy’s goal in the next three years, is to teach one million people to learn how to program. Apart from Tim’s own courses, which are all available here, we are working with the very best teachers, creating courses to teach the essential skills required by developers, at all levels. One other important philosophy is that our courses are taught by real professionals; software developers with real and substantial experience in the industry, who are also great teachers. All our instructors are experienced, software developers! Our team is busy creating new courses right now. Whether you are a beginner, looking to learn how to program for the very first time, or to brush up on your existing skills, or to learn new languages and frameworks, the Academy has you covered. Show more Show less Jon Avis - SQL Instructor IT Systems Engineer and SQL Instructor 4.5 Instructor Rating 17,450 Reviews 75,823 Students 2 Courses Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Systems Engineer. This has allowed me to become an expert in SQL, Databases, Unix, Shell Scripting and coding in multiple languages. Part of my role as a Systems Engineer is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6776f26baff05427',m:'c5eec44c4bb6855bc1f41160ed592c286180e407-1627735769-1800-AR1cMhKcOwbi536tM1WBtEGkX6ZZIxUtJOUjNeGP3gA74VafEc7DOfN5Mxna9eQbIXAVM31Vk2A+S44XaeRRwZHjPzqMXZkSS0Mo+FnilSv/FuONtvj9ukrXaal6ndPGvtVh4lIsbGowry9PAGQBUW54XmMZBBXoswbczW8iKxEQ',s:[0x037bff3fbb,0x0e8c8e1a06],}})();
  2. Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector. In-depth knowledge of database design will give students an edge over other applicants. Curated for the Udemy Business collection Course content 14 sections • 122 lectures • 7h 51m total length Expand all sections Course Introduction 2 lectures • 5min Welcome to the Course Preview 01:28 Syllabus Explanation 03:42 Installation and Setup 8 lectures • 1hr 1min Section Introduction 00:41 Databases, SQL and MySQL 03:08 Relational Database Management System 02:18 MySQL Installation for Windows Preview 15:00 MySQL Installation for Mac 12:17 MySQL Installation for Linux 11:07 MySQL Workbench Overview 13:13 Create Database Preview 03:23 Data Definition Language 7 lectures • 26min Section Introduction 01:32 Data Types Preview 06:34 Primary and Foreign Keys 02:53 Creating the Coffee Store Database 08:54 Modifying Tables: Adding and Removing Columns 03:08 Deleting Tables 01:28 Truncating Tables 01:39 More On Alter Table 9 lectures • 39min Section Introduction 01:25 Creating Our Test Database 05:30 Add and Remove Primary Key 05:25 Add and Remove Foreign Key 04:56 Add Unique Constraint 03:25 Change Column Name 03:15 Change Column Data Type 04:44 Exercise 1 01:30 Solution 1 08:27 Data Manipulation Language 5 lectures • 18min Section Introduction 00:50 Inserting Data Into Tables Preview 05:37 Updating Data in Tables 06:07 Deleting Data from Tables 02:49 Completing the Coffee Store Database 02:38 Selecting from a Table 18 lectures • 58min Section Introduction 01:14 Select Statement 01:46 Where Clause Preview 04:53 Using Inequality Symbols 03:03 Null Values 03:10 Exercise 1 01:06 Solution 1 03:55 In, Not In 03:44 Between 04:04 Like 04:52 Order By 06:19 Exercise 2 00:55 Solution 2 04:23 Distinct Preview 05:11 Limit 02:56 Column Name Alias 02:03 Exercise 3 00:50 Solution 3 03:45 Selecting From Multiple Tables 8 lectures • 33min Section Introduction 01:08 What Are Joins? 03:08 Inner Join 08:55 Left Join 05:23 Right Join 03:15 Joining more than Two Tables 04:33 Exercise 1 01:06 Solution 1 05:55 Database Design 10 lectures • 40min Section Introduction 01:23 Normalization - What is it? Preview 05:23 1st Normal Form (1NF) 03:30 2nd Normal Form (2NF) 06:27 3rd Normal Form (3NF) 09:30 Relationships 01:05 Relationships - One to One 02:30 Relationships - One to Many 02:00 Relationships - Many to Many 04:00 Constraints 03:53 Creating a Cinema Booking System Database 10 lectures • 41min Section Introduction 01:11 Database Schema Overview 07:26 Create Films Table 04:55 Create Customers Table 02:53 Create Rooms Table 02:19 Create Screenings Table 04:45 Create Seats Table Preview 03:53 Create Bookings Table 03:52 Create Reserved_Seat Table 04:35 Insert the Data 05:22 Aggregate Functions 12 lectures • 34min Section Introduction 00:41 What are Aggregate Functions 02:30 Count 02:38 Sum 02:36 Min and Max 02:39 Average Preview 02:09 Exercise 1 00:46 Solution 1 04:09 Grouping Data 08:52 Having Clause 01:44 Exercise 2 00:44 Solution 2 04:11 4 more sections Requirements A PC (Windows or Linux) or Mac is required No prior knowledge of Databases, SQL or MySQL is needed. Description Have you heard that database skills are essential for developers to be skilled in and understand? Are you wanting to understand SQL and databases in general, but don't know where to start? Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn. Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases. Whatever the reason you have arrived here, this course will... Help you understand and apply SQL with MySQL, including Database Design and Data Analysis. Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities. Key concepts you will learn and work with in this course. SQL (Structured Query Language - very much an in-demand technology). MySQL (one of the worlds most popular and widely used databases). Database Design Data Analysis The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy. You will struggle to find another MySQL course that has a section on this. This section alone, will give you a huge edge over other applicants for jobs. Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section. Creating, Modifying and Deleting Tables in a Database (DDL) Inserting, Updating and Deleting Data from Tables (DML) Select Queries Joins Aggregate Functions Subqueries Database Design Creating Databases. In addition there are installation videos covering MySQL on Windows, Mac or Linux. Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material. Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database. Why enrolling in this course is the best decision you can make. Become skilled as a database developer generally needs you to learn SQL, a database, and then database design. Often this will require multiple courses. However you learn all those topics, and data analysis in this one course. Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday. Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course. Essentially, you are learning from someone who has all the professional training, skills, and experience needed to teach you how to become proficient with SQL, MySQL and Database design as quickly as possible. If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you! After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design. The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities. SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course. Your new job or consulting opportunity awaits! Why not get started today? Click the Signup button to sign up for the course! Who this course is for: Anyone who wants to learn how to use SQL and MySQL. Show more Show less Featured review Daniel Council 62 courses 16 reviews Rating: 5.0 out of 5 2 years ago Great basics course, tim's team is stellar, using him for python at the moment as well, and took some of his java course in the past when i did work with it. Highly reccomend this if you are new to databases Show more Show less Instructors Tim Buchalka's Learn Programming Academy Professional Programmers and Teachers - 1.24M students 4.5 Instructor Rating 361,923 Reviews 1,254,942 Students 53 Courses The Learn Programming Academy was created by Tim Buchalka, a software developer with 35 years experience, who is also an instructor on Udemy, with over 1.24M+ students in his courses on Java, Python, Android, C# and the Spring framework. The Academy’s goal in the next three years, is to teach one million people to learn how to program. Apart from Tim’s own courses, which are all available here, we are working with the very best teachers, creating courses to teach the essential skills required by developers, at all levels. One other important philosophy is that our courses are taught by real professionals; software developers with real and substantial experience in the industry, who are also great teachers. All our instructors are experienced, software developers! Our team is busy creating new courses right now. Whether you are a beginner, looking to learn how to program for the very first time, or to brush up on your existing skills, or to learn new languages and frameworks, the Academy has you covered. Show more Show less Jon Avis - SQL Instructor IT Systems Engineer and SQL Instructor 4.5 Instructor Rating 17,450 Reviews 75,823 Students 2 Courses Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Systems Engineer. This has allowed me to become an expert in SQL, Databases, Unix, Shell Scripting and coding in multiple languages. Part of my role as a Systems Engineer is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6776f26baff05427',m:'c5eec44c4bb6855bc1f41160ed592c286180e407-1627735769-1800-AR1cMhKcOwbi536tM1WBtEGkX6ZZIxUtJOUjNeGP3gA74VafEc7DOfN5Mxna9eQbIXAVM31Vk2A+S44XaeRRwZHjPzqMXZkSS0Mo+FnilSv/FuONtvj9ukrXaal6ndPGvtVh4lIsbGowry9PAGQBUW54XmMZBBXoswbczW8iKxEQ',s:[0x037bff3fbb,0x0e8c8e1a06],}})();
  3. In-depth knowledge of database design will give students an edge over other applicants. Curated for the Udemy Business collection Course content 14 sections • 122 lectures • 7h 51m total length Expand all sections Course Introduction 2 lectures • 5min Welcome to the Course Preview 01:28 Syllabus Explanation 03:42 Installation and Setup 8 lectures • 1hr 1min Section Introduction 00:41 Databases, SQL and MySQL 03:08 Relational Database Management System 02:18 MySQL Installation for Windows Preview 15:00 MySQL Installation for Mac 12:17 MySQL Installation for Linux 11:07 MySQL Workbench Overview 13:13 Create Database Preview 03:23 Data Definition Language 7 lectures • 26min Section Introduction 01:32 Data Types Preview 06:34 Primary and Foreign Keys 02:53 Creating the Coffee Store Database 08:54 Modifying Tables: Adding and Removing Columns 03:08 Deleting Tables 01:28 Truncating Tables 01:39 More On Alter Table 9 lectures • 39min Section Introduction 01:25 Creating Our Test Database 05:30 Add and Remove Primary Key 05:25 Add and Remove Foreign Key 04:56 Add Unique Constraint 03:25 Change Column Name 03:15 Change Column Data Type 04:44 Exercise 1 01:30 Solution 1 08:27 Data Manipulation Language 5 lectures • 18min Section Introduction 00:50 Inserting Data Into Tables Preview 05:37 Updating Data in Tables 06:07 Deleting Data from Tables 02:49 Completing the Coffee Store Database 02:38 Selecting from a Table 18 lectures • 58min Section Introduction 01:14 Select Statement 01:46 Where Clause Preview 04:53 Using Inequality Symbols 03:03 Null Values 03:10 Exercise 1 01:06 Solution 1 03:55 In, Not In 03:44 Between 04:04 Like 04:52 Order By 06:19 Exercise 2 00:55 Solution 2 04:23 Distinct Preview 05:11 Limit 02:56 Column Name Alias 02:03 Exercise 3 00:50 Solution 3 03:45 Selecting From Multiple Tables 8 lectures • 33min Section Introduction 01:08 What Are Joins? 03:08 Inner Join 08:55 Left Join 05:23 Right Join 03:15 Joining more than Two Tables 04:33 Exercise 1 01:06 Solution 1 05:55 Database Design 10 lectures • 40min Section Introduction 01:23 Normalization - What is it? Preview 05:23 1st Normal Form (1NF) 03:30 2nd Normal Form (2NF) 06:27 3rd Normal Form (3NF) 09:30 Relationships 01:05 Relationships - One to One 02:30 Relationships - One to Many 02:00 Relationships - Many to Many 04:00 Constraints 03:53 Creating a Cinema Booking System Database 10 lectures • 41min Section Introduction 01:11 Database Schema Overview 07:26 Create Films Table 04:55 Create Customers Table 02:53 Create Rooms Table 02:19 Create Screenings Table 04:45 Create Seats Table Preview 03:53 Create Bookings Table 03:52 Create Reserved_Seat Table 04:35 Insert the Data 05:22 Aggregate Functions 12 lectures • 34min Section Introduction 00:41 What are Aggregate Functions 02:30 Count 02:38 Sum 02:36 Min and Max 02:39 Average Preview 02:09 Exercise 1 00:46 Solution 1 04:09 Grouping Data 08:52 Having Clause 01:44 Exercise 2 00:44 Solution 2 04:11 4 more sections Requirements A PC (Windows or Linux) or Mac is required No prior knowledge of Databases, SQL or MySQL is needed. Description Have you heard that database skills are essential for developers to be skilled in and understand? Are you wanting to understand SQL and databases in general, but don't know where to start? Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn. Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases. Whatever the reason you have arrived here, this course will... Help you understand and apply SQL with MySQL, including Database Design and Data Analysis. Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities. Key concepts you will learn and work with in this course. SQL (Structured Query Language - very much an in-demand technology). MySQL (one of the worlds most popular and widely used databases). Database Design Data Analysis The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy. You will struggle to find another MySQL course that has a section on this. This section alone, will give you a huge edge over other applicants for jobs. Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section. Creating, Modifying and Deleting Tables in a Database (DDL) Inserting, Updating and Deleting Data from Tables (DML) Select Queries Joins Aggregate Functions Subqueries Database Design Creating Databases. In addition there are installation videos covering MySQL on Windows, Mac or Linux. Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material. Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database. Why enrolling in this course is the best decision you can make. Become skilled as a database developer generally needs you to learn SQL, a database, and then database design. Often this will require multiple courses. However you learn all those topics, and data analysis in this one course. Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday. Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course. Essentially, you are learning from someone who has all the professional training, skills, and experience needed to teach you how to become proficient with SQL, MySQL and Database design as quickly as possible. If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you! After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design. The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities. SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course. Your new job or consulting opportunity awaits! Why not get started today? Click the Signup button to sign up for the course! Who this course is for: Anyone who wants to learn how to use SQL and MySQL. Show more Show less Featured review Daniel Council 62 courses 16 reviews Rating: 5.0 out of 5 2 years ago Great basics course, tim's team is stellar, using him for python at the moment as well, and took some of his java course in the past when i did work with it. Highly reccomend this if you are new to databases Show more Show less Instructors Tim Buchalka's Learn Programming Academy Professional Programmers and Teachers - 1.24M students 4.5 Instructor Rating 361,923 Reviews 1,254,942 Students 53 Courses The Learn Programming Academy was created by Tim Buchalka, a software developer with 35 years experience, who is also an instructor on Udemy, with over 1.24M+ students in his courses on Java, Python, Android, C# and the Spring framework. The Academy’s goal in the next three years, is to teach one million people to learn how to program. Apart from Tim’s own courses, which are all available here, we are working with the very best teachers, creating courses to teach the essential skills required by developers, at all levels. One other important philosophy is that our courses are taught by real professionals; software developers with real and substantial experience in the industry, who are also great teachers. All our instructors are experienced, software developers! Our team is busy creating new courses right now. Whether you are a beginner, looking to learn how to program for the very first time, or to brush up on your existing skills, or to learn new languages and frameworks, the Academy has you covered. Show more Show less Jon Avis - SQL Instructor IT Systems Engineer and SQL Instructor 4.5 Instructor Rating 17,450 Reviews 75,823 Students 2 Courses Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Systems Engineer. This has allowed me to become an expert in SQL, Databases, Unix, Shell Scripting and coding in multiple languages. Part of my role as a Systems Engineer is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6776f26baff05427',m:'c5eec44c4bb6855bc1f41160ed592c286180e407-1627735769-1800-AR1cMhKcOwbi536tM1WBtEGkX6ZZIxUtJOUjNeGP3gA74VafEc7DOfN5Mxna9eQbIXAVM31Vk2A+S44XaeRRwZHjPzqMXZkSS0Mo+FnilSv/FuONtvj9ukrXaal6ndPGvtVh4lIsbGowry9PAGQBUW54XmMZBBXoswbczW8iKxEQ',s:[0x037bff3fbb,0x0e8c8e1a06],}})();