Database Core Concepts: Beginner

  • 31 Courses | 32h 1m 59s
  • 9 Books | 53h 30m
  • Includes Lab
Likes 102 Likes 102
 
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 10s
    NOW PLAYING
  • Playable
    2. 
    The Relation of Data and the Various Databases
    8m 30s
    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 3m 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 4m 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 | 58m 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 19m 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 | 41m 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 23m 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 28m 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 | 40m has Assessment available Badge
SQL Transactions
Master SQL transactions. Explore transactions and how to group statements, Transact-SQL, and transaction logs.
8 videos | 1h 4m has Assessment available Badge
SQL Transaction Locks
Master SQL transaction locks. Explore transaction locks and explore the different levels of locking.
5 videos | 42m has Assessment available Badge