Learn SQL Programming with MySQL Database from scratch. SQL Commands, Functions, Expressions, Joins, Procedures, Views.
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
-
Stored Procedures and Views
Requirements
-
Enthusiasm and determination to make your mark on the world!
Description
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
Course content
11 sections • 14 lectures • 8h 1m total length
- Basics of Database
- SQL Basic Understanding
- Introduction to SQL
- SQL Basic Commands
- SQL Basic and Aggregate Functions
- SQL Regular Expressions
- SQL Comparison Clauses
- SQL String Functions
- SQL Numeric Functions and Data Functions
- SQL Joins Introduction and Demonstration
- MySQL Workbench, Procedures and Views
Created by: Uplatz Training (Fastest growing Global IT Training Provider)
Last updated 10/2020
English
English [Auto]
2.3 GB (Direct Download Available)
New
24,474 students
https://www.udemy.com/course/sql-programming-and-mysql-developer-training/
Download link
