❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [August 13th, 2023]
Skills and Knowledge Acquired:
This course will provide learners with the skills and knowledge to confidently use SQL, understand MySQL, and be skilled in database design. Learners will gain an understanding of key concepts such as Structured Query Language (SQL), MySQL, Database Design, Data Analysis, DDL (Creating, Modifying and Deleting Tables in a Database), DML (Inserting, Updating and Deleting Data from Tables), Select Queries, Joins, Aggregate Functions, Subqueries, and Database Design. Additionally, learners will gain the ability to create databases and install MySQL on Windows, Mac, or Linux. Through exercises and video solutions, learners will be able to apply the concepts they have learned and gain a better understanding of the material.
Contribution to Professional Growth:
This course provides an opportunity for professional growth by teaching the essential skills needed to become proficient in SQL, MySQL, and Database Design. Through the course, students will learn key concepts such as DDL, DML, Select Queries, Joins, Aggregate Functions, Subqueries, and Database Design. Additionally, the course provides installation videos for MySQL on Windows, Mac, and Linux, as well as multiple exercises with video solutions to further help students understand the material. With the knowledge gained from this course, students will be able to confidently use SQL, have a solid understanding of MySQL, and be skilled in Database Design, which are all highly sought after skills in the job market.
Suitability for Further Education:
This course is suitable for preparing further education in SQL, MySQL, and Database Design. It covers key concepts such as Structured Query Language (SQL), MySQL, Database Design, Data Analysis, DDL, DML, Select Queries, Joins, Aggregate Functions, Subqueries, and Database Design. It also includes installation videos for MySQL on Windows, Mac, and Linux. With exercises and video solutions, this course provides a comprehensive overview of the topics and gives students the skills and knowledge they need to increase their job or consulting opportunities.
Course Syllabus
Course Introduction
Installation and Setup
Data Definition Language
More On Alter Table
Data Manipulation Language
Selecting from a Table
Selecting From Multiple Tables
Database Design
Creating a Cinema Booking System Database
Aggregate Functions
Subqueries
MySQL Functions - String Functions and Date Functions
Challenges
Extra Information - Source code, and other stuff