SQL Programming and MySQL Developer Certification Training
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
Course content
- Preview30:09
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
Instructor
![Uplatz Training](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 5,948 Reviews
- 301,925 Students
- 97 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.