Students gain knowledge and skills in designing and implementing databases using SQL server platform
\ntechnologies and the SQL query language. Upon completion of the course, students will know the syntax of
\nSQL. They will know how to use various user functions and triggers. They will be able to create and
\nmodify databases and tables, as well as to know how to handle keys, write scripts, and work with stored
\nprocedures, functions, views, triggers and transactions.<\/p>\n
Database concept. Database systems and models. Data normalisation. Database life cycle. The SQL query
\nlanguage. Statements for data manipulation, statements for control and management functions,
\ncommands for defining objects in the database. Data integrity, indexes, and query optimisation;
\ntransaction management and concurrency; triggers; database performance and settings; query
\nprocessing and execution plans; data security; the backup and recovery of databases; distributed database
\nsystems.<\/p>\n
The basics of programming in SQL (SELECT, INSERT, UPDATE, DELETE; SQL JOIN operators;
\nGROUP BY, SUM; SET operators; CREATE, ALTER, DROP). Creating databases and managing databases
\nand their components. Implementing data integrity. Planning to use indexes. Index creation and
\nmaintenance. Implementing user-defined functions. The design,development and use of stored procedures. Trigger design and implementation. Query performance optimisation. Query analysis. Managing transactions and locks to ensure data concurrency and recovery.<\/p>\n","protected":false},"excerpt":{"rendered":"
Objectives and outcomes Students gain knowledge and skills in designing and implementing databases using SQL server platform technologies and the SQL query language. Upon completion of the course, students will know the syntax of SQL. … Read more<\/a><\/p>\n Read more<\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[199],"tags":[],"class_list":["post-13871","post","type-post","status-publish","format-standard","hentry","category-subjects"],"acf":[],"yoast_head":"\n