Databases, Rules, & Procedures
Beginner
- 14 videos | 1h 16m 2s
- Includes Assessment
- Earns a Badge
Most applications today require access to a datastore for saving, modifying, and retrieving data. Learn about available databases, RDBM systems, entity relationship diagrams, normalization, structured query language, and stored procedures.
WHAT YOU WILL LEARN
-
describe the characteristics and capabilities of various types of databases, including table structure
identify the core concepts of RDBMS, including primary, foreign and unique keys, and relationship types
recognize the purpose of entity relationship diagrams and their associated components
recognize basic entity relationship diagrams to demonstrate the relationships existing in a database
describe what normalization is and identify the benefits it provides
describe the different levels of normal forms and the advantages and disadvantages of each
describe the purpose of SQL and how it can be used to access data in a database -
identify and write basic SQL statements for reading, writing, and editing data in a database
create a new SQL database, import SQL data and use SQL commands to access a database
describe the different types of stored procedures and the benefits stored procedures provide
create and access a stored procedure
describe various types of data stores such as flat files and XML files
connect to an XML data store programatically
identify the fundamental concepts associated with Windows Store Apps and databases, including stored procedures and normalization
IN THIS COURSE
-
2m 22sUpon completion of this video, you will be able to describe the characteristics and capabilities of various types of databases, including their table structures. FREE ACCESS
-
4m 25sLearn how to identify the core concepts of RDBMS, including primary, foreign, and unique keys, and relationship types. FREE ACCESS
-
3. Entity Relationship Diagrams6m 2sAfter completing this video, you will be able to recognize the purpose of entity relationship diagrams and their associated components. FREE ACCESS
-
4. Creating Entity Relationship Diagrams3m 38sAfter completing this video, you will be able to recognize basic entity relationship diagrams and apply the relationships that exist in a database. FREE ACCESS
-
5. Introduction to Database Normalization2m 14sUpon completion of this video, you will be able to describe what normalization is and identify the benefits it provides. FREE ACCESS
-
6. Normalization Rules7m 35sUpon completion of this video, you will be able to describe the different levels of normal forms and the advantages and disadvantages of each one. FREE ACCESS
-
7. Introduction to SQL2m 42sAfter completing this video, you will be able to describe the purpose of SQL and how to use it to access data in a database. FREE ACCESS
-
8. SQL Statements7m 40sFind out how to identify and write basic SQL statements for reading, writing, and editing data in a database. FREE ACCESS
-
9. Using SQL9m 37sFind out how to create a new SQL database, import SQL data, and use SQL commands to access a database. FREE ACCESS
-
10. Stored Procedures3m 40sAfter completing this video, you will be able to describe the different types of stored procedures and the benefits they provide. FREE ACCESS
-
11. Creating Stored Procedures7m 3sIn this video, you will learn how to create and access a stored procedure. FREE ACCESS
-
12. Database Connection Methods3m 43sAfter completing this video, you will be able to describe various types of data stores such as flat files and XML files. FREE ACCESS
-
13. Connecting to Data Stores8m 55sIn this video, find out how to connect to an XML data store programmatically. FREE ACCESS
-
14. Exercise: Using Windows Store Apps and Databases6m 26sDuring this video, you will learn how to identify the fundamental concepts associated with Windows Store Apps and databases, including stored procedures and normalization. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
