Practical T-SQL: 300+ quizzes;165 hands-on, useful exercises

Practical T-SQL: 300+ quizzes;165 hands-on, useful exercises, available at $64.99, has an average rating of 3.4, with 174 lectures, 7 quizzes, based on 20 reviews, and has 168 subscribers.

You will learn about Get started fast: The concepts an terms you need for working with relational database and SQL. How to use the SQL Server Management Studio to work with SQL Master the SQL that you will use every day. Learn to write SQL statements that retrieve and update the data in a database Learn to work with inner and outer joins, summary queries, and subqueries…it's all here How to use data types and built-in functions to handle everyday challenges like manipulating character data, rounding numbers, and working with date/time values Design databases from first principle. Normalize your data: Go through the first three normal forms Create a database and its tables using SQL statements or Management Studio. Learn to use the snippets to create the initial templates of codes for modification Use sequence to generate to generate a complex series of integers that you can assign to a column Master advanced SQL features: Work with views, stored procedures and its parameters, functions, table-valued parameters, triggers, and cursors Innovative hands-on and interactive exercises not found in any course. Write and execute your SQL code within a custom interface outside of SSMS Click button to switch between problem statement and its solution. Navigate back and forth between exercises. Drag & Drop exercises same as in Microsoft exams About 390 quizzes, over 300 hands on exercises to be coded within your SSMS, and over75 interactive exercises that can be performed in a custom interface This course is ideal for individuals who are Data Analyst who want to experience the power of SQL queries to manipulate data or Report developers who need to work with SQL data or SQL Server database administrators who write ad-hoc queries or IT/Business students preparing to enter the industry or Individuals who want to make the transition from other RDBMS to the SQL Server platform or Individuals preparing for the Microsoft Querying exams It is particularly useful for Data Analyst who want to experience the power of SQL queries to manipulate data or Report developers who need to work with SQL data or SQL Server database administrators who write ad-hoc queries or IT/Business students preparing to enter the industry or Individuals who want to make the transition from other RDBMS to the SQL Server platform or Individuals preparing for the Microsoft Querying exams.

Enroll now: Practical T-SQL: 300+ quizzes;165 hands-on, useful exercises

Summary

Title: Practical T-SQL: 300+ quizzes;165 hands-on, useful exercises

Price: $64.99

Average Rating: 3.4

Number of Lectures: 174

Number of Quizzes: 7

Number of Published Lectures: 174

Number of Published Quizzes: 7

Number of Curriculum Items: 181

Number of Published Curriculum Objects: 181

Original Price: A$119.99

Quality Status: approved

Status: Live

What You Will Learn

Get started fast: The concepts an terms you need for working with relational database and SQL. How to use the SQL Server Management Studio to work with SQL
Master the SQL that you will use every day. Learn to write SQL statements that retrieve and update the data in a database
Learn to work with inner and outer joins, summary queries, and subqueries…it's all here
How to use data types and built-in functions to handle everyday challenges like manipulating character data, rounding numbers, and working with date/time values
Design databases from first principle. Normalize your data: Go through the first three normal forms
Create a database and its tables using SQL statements or Management Studio. Learn to use the snippets to create the initial templates of codes for modification
Use sequence to generate to generate a complex series of integers that you can assign to a column
Master advanced SQL features: Work with views, stored procedures and its parameters, functions, table-valued parameters, triggers, and cursors
Innovative hands-on and interactive exercises not found in any course. Write and execute your SQL code within a custom interface outside of SSMS
Click button to switch between problem statement and its solution. Navigate back and forth between exercises. Drag & Drop exercises same as in Microsoft exams
About 390 quizzes, over 300 hands on exercises to be coded within your SSMS, and over75 interactive exercises that can be performed in a custom interface

Who Should Attend

Data Analyst who want to experience the power of SQL queries to manipulate data
Report developers who need to work with SQL data
SQL Server database administrators who write ad-hoc queries
IT/Business students preparing to enter the industry
Individuals who want to make the transition from other RDBMS to the SQL Server platform
Individuals preparing for the Microsoft Querying exams

Target Audiences

Data Analyst who want to experience the power of SQL queries to manipulate data
Report developers who need to work with SQL data
SQL Server database administrators who write ad-hoc queries
IT/Business students preparing to enter the industry
Individuals who want to make the transition from other RDBMS to the SQL Server platform
Individuals preparing for the Microsoft Querying exams

This is the second edition and a complete overhaul of my first SQL Server Querying course based on SQL Server 2016 and 2019. This course shows you how to code the SQL statements that you need for your application if you are already in the industry. If you are a student preparing to enter a competitive world, this course will give you the advantage you need to succeed. We teach you how to code SQL scripts so they run efficiently. The course shows you how to take advantage of the most useful advanced features that SQL Server has to offer.

This SQL Server course is based on SQL Server 2016 and 2019. In this course we teach you all that you need to use SQL Server effectively and to write good SQL scripts. We cover the following topics:

Get started fast
1. The concepts and terms you need for working with relational database and SQL
2. How to use the Management Studio to work with a SQL Server database
3. Explore the common Data Manipulation Language (DML) and Data Definition Language (DDL)
4. Learn to design your data to the 3rd Normal Form
Master the SQL that you will use everyday
1. How to write SQL statements that retrieve and update data in a database
2. How to work with inner and outer joins, summary queries, and subqueries…it’s all here for you
3. Write sophisticated stored procedures and functions with required and optional parameters with return values to calling programs
4. Write Triggers (INSERT, UPDATE, DELETE, INSTREAD OF) to handle all scenarios including data and referential integrity
5. Learn to use snippets to provide templates for creating objects (stored procs, tables, functions, triggers etc.) …and more
Learn how to create databases
1. Learn to create a database and its tables using SQL statements or the Management Studio…valuable skills, whether you are on the DBA track or not
Learn to code the Data Manipulation Language (DML)including all the action queries.
Interactive, hands-on exercises controlled by a (innovative) custom user-defined interface. Execute all your SQL scripts within custom interface (no SSMS). Move between problem and solution at the click of a button. Experience a unique learning experience

Course Curriculum

Chapter 1: An introduction to relational databases and SQL

Lecture 1: How the custom, interactive user-interface works

Lecture 2: Learning objectives for Section One

Lecture 3: The architecture of a simple client/server system

Lecture 4: How the tables in a relational database are related

Lecture 5: Defining columns in a table

Lecture 6: An introduction to the SQL statements

Lecture 7: Statements for working with database objects

Lecture 8: How to query a single database

Lecture 9: Joining data from two or more tables

Lecture 10: How to add, update, and delete data in a table

Lecture 11: Coding guidelines

Lecture 12: Working with Views

Lecture 13: Stored Procedures, Triggers, and User-defined functions

Chapter 2: How to use the Management Studio

Lecture 1: How to connect to a database server INCLUDING LECTURE RESOURCES

Lecture 2: How to configure SQL Server (The SQL Server Configuration Manager)

Lecture 3: How to connect to a database server

Lecture 4: How to navigate through the database objects

Lecture 5: How to work with the SQL database diagram

Lecture 6: How to view the column definition of tables

Lecture 7: How to view and modify databases: database diagram, column definition, tables

Lecture 8: How to view data of a table

Lecture 9: How to enter and execute a query

Lecture 10: How to handle syntax errors

Lecture 11: How to handle SQL syntax errors

Lecture 12: How to open and save queries (*.sql files)

Chapter 3: How to retrieve data from a single table

Lecture 1: Understand the basic syntax of SELECT statement INCLUDING SECTION 3 RESOURCES

Lecture 2: The syntax of the extended SELECT statement

Lecture 3: How to code arithmetic expressions in a SELECT statement

Lecture 4: Using functions is a SELECT statement

Lecture 5: How to use the DISTINCT keyword to eliminate duplicate rows

Lecture 6: Using the TOP clause to return a subset of a selected row

Lecture 7: Using the comparison operators in a WHERE clause

Lecture 8: Using the AND, OR and NOT logical operators

Lecture 9: How to use the IN operator

Lecture 10: How to use the LIKE operator

Lecture 11: How to use the IS NULL clause

Lecture 12: How to code the ORDER BY clause

Lecture 13: How to sort a result set by an alias, an expression, or a column number

Lecture 14: How to retrieve a range of selected rows

Chapter 4: How to retrieve data from two or more tables

Lecture 1: Introduction to this section including resources for the section

Lecture 2: How to code an inner join

Lecture 3: Using correlation names

Lecture 4: Using compound join conditions

Lecture 5: How to use self-join

Lecture 6: Inner joins that join more than two tables

Lecture 7: How to use outer join for more than two tables

Lecture 8: Join Examples

Lecture 9: More about outer join

Lecture 10: Using cross join

Lecture 11: Unions that combine data from the same table

Lecture 12: Examples of Unions

Lecture 13: More examples on unions

Lecture 14: How to use the EXCEPT and the INTERSECT operators

Chapter 5: How to code summary queries

Lecture 1: Introduction and learning objectives

Lecture 2: How to work with aggregate functions

Lecture 3: Examples of aggregate functions

Lecture 4: How to code the GROUP BY and HAVING clauses

Lecture 5: Examples of queries that use the GROUP BY and HAVING clauses

Lecture 6: Comparing the HAVING to the WHERE clauses for filtering query result sets

Lecture 7: Coding complex search conditions

Lecture 8: How to use the OVER operator

Lecture 9: Section 6: hands-on exercises 1-6

Lecture 10: How to use the OVER clause

Chapter 6: How to code subqueries

Lecture 1: Learning objectives for section

Lecture 2: Introducing subqueries

Lecture 3: How subqueries compare to joins

Lecture 4: How to code subqueries in search conditions

Lecture 5: How to code correlated subqueries

Lecture 6: How to use the EXISTS operator

Lecture 7: How to use derived tables

Lecture 8: Using subqueries in a SELECT statement

Lecture 9: Guidelines for writing complex queries

Lecture 10: Writing pseudocode

Lecture 11: How to work with common table expressions (CTE)

Chapter 7: How to insert, update, and delete data to modify data in a table

Lecture 1: Introduction and lesson objectives. Section resources found here

Lecture 2: Creating test tables

Lecture 3: How to insert new rows

Lecture 4: How to insert default values and null values

Lecture 5: How to insert rows selected from another table (using subqueries)

Lecture 6: How to modify existing rows

Lecture 7: How to use subqueries in an update operations

Lecture 8: How to use joins in an update operation

Lecture 9: How to delete existing rows

Lecture 10: How to use subqueries and joins in a delete operations

Lecture 11: How to merge rows

Chapter 8: Working with data types

Instructors

Samuel Osei-Tutu
Microsoft Certified Professional, Consultant and Author

Rating Distribution

1 stars: 2 votes
2 stars: 1 votes
3 stars: 2 votes
4 stars: 6 votes
5 stars: 9 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu