Overzicht cursussen T-SQL
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
10 uur in totaal
Partner: Udemy
Instructeur:
Vision Training Systems Technology Institute Online dba
Learn the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server..
Wat je leert: provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. , You will learn how to write queries that return data from tables as well as create, update, or delete data in a database. , These queries will allow f
Meer info
Wat je leert: provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. , You will learn how to write queries that return data from tables as well as create, update, or delete data in a database. , These queries will allow f
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
7 uur in totaal
Partner: Udemy
Instructeur:
Trevoir Williams
Querying | Microsoft SQL Server | T-SQL | 70-461 | Azure Data Studio | DDL | DML | Database Administration.
Wat je leert: Individuals who are new to SQL and want to learn the fundamentals of working with databases and writing SQL queries. , Data analysts who want to leverage SQL for data extraction, manipulation, and analysis , BI professionals who need to work with databases a
Meer info
Wat je leert: Individuals who are new to SQL and want to learn the fundamentals of working with databases and writing SQL queries. , Data analysts who want to leverage SQL for data extraction, manipulation, and analysis , BI professionals who need to work with databases a
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
5 uur in totaal
Partner: Udemy
Instructeur:
Vandana Soni
Ideal for beginners who want to earn Microsoft certification for SQL Server..
Wat je leert: Understand database design , Understand first, second and third normal form schemas , Normalize Databases
Meer info
Wat je leert: Understand database design , Understand first, second and third normal form schemas , Normalize Databases
Doelgroep: Voor gevorderden..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
1 uur in totaal
Partner: Udemy
Instructeur:
Mike West
Moving Beyond the Basics.
Wat je leert: You'll learn more than the basics of of how to manipulate SQL Server data. , You'll be able to begin crafting more complex stored procedures with hands on exercises. , You'll learn how to craft cleaner code that's properly optimized.
Meer info
Wat je leert: You'll learn more than the basics of of how to manipulate SQL Server data. , You'll be able to begin crafting more complex stored procedures with hands on exercises. , You'll learn how to craft cleaner code that's properly optimized.
Doelgroep: Voor gevorderden..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
5 uur in totaal
Partner: Udemy
Instructeur:
Vikas Munjal
Learn Basic to Advanced Level Training of Indexes and Execution Plans using T-SQL Commands in Microsoft SQL Server.
Wat je leert: Participants will get deeper knowledge on Clustered ,Non Clustered Indexes & Fragmentation Concepts , Participants will learn commonly used Execution Plans , Participants will learn to find the patterns which may be slowing down the query performance
Meer info
Wat je leert: Participants will get deeper knowledge on Clustered ,Non Clustered Indexes & Fragmentation Concepts , Participants will learn commonly used Execution Plans , Participants will learn to find the patterns which may be slowing down the query performance
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
6 uur in totaal
Partner: Udemy
Instructeur:
Bluelime Learning Solutions
Learn how to use Microsoft's version of SQL to Query Microsoft SQL Server Databases.
Wat je leert: Query Multiple Database Tables , Change query output column names using case expressions , Perform Various table joins
Meer info
Wat je leert: Query Multiple Database Tables , Change query output column names using case expressions , Perform Various table joins
Doelgroep: Alle niveaus..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
2 uur in totaal
Partner: Udemy
Instructeur:
Kris Wenzel
Learn INNER, OUTER, LEFT, RIGHT, SELF, & CROSS JOINS | use JOIN and ON clauses | SQL Query for Multiple Tables | T SQL.
Wat je leert: Completely revamped course, fully reproduced videos, new exercises, and more! , Understand the different types of joins available in SQL Server, including inner joins, outer joins, and cross joins. , Know how to use the JOIN clause to combine row
Meer info
Wat je leert: Completely revamped course, fully reproduced videos, new exercises, and more! , Understand the different types of joins available in SQL Server, including inner joins, outer joins, and cross joins. , Know how to use the JOIN clause to combine row
Doelgroep: Voor gevorderden..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
3,5 uur in totaal
Partner: Udemy
Instructeur:
Bluelime Learning Solutions
Practical Hands-on Advanced Transact-SQL (T-SQL)Queries ..
Wat je leert: Understand and write Aggregate Functions , Understand and write Analytic Functions , Understand and write SET Operators
Meer info
Wat je leert: Understand and write Aggregate Functions , Understand and write Analytic Functions , Understand and write SET Operators
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
1 uur in totaal
Partner: Udemy
Instructeur:
Steve Fox
In 60 minutes, learn 30 of the most important Transact-SQL (T-SQL) tasks that data analysts need to perform.
Wat je leert: By the end of this course students will be comfortable performing the core T-SQL tasks that data analysts perform on a daily basis. This will include activities such as writing T-SQL to : , Create databases and tables. , Select either all or a subset of dat
Meer info
Wat je leert: By the end of this course students will be comfortable performing the core T-SQL tasks that data analysts perform on a daily basis. This will include activities such as writing T-SQL to : , Create databases and tables. , Select either all or a subset of dat
Doelgroep: Alle niveaus..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
2 uur in totaal
Partner: Udemy
Instructeur:
Kris Wenzel
Subquery MySql, PostgreSQL, SQLite, Microsoft SQL Server | TSQL | Correlated subquery | Inner query | Nested query.
Wat je leert: Write subqueries to select data from multiple tables. , Create subqueries to return a single value or multiple values. , Use subqueries in the SELECT, FROM, WHERE, and HAVING clauses.
Meer info
Wat je leert: Write subqueries to select data from multiple tables. , Create subqueries to return a single value or multiple values. , Use subqueries in the SELECT, FROM, WHERE, and HAVING clauses.
Doelgroep: Voor gevorderden..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
6 uur in totaal
Partner: Udemy
Instructeur:
Vikas Munjal
Transact SQL Query Programming & Developer Advanced Microsoft SQL Server Online Video Training Course by Vikas Munjal.
Wat je leert: Feel more confident in handling real life scenarios and writing complex codes
Meer info
Wat je leert: Feel more confident in handling real life scenarios and writing complex codes
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
2 uur in totaal
Partner: Udemy
Instructeur:
Mike West
A Real World Introduction to Transact-SQL.
Wat je leert: At the conclusion of this course you'll have a fundamental understanding of Transact-SQL. , You'll learn the 4 components of every query. , You'll also learn the difference between DML and DDL and when to use each.
Meer info
Wat je leert: At the conclusion of this course you'll have a fundamental understanding of Transact-SQL. , You'll learn the 4 components of every query. , You'll also learn the difference between DML and DDL and when to use each.
Doelgroep: Alle niveaus..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
5 uur in totaal
Partner: Udemy
Instructeur:
Kris Wenzel
Stored Procedures Database Programming, Write TSQL Server Stored Procs for Data Engineering, Data Analysis, and DBA's.
Wat je leert: Understand what a stored procedure is and how it differs from other types of SQL queries. , Understand how to pass parameters to and from stored procedures. , Know how to use variables and control structures such as IF/ELSE and WHILE loops within
Meer info
Wat je leert: Understand what a stored procedure is and how it differs from other types of SQL queries. , Understand how to pass parameters to and from stored procedures. , Know how to use variables and control structures such as IF/ELSE and WHILE loops within
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
9 uur in totaal
Partner: Udemy
Instructeur:
Raphael Asghar
All the information needed within the courses to set yourself for a successful career as a SQL Production DBA.
Wat je leert: Students will be able to create database, tables, view, stored procedures, filter data, update and delete information and be able to create complex joins of tables
Meer info
Wat je leert: Students will be able to create database, tables, view, stored procedures, filter data, update and delete information and be able to create complex joins of tables
Doelgroep: Voor beginners..
Type Opleiding: online/e-learning
Taal: Engels
Duur:
28,5 uur in totaal
Partner: Udemy
Instructeur:
Phillip Burton • 800,000+ students so far
From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, and 2022. Helps with DP-600.
Wat je leert: create tables in a database and ALTER columns in the table. , Know what data type to use in various situations, and use functions to manipulate date, number and string data values. , retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORD
Meer info
Wat je leert: create tables in a database and ALTER columns in the table. , Know what data type to use in various situations, and use functions to manipulate date, number and string data values. , retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORD