SQL for Beginners Learn SQL using MySQL and Database Design
What you’ll learn
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.
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 DesignData AnalysisThe 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 QueriesJoinsAggregate FunctionsSubqueriesDatabase DesignCreating 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!
Overview
Section 1: Course Introduction
Lecture 1 Welcome to the Course
Lecture 2 Syllabus Explanation
Section 2: Installation and Setup
Lecture 3 Section Introduction
Lecture 4 Databases, SQL and MySQL
Lecture 5 Relational Database Management System
Lecture 6 MySQL Installation for Windows
Lecture 7 MySQL Installation for Mac
Lecture 8 MySQL Installation for Linux
Lecture 9 MySQL Workbench Overview
Lecture 10 Create Database
Section 3: Data Definition Language
Lecture 11 Section Introduction
Lecture 12 Data Types
Lecture 13 Primary and Foreign Keys
Lecture 14 Creating the Coffee Store Database
Lecture 15 Modifying Tables: Adding and Removing Columns
Lecture 16 Deleting Tables
Lecture 17 Truncating Tables
Section 4: More On Alter Table
Lecture 18 Section Introduction
Lecture 19 Creating Our Test Database
Lecture 20 Add and Remove Primary Key
Lecture 21 Add and Remove Foreign Key
Lecture 22 Add Unique Constraint
Lecture 23 Change Column Name
Lecture 24 Change Column Data Type
Lecture 25 Exercise 4.1
Lecture 26 Solution 4.1
Section 5: Data Manipulation Language
Lecture 27 Section Introduction
Lecture 28 Inserting Data Into Tables
Lecture 29 Updating Data in Tables
Lecture 30 Deleting Data from Tables
Lecture 31 Completing the Coffee Store Database
Section 6: Selecting from a Table
Lecture 32 Section Introduction
Lecture 33 Select Statement
Lecture 34 Where Clause
Lecture 35 Using Inequality Symbols
Lecture 36 Null Values
Lecture 37 Exercise 6.1
Lecture 38 Solution 6.1
Lecture 39 In and Not In
Lecture 40 Between
Lecture 41 Like
Lecture 42 Order By
Lecture 43 Exercise 6.2
Lecture 44 Solution 6.2
Lecture 45 Distinct
Lecture 46 Limit
Lecture 47 Column Name Alias
Lecture 48 Exercise 6.3
Lecture 49 Solution 6.3
Section 7: Selecting From Multiple Tables
Lecture 50 Section Introduction
Lecture 51 What Are Joins?
Lecture 52 Inner Join
Lecture 53 Left Join
Lecture 54 Right Join
Lecture 55 Joining more than Two Tables
Lecture 56 Exercise 7.1
Lecture 57 Solution 7.1
Lecture 58 Creating Entity Relationship diagrams in Workbench
Section 8: Database Design
Lecture 59 Section Introduction
Lecture 60 Normalization – What is it?
Lecture 61 1st Normal Form (1NF)
Lecture 62 2nd Normal Form (2NF)
Lecture 63 3rd Normal Form (3NF)
Lecture 64 Relationships
Lecture 65 Relationships – One to One
Lecture 66 Relationships – One to Many
Lecture 67 Relationships – Many to Many
Lecture 68 Constraints
Section 9: Creating a Cinema Booking System Database
Lecture 69 Section Introduction
Lecture 70 Database Schema Overview
Lecture 71 Create Films Table
Lecture 72 Create Customers Table
Lecture 73 Create Rooms Table
Lecture 74 Create Screenings Table
Lecture 75 Create Seats Table
Lecture 76 Create Bookings Table
Lecture 77 Create Reserved_Seat Table
Lecture 78 Insert the Data
Section 10: Aggregate Functions
Lecture 79 Section Introduction
Lecture 80 What are Aggregate Functions
Lecture 81 Count
Lecture 82 Sum
Lecture 83 Min and Max
Lecture 84 Average
Lecture 85 Exercise 10.1
Lecture 86 Solution 10.1
Lecture 87 Grouping Data
Lecture 88 Having Clause
Lecture 89 Exercise 10.2
Lecture 90 Solution 10.2
Section 11: Subqueries
Lecture 91 Section Introduction
Lecture 92 What Are Subqueries
Lecture 93 Non-Correlated Subqueries: Part 1
Lecture 94 Non-Correlated Subqueries: Part 2
Lecture 95 Correlated Subqueries
Lecture 96 Exercise 11.1
Lecture 97 Solution 11.1
Section 12: MySQL String and Data Functions
Lecture 98 Section Introduction
Lecture 99 What Are MySQL Functions?
Lecture 100 Concatenation
Lecture 101 Substrings
Lecture 102 Upper and Lower Case
Lecture 103 Exercise 12.1
Lecture 104 Solution 12.1
Lecture 105 Date Function
Lecture 106 Month Function
Lecture 107 Year Function
Lecture 108 Exercise 12.2
Lecture 109 Solution 12.2
Section 13: Challenges
Lecture 110 Section Introduction
Lecture 111 Challenge One
Lecture 112 Solution One
Lecture 113 Challenge Two
Lecture 114 Solution Two
Lecture 115 Challenge Three
Lecture 116 Solution Three
Lecture 117 Challenge Four
Lecture 118 Solution Four
Lecture 119 Challenge Five
Lecture 120 Solution Five
Lecture 121 Challenge Six
Lecture 122 Solution Six
Lecture 123 Should I break normalisation?
Section 14: Extra Information – Source code, and other stuff
Lecture 124 Source codes
Lecture 125 Bonus Lecture and Information
Anyone who wants to learn how to use SQL and MySQL.
Course Information:
Udemy | English | 8h 24m | 2.97 GB
Created by: Tim Buchalka’s Learn Programming Academy
You Can See More Courses in the Developer >> Greetings from CourseDown.com