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 structureidentify the core concepts of RDBMS, including primary, foreign and unique keys, and relationship typesrecognize the purpose of entity relationship diagrams and their associated componentsrecognize basic entity relationship diagrams to demonstrate the relationships existing in a databasedescribe what normalization is and identify the benefits it providesdescribe the different levels of normal forms and the advantages and disadvantages of eachdescribe 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 databasecreate a new SQL database, import SQL data and use SQL commands to access a databasedescribe the different types of stored procedures and the benefits stored procedures providecreate and access a stored proceduredescribe various types of data stores such as flat files and XML filesconnect to an XML data store programaticallyidentify the fundamental concepts associated with Windows Store Apps and databases, including stored procedures and normalization
IN THIS COURSE
-
1.Introduction to Databases2m 22sUP NEXT
-
2.RDBMS Fundamentals4m 25s
-
3.Entity Relationship Diagrams6m 2s
-
4.Creating Entity Relationship Diagrams3m 38s
-
5.Introduction to Database Normalization2m 14s
-
6.Normalization Rules7m 35s
-
7.Introduction to SQL2m 42s
-
8.SQL Statements7m 40s
-
9.Using SQL9m 37s
-
10.Stored Procedures3m 40s
-
11.Creating Stored Procedures7m 3s
-
12.Database Connection Methods3m 43s
-
13.Connecting to Data Stores8m 55s
-
14.Exercise: Using Windows Store Apps and Databases6m 26s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.