What Will You Learn?
The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.
Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.
About This Course
Provider: Youtube
Format: Online
Duration: 4 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: This is SQL and Database Course for Beginners
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: NA
Key Topics: SQL, JOIN, FUNCTION, UNION, TRIGGER
Topic Covered:
- What is a Database?
- Tables & Keys
- SQL Basics
- MySQL Windows Installation
- MySQL Mac Installation
- Creating Tables
- Inserting Data
- Constraints
- Update & Delete
- Basic Queries
- Company Database Intro
- Creating Company Database
- More Basic Queries
- Functions
- Wildcards
- Union
- Joins
- Nested Queries
- On Delete
- Triggers
- ER Diagrams Intro
- Designing an ER Diagram
- Converting ER Diagrams to Schemas
0 Comments