Winkelwagen
U heeft geen artikelen in uw winkelwagen
Microsoft SQL Server Introduction to SQL E-learning
Introduction to SQL E-learning
€159,00

Goedkoper ergens anders?

Laat het ons weten!

+31367601019 [email protected]

Introduction to SQL E-learning

|
€159,00 Excl. btw
€192,39 Incl. btw
  • Bestel 2 voor €155,82 per stuk en bespaar 2%
  • Bestel 3 voor €154,23 per stuk en bespaar 3%
  • Bestel 4 voor €152,64 per stuk en bespaar 4%
  • Bestel 5 voor €151,05 per stuk en bespaar 5%
  • Bestel 10 voor €143,10 per stuk en bespaar 10%
  • Bestel 25 voor €135,15 per stuk en bespaar 15%
  • Bestel 50 voor €127,20 per stuk en bespaar 20%
Op voorraad
|
Bestel voor 16:00 uur en start vandaag.
Je hebt nog counting... uur
  • Bestellen op Factuur
  • Beste opleider 2019
  • Na Betaling Direct Starten
Cursusinhoud/-informatie

Introduction to SQL E-learning

Bestel deze unieke E-learning cursus Introduction to SQL online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, voortgangsbewaking door rapportages en testen per hoofdstuk om de kennis direct te toetsen.

Cursusinhoud

Course 1: Introduction to SQL (2 Hours, 53 Minutes)

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.

  • start the course
  • identify a database and how it relates to SQL
  • describe the relational concepts of SQL, various database
  • types, and when and why they are used
  • use SQL to describe the differences between SQL and other
  • languages
  • describe in high level, structured query language and its
  • use
  • use SQL to create a simple statement
  • describe data types and their relation to SQL
  • use SQL to create a simple database example
  • describe tables and how to create them in SQL
  • use tables to further dive into the complexities of SQL
  • use the INSERT statement in SQL
  • use SQL to create more complex tables
  • use SQL to alter an existing table
  • use SQL to delete an existing table
  • use SELECT to take a look at a table
  • use the NULL statement in SQL
  • use the DEFAULT statement in SQL
  • use the SELECT statement in SQL queries
  • use SELECT to retrieve data from more than one table in
  • SQL
  • use SQL to create several data types
  • use DELETE to remove data from a table in SQL
  • use UPDATE to change data in SQL
  • use ORDER BY with results to sort data in SQL
  • use WHERE to filter data and retrieve requested results in
  • SQL
  • use all data management components in an example in SQL
  • describe SQL and the query while demonstrating how to create a
  • table and manipulate it

Course 2: Introduction to SQL: Managing Table Design (1 Hour, 55 Minutes)

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.

  • start the course
  • define multiple tables and describe their use in SQL
  • use SQL for the process of connecting tables
  • use FOREIGN KEY with CREATE in SQL architecture
  • describe relationships between tables and the different patterns
  • use composite keys and their relative values
  • describe the functional dependencies and their use
  • use functional dependencies in a example
  • use inner joins in SQL
  • use equijoins and non-equijoins and describe their differences in SQL architecture
  • use Outer Joins in SQL
  • use multiple joins and multiple conditions in SQL
  • use the UNION operator and describe how it combines results
  • describe a subquery and its use in SQL
  • use query as a SELECT column in SQL
  • use correlated and noncorrelated queries in SQL
  • use a query with a natural join
  • use IN, NOT IN commands in SQL
  • use correlated query with EXISTS and NOT EXISTS operators
  • use HAVING clause in SQL with queries
  • use queries with the UPDATE statement in SQL
  • use queries with the INSERT statement in SQL
  • use queries with the DELETE FROM statement in SQL
  • use SQL to create a more complex query
  • use SQL more efficiently with operational tips
  • describe the multiple layers of tables and their management in various SQL queries

Course 3: Introduction to SQL: Multiple Tables and Advanced Queries (2 Hours, 39 Minutes)

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.

  • start the course
  • define multiple tables and describe their use in SQL
  • use SQL for the process of connecting tables
  • use FOREIGN KEY with CREATE in SQL architecture
  • describe relationships between tables and the different patterns
  • use composite keys and their relative values
  • describe the functional dependencies and their use
  • use functional dependencies in a example
  • use inner joins in SQL
  • use equijoins and non-equijoins and describe their differences in SQL architecture
  • use Outer Joins in SQL
  • use multiple joins and multiple conditions in SQL
  • use the UNION operator and describe how it combines results
  • describe a subquery and its use in SQL
  • use query as a SELECT column in SQL
  • use correlated and noncorrelated queries in SQL
  • use a query with a natural join
  • use IN, NOT IN commands in SQL
  • use correlated query with EXISTS and NOT EXISTS operators
  • use HAVING clause in SQL with queries
  • use queries with the UPDATE statement in SQL
  • use queries with the INSERT statement in SQL
  • use queries with the DELETE FROM statement in SQL
  • use SQL to create a more complex query
  • use SQL more efficiently with operational tips
  • describe the multiple layers of tables and their management in various SQL queries

Course 4: Introduction to SQL: Views, Transactions, and SQL Security Architecture (3 Hours, 9 Minutes)

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.

  • start the course
  • describe views and their relation to the SQL architecture
  • use SQL to create a simple view
  • use the various views in SQL architecture
  • use SQL to update a view
  • use SQL to drop views
  • describe the various transactions and their use in SQL
  • describe the various ACID transactions and their use
  • use Transactions in SQL
  • use ROLLBACK statement in SQL
  • use the COMMIT statement in SQL
  • use ROLLBACK and COMMIT in an SQL query
  • use SQL to define Transact-SQL and the relation with transaction types
  • use transaction logs and define their purpose in SQL
  • describe locks and their use in SQL
  • use SQL to introduce the various levels of locking and their use
  • use SQL to describe the various lock modes
  • use SQL to identify the levels of locking
  • use SQL to create an implementation using locks
  • describe the various security concepts in SQL
  • use SQL to describe the philosophy behind User IDs and their use
  • use SQL to describe how to create a user and how to manage them
  • use SQL to describe the use of group IDs and roles in
  • use SQL to define the use of privileges and restrictions
  • use SQL security processes to create a user and a group with privileges
  • describe views, transactions, and the security model and the relation to SQL
Heeft u niet gevonden wat u zocht?
Laat ons helpen!
Specificaties
Algemene eigenschappen
Duur: 7 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja
Beoordelingen
average of 0 review(s)
Geen reviews gevonden
Help ons en andere klanten door het schrijven van een review
Schrijf uw beoordeling!




Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »