Databases, Rules, & Procedures

Beginner
  • 14 videos | 1h 16m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 146 users Rating 4.3 of 146 users (146)
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 22s
    Upon 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 25s
    Learn how to identify the core concepts of RDBMS, including primary, foreign, and unique keys, and relationship types. FREE ACCESS
  • Locked
    3.  Entity Relationship Diagrams
    6m 2s
    After completing this video, you will be able to recognize the purpose of entity relationship diagrams and their associated components. FREE ACCESS
  • Locked
    4.  Creating Entity Relationship Diagrams
    3m 38s
    After completing this video, you will be able to recognize basic entity relationship diagrams and apply the relationships that exist in a database. FREE ACCESS
  • Locked
    5.  Introduction to Database Normalization
    2m 14s
    Upon completion of this video, you will be able to describe what normalization is and identify the benefits it provides. FREE ACCESS
  • Locked
    6.  Normalization Rules
    7m 35s
    Upon 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
  • Locked
    7.  Introduction to SQL
    2m 42s
    After 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
  • Locked
    8.  SQL Statements
    7m 40s
    Find out how to identify and write basic SQL statements for reading, writing, and editing data in a database. FREE ACCESS
  • Locked
    9.  Using SQL
    9m 37s
    Find out how to create a new SQL database, import SQL data, and use SQL commands to access a database. FREE ACCESS
  • Locked
    10.  Stored Procedures
    3m 40s
    After completing this video, you will be able to describe the different types of stored procedures and the benefits they provide. FREE ACCESS
  • Locked
    11.  Creating Stored Procedures
    7m 3s
    In this video, you will learn how to create and access a stored procedure. FREE ACCESS
  • Locked
    12.  Database Connection Methods
    3m 43s
    After completing this video, you will be able to describe various types of data stores such as flat files and XML files. FREE ACCESS
  • Locked
    13.  Connecting to Data Stores
    8m 55s
    In this video, find out how to connect to an XML data store programmatically. FREE ACCESS
  • Locked
    14.  Exercise: Using Windows Store Apps and Databases
    6m 26s
    During 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.

YOU MIGHT ALSO LIKE

Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Channel MySQL
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Course SQL Concepts & Queries
Rating 4.6 of 2013 users Rating 4.6 of 2013 users (2013)
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)