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 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 Show less Continue reading...
