課程介紹

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 tr

…[更多細節]

哪些人適合這堂課？

• Who wanna learn basic concepts of Database Design
• Who wanna learn advanced concepts of Database Design

學習目標

• Can make better database using standard principles
• Prepare better database from scratch
• Feel comfortable to write database design in resume

課程介紹

Whichever database application you use does not matter! This course will cover design concepts for all relational database management systems. This course is designed for those who want to download this course or watch it ad free. This is a course fo

…[更多細節]

哪些人適合這堂課？

• Anyone working with relational databases. This course starts from the beginning. No prior knowledge is required but will of course make things easier and more clear to you
• This course is perfect for anyone with an intermediate level of skill. We will be discussing all of the major concepts in database design and this course will help you refresh your skills or bring you to the advanced level

學習目標

• Learn the definition of relations, tuples, attributes, and over one hundred other vocabulary words!
• Learn all of the types of relationships and how to properly design them all within a database. This includes one to one, one to many, and many to many. You will also learn about the difference between a parent table and a child table
• Learn about all of the types and categories of keys including superykeys, candidate keys, primary keys, alternate keys, natural keys, surrogate keys, simple keys, compound keys, composite keys, and foreign keys
• Learn database normalization. We will be learning the first 3 normal forms of database normalization. This will reduce redundant and incorrect data as well as protect our database integrity
• Learn about data, data types, foreign key constraints, and other important concepts used to create the best database
• Learn to design a database from beginning to end!

課程介紹

Database design is one of the most important aspects of Web programming. Successful implementation of any system with Data Storage will always need proper database design. In order to create great database design you will not only have to master the

…[更多細節]

哪些人適合這堂課？

• Web Developers and Database designers

學習目標

• To Learn Database design Process
• To Learn Database Normalization
• To Learn Database development using MySQL
• To Master SQL
• To Learn to use PHP with MySQL

課程介紹

This course is offered to allow for download and anytime use as well as for anybody who wishes to support my YouTube channel.

About this course:

This is an introductory course that dives into the basics of many topics in databasing, including:

Dat

…[更多細節]

哪些人適合這堂課？

• This course will work for any beginner who has never worked with databases or spreadsheets.
• This course is perfect for those with a small skill set in computers, but need assistance in fully grasping technical aspects of data management.
• This course is perfect for those in almost any databasing course in college.
• This course will work for tech geeks who need some refreshers or a broader view of database technology.

學習目標

• By the end of the course, you will be able to Design a database, Build a database and Upkeep a database.
• Manage Data in a organized, non-redundant, speedy method.
• You will be able to recognize potential Database faults that could lead to disaster and fix them through Foreign Key Constrains, proper MySQL Datatypes, storage engines, and more.
• You will understand the back end of a website in areas such as retrieving data from users and data encryption.
• You will have an awesome skill to add to any Résumé.
• Much more.

課程介紹

Learn how to design a proper relational database with this course!

This course will teach you how to create an effective relational database design using proven concepts and industry knowledge.

Effective database designs will help make systems fast

…[更多細節]

哪些人適合這堂課？

• Software developers or web developers
• Students wishing to know more about database design
• Those looking to get into a database role

學習目標

• Learn how to design a relational database
• Learn what normalisation is, and each of the three normal forms
• Start designing a database from nothing
• Learn how to identify tables, and how to create relationships

課程介紹

Are you interested in a career in Data Science or Data Analytics?

In that case, inevitably you are going to encounter databases in your work.

But how do you interact with databases?

The answer is simple: SQL 

SQL stands for Structured Query Langu

…[更多細節]

哪些人適合這堂課？

• Anybody who wants to learn PostgreSQL
• Anybody who wants to better understand how databases work
• Anybody who wants to enhance their Data Science career

學習目標

• Create basic SQL Queries
• Create advanced SQL Queries
• Create Left, Right, Inner and Full Outer joins
• Create new tables, alter existing tables in Databases
• Normalize Databases
• Understand database design
• Understand first, second and third normal form schemas

課程介紹

Are you new to Databases and Database Design? Do you feel like you’re left guessing how to properly design the database for your project? ..Or maybe you just want to add this on-demand skill to your CV.

Our Database Design Beginner’s Tutorial is her

…[更多細節]

哪些人適合這堂課？

• Aspiring Data Analysts
• Non-technical Professionals looking to integrate Databases in their projects
• College Graduates who want to land a new job as Software Developers
• Developers wanting to learn more about Database Design
• Entrepreneurs wanting to better use data in their business
• Students just getting started with databases

學習目標

• Learn what a database is
• Learn how databases work and why are they important
• Learn data modeling and the 3 levels of relational database design
• Learn what are the steps to create a sound database design
• Learn what database normalization is and how to apply 1NF, 2NF and 3FN in database design
• Learn how to build database relationships: one-to-one, many-to-one and many-to-many
• Understand better every theoretical step by following several concrete examples
• You will be able to design a relational database from scratch
• You will be able to answer the most common interview questions about databases
• You will have a concrete e-commerce database design schema to add to your portofolio

課程介紹

This course familiarizes the student with techniques necessary to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development proj

…[更多細節]

哪些人適合這堂課？

• Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design

學習目標

• What is a database
• Understand different types of databases
• Understand normalization
• Assign relationships
• Eliminate repetition
• Relate tables with IDs
• Design rules

課程介紹

The hardest part about databases is that there is a huge mountain of knowledge needed before even beginning to understand how to design and create them. It doesn’t have to be this way. This course will take you from knowing nothing about databases to

…[更多細節]

哪些人適合這堂課？

• This Database Design course is for beginners who have no prior experience with databases or database design. This course will only go over designing. Avoid this course if you are more experienced or are looking to actually use SQL to program a database.

學習目標

• Create correct Database Relationships
• Design databases with referential integrity
• Design primary keys and foreign keys
• Use gained skills to correct bad designs in database structures
• Decide which tables should be parents and which tables should be children

課程介紹

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more…

I’ve design this course from step-by-step move from basic to advanced topics. Here is a partial lis

…[更多細節]

哪些人適合這堂課？

• Complete beginners to database world
• Anyone wanting to learn SQL or PostgreSQL
• Anyone wanting to learn advanced query expressions
• Application engineers seeking to expand their backend skillset
• Anyone wants to learn from basic to advanced functionality of PostgreSQL

學習目標

• Learn with 60+ hours of hands-on practical exercises
• Step-by-step walkthrough to perform simple to complex SQL queries
• Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions, and much more
• How to create a database from scratch
• Creating and using various Data types
• Creating User-defined data types
• Table and Column constraints
• Understanding, Using, and creating custom Sequences
• String Functions
• Aggregate Functions
• Date/Time Functions with query analysis
• Grouping data with group sets
• Schemas creations and privileges
• Table Partitioning techniques
• Exploring Array Functions
• In-depth JSON data types and queries
• Subqueries
• Common Table Expressions (CTEs)
• Recursive Common Table Expressions
• Advanced Window Functions
• Server Programming
• Functions with SQL Language
• Functions with PL/pgSQL Language
• Exploring Stored Procedures
• Indexes and queries performance optimizations
• Multiple Data Views types and Security
• Using Regular Expressions for Text Patterns
• Power Text Searches with special data types and indexes
• Crosstab Reports with crosstab extensions
• Making our database for global languages – Internationalization
• psql Utility Commands
• Understanding PostgreSQL Internals
• Triggers
• Using Cursors
• Data integrity with Transactions and Savepoints
• Managing PostgreSQL security
• Extended PostgreSQL echosystem
• Analyze sample HR, Stocks, Northwind, Global Trades databases
• Practice with huge number of queries
• Use SQL to perform data analysis
• Confident putting SQL and PostgreSQL on your resume