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 Typescript HTML5 PHP
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 Data Analysis Data Warehouse Blockchain Business Intelligence
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 SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Google Analytics Email Marketing Startup Advertising Strategy

DevelopmentDatabase Design & DevelopmentSQL

SQL Programming and MySQL

Learn SQL Programming with MySQL Database from scratch. SQL Commands, Functions, Expressions, Joins, Procedures, Views.
Rating: 4.4 out of 54.4 (276 ratings)
24,568 students
Created by Uplatz Training
Last updated 2/2021
English
English [Auto]

What you'll learn

  • Fundamentals of SQL (Structured Query Language)
  • Prepare for SQL Certification
  • Become an SQL Developer / Application Developer / DBA
  • Basics of Databases – Data Models and basic terminologies
  • What is DBMS? Advantages and disadvantages of DBMS
  • What is SQL? What can SQL do?
  • SQL Process, ACID Properties, ER Model
  • SQL Best Practices, Database Normalization
  • Introduction to SQL - SQL Commands, SQL Constraints, Types of Keys, MySQL Hands-on
  • SQL Basic Commands with demonstration
  • Aggregation Functions, Regular Expression Functions
  • Exists, Not Exists, Create Table like, Case when, NULL Functions
  • SQL String and Numerical Functions
  • Date Functions
  • SQL Joins – Introduction and demonstration
  • Introduction MySQL Workbench
  • Stored Procedures and Views

Requirements

  • Enthusiasm and determination to make your mark on the world!

Description

A warm welcome to the SQL Programming and MySQL course by Uplatz.


What is SQL?

Structured Query Language (SQL) is a standard language for storing, manipulating and retrieving data in databases. It is used to manipulate data in relational databases.

In simple words, SQL is the standard programming language used to design, create and manage relational databases. Relational systems are made up of a set of tables containing rows and columns of data. Each column in a table represents a category of data, such as a customer name or address, and each row contains a data value for the intersecting column. Some of the major ways in which SQL is used in conjunction with a relational database are for the purposes of storing, retrieving, and manipulating data stored in a relational database.

We live in a data-driven world where people search through data to find insights to form the basis for strategy, marketing, operations, and implementation. There are a lot of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill for anyone interested including data scientists, data analysts, data engineers, business analysts, consultants, and so on. Used since the 1970s, SQL will be a technology staple for the foreseeable future. It's a universal coding language that will help you transition into learning other computer languages, including JavaScript and Python.


Features of SQL

  • Modifying database table and index structures

  • Adding, updating and deleting rows of data

  • Retrieving information from a database for transaction processing and analytics

  • Generating tables and other database projects


What is MySQL?

MySQL is a relational database management system based on SQL, which is the popular language for accessing and managing the records in the database. MySQL is open-source and free software under the GNU license. It is supported by Oracle Company. MySQL is currently the most popular database management system software used for managing the relational database. It is open-source database software, which is supported by Oracle Company. It is fast, scalable, and easy to use database management system in comparison with Microsoft SQL Server and Oracle Database. It is commonly used in conjunction with PHP scripts for creating powerful and dynamic server-side or web-based enterprise applications.

The core of the MySQL database is the MySQL Server. This server is available as a separate program and responsible for handling all the database instructions, statements, or commands. The working of MySQL database with MySQL Server is given below:

  1. MySQL creates a database that allows you to build many tables to store and manipulate data and defining the relationship between each table.

  2. Clients make requests through the GUI screen or command prompt by using specific SQL expressions on MySQL.

  3. Finally, the server application will respond with the requested expressions and produce the desired result on the client-side.

The developers can use any MySQL GUI. The chosen GUI should be lighter and user-friendly to make your data management activities faster and easier. Some of the most widely used MySQL GUIs are MySQL Workbench, SequelPro, DBVisualizer, Navicat DB Admin Tool, etc.

MySQL is a Relational Database Management System (RDBMS) software that provides many functionalities, some of the key ones are as follows:

  • MySQL allows us to implement database operations on tables, rows, columns, and indexes.

  • It defines the database relationship in the form of tables (collection of rows and columns), also known as relations.

  • It provides the Referential Integrity between rows or columns of various tables.

  • MySQL allows us to updates the table indexes automatically.

  • MySQL uses many SQL queries and combines useful information from multiple tables for the end-users.

  • It is an open-source database, so you don't have to pay a single penny to use it.

  • It is a very powerful program that can handle a large set of functionality of the most expensive and powerful database packages.

  • MySQL is customizable because it is an open-source database, and the open-source GPL license facilitates programmers to modify the SQL software according to their own specific environment.

  • It is quicker than other databases, so it can work well even with the large data set.

  • MySQL supports many operating systems with many languages like PHP, PERL, C, C++, JAVA, etc.

  • MySQL uses a standard form of the well-known SQL data language.

  • It is very friendly with PHP, the most popular language for web development.

  • MySQL supports large databases, up to 50 million rows or more in a table.

MySQL follows the Client-Server Architecture. This model is designed for the end-users called clients to access the resources from a central computer known as a server using network services. Here, the clients make requests through a graphical user interface (GUI), and the server will give the desired output as soon as the instructions are matched. The process of MySQL environment is the same as the client-server model.


Uplatz provides this comprehensive SQL Programming and MySQL training. In this course, you will learn how to select data from multiple tables using both inner and outer joins and unions, understand how to create subqueries to develop more complex retrieval capabilities, and use DDL to create your own database and to populate tables. In addition, learn about database design, primary keys, foreign keys, indexes, table relationships, referential integrity, and normalization/denormalization techniques. This course prepares you to work with any relational database, such as Oracle, DB2, SQL Server, Sybase, or MySQL.

With this SQL programming course, you'll be able to understand the key concepts of Structured Query Language (SQL) and will gain a solid working knowledge of this powerful and universal database programming language.


In this SQL Programming and MySQL Developer course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. You'll get to know about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure. Then you'll discover how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables. Learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns. You will gain knowledge on how to gather significant statistics from data using aggregate functions, and see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.

This SQL Programming and MySQL course will show you how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL. You’ll learn to use Structured Query Language (SQL) to extract and analyze data stored in databases. You’ll first learn to extract data, join tables together, and perform aggregations. Then you’ll learn to do more complex analysis and manipulations using subqueries, temp tables, and window functions. By the end of the course, you’ll be able to write efficient SQL queries to successfully handle a variety of data analysis tasks.

By the end of this SQL course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database. This SQL training will help you learn SQL concepts and their implementation along with deep-dive into SQL queries, so that you can become a successful SQL developer. You will find out what are SQL commands, syntax, data types, operators, creation & dropping of tables, inserting and selecting queries.

The MySQL part of the course includes all topics of MySQL database that provides for how to manage database and to manipulate data with the help of various SQL queries. These queries are: insert records, update records, delete records, select records, create tables, drop tables, etc. Learn to use SQL to select, update, insert, and delete data from database tables, and acquire hands-on skills on MySQL database.



SQL Programming and MySQL - Course Syllabus


1. Basics of Databases

  • Data Models and basic terminologies

  • Advantages and disadvantages of DBMS

2. SQL Basic Understanding

  • What is SQL?

  • What SQL Can do?

  • SQL Process

  • ACID Properties

  • What is ER Model?

  • Best Practices

  • Database Normalization

3. Introduction to SQL

  • SQL Commands

  • SQL Constraints

  • Types of Keys

  • MySQL Hands-on

4. SQL Basic Commands with demonstration

5. Basics and Aggregation Functions

6. Regular Expression Functions

7. SQL Comparison Clauses

  • exists

  • not exists

  • create table like

  • case when

  • NULL Functions

8. SQL String Functions

9. SQL Numerical Function

10. Introduction to Date Functions

11. SQL Joins – Introduction and demonstration

12. Introduction MySQL Workbench

13. Stored Procedures and Views

Who this course is for:

  • SQL Developers and SQL Database Developers
  • Application Developers and Back End Programmers
  • Data Analysts and Support Analysts (SQL)
  • Database Administrators and MySQL DBAs
  • Newbies and Beginners aspiring for a career as Database/SQL Developer
  • MySQL Developers
  • Oracle, SQL, ERP Application Support Analysts
  • Anyone interested to learn SQL programming
  • SQL Analysts
  • Marketing/Financial/Operational Analysts
  • ETL Developers and Data Integration Programmers
  • Data warehousing Professionals
  • Full Stack Web Developers - SQL
  • Backend Developers Java Spring SQL
  • Data Consultants and Business Consultants
  • PHP Developers (MySQL)
  • Database Analysts & Database Tuning Experts
  • Cloud Engineers - AWS, Azure, Google, IBM
  • Database Architects & Solution Architects

Instructor

Uplatz Training
Fastest growing Global IT Training Provider
Uplatz Training
  • 3.7 Instructor Rating
  • 11,244 Reviews
  • 377,102 Students
  • 152 Courses

Uplatz is UK-based leading IT Training provider serving students across the globe. Our uniqueness comes from the fact that we provide online training courses at a fraction of the average cost of these courses in the market.

Over a short span of 3 years, Uplatz has grown massively to become a truly global IT training provider with a wide range of career-oriented courses on cutting-edge technologies and software programming.

Our specialization includes Data Science, Data Engineering, SAP, Oracle, Salesforce, AWS, Microsoft Azure, Google Cloud, IBM Cloud, SAS, Python, R, JavaScript, Java, Full Stack Web Development, Mobile App Development, BI & Visualization, Tableau, Power BI, Spotfire, Data warehousing, ETL tools, Informatica, IBM Data Stage, Digital Marketing, Agile, DevOps, and more.

Founded in March 2017, Uplatz has seen phenomenal rise in the training industry starting with an online course on SAP FICO and now providing training on 5000+ courses across 103 countries having served 300,000 students in a period of just 3 years.

Uplatz's training courses are highly structured, subject-focused, and job-oriented with strong emphasis on practice and assignments. Our courses are designed and taught by more than a thousand highly skilled and experienced tutors who have strong expertise in their areas whether it be AWS, Azure, Adobe, SAP, Oracle, or any other technology or in-demand software.

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
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.