Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 2.32 GB | Duration: 8h 1m

What is DBMS?

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 teologies

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 deteation to make your mark on the world!

Description

SQL Programming and MySQL - Course Syllabus

1. Basics of Databases

Data Models and basic teologies

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 Bners 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 Eeers - AWS, Azure, Google, IBM

Database Architects & Solution Architects



DOWNLOAD
uploadgig