Database Core Concepts: Beginner

  • 31 Courses | 30h 12m 56s
  • 9 Books | 53h 30m
Likes 87
 
Information is as valuable as gold, but before you master DB administration, you need to understand the ins and outs. Explore the basics of DBs.

GETTING STARTED

SQL Concepts & Queries

  • Playable
    1. 
    Introduction to the Database Concept
    10m 13s
    NOW PLAYING
  • Playable
    2. 
    The Relation of Data and the Various Databases
    8m 33s
    UP NEXT

COURSES INCLUDED

SQL Concepts & Queries
Master SQL concepts. Learning the core fundamentals creates a foundation. Discover relational databases and Structured Query Language (SQL) database concepts.
7 videos | 1h has Assessment available Badge
SQL Tables
Master SQL tables. Take your first steps in learning about relational databases and Structured Query Language (SQL) tables. Discover how to manage tables, and queries, including complex tables, changing tables, and deleting tables.
9 videos | 1h has Assessment available Badge
SQL Selecting, Ordering, & Filtering
Manipulating databases is a necessary skill. Explore Structured Query Language (SQL) and dive into the architecture. Discover efficient and easily manageable databases using features like SELECT, data types, UPDATE, and ORDER BY.
9 videos | 55m has Assessment available Badge
Table Design: Tables, Columns, & Numbers
Fundamentals create foundation. Get a clear picture of what SQL is all about. Discover table functions including ALTER and CREATE, as well as column functions and math operators.
13 videos | 1h 17m available Badge
Table Design: Functions & Strings
Master the core functions of SQL strings. Strings are a key component to any database, and you can work magic using fundamental SQL commands. Explore string functions like LENGTH, REVERSE, and TRIM, as well as how to put them together.
8 videos | 40m available Badge
Multiple SQL Tables
Work with multiple tables. Mastering the fundamentals of SQL creates a foundation. Explore multi-table database architecture and design, connecting several tables, using inner/outer joins, and equijoins and non-equijoins.
12 videos | 1h 20m available Badge
Advanced SQL Queries
Master advanced queries. Queries in SQL allow you to manipulate databases like a pro. Discover advanced techniques including subqueries, correlated queries, difficult queries, and learn query tips for better efficiency.
13 videos | 1h 24m available Badge
SQL Views
Discover SQL views. Explore SQL views in detail, defining various views and their management, from creating views to view types, updating, and dropping views.
5 videos | 38m has Assessment available Badge
SQL Transactions
Master SQL transactions. Explore transactions and how to group statements, Transact-SQL, and transaction logs.
8 videos | 1h has Assessment available Badge
SQL Transaction Locks
Master SQL transaction locks. Explore transaction locks and explore the different levels of locking.
5 videos | 40m has Assessment available Badge
SQL Security Architecture
Mastering security is crucial. Explore one of the most important aspects of SQL security. Discover the lock system, levels of security access and management, privileges and rights, and the setup and installation of security architecture.
7 videos | 52m has Assessment available Badge
Architecture Concepts
A database is used by organizations to store their data and to allow their employees to access, update, and manage it. Learn about databases, including types, users, characteristics, architectures, and database models.
11 videos | 1h 14m has Assessment available Badge
Normalization Concepts
Organizations use a Database Management System to manipulate, organize and retrieve data. Learn about these systems, their components, and Dr. Edgar Codd's rules for a database to be considered relational.
13 videos | 1h 24m has Assessment available Badge
Relational Algebra & Calculus
Storing data is important, but it's equally important to be able to manipulate and analyze it using a query language like SQL. Explore relational algebra and calculus, developed by Dr. Edgar Codd for his theory for the relational database.
11 videos | 1h 2m has Assessment available Badge