Whether you`re new to SQL or a more experienced developer, this course is a great start and an eye-opener on how much you`re missing out on in SQL. You will cover, how to create complex inner and outer joins, summary queries, and subqueries. What the different data types are and how to handle the common problems you run into with various types of data. How to use built-in functions or write your own to handle everyday challenges. You will also see the basics of database design and implementation using the Management Studio.
No particular programming experience is required, the course is taught from a developer`s perspective but it will also suit those new to relational databases and database technology.
An introduction to relational databases and SQL
An introduction to client/server systems
An introduction to SQL and SQL-based systems
The Transact-SQL statements
How to work with other database objects
How to use SQL from an application program
An introduction to SQL Server 2019
An introduction to the Management Studio
How to manage the database files
How to view and modify the database
How to work with queries
How to view the documentation for SQL Server
An introduction to the SELECT statement
How to code the SELECT clause
How to code the WHERE clause
How to code the ORDER BY clause
How to work with inner joins
How to work with outer joins
Other skills for working with joins
How to work with unions
How to work with aggregate functions
How to group and summarize data
How to summarize data using SQL Server extensions
An introduction to subqueries
How to code subqueries in search conditions
Other ways to use subqueries
Guidelines for working with complex queries
How to work with common table expressions
How to create test tables
How to insert new rows
How to modify existing rows
How to delete existing rows
How to merge rows
A review of the SQL data types
How to convert data
How to work with string data
How to work with numeric data
How to work with date/time data
Other functions you should know about
How to design a data structure
How to normalize a data structure
An introduction to DDL
How to create databases, tables, and indexes
How to use constraints
How to change databases and tables
How to work with sequences
The script used to create the AP database
How to work with a database
How to work with tables
How to generate scripts
An introduction to views
How to create and manage views
How to use views
How to use the View Designer
An introduction to scripts
How to work with variables and temporary tables
How to control the execution of a script
Advanced scripting techniques
Procedural programming options in Transact-SQL
How to code stored procedures
How to code user-defined functions
How to code triggers
How to work with transactions
An introduction to concurrency and locking
How SQL Server manages locking
How to prevent deadlocks
How to work with SQL Server login IDs
How to work with permissions
How to work with roles
How to manage security using the Management Studio
An introduction to XML
How to work with the xml data type
How to work with XML schemas
Two more skills for working with XML
An introduction to BLOBs
How to use SQL to work with a varbinary(max) column
A .NET application that uses a varbinary(max) column
How to use FILESTREAM storage
