Databases, Rules, & Procedures

Beginner
  • 14 Videos | 1h 16m 2s
  • Includes Assessment
  • Earns a Badge
Likes 130 Likes 130
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

  • Playable
    1. 
    Introduction to Databases
    2m 22s
    UP NEXT
  • Playable
    2. 
    RDBMS Fundamentals
    4m 25s
  • Locked
    3. 
    Entity Relationship Diagrams
    6m 2s
    FREE ACCESS
  • Locked
    4. 
    Creating Entity Relationship Diagrams
    3m 38s
    FREE ACCESS
  • Locked
    5. 
    Introduction to Database Normalization
    2m 14s
    FREE ACCESS
  • Locked
    6. 
    Normalization Rules
    7m 35s
    FREE ACCESS
  • Locked
    7. 
    Introduction to SQL
    2m 42s
    FREE ACCESS
  • Locked
    8. 
    SQL Statements
    7m 40s
    FREE ACCESS
  • Locked
    9. 
    Using SQL
    9m 37s
    FREE ACCESS
  • Locked
    10. 
    Stored Procedures
    3m 40s
    FREE ACCESS
  • Locked
    11. 
    Creating Stored Procedures
    7m 3s
    FREE ACCESS
  • Locked
    12. 
    Database Connection Methods
    3m 43s
    FREE ACCESS
  • Locked
    13. 
    Connecting to Data Stores
    8m 55s
    FREE ACCESS
  • Locked
    14. 
    Exercise: Using Windows Store Apps and Databases
    6m 26s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease
BOOK Access For Dummies
COURSE Database Fundamentals: Database Administration Basics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Programming Structure, Methods, & Variables
Likes 121 Likes 121  
COURSE Recursion, Exceptions, Randomization, & Sorting
Likes 37 Likes 37  
COURSE Programming Strings & Data Structures
Likes 68 Likes 68