وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Database Foundations: Intro to Databases

سرفصل های دوره

What is a database? How can you build one? Do you want to learn more? In this course, database expert Adam Wilbert shows you how to set up container-based servers, connect a management GUI, and start building a database for your valuable data. You don’t need to come with any specific prior knowledge or have any specific software pre-installed. This course’s content is applicable to learners on any operating system. Learn about how to set up a database playground, how to include a user-friendly graphical interface, how to create table objects, how to add data to a table, and how to retrieve and manipulate data. The course includes exercise files so that learners can practice executing the same commands shown on screen. At the conclusion of the course, Adam shares some ideas for continuing your learning journey.


01 - Introduction
  • 01 - An introduction to database foundations
  • 02 - What you should know
  • 03 - Using the exercise files

  • 02 - 1. Database Core Concepts
  • 01 - What is a database
  • 02 - Storing data efficiently
  • 03 - Relational database management systems
  • 04 - The client-server model

  • 03 - 2. Set Up a Database Playground
  • 01 - Purpose of the playground
  • 02 - Install Docker
  • 03 - Database server containers
  • 04 - Local installation alternatives to Docker
  • 05 - RDBMS command-line interfaces
  • 06 - Challenge Create a server container
  • 07 - Solution Create a server container

  • 04 - 3. Graphical Interfaces
  • 01 - Management interfaces
  • 02 - Install Azure Data Studio
  • 03 - Connect to a database server
  • 04 - Explore the servers contents
  • 05 - Create a database
  • 06 - Challenge Create a database
  • 07 - Solution Create a database

  • 05 - 4. Create Table Objects
  • 01 - Structured Query Language
  • 02 - Organize a database with schemas
  • 03 - Table columns
  • 04 - Create tables
  • 05 - Alter tables
  • 06 - Reserved keywords
  • 07 - Challenge Create a table
  • 08 - Solution Create a table

  • 06 - 5. Add Data to a Table
  • 01 - Table rows
  • 02 - Add records
  • 03 - Update and delete records
  • 04 - Saving and using SQL scripts
  • 05 - Challenge Add data to a table
  • 06 - Solution Add data to a table

  • 07 - 6. Retrieve Information
  • 01 - Querying data
  • 02 - Return data with SELECT and FROM
  • 03 - Filter rows with WHERE
  • 04 - Sort values with ORDER BY
  • 05 - Combine data with JOIN
  • 06 - Limiting the number of rows returned

  • 08 - 7. Manipulate Data
  • 01 - Display column aliases with AS
  • 02 - Mathematical operations
  • 03 - Use built-in functions
  • 04 - Aggregate data with GROUP BY
  • 05 - Filtering groups with HAVING
  • 06 - Challenge Query data
  • 07 - Solution Query data

  • 09 - Conclusion
  • 01 - Next steps
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 24087
    حجم: 603 مگابایت
    مدت زمان: 205 دقیقه
    تاریخ انتشار: 12 آذر 1402
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید