video2brain - SQL lernen und anwenden
Language: German | Duration: 14h 43m | H264 | 1024x576 | 15fps 100Kbps | AAC 44.1KHz 96Kbps | 1.23GB
Structured Query Language with Microsoft SQL Server, Oracle, and MySQL
The standard database language SQL (Structured Query Language) is the basis for any work with relational databases.
The experienced database developer and trainer Konopasek Clement leads you by the example of the most common database management systems, Microsoft SQL Server, Oracle, and MySQL completely through the use of SQL areas and indicates specific examples, the practical use. He also goes into the implementation differences between SQL Server, Oracle, and MySQL.
The Structured Query Language, SQL is short, the basis for employment and with the development of relational databases. This video training is aimed anyone who is engaged in study or work with relational databases. Beginners will be introduced step by step, in SQL, advanced users and developers can enter directly into the desired topic.
The experienced database developer, trainer and lecturer Clement Konopasek used to convey the contents of the three leading database management systems: Microsoft SQL Server, Oracle, and MySQL. He focuses on standard SQL statements that are used on all three systems in the same way. At the same time he has also always points to the existing differences between the three systems.
You learn in this video tutorial, all areas of SQL language. To start, you know, how many variations you can access data in a relational database and specify how extensive the desired result. You also learn how to recreate it with the structure of a SQL database, and expand and how you can write to your database. But also on transactions and access permissions you can find out in this video tutorial.
The video training is based on the freely-available editions of each of the three editors and database management systems, so you can follow all the examples themselves completely.
They also master concepts such as SELECT, CREATE and INSERT, UPDATE and DELETE are you with this video tutorial, a database pro!
From the contents
SQL - Structured Query Language
The Structured Query Language is a standardized query language for relational database systems. With in-depth knowledge of SQL you easily work with different systems. Only a few details are product specific but easily learned. Thus, the input and switching to another system a breeze.
Introduction to the work environment
The SQL editor to write the instructions, the work environment for SQL enthusiasts. Learn in this section are familiar in training for upcoming deployment editors.
The Data Query Language - DQL
Whether you need a quick piece of information from the database or a complex analysis of your concern. The Data Query Language, you need read access to your database in any form:
* SELECT and FROM
* WHERE clause
* Sort with ORDER BY
* Group functions and grouping
* SET Operators
The Data Manipulation Language - DML
To share data with SELECT statements are evaluated, they must first be inserted into the database. The data manipulation language for each form of write access to databases in charge. This chapter is aimed at those who want in the database not only read :
All or nothing is the motto. Transactions combine several write operations to a total process and how to ensure that there remain no disturbances of any kind arising from incomplete data changes. Get to know in this section dealing with such an important tool for data consistency.
The Data Definition Language - DDL
SQL is the language with which the structure of a relational database is created. The language used for this field is the Data Definition Language. DDL statements are used among others to create tables and relationships:
* Views / Views
The Data Control Language - DCL
The Data Control Language is used to create users and roles on the one hand and the management of access permissions on the other. The security is implemented at various database systems in different ways. Look in this section, basic concepts which are generally realized.