How to find a job with T-SQL skills

1. SQL and Transact-SQL (T-SQL) For Beginners

4.1

(179)

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL, MySQL etc. Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server's version of SQL is known as Transact-SQL  (T-SQL). In this course you will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way. What You will learn includes: Installing SQL ServerInstall SSMSBasic Database  ConceptsCreating DatabaseCreating TableCreating ViewsCreating stored proceduresReading data from a databaseUpdating database recordsBacking up databaseDeleting RecordsTruncating TableDropping TableDropping DatabaseRestore Database...

2. Season 1: Database, SQL Server, T-SQL

4.3

(115)

This course introduces concepts around SQL Server, uses of SQL Server Management Studio and intends to get you familiar with applications of Transact-SQL. Consider this as your first Season amongst the many to follow, leading a path to Database, SQL, Reporting, Automation, Data Engineering, and Data Science. Make the most out of this course by making sure you time block learning sessions into your daily routine. Additionally do not forget to share feedback and drop a message in case you feel there are any areas of improvement within the course curriculum. The design of the courses is such that, it's been partitioned into Seasons, this being the first of multiple to follow. The first Season focuses on breaking the barriers and forming a solid foundation on the concepts of SQL Server. We start right from basics of installing an instance in our local computer, and then moving on to introducing SQL Server Management Studio. We will mostly use SSMS throughout this course. As we move ahead we will dissect what is SQL and Transact-SQL, what the basic types of statements viz. Data Definition Language, Data Manipulation Language, and Select. From basics to just about all the practical examples that you need to follow, to start your journey into the data ecosystem...

3. T-SQL in SQL Server For Beginners

4.5

(66)

Learn to become a T-SQL writer in SQL Server Database. This course is for anybody who wants to become a T-SQL Expert in a SQL Server Database but doesn't know what skills or steps to take. Nearly every company uses T-SQL and usually, they need a T-SQL Expert. To become good at T-SQL, you need technical, communication and problem-solving skills. As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves responsible for developing and operating databases. In this course 'T-SQL in SQL Server For Beginners', I will cover how to use T-SQL and you will learn the same skills no matter which version of SQL Server you use. You will learn how to Install SQL ServerUse SQL Server to retrieve information from a databaseUse SQL Server to update information from a databaseUse SQL Server to delete information from a databaseUse SQL Server to insert information into a databaseHow to join tables within a SQL Server database. How to filter information within a SQL Server databaseWith this course, you will be able to start to think about different occupations that you would be interested in. You might be interested in becoming a SQL Server Developer after finishing the course or you might venture into becoming a SQL Server Developer...

4. Microsoft SQL for beginners: ( MS-SQL Server,T-SQL, SSMS )

4.4

(428)

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL, MySQL etc. Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server's version of SQL is known as Transact-SQL  (T-SQL).    In this course you will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way. T-SQL is also popularly referenced to as T-Sequel. In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database.  But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL. This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries. What You will learn includes: Installing SQL ServerInstall SSMSBasic Database  ConceptsCreating DatabaseCreating TableCreating ViewsCreating stored proceduresReading data from a databaseUpdating database recordsBacking up databaseDeleting RecordsTruncating TableDropping TableDropping DatabaseRestore DatabaseQuery Multiple Database TablesChange query output column names using case expressionsPerform Various table joinsFilter records and remove duplicatesWrite basic T-SQL StatementsUnderstand T-SQL TOP CommandUnderstand NormalisationKnow how to use SSMSCreate ViewsCreate Stored ProceduresUnderstand NULL ValuesData TypesFunctions...

5. Learn Advanced T-SQL For SQL Server Administrator

4.3

(871)

The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more.  The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment.  In addition, the student will be given examples of block statements, transactions commands, recursive CTEs, error handling, variables, and much more.  This course will greatly help those students that want to understand how to read, modify, and execute from simple to complex stored procedures.  By creating stored procedures, the developer has greater control in the execution of SQL commands, permissions, and greater flexibility in updating the sproc...

6. Learn T-SQL From Scratch For SQL Server Administrator

4.4

(2,586)

These individual courses will take you step by step in learning what it takes to become a SQL Production Database Administrator and will teach you the skills, roles, tasks, and responsibilities a SQL Production Database Administrator does on a daily basis. The great benefit of these courses is that you can navigate to one site to learn all that is needed to manage your SQL Server Environment...

7. Microsoft SQL Server And T-SQL Course For Beginners

4.4

(214)

Microsoft SQL Server also known as SQL Server is a mature technology which can be used not just by developers but by marketers, sales teams, product managers and much more - it is a query language that allows you to ask questions from securely stored data. Think of it this way - any business on this planet makes money with data. The fancy user interfaces, cool animations are nice but that's not what makes the money. Think about it. when you go to Facebook or Instagram do you care about the fancy animations and user interface or do you care to see your friends, what they are up to, check out events and be part of the goings on of that entire digital ecosystem?Of course it is the second choice. the fancy user interfaces are cool and make the experience pleasant but in the end you care about your friends and what they are up to, you care about being part of the ecosystem... Now your friends, followers, events, what everyone is up to is data and as I mentioned before that is what makes companies money. Microsoft SQL Server (SQL Server) is one of the most mature technologies that allows companies to handle data, store it securely, access it quickly and much more. Now if you know about Microsoft SQL Server (SQL Server) and you know how to create database objects, how to normalize tables, how to retrieve data, prepare reports, insert and delete data safely and you know about best practices then you are an amazingly valuable asset to the company. If you have a business that you are trying to grow and have data which you are trying to handle then Microsoft SQL Server (SQL Server) is a great choice which is another reason for you to learn this skill. Now guess what? All of those things we will be learning in this course and MUCH more! Take my advice and learn this valuable skill, you will not regret it. After dedicating only a few days and really focusing you can acquire this valuable skill and set a new course for your life...

8. Database Developer - SQL Server/T-SQL/Database Migration

4.5

(111)

One of the many roles of a database developer includes working with relational database servers, using T-SQL(Transact ) to interact with Microsoft SQL Server  and also performing database migrations from one relational database management system to another. There are several tools available to perform database and data migration. In this course we will be using a free powerful tool by Oracle called Oracle SQL Developer to migrate a third party database from Microsoft SQL Server into Oracle. Database migration involves several steps specified below: Setting up a Migration Repository: The Migrations Repository is a database schema that stores the meta data collected and transformed in the migration process. Configuring the Third Party Database Connection : You  need to configure a database connection for the database  which  you would like to migrate. There are two steps to this process: Download JDBC driver and Connecting to Third  Party  Database. Capturing Source Database: This step is used to capture a snapshot of the current state of your third-party database and is necessary to provide SQL Developer  with a point in time view of your database. Once this step is complete, the Migration wizard works on the meta-data stored in its repository, instead of issuing queries against your live database. Convert Captured Model to Oracle: The next step in the migration process is to convert the captured model  of the database to an Oracle-specific model. Translate Third Party SQL Objects to Oracle: The next step in the migration process is to translate the T-SQL objects - constraints, functions, procedures, triggers, views - to Oracle SQL objects. Generating Scripts to Create Target Database: Once the conversion process has completed, SQL Developer has a model of what the converted database will look like. This is used to generate SQL scripts for the creation of the new Oracle Database schema(s) and to run these scripts. Move Data from Third Party Database  to Oracle: The last step in the Migration Wizard is to  move the data to the new database.  Migrating the data is a process that copies the data from the third-party database to the new tables in the Oracle database. The Migration Wizard uses the  same Oracle database connection required to run the scripts as it does to move the data...

9. T-SQL For Beginners: Learn to Query SQL Server Databases

4

(102)

Welcome everyone to the T-SQL course. T-SQL is also popularly referefered to as T-Sequel. In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database. But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL. This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries. What You Will Learn in this course includes: Query Multiple Database TablesChange query output column names using case expressionsPerform Various table joinsFilter records and remove duplicatesWrite basic T-SQL StatementsUnderstand T-SQL TOP CommandUnderstand NormalisationKnow how to use SSMSCreate ViewsCreate Stored ProceduresUnderstand NULL ValuesData TypesFunctionsThis is a video based course of about hours with lots of practical hands on examples to follow along...

10. Introduction to T-SQL for Data Analysts

4.2

(221)

This course teaches students the core Transact SQL (T-SQL) skills and tasks that Data Analysts need to perform, such as how to connect to databases, define data extracts, query, & format data. This is a crash course, and in just over 1 hour, students will build a strong foundation knowledge of T-SQL. This course is different from most other T-SQL courses, in that it focuses on skills required by data analysts. It avoids other tasks such as defining user permissions, building indexing, and designing databases that database administrators and designers focus on. Because this course is tailored towards students wanting to develop data analyst skills, it is very compressed and in 60 minutes students will develop an understanding of 30 of the core T-SQL tasks data analysts perform. The course, and supporting material is designed to enable students to follow along in real-time with the instructor. The course consists of 6 lectures, and assumes no prior understanding or experience with Microsoft SQL Server or writing code. The T-SQL code provided with the course works with Microsoft SQL Server 2008 to 2016. It will also work with all editions of SQL Server. How to obtain either a free, or low cost copy of Microsoft SQL Server is discussed in the course...

11. 70-461 Session 3: Querying Microsoft SQL Server (T-SQL code)

4.8

(946)

This course is the foundation for the Microsoft Certificate 70-461: Querying Microsoft SQL Server 2012/2014. Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. We'll start off by creating views, which enable us to store these SELECT queries for future use. We'll add security and create indexed views. We'll then create AFTER and INSTEAD OF triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at what happens when triggers run triggers, and how to handle multiple rows in a session. We'll look at the database that we previously developed, and see what is wrong with it. To solve these problems, we'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints. This will stop erroneous data from being added some data. No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial. There are regular quizzes to help you remember the information. Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL...

12. 70-461 Session 7: Querying Microsoft SQL Server (T-SQL code)

4.9

(204)

This course is the foundation for the Microsoft Certificate 70-461: Querying Microsoft SQL Server 2012/2014. Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. Welcome to Session 7 of this T-SQL course. In this session: We will be looking at transactions, seeing how to explicitly start and end them, and finding out how they can block other users in the database. Then we'll see about how to create clustered and non-clustered indexes and heaps, and their role in optimising queries. We'll also see how we can use Dynamic Management Views to see how we can improve our use of indexes. We'll then look at how to write a cursor, and when to use this row-based operation, and The impact of using scalar UDFs. No prior knowledge other than what we covered in Sessions 1 to 6 is required. This course builds on the knowledge previously gained in those previous sessions. There are regular quizzes to help you remember the information. Once finished, you will know what how to create transactions, indexes, cursors, XML data and more, and we'll have expanded on our current knowledge of T-SQL...

13. 70-461 Session 4: Querying Microsoft SQL Server (T-SQL code)

4.6

(2,362)

This course is the foundation for the Microsoft Certificate 70-461: Querying Microsoft SQL Server 2012/2014. Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. Welcome to Session 4 of this T-SQL course. In this course: We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement. We'll add some error handling with TRY, CATCH and THROW. We'll also combine datasets together and compare them, by looking atUNION and UNION ALL, which allows us to combine sets, INTERSECT and EXCEPT, which compares datasets, and the mighty MERGE statement, which allows for conditional INSERT, UPDATE and DELETEs. We'll also create conditional logic: CASE, the equivalent of the IF statement in Excel, ISNULL and Coalesce, which replaces NULLs, No prior knowledge other than what we covered in Sessions 1 to 3 is required. However, prior experience with Excel or Access would be beneficial. There are regular quizzes to help you remember the information. Once finished, you will know what how to write procedures, add error handling, and combine datasets together and compare them, and we'll have expanded on our current knowledge of T-SQL...

14. 70-461 Session 6: Querying Microsoft SQL Server (T-SQL code)

4.6

(1,894)

This course is the foundation for the Microsoft Certificate 70-461: Querying Microsoft SQL Server 2012/2014. Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. Welcome to Session 6 of this T-SQL course. We'll start with creating sub-queries, in the WHERE, FROM and SELECT clause. We'll be created correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions (CTE) using the WITH statement and PIVOTting and UNPIVOTting, and we'll be using what we have learned to solve a common business problem. We'll be looking at functions, including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then look at synonyms, dynamic SQL, and GUIDs. We'll also look at sequences. Finally, we'll look at use XML data, shredding and querying it, manipulating JSON data, and exploring Temporal Data, so you can query data that used to be in your tables. No prior knowledge other than what we covered in Sessions 1 to 5 is required. This course builds on the knowledge previously gained in those previous sessions. There are regular quizzes to help you remember the information. Once finished, you will know what how to write subqueries, functions, sequences and more, and we'll have expanded on our current knowledge of T-SQL...

15. 70-461 Session 5: Querying Microsoft SQL Server (T-SQL code)

4.5

(1,968)

This course is the foundation for the Microsoft Certificate 70-461: Querying Microsoft SQL Server 2012. Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. We will now be creating aggregate queries, using the OVER() clause, together with PARTITION BY and ORDER BY. We'll also compare and contrast RANGE and ROWS, and how they work with CURRENT ROW and UNBOUNDED. We'll be reviewing the ranking functions ROW NUMBER, RANK, DENSE RANK and NTILE. We'll look at the 8 analytic functions new to SQL Server 2012, such as LAG, LEAD, FIRST VALUE and LAST VALUE. We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING ID. We'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates. No prior knowledge other than what we covered in Sessions 1 to 4 is required. This course builds on the knowledge previously gained in those previous sessions. There are regular quizzes to help you remember the information. Once finished, you will know what how to write ranking functions, analytic functions, grouping sets and spatial aggregates, and we'll have expanded on our current knowledge of T-SQL...

16. Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

4.4

(1,919)

SQL developers are expected to have a variety of skills that will enable them perform tasks such as: design, implementation and maintenance of structured query language (SQL) databases. They may work as database or web developers, depending on the specific position. SQL developers often spend many work hours seated in front of computers. As an SQL developer, you should have strong analytical, communication, and problem-solving skills. A knowledge of SQL servers, SQL Server Analysis Services -SSAS, SQL Server integration services (SSIS) and server reporting services (SSRS) is also important. This course is Hands-on  and by the end of the course you will have experience  of working with relational database management systems like Microsoft SQL Server. Some of what you will learn on the  course includes following: How to implement a data warehouse solutionDebug and Troubleshoot SSIS packages. Cleansing data by using Data Quality Services. Extend SSIS with custom scripts and components. How to create ETL (Extract, Transform, Load) processHow to deploy SSIS PackageHow to create SSIS package using SQL Server Integration ServicesHow to download and install SQL Server Data ToolsHow to perform data analysis with SQL Server Analysis Server - SSASHow to create reports using SQL Server Reporting ServicesHow to download and install SQL ServerIntroduction to T-SQL basicsHow to implement Table JoinsUsing Aggregate functions...

17. Advanced T-SQL: Window Functions for Advanced Querying

4.6

(284)

Unlock the Power of Data Analysis with Ease Using Window Functions! Welcome to our self-paced course, where we'll take you on a journey to master the art of data analysis in SQL databases using the incredible capabilities of Window Functions. Why Window Functions? Here's what you'll gain: Explore the Core Concepts: We'll start with the basics and delve into the key principles behind Window Functions, making even complex data analysis seem like a breeze. Diverse Window Functions: Discover a treasure trove of Window Functions at your fingertips. From ROW NUMBER to LAG and LEAD, you'll have an arsenal of tools to solve diverse data challenges. Crafting Your Own Functions: Learn how to design and tailor Window Functions to your specific analytical needs. Unlock the potential to extract valuable insights from your data like never before. Practical Implementation: We won't just stop at theory. Our course provides hands-on experience, allowing you to apply these techniques in real-world scenarios. This course offers a complete learning package: Engaging Video Presentations: Our dynamic video lessons bring concepts to life, making learning enjoyable and accessible. Comprehensive Resources: Access a wealth of resources, including reference links to text-based materials, ensuring you have all the support you need. Universal Compatibility: Window Functions are part of the ANSI standard SQL specification, meaning you can apply these skills to any relational database management system supporting SQL. Have questions or need assistance? Our Q & A section is your lifeline, connecting you with experts who are ready to help you conquer any challenges you encounter. Plus, upon course completion, you'll receive a certificate, a testament to your proficiency in implementing Window Functions. Don't wait any longer-seize this opportunity to supercharge your data analysis skills. Enroll now and elevate your career to new heights!...

18. SQL Server: Learn T-SQL in 9 hours (ITS-201, 98-364)

4.7

(930)

This course is the foundation for the IT Specialist Certification OD 201 Databases Fundamentals (which previously was Microsoft's 98-364 exam), and focuses on Microsoft SQL Server. Learn in just a few hours how to create tables, queries, views, procedures and more. What do people like you say about it?Seme says Thank you very much for your valuable course. I really enjoyed this course. Packed a lot of information , I found it very interesting and useful. Thank you. Gasper says Phillip always does a great job, this is my third course from him. Passionate and informed, I will take as many courses as I can from him. Jonas says Explaining SQL on a very easyway! Takes you though everything you need to know nice and calm. We start off by installing for free on your Windows desktop or laptop SQL Server, and learning how the six clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We'll examine how data is stored in tables, and see why normalisation is important for the proper building of tables. We'll then look at constraints, which allows you to set up rules for your data. Following this, how can we insert, update and delete data? We'll also create views, procedures, functions, and have a look at triggers. Finally, we'll investigate how to speed up your queries using indexes, add security, and back up your data. No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free! There are regular quizzes to help you remember the information, so you can be sure that you are learning. Once finished, you will have a good introductory knowledge of how databases work and be able to construct your own SELECT statements. And with a bit of practice, you could also go for the official IT Specialist exam - wouldn't that certificate look good on your CV or resume?...

19. SQL/ETL Developer - T-SQL/Stored Procedures/ETL/SSIS

4.2

(226)

A common problem that organizations face is how to gathering data from multiple sources, in multiple formats, and move it to one or more data stores. The destination may not be the same type of data store as the source, and often the format is different, or the data needs to be shaped or cleaned before loading it into its final destination. Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store. SQL Server Integration Services (SSIS) is a useful  and powerful Business Intelligence Tool. It is best suited to work with SQL Server Database. It is added to SQL Server Database when you install SQL Server Data Tools  (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects. SSIS can be used for: Data Integration Data Transformation Providing solutions to complex Business problems Updating data warehouses Cleaning data Mining data Managing SQL Server objects and data Extracting data from a variety of sources Loading data into one or several destinationsWhat You Will Learn.... How to install SQL Server Database  How to download and attach a database to SQL Server How to download and install SQL Server Data Tools How to Create a New Integration Services Project How to add and Configuring a Flat File Connection Manager How to add and Configuring an OLE DB Connection Manager How to add a Data Flow Task to the Package How to add and Configuring the Flat File Source How to add and Configuring the Lookup Transformations How to Create Integration Services Tasks How to Create  New Connection Manager How to Write data to a SQL Server database How to Execute a package from SQL Server Data Tools How to Control Data Flow for Flat Files How to test  Packages SQL FunctionsT-SQL Stored proceduresExtracting data from multiple tables...