Description: As with any development skill in the industry, learning the core fundamentals creates a foundation. This course describes the SQL views in more detail, defining the various views and their management, and introduces concepts such as Transactions and how to group statements, Transact-SQL, and transaction logs. In this course, you will learn about one of the most important aspects of SQL – its security. You will learn about defining the lock system and various levels of security access and management as well as many other operators and functions used in SQL statements. This includes the setup and installation of security architecture. By the end of these courses, you will be well on your way to creating efficient and easily manageable databases and have fun while doing it.
Target Audience: Individuals interested in learning about the various SQL views and their purpose, transactions, transaction logs, and the SQL full security architecture
Duration: 03:09
Description: As with any development skill in the industry, learning the core fundamentals creates a foundation. In the course, you will learn about multi-table database architecture and design; connecting several tables; and concepts using inner outer joins, equijoins, and non-equijoins. You will also learn about subqueries and advanced queries in SQL; using statements with multiple conditions and multiple joins; new operators; and functions to manage your data. This course also covers Multijoins, UNION operator, and functional dependencies. By the end of these courses, you will be well on your way to creating efficient and easily manageable databases and have fun while doing it.
Target Audience: Individuals interested in learning multi-layer architecture in SQL and about joins, subqueries, and functional dependencies
Duration: 02:39
Description: As with any development skill in the industry, learning the core fundamentals creates a foundation. In this course you will learn about ALTER and CREATE, constraints and their use, grouping and aggregating concepts, using SQL arithmetic, and the various string functions. This course will provide concepts and strategies to form a more thorough approach to database management and assist you by providing a clearer picture of what SQL is all about. By the end of these courses, you will be well on your way to creating efficient and easily manageable databases and have fun while doing it.
Target Audience: Individuals interested in gaining a broader understanding of how to manage data with grouping and string functions in SQL
Duration: 01:55
Description: As with any development skill in the industry, learning the core fundamentals creates a foundation. In this course, you will take your first steps in learning about relational databases and Structured Query Language (SQL). This course covers concepts of a database and an introduction to SQL, diving into the architecture, creating and managing tables, and queries. This course looks at the various basic components and how to create a standard query. By the end of these courses, you will be well on your way to creating efficient and easily manageable databases and have fun while doing it.
Target Audience: Individuals interested in learning the architecture of SQL from the beginning and those interested in acquiring the ability to define database concepts, construct a standard query, and create an SQL database
Duration: 02:53