khayyam88 · 25-Ноя-11 20:22(13 лет 10 месяцев назад, ред. 11-Окт-12 15:34)
Oracle Database 11g SQL Fundamentals 1 1Z0-051 Год выпуска: 2011 Производитель: Cbt Nuggets Сайт производителя: http://www.cbtnuggets.com Автор: Timothy L. Warner Продолжительность: 10 hrs Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Data, data everywhere…take control of your database and learn to manipulate it with the tried-and-true Structured Query Language (SQL) in Oracle Database 11g. Whether you're an IT pro who wants to add Oracle DBA and SQL querying to your tool belt, a DBA in another technology who wants to dive into Oracle, or a newcomer to relational databases who yearns to learn SQL, this series will give you what you need to reach your goal. In this course, you'll gain SQL proficiency and be able to take control of your data. Best of all, you can apply the skills you learn not only to Oracle, but to almost any RDBMS platform! And, trainer Tim Warner gives you all sorts of cool supplemental learning references –all of the SQL work files can bee downloaded free at nuggetlab.com, and the course is filled with recommendations for white papers, Web sites and more. Once you've finished this Nugget series, you'll be fully prepared to pass the 1Z0-051 SQL Fundamentals exam – and be ready to move on to the next in line for the Oracle DBA OCA track. More importantly, you'll gain an extremely useful and portable tool that will help you make the most of your database.
Содержание
Oracle Database 11g SQL Fundamentals 1 Course Introduction In this nugget, we start by defining what Oracle is and how it fits into the concepts of the database, relational database, and relational database management system. Next we perform a deep-dive into the Oracle certification program, learning exactly how the current course maps to the Oracle Certified Associate (OCA) credential. We also provide tips and tricks for getting the most out of the training, and give suggestions on how to pass the 1Z0-051 exam with a minimum of muss or fuss. 00:18:23 About SQL In this nugget, we set the stage for the rest of the training. Here we formally define the Structured Query Language (SQL), explaining its basic modes of operation, as well as how Oracle's implementation of SQL stacks up to the ANSI/ISO standard as well as other vendors' implementations. We complete this nugget with quick-start tutorials on how to use SQL*Plus as well as Oracle SQL Developer. 00:41:33 Retrieving Data By Using the SELECT Statement The SELECT statement is the universal workhorse of SQL. In this nugget we discuss both the theory and practice of using SELECT to retrieve query results from Oracle database. 00:38:10 Restricting and Sorting Data In this nugget we continue our discussion of the SQL SELECT statement, this time learning how to pare down our query results by employing the powerful WHERE clause. We also learn how to sort our query results by leveraging the ORDER BY statement, and finally begin to write more dynamic, interactive SQL by using substitution variables. 00:37:24 Using Single-Row Functions to Customize Output In this nugget we introduce the concept of the function, both from a general mathematics standpoint, and then with sharper focus on Oracle Database 11g. We spend our time learning to master the basic character, number, and date functions that you'll be expected to understand on the SQL Fundamentals certification exam. 00:36:51 Reporting Aggregated Data Using the Group Functions In this nugget we apply many of the function-related principles we picked up in the previous nugget. Here we learn how to aggregate data across multiple table rows by employing both grouping functions as well as the GROUP BY SQL statement. We also will understand how to filter grouped rows by using the HAVING clause. 00:30:04 PL/SQL Basics In this nugget we truly round out our Oracle SQL skills by conducting a survey of PL/SQL, Oracle's procedural programming extensions to the Structured Query Language. By the end of this nugget you will not only understand the basic nomenclature and syntax of PL/SQL, but you'll also be able to write basic PL/SQL blocks, both the anonymous and named varieties. 00:36:03 Displaying Data from Multiple Tables In this nugget we truly begin to see the great beauty of the relational database model. Here we learn how to query across multiple related tables by using joins. In addition to learning all about the supported join types in Oracle Database, we will also flirt around with the concept of constraints, two of which (primary key and foreign key) are crucial to our understanding of the relational model. 00:38:11 Using Subqueries In this nugget we broaden and deepen our usage of the SELECT statement by learning how to embed one SELECT inside of another SELECT; this is called a subquery. As we'll learn, subqueries are useful for data load scenarios as well as when we aren't quite sure which row(s) we need to evaluate in a WHERE clause. By the end of this nugget you will not only understand how subqueries work, but you'll be able to write both single-row and multi-row subqueries in either the simple or correlated processing formats. 00:24:21 Using the Set Operators SQL is a set-oriented database access language. In this nugget we learn various methods of combining multiple result sets. Here we master the use of the UNION, MINUS, and INTERSECT keywords in combining multiple queries into a single result set. 00:23:51 Using DDL Statements to Create and Manage Tables In this nugget we formally treat the subject of creating, altering, and dropping database objects; this collection of SQL commands is formally called Data Definition Language, or DDL. In this nugget we start with a high-level overview of the major database objects. We then follow up with learning how to design and create tables, and then conclude with a consideration of the importance and use of integrity constraints in database tables and views. 00:46:29 Creating Other Schema Objects Part 1 In this nugget we continue the discussion we opened in the previous nugget on DDL statements in Oracle Database 11g. Here we learn how to design and implement sequences and views. 00:31:43 Creating Other Schema Objects Part 2 Indexes, when properly designed and used, can dramatically speed up query performance in an RDBMS. In this nugget we cover the fundamental points concerning indexes. We also learn just what synonyms are--not in the English grammar context, but instead in the Oracle database nomenclature. 00:34:39 Manipulating Data Part 1 Thus far in the course we have covered the use of SELECT and the DDL command suite. Formally speaking, SELECT is actually one of the Data Manipulation Language (DML) statements in SQL. In this nugget we cover two of the major DML players, namely the INSERT and UPDATE statements. 00:30:32 Manipulating Data Part 2 In this nugget we "book end" our discussion from Nugget #14, wrapping up our consideration of basic DML by investigating the finer points of the DELETE statement. We also define and discuss what database transactions are as well as how to control their operation in Oracle Database 11g. 00:30:34 Basic Oracle Database Security Relational database security is a huge topic and can constitute a very lucrative career for those who are so talented and interested. In this nugget we survey some of the major principles behind user account security in Oracle Database 11g. In particular, we learn how to create and administer Oracle user accounts. We then delve into access control, learning how to leverage the GRANT and REVOKE statements. We complete this nugget with some best-practice advice on leveraging database roles to make our database security more efficient and effective. 00:35:14 Accessing the Data Dictionary The data dictionary in Oracle Database 11g is a read-only collection of tables that stores metadata about the database. As such, an understanding of the data dictionary is crucial for anyone who presents himself or herself as an Oracle DBA. By the conclusion of this nugget you will not only be able to intelligently discuss the data dictionary, but you will also know how to query the data dictionary views as an ordinary schema (user) and as a DBA. 00:22:19 Referencing the Oracle Documentation While Oracle's documentation library is presented to the public at no charge, Oracle keeps much of the "good stuff" behind a paywall for, well, paying Oracle Support customers. The purpose of this nugget is to deeply familiarize you with the free and excellently written/organized corpus of technical documentation in the Oracle Web site. This is a best-kept secret of Oracle, and you should make the official Oracle Documentation a daily read as you build your skill set up and out. 00:22:24 Using Oracle Flashback Query In the life of the DBA, restoring data that was accidentally or intentionally dropped or deleted can be a fairly regular occurrence. Here we turn to the nifty Flashback technology in Oracle Database 11g to learn first of all how Flashback works, and then how we can leverage Flashback to recover individual rows or entire tables from the ether. We'll also spend some time with the Oracle Recycle Bin. 00:24:57 Query Optimization Basics In this concluding nugget of the series we apply everything we've learned over the course of this training and pick up some practical advice on how to tune and optimize our SQL queries. To start with we will explain how Oracle parses (interprets) SQL. We will then practice using the EXPLAIN PLAN statement to view the fine details of Oracle's query execution plans. Finally, we finish up with a "laundry list" of strategies for customizing how Oracle builds its execution plans. 00:25:41
Видео
Format : AVC
Format/Info : Advanced Video Codec
Format profile : High@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Bit rate : 80.0 Kbps
Nominal bit rate : 1 500 Kbps
Width : 800 pixels
Height : 600 pixels
Display aspect ratio : 4:3
Frame rate mode : Variable
Frame rate : 14.984 fps
Minimum frame rate : 0.612 fps
Maximum frame rate : 30.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.011
Stream size : 10.5 MiB (48%)
Writing library : x264 core 100
Аудио
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Bit rate mode : Variable
Bit rate : 82.7 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 48.0 KHz
Compression mode : Lossy
Stream size : 10.9 MiB (49%)
К данному курсу следует относиться с определённой осторожностью.
Во-первых у этого Timothy Warner хренова туча сертификатов, но Oracle среди них нет) Но, на самом деле, это ещё цветочки. Уже в четвёртом видео он что-то заявляет про оракловый формат даты по умолчанию (типа '01-JAN-99') и предлагает использовать HIRE_DATE LIKE '%98' для отделения дат 1998 года. Также феерично он упомянул про wildcard symbols в условии BETWEEN (типа LAST_NAME between 'B%' and 'E%'). И это в одном видео. То есть, в этом курсе, конечно, можно подчеркнуть для себя что-то полезное, и темы в нём соответствуют экзамену 1Z0-051. Но всё же, курс содержит явные фактические ошибки относительно oracle sql - как минимум прелестные % в between и классическую nls-бомбу при работе с датами как со строками, как я упомянул ранее.
Согласе, есть огрехи, неточности, а иногда и попросту ошибки. (и это относится ко всем его видео по ораклу) Но все же большой плюс его видео в том, что он в режиме реально времени в конце каждого наггета после теории показывает на "живой" системе о чем он рассказывал. Если вы хотете после просмотра его видео стать гуру в СУБД Оракл и сходу сдать все экзамены на OCP- это видел не для вас. Ну а если же вы новичек или не имеете ни малейшего представления о какой-либо из тем экзамена- его серия будет вам очень полезна, т.к. мне гораздо легче давалось чтение мануалов после просмотра некоторых наггетов.
Есть ли у кого экзамены к курсу 1Z0-051? Заранее спасибо.
lovejoi4 писал(а):
59035615Podoidet li dani kurs dla cheloveka kotori tolka znakomitsa s SQL?
нет, не стоит мучаться, Оракл имеет много плюшек, которых нет в MySQL, не стоит голову по началу грузить тригерами, процедурами и другими вещами, MySQL простой как рубль, начните с простого, иначе интерес потеряете. Есть ли у кого экзамены к курсу 1Z0-051? Заранее спасибо.
artem-82 єто есть в другом курсе для DBA, вопрос к знатокам, а чем Оракл отличается от Postgresql ?
Я вот лично обнаружил , что для нормальной работы с Оракл нужно покупать лицензии и в этой бд можно определять свои типы данных .
