Learn SQL by Learning & Doing: Setup, Databases & T-SQL for Beginners – Start Your Data Journey in under two hours!
What you will learn
Introduction to SQL Server versions and deployment types, a general overview.
Introduction to SQL and T-SQL, lectures and also hands-on workshops.
Introduction to Data Careers using T-SQL and SQL Server, choosing to go Permanent or Contractor in industry when starting out.
Setup a learning and development environment to start your data career. Download, install and configure SQL Server Express 2022 Edition and connect.
Download, install, configure and connect a variety of IDEs and SQL Editors to your installed SQL Server instance. Choose a favourite or keep them all.
Code SQL and T-SQL, writing statements to create first databases, database tables, populate database tables and retrieve data from your new tables.
Connect with your instructor with over 25 years industry experience in Data and Software Engineering.
Created a learning and development environment that is validated, providing you with a solid foundation for future courses and workshops with Gennaro Borrelli.
Why take this course?
This FREE course serves two important purposes:
It’s a perfect introduction to T-SQL for absolute beginners, AND it’s a quick and easy setup guide for students taking other T-SQL courses.
In under 2 hours, you’ll learn by doing β setting up your SQL environment (SQL Server Express, SSMS, VS Code), creating a simple database, a database table and returning all results, effectively writing your first T-SQL queries.
Start your data journey today!
* Set up your SQL development environment with SQL Server Express.
*Β Connect to your local database instance with SQL Server Management Studio (SSMS), and Visual Studio Code.
* Learn how to create a database, a database tables, populate it with data, and retrieve all data.
* Write basic T-SQL queries to retrieve and manipulate data.
*Β Learn how to manage your Windows Operating System Database Server Services
* Gain the confidence to explore more T-SQL further.
** This course is ideal for: * *
* Absolute beginners with no prior database or programming experience.
* Students enrolled in other T-SQL courses who need a quick and easy setup guide.
* Anyone curious about data and wanting to explore the world of databases.
** Why learn T-SQL? **
T-SQL is the standard language for working with Microsoft SQL Server databases, a powerful and widely used database management system. Mastering T-SQL opens doors to a variety of career opportunities in the data field.
** What makes this course unique? **
* Hands-on, practical approach: * You’ll learn by doing, not just watching.
* Concise and efficient: * Get started with T-SQL in under 2 hours.
* Dual purpose: * Perfect for beginners and as a setup guide.
* Free of charge: * Start your data journey without any financial commitment.
Enrol now and start your T-SQL journey today!
Known Issues: The video margins in the VS Code sections are slightly off, but the content is still fully usable.
We are working to resolve this issue.
#sql #tsql #data #databases #rdbms #learning #tutorials