Regular Price: £200 Batch Price: From £200 📅 View Dates & Prices Group Booking Discount: From £100 per person 🧮 Calculate & Book 1-to-1 Training: £200 📋 Booking Request Form Course Overview This course is designed for beginners who wish to design and implement databases with Microsoft SQL Server. It is a virtual online classroom-based course that covers relational database fundamentals, database design, Structured Query Language (SQL) and database administration. Following topics are included in this course: Database Concepts and Introduction of MS SQL Server Planning and Creating Databases Constraints and Data Integrity Structured Query Language (SQL) and T-SQL Retrieving Data with SQL and T-SQL Creating Views T-SQL Programming Migrating, Importing and Exporting Backing Up and Restoring Requirements No existing knowledge of Microsoft SQL Server is required. You should have basic computing knowledge. Familiarity with relational database concepts is helpful but not required. Course Content Database Concepts and Introduction of MS SQL Server Database and DBMS Editions of MS SQL Server Downloading and Installing Microsoft SQL Server Planning and Creating Databases Planning Your Database Creating a SQL Server database Creating tables Data types in SQL Server Defining Primary keys and Identity Specification Inserting, Updating and Deleting records Creating default values Constraints and Data Integrity Introduction of Database Constraints Unique Key Constraint Primary and Foreign Key Constraint Relationships in a Database Composite Primary Keys Creating Database Diagram Referential Integrity Structured Query Language (SQL) and T-SQL Introduction of SQL and Transact-SQL (T-SQL) Introduction of Data Definition Language (DDL) USE Command Create Databases using T-SQL Drop Databases using T-SQL Creating, Altering and Removing Tables using T-SQL Commenting and Saving T-SQL Introduction of Data Manipulation Language (DML) INSERT statements UPDATE statements DELETE statements Using SELECT statements Introduction to the SELECT statements Using WHERE for filtering Using the NOT operator Using the LIKE operator Using IS NULL and IS NOT NULL Using ORDER BY for sorting Using DISTINCT to find unique values Concatenating Columns Creating Calculated Field Limiting Results by using TOP Clause Creating Views Introduction of Views Creating Views using T-SQL Using View Designer Tools Importing and Exporting Data Import and Export Wizard Import Data into SQL Server Exporting Data Backing Up and Restoring Introduction to Database Backups Creating backups Restoring databases Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later. Price Calculator & Booking Request Form Calculate prices for Corporate, 1-on-1 or group training and request a booking. Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to: book a course on different dates book for a group of delegates book corporate training book a customised training book a one-on-one training The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information Study Path These are some suggested study paths, but you may book the courses according to your requirements. Database Design with Microsoft SQL Server > Querying Data with SQL and T-SQL > SQL Server Integration Services (SSIS) > SQL Server Reporting Services (SSRS) Database Design with Microsoft SQL Server > Programming with C# for Beginners > Web Development with ASP.NET Database Design with Microsoft SQL Server > Power BI with Excel Please contact us us if you need any help to choose your study path. Career Path These are some possible career paths after completing this course: Junior Database Designer/Developer > Database Designer/Developer > Senior Database Designer/Developer Junior Database Designer/Developer > Report Developer Data Analyst