Basics of Database Design & Development
Basics of Database Design & Development, available at $29.99, has an average rating of 4.29, with 33 lectures, based on 794 reviews, and has 151931 subscribers.
You will learn about Can make better database using standard principles Prepare better database from scratch Feel comfortable to write database design in resume This course is ideal for individuals who are Who wanna learn basic concepts of Database Design or Who wanna learn advanced concepts of Database Design It is particularly useful for Who wanna learn basic concepts of Database Design or Who wanna learn advanced concepts of Database Design.
Enroll now: Basics of Database Design & Development
Summary
Title: Basics of Database Design & Development
Price: $29.99
Average Rating: 4.29
Number of Lectures: 33
Number of Published Lectures: 32
Number of Curriculum Items: 33
Number of Published Curriculum Objects: 32
Original Price: $119.99
Quality Status: approved
Status: Live
What You Will Learn
- Can make better database using standard principles
- Prepare better database from scratch
- Feel comfortable to write database design in resume
Who Should Attend
- Who wanna learn basic concepts of Database Design
- Who wanna learn advanced concepts of Database Design
Target Audiences
- Who wanna learn basic concepts of Database Design
- Who wanna learn advanced concepts of Database Design
Database design is the process of producing a detailed data model of a database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design. Through this tutorial we will try to teach the basis components of database design and explains how to make a good database design.
Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know what these rules are, but more importantly is to know why these rules exist, otherwise you will tend to make mistakes!
Contents of this course
- Introduction and Database Overview
- Understanding SQL Types of commands
- Tables, Views and Stored Procedures
- Database constraints
- Database Normalization
- ER Diagram
- Relational Database Management System
- NoSQL
- RDBMS vs. NoSQL
Course Curriculum
Chapter 1: Basics of Database Design
Lecture 1: Introduction and Database Overview
Lecture 2: Understanding SQL Types of Commands
Lecture 3: Tables, Views and Stored Procedures
Lecture 4: Database Constraints
Lecture 5: Database Normalization
Lecture 6: ER Diagram
Lecture 7: Relational Database Management System
Lecture 8: NoSQL
Lecture 9: RDBMS vs. NoSQL
Chapter 2: Bonus Section: Learning MySQL Development
Lecture 1: Introduction to MySQL
Lecture 2: Data types in MySQL Part – 1
Lecture 3: Data types in MySQL Part – 2
Lecture 4: XAMPP Installation
Lecture 5: MySQL Workbench Installation
Lecture 6: Creating with PHPMyAdmin
Lecture 7: Creating Database & Table through MySQL Workbench
Lecture 8: Design and Accounts
Lecture 9: Import and Export
Lecture 10: Introduction to MySQL Queries and SELECT Clause
Lecture 11: Inserts Updates and Deletes
Lecture 12: Storage Engines
Lecture 13: Mastering Table Joining: Part 1
Lecture 14: Mastering Table Joining: Part 2
Lecture 15: Working with Math and Strings: Part 1
Lecture 16: Working with Math and Strings: Part 2
Lecture 17: Group By: Part 1
Lecture 18: Group By: Part 2
Chapter 3: Bonus Section: Working with MongoDB (NoSQL Database)
Lecture 1: MongoDB Installation
Lecture 2: Basic Queries: Part 1
Lecture 3: Basic Queries: Part 2
Lecture 4: Advanced Queries: Part 1
Lecture 5: Advanced Queries: Part 2
Instructors
-
Creative Online School
Creative & Engaging Online Courses
Rating Distribution
- 1 stars: 25 votes
- 2 stars: 42 votes
- 3 stars: 159 votes
- 4 stars: 266 votes
- 5 stars: 302 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Learn to Fix iPhones and Start a Delivery Service
- Make Money With High Ticket Sales (Even If You're A Newbie)
- Masterclass: Start a Profitable Internet Cafe Business
- Google Analytics for Shopify: A Complete Step-by-Step Guide
- Creating Amazing Property Video (Using Your Smartphone)
- The Fundamentals of Business Intelligence (BI)
- Outsource Easier!
- Amazon SEO & Listing Optimization SECRETS to Double Sales
- Strategic Workforce Planning: A Fundamental Beginner's Guide
- Start A Start Hustle And Build A Second Income
- SPA RETAIL 101 – how to create a sales culture in your Spa?
- Beyond Upwork: How to Find Freelance Clients Outside Upwork
- How to manage event venue
- Ultimate Amazon FBA Mastery Course – Start With Any Budget
- The Gaming Youtube Masterclass
- Power BI Business User
- PMI – PgMP | 2024 Real Practice Exams (1150 Questions)
- Six Sigma: Certified Lean Six Sigma Green Belt | Accredited
- International B2B Trade Shows Management
- Project Management Guide for Human Resources (HR)