SQL-Database
SQL-Database - Image 2

SQL-Database

Price range: $105.00 through $305.00

SKU: N/A Categories: , Tags: , ,

Description

SQL beginning to Intermediate

SQL (Structure Query Language) Syllabus

  • Basics of SQL

  • Learn and Setup Environment (XAMPP)

  • Operation using SQL

  • Joins

  • Basic Performance tuning

  • Sub Queries

  • Data normalization

  • Stored Procedure

  • Views/Macro etc

  • ETL

  • Data cleansing

  • Data Validation

  • PHP Rest API -CRUD using JSON data

Hands on Project(s) – TBD

Duration – 4 Months,

Classes will be in the weekends inA

Details:

1. Set up a model
a.Logical Model
b. Physical model
c. Example data?
Hospital management system
admin/user/doctor
find doctor and thier prfile
take appointment
preemptive measure based on your heart/pressure
results of test and prescription
access /refill prescription
doctor can see patients pofile , symptom and
request blood donation info along with demographic
preventive care allergy

2. Adhoc Question
Joins predefined
Relationships

What if/Why /Results
DSS

Results: Reports:
a. Adhoc
b. Predefined
c. Performance

Power Bi
Python
mySQL –> SQL
plot/dash board

Conclusion

Database development
Reporting
ETL (Extract Transform and Load)
ELT
Data Validation

Project:
Hospital Management
or
Covid Data (rest api/flat file )
Mapping document
load into mySQL (validate/normalize, business rule)
Number of death, sql/power bi
Report
Preventive decision using profiling

 

Additional information

Choose your plan:

Monthly Payment-3 months, One time Payment

Reviews

There are no reviews yet.

Be the first to review “SQL-Database”

Related products