Learn the fundamentals of database programming. Find out how to build a database, define relationships, and write queries.
Overview
Syllabus
Introduction
- Why use a database?
- What you should know
- Understanding databases: Benefits of spreadsheets
- Understanding databases: Benefits of structured data
- Relational databases
- Keys and unique values
- Relationships
- ACID and transactions
- Basic SQL
- Modeling and planning a database
- Naming tables
- Columns and data types
- Numbers and other types
- Primary and foreign keys
- Creating relationships
- One-to-many relationships
- Many-to-many relationships
- One-to-one relationships
- Relationship rules and referential integrity
- Normalization
- First normal form
- Second normal form
- Third normal form
- Denormalization
- Creating a database
- Creating tables
- Writing SQL queries
- Narrowing query results
- Sorting results
- Aggregate functions
- Joining tables
- Modifying data
- Indexes, transactions, and stored procedures
- Access control, compliance, and injection
- Software options
- Next steps
Taught by
Scott Simpson
Reviews
4.8 rating, based on 4 Class Central reviews
4.7 rating at LinkedIn Learning based on 7128 ratings
Showing Class Central Sort
-
thank you Linkdin for such amazing course you provided
this one is best of my knowledge , you can better with the database after completing this awesome course -
Very nice explanation in an easy and efficient way, with a good platform to study well to gain knowledge as well as certificates and here I am leaving a review for who are confused to learn here don't think just join the class and learn.
-
Excellent learning course. For the beginners it will be useful. All the basic details are explained in cleared way so that everyone can understand easily. For students this course will be suggested
-
a good platform to study good to gain knowledfe as well as certificates and here i am leaving a review for who are confused to learn here.dont think just join the class and learn