پیشنهاد فرادرس

آشنایی با دیتابیس های مختلف زبان SQL

دسته بندی ها: آموزش SQL Server ، پایگاه داده ، آموزش های CBTNuggets ، آموزش SQL

آشنایی-با-دیتابیس-های-مختلف-زبان-sql

در این آموزش تصویری با دیتابیس های مختلف زبان SQL و همچنین کار با دستوارت SQL آشنا می شوید.

این دوره آموزشی محصول CBT Nuggets می باشد.

سرفصل های دوره آموزشی:

  • کار با پایگاه داده ها و کوئری ها
  • مبانی sql
  • فیلتر کردن داده ها
  • استفاده از توابع
  • کار با GROUP BY
  • درج، حذف، و نمایش داده
  • جداول چندگانه
  • چند جدول پیشرفته Queries
  • توابع SQL
  • کار با تراکنش ها
  • تعریف داده ها
  • ایجاد جدول، انواع داده ها
  • داده های رابطه ای
  • ایجاد کلید های اولیه، ایجاد محدودیتهای کلید خارجی
  • بالا بردن سرعت پرس و جو
  • ابزار برای کار با SQL
  • کار با phpMyAdmin، SQL و سرور مدیریت و MySQL Query Analyzer
  • اصول طراحی پایگاه داده
  • قابلیت های پیشرفته پایگاه داده
  • ویژگی های XML

لیست سرفصل های دوره آموزشی:

Regardless of which database platform you use -- Oracle, SQL Server, MySQL, SQLite, PostgreSQL, and more -- learning industry-standard SQL query syntax will give your database efforts a real boost.

This Don Jones training shows you how to write simple and complex queries in industry-standard SQL syntax, adapt syntax to vendor-specific SQL variants, defend against attacks like SQL injection, understand and optimize database designs, and even help optimize query performance through indexing.

Every CBT Nuggets course -- whether it's certification track or, like this one, solely on-the-job training -- gives you the hands-on skills you need to be a more effective IT professional.

All trademarks and copyrights are the property of their respective holders.

1. Introduction (00:08:23) Overview of the course, what variations of SQL this course works with 2. Database and Querying Concepts and Overview (00:20:29) Terminology, ANSI standards, what is "null," default values, auto-incrementing columns 3. SELECT: The Basics (00:21:01) Querying data, selecting columns, basic filtering, basic sorting 4. Filtering Data with WHERE (00:20:19) Comparison operators, IN and BETWEEN operators, Boolean operators, IS operator, string and date delimiters, special functions like SOUNDEX and DIFFERENCE 5. SELECT: Using Functions (00:19:32) How to use common functions in the SELECT statement 6. SELECT: Aggregates, GROUP BY, and HAVING (00:22:09) Aggregate/set functions, COUNT, MAX, MIN, SUM, AVG, and so on, GROUP BY and HAVING clauses 7. SELECT: Advanced Tricks (00:26:52) TOP/LIMIT, sub-queries, table and column aliasing, DISTINCT, CASTing data types 8. INSERT, DELETE, and UPDATE Queries (00:18:04) Adding data, deleting data, and changing data; using SELECT in an INSERT, using TOP/LIMIT and WHERE 9. SELECT: Multiple Tables (00:18:27) CROSS JOIN, NATURAL JOIN, INNER JOIN, and OUTER JOINs 10. SELECT: Advanced MUlti-Table Queries (00:16:19) UNION operator, UNION JOIN, INTERSECT and EXCEPT operators 11. Common SQL Functions (00:18:02) Numeric functions, String functions, Date/Time functions 12. Transactions (00:15:46) START TRANSACTION / BEGIN WORK / BEGIN TRANSACTION, COMMIT, ROLLBACK, and transaction concepts 13. Data Definition (00:19:47) CREATE TABLE, common data types, ALTER TABLE, DROP TABLE 14. Understanding Relational Data (00:23:47) Creating primary keys, creating foreign key constrains, creating NOT NULL constraints, create UNIQUE constrains, creating CHECK constraints, understanding constraints' impact on relational data 15. Speeding Up Queries, and Slowing them Down: Indexes (00:23:34) Index concepts, CREATE INDEX, rebuilding/reorganizing indexes, DROP INDEX 16. CAUTION: SQL Injection Attacks (00:22:06) How they work, how to prevent them (escaping data and stored procedures) 17. Tools for working with SQL (00:17:31) phpMyAdmin, SQL Server Management Studio, MySQL Query Analyzer, Other Tools 18. Cursors (00:20:12) Introduction and concepts, OPEN and CLOSE, FETCH, downsides of cursors 19. Database Design Principles (00:28:42) First, Second, and Third Normal form; denormalization 20. Advanced Database Capabilities (00:21:06) Platform-specific features, triggers, XML data manipulation, background jobs, and so on.

عنوان دوره: CBT Nuggets - Database Various SQL Languages حجم فایل: 863MB

آیا این نوشته را دوست داشتید؟
CBT Nuggets Database Various SQL Languages

پیشنهاد فرادرس