Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy Coaching CBT Cognitive Behavioral Therapy
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing Startup YouTube Marketing

IT & SoftwareOther IT & SoftwareSQL

The Complete SQL and MySQL Course - From Beginner to Expert

Learn the Basics of Managing Data with SQL - Basics, Transactions, Views, Pages and Stored Procedures
Bestseller
Rating: 4.2 out of 54.2 (829 ratings)
11,354 students
Created by Holczer Balazs
Last updated 3/2021
English
English [Auto]

What you'll learn

  • understand the basic concepts of databases
  • get a good grasp of SQL and MySQL queries
  • understand database management systems (DBMSs) and database languages
  • understand table manipulation
  • understand pages
  • understand views
  • understand strored procedures
  • understand the data structures (B trees and B+ trees) behind databases

Requirements

  • Internet connection

Description

In this course you can learn the fundamental basics of data management with SQL and MySQL. Learn everything that you will need to make queries with the most popular data manipulating programming language - SQL. This course is about SQL commands in the main. You will learn the basics of queries. Let's take a look at what you are going to learn in this course:

Section 1 - Setting up The Environment:

  • setting up the environment

  • installing MySQL server on Windows and MacOS

Section 2 - Database Theory

  • what are databases?

  • what are database management systems (DBMSs)?

  • what are database languages?

  • the data structures (B-trees) behind databases

  • procedural and non-procedural programming languages

Section 3 - Creating and Manipulating Tables

  • basic data types (integers, floating point numbers and characters)

  • enums and dates

  • how to create databases?

  • how to insert and remove items?

  • how to update existing items or database tables?

Section 4 - Basic SQL

  • basic SQL and MySQL commands

  • select, where and wildcards

  • logical operators

  • ORDER BY and GROUP BY commands

Section 5 - Multiple Tables

  • joining multiple database tables

  • inner join

  • left and right join

Section 6 - Database Normalization

  • what is database normalisation?

  • first normal form (NF1)

  • second normal form (NF2)

  • third normal form (NF3)

Section 7 - Subqueries:

  • advanced SQL and MySQL

  • what are subqueries?

  • correlated and non-correlated subqueries

Section 8 - Transactions

  • what is database locking?

  • the ACID principles?

  • COMMIT, ROLLBACK and SAVEPOINT

Section 9 - Views

  • what are views and why are they crucial?

  • creating views

  • updating views

  • dropping views

Section 10 - Indexes and Constraints

  • what are indexes and why to use them?

  • primary keys and foreign keys revisited

  • what are constraints?

Section 11 - Data Structures Behind Databases

  • what are pages?

  • the basic concept of paging in operating systems

  • external memory and internal memory

  • B tree data structure

  • B+ tree data structure

Section 12 - Stored Procedures

  • what are stored procedures?

  • variables

  • loops

  • conditional statements

Learning the fundamentals of SQL and MySQL is a good choice and puts a powerful tool at your fingertips. SQL is easy to learn as well as it has excellent documentations.

The most important fact about SQL that it is used in almost every field from software engineering to financial analysis so understanding the concepts and basic language features can prove to be very marketable.

Thanks for joining the course, let's get started!

Who this course is for:

  • This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

Instructor

Holczer Balazs
Software Engineer
Holczer Balazs
  • 4.5 Instructor Rating
  • 30,320 Reviews
  • 237,074 Students
  • 33 Courses

My name is Balazs Holczer. I am from Budapest, Hungary. I am qualified as a physicist. At the moment I am working as a simulation engineer at a multinational company. I have been interested in algorithms and data structures and its implementations especially in Java since university. Later on I got acquainted with machine learning techniques, artificial intelligence, numerical methods and recipes such as solving differential equations, linear algebra, interpolation and extrapolation. These things may prove to be very very important in several fields: software engineering, research and development or investment banking. I have a special addiction to quantitative models such as the Black-Scholes model, or the Merton-model.

Take a look at my website if you are interested in these topics!

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.