SQL on Windows Pc

SQL, the language once called the database specialist Michael Stonebraker as "Intergalactic Language", despite or because of its long history, is still the only instrument for dealing with relational database systems. She has undergone significant changes over the past two decades and has been the SQL: 2003 standard to an extensive modern and complex tool. Still further modernized and sharpened for the use of this tool has been through the revisions SQL: 2008 and SQL: 2011, the first of which was fully taken into account in this course.

The aim of this course is to introduce SQL both in its basic functionality as well as to provide further and advanced aspects of this powerful language and practically tested.
After a solid introduction to the fundamentals of relational database systems you will give practical and with many examples of the daily use of SQL. Based on a continuous course example you can try out as an ambitious SQL beginners your newly acquired knowledge of the simplest statements up to the most complex queries in numerous practical tasks and apply.
The course is based of the SQL: 2008 language standard, all examples and SQL: 2011- compliant. In addition, you will learn the major dialects of the database systems MySQL, SAP Sybase ASE and Oracle.

Chapter 1 gives an overview of the development of SQL. In addition, you install MySQL on your computer, the database system that you will use throughout the course.
In Chapter 2, you will become familiar with the basics of the relational model and the fundamental aspects and functionalities of database systems. You learn the database modeling as a process to know and become familiar with our course example.
In Chapter 3, you will get to know simple SQL statements and execute. Familiarize yourself with SQL data types and try simple operators and predicates.
Chapter 4 is devoted to working with multiple database tables. You learn how to be present with JOINS and subqueries information distributed in the database, relating the united and in queries. You will also learn the powerful instrument of the SQL group functions to use.
In Chapter 5, the SQL commands Meet for data manipulation. You will add, change and delete data in tables. Data manipulation in large database systems requires a sound understanding of the transaction concept, which is also discussed in this chapter.
In Chapter 6, you will do your first steps on the smooth floor of the schema manipulation. You will define, modify, and delete after you the necessary planning and documentation were presented tables. You will also become familiar with views and other important database objects and learn how it invests, modify, and delete.
Chapter 7 is devoted to various aspects of data integrity and introduces the SQL objects constraints and assertions. They learn the concept of referential integrity know and become familiar with the concepts of SQL, which are intended to ensure data integrity, familiar. Educate Yourself database objects Domain and trigger know.
Finally, Chapter 8 introduces the mechanisms providing for the SQL for safeguarding the security of the database. You learn how users, schemas and roles created, changed and deleted. In addition we show you the different implementations of these concepts in MySQL, SAP Sybase ASE and Oracle.

Interne Aktualisierungen

Allows applications to open network sockets.