- Introduction
- Overview of SQL
- Database organization
- Row and Columns
- Data: Inserting, Updating and Deleting
- Joining queries across tables
- Data types
- The CREATE TABLE statement
- Numeric types
- Date and time types
- String & Enumeration types and SERIAL type alias
- Comparison, Logical and Arithmetic Operators
- Operator precedence
- The CASE statement and The IF function
- String comparisons
- Regular expressions and string concatenation
- Numeric conversions
- Trimming and padding
- Case conversion
- Substrings and Soundex
- Value functions
- Basic math and trigonometry
- Logarithms, radians and degrees
- String contactenation
- Quote marks
- Integer division
- Comments
- Conclusion
What you'll learn
- Learn the fundamentals of MySQL
- Learn how to use SQL with Python together
- Writing queries
- Creating and updating databases and tables
- Data types in MySQL
- Using MySQL built-in functions
- Working with string and mathematical functions
- Designing Databases
Description
Unlock the power of MySQL, a cornerstone in database management systems for small- to medium-sized web projects. Join us in this comprehensive course, where you'll embark on a journey through clear and concise tutorials, empowering you to create and manage your own MySQL database.
We'll start off exploring database fundamentals, as well as MySQL features. Students will learn the basics of MySQL that guide you through creating and maintaining a MySQL database of your own. We'll explores the basic syntax, using SQL statements to insert, update, and delete data from your tables.
We'll also cover creating a new database from scratch, as well as working with data types, operators, and string and mathematical functions. In addition, you will learn about the key differences between standard SQL and SQL as implemented by MySQL.
Dive into the fundamentals as we explore the basic syntax of MySQL, mastering the art of using SQL statements to seamlessly insert, update, and delete data from your tables. Take command of your database by learning to create one from scratch, and gain proficiency in handling data types, operators, and leveraging string and mathematical functions for efficient data manipulation.
Navigate the intricacies of MySQL with ease as we highlight the key differences between standard SQL and MySQL's unique implementation. Whether you're a beginner seeking a solid foundation or an intermediate user aiming to refine your skills, this course equips you with the knowledge and practical insights needed to harness the full potential of MySQL for your web projects. Join us and elevate your database management expertise!
Other Courses
Basics of Reading the Quran (Qaidat Nuraniyah)
Simple Tajweed using the Qaida Nuraniyah Book
From Intermediate to Native Learn English In just 20 videos
Learn with methods used by polyglots and different technics that will help you learn a language in an exponential way
Digital Marketing: Target Audience, STP & Brand Storytelling
Identify your target audience and market & Leverage an effective communication strategy to hook your audience in
Introduction to Computer Organization
Master from scratch basic computer organization and number representation to ace computer architecture exams!
About the instructors
- 4.38 Calificación
- 2283 Estudiantes
- 2 Cursos
Flow Learning
Programmer & Microsoft Educators
Through my company, Flow Learning, we provide educational material on programming and Microsoft products. I've been developing software professionally for more than 20 years in domains as diverse as browser development, web services, online payments, instant messaging, for 3D distributed game platforms, IoT sensors and virtual reality. My technical expertise includes databases, low-level networking, distributed systems, user interfaces, and general software development life cycle.
Student feedback
Course Rating
Reviews
Excellent Course! Ton of Useful info
Overall great course!
Lots of good info on MySQL and also how to use SQL with Python
Not bad, basic knowledge. Only theory, without any practice and questions. Last point of the course "Designing Databases" is absent.
excellent intro to mysql